Using vb.net 2005
I am trying to open a connection object in a windows service but getting an error, what do i need to do:
what I have now:
[Code]....
on the Open line i'm getting a squiggly error saying "declaration expected" for the MyCon.Open.
do I need to import something?
I have used vs 2008 to develop an asp.net application.
This application can run in windows xp, windows vista, but can't run under windows 7.
When the application want to new an database connection, it retun null.
I am using sqlserver 2005 express sp3 as my database.
The connection is :
Data Source=./SQLEXPRESS;Initial Catalog=mydb;Integrated Security=True
How can I do?
Using vb.net/vs.net 2005
I am writing a windows service but normally I write only asp.net apps. In asp.net app I store my connection strings in a web.config file, what is the correct place to store connection strings in a windows service?
I'm using Visual Studio 2008, and my database is SQL Server 2000.
I want to add a connection to the Server Explorer in VS. The Data source is Microsoft SQL Server (SqlClient). After entering in all my information and I click Test Connection, it is successful.
But when I click OK, I get the error:
Unable to add data connection. ExecuteScalar requires an open and available connection. The connection's current state is closed.
I previously used a datasource and a connection string to connect to my database on sql server and all orked fine. The connection string was saved in my web.config file and is: ....
View 1 RepliesIam using ftp client wrapper class for accessing ftp.
iam able to download files from ftp when used in windows application
when i try to use the same code with windows service i get an error
the error is
"The underlying connection was closed: An unexpected error occurred on a receive. "
this error i get on directory listing
the stack trace is:
[Code]....
Note:
FTP is getting connected throgh service
FTP is getting connected throug FileZilla, internet explorer
soruce code:
[Code]....
I am confused over this point that Connection with databse in ado.net is a managed object or unmanged object, from the past couple of years i was assuming that it is unmanged but a post from MSDN says it is managed (Correct me if i am wrong :)), i am attching the link of that post herewith
[URL]
When i create a Windows Service for getting information from a Web Application(ASP.NET c#) for scheduling some task in the client machine.
To consume WCF from the web application. I added WCF reference to Window Service project as a service reference, everything seems fine. It updated app.config file, added service reference etc.
it was not working.
[Code]....
I deployed my MVC app to IIS 7.0 and I keep getting the following error; ExecuteNonQuery requires an open and available Connection. The connection's current state is closed I dont get this with the app locally on my machine. Where could this error be occurring??
View 2 RepliesI've scenario where I want to insert data into database without post back. there are around 12 to 13 fields which i need to insert. I'm passing DTO from the client side which is actually Json object. Now the problem which i'm facing is how to convert that Json object which i got in webservice to the "class" (in my case class name is User) object.
[Code]....
In the above case AddNewUser method takes the object of User class. But i'm getting casting error. So how do I convert Json object to the "User" class object?
I could really use some help on this one. I've been fighting it now for several days and we are supposed to start testing early next week.I am subscribing to 4 web services all hosted by the same company. The integration with 1, 2 and 3 all went fine, but on the fourth I keep getting the very unhelpful error:
System.Web.Services.Protocols.SoapException = {"Server was unable to process request. ---> Object reference not set to an instance of an object."}
[code]...
I have the following code:
[WebMethod]
[SoapHeader("_webServiceAuth")]
public User GetUser(string username){
try
{
this._validationMethods.Validate(_webServiceAuth);
User user = new User(username);
[code]...
I have a web application - .net 4. The client is having a requirement that he want to send email to his users on a regular basis about his new courses etc.
The webapplication created will hosted on a "Shared hosting environment" with no excess to windows services - file system other than the web root folder through FTP.
Due to shared hosting i cannot create a windows service for him which will check the database - if there are any scheduled mail to send every 5 min.
So my question is - Is there anyway i can run a wcf web service or any other web based service or page or handler which can keep running and automatically checks the database for any new scheduled mails - if yes start sending it automatically in an different thread.
I have problems connecting to my database server. The database server is not local, I am connected via its IP address. It works fine in my development machine. After publishing the website to my server, it can not connect to my database server. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)Why can't my publish server connect to the database server, whereas it works fine through the development machine?
View 5 RepliesWhen should i open and close the database connection.and which are best data classes (for e.g dataset, datatable etc) should i use when connection is open or close.
View 3 RepliesThis is regarding ASP.Net (VB) 2.0 and SQL Server 2008. My project's (there is only one in my solution) has a "Start Action" set to a "Specific Page" (..FormsfrmMain.aspx). Occasionally (though not always) a large number of connections (30+) will be opened prior to the frmMain.PreInit event. These connections stay open for quite some time. I am closing all of my connections with extreme prejudice. In my "finally" clause of my try...catch I have myconnection.close. Immediately after the "End Try" I have myconnection.dispose (redundant, I know). I have accounted for all connections. I placed a breakpoint on frmMain.PreInit and then (sometimes) a large number of connections (used SSMS to run sp_who and sp_who2) will have just opened.What would open a large number of connections prior to the starting page's preinit event? I am closing (and then disposing) all of my connections. I thought that I must be missing a myconnection.close in the "finally" clause, but I have looked repeatedly and cannot find anywhere that a connection is open and then not closed. Also, I do not believe that I have even opened a connection prior to the frmMain's preinit event.
View 3 RepliesI devlopyed on asp.net application in IIS, i need to know how many current database connection is open for the database..
so how can i check how many connection are currently using for this database... if we dont want some connection how can we kill the connection
this is general to any operation calling an SQL server, or anything requiring an open connection at that.Say I have anywhere from 20 to 1000 Select calls to make for each item in data being looped. For each step, I'll select from sql, store data locally in a struct, then proceed. This is not a very expensive call, so should I keep the connection open for the entire loop? Or should I open and close every step? How expensive in run time is opening a connection? I would think it'd be better to keep the connection open, but would like to get the correct response for this.
View 4 RepliesI am trying to connect linq to dbf file. I am using VS2008 on windows xp with sp2. For most part I can create a connection and see the tables in the server explore, but when I try to drag and drop a table onto the .dbml i get "The selected object is an unsupported data provider". I have been trying to use FoxPro to connect to the DBF. In VS in the Data Connections I go to modify the connection and hit test and the connection says success, but no tables appear.
View 1 RepliesI have an application that takes a long time to open odbc connections (like 20 sec) also takes forever using arcmap and arcsde but when I try the connection on the odbc data source administrator, it tests it really fast. Does anyone have any idea of what my be causing this? btw the application works fine in another computer with another database
View 2 Replies[Code]....
and i am receiving error as
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Description:An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I wrote a small socket client application talking to my asp.net server application.
On the asp.net side, I created a IHttpHandler. I want to send data back and forth on one HTTP request.
I tried the following code which run an infinite loop inside function ProcessRequest(). The client side opens a socket connection and send HTTP POST request.
I am not sure how asp.net work. In HTTP POST I have to specify Content-Length, I tried a small value, like 20, then asp.net handler can only get 20 bytes in the inputstream. I tried to use 4096000 bytes(close to the maximum IIS allowed), then the inputstream cannot get anything, it seems IIS is waiting for all data(4096000) to come from client side before it gives the handler a chance to read from the socket.
public class DeviceDataHandler : IHttpHandler
{
public void ProcessRequest(HttpContext context)
{
try
{
Stream inputstream = context.Request.InputStream;
Stream outputstream = context.Response.OutputStream;
/loop forever until exception is thrown
while (true)
{
ProcessData(inputstream, outputstream);
}
}
catch (Exception ex)
{
ZenLog.logError("DeviceConnector exception: " + ex.Message);
}
}
public bool IsReusable
{
get
{
return true;
}
}
}
When I'm using this to open Connection to DB,
Do I need to Close it at the end?
Or by using it, it close by itself?
using (SqlConnection cnn = new SqlConnection(connectionInfo))
how many users can open a connection to Microsoft Access database simultaneously ?I am using asp.net 4.0 to write my application.
<add name="E_ShopAccessConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|
eport.mdb;Persist Security Info=True" providerName="System.Data.OleDb"/>
we usually open a connection by con.open() and close the connection by con.close().when we create a method like,
public void conopen()
{
if(connectionstate.open)
con.open();
con.close();
}
what is basically the use of this method..??...why we create this method when we have co.open() and con.close();