Hi I am trying to open a connection. code is as follows
<object RUNAT="SERVER" ID="conn"PROGID="ADODB.Connection"></object>
<% conn.Open Application("ConnectionString") %>
The error is as follows:
Microsoft OLE DB Provider for SQL Server: [DBNETLIB][ConnectionRead (Error SIO_KEEPALIVE_VALS()).]General network error. Check your network documentation.
I really dont know what is this object id in asp page. for debugging purpose I have created new application in VS.NET and added all the files and when I run i get this error. Please help. I have not added any code in Global.asax and web.config. The SQL server is on different machine and I could open connection using normal ASP and ASP.NET projects but only this <OBJECT> tag could not open connection I dont know the theory behind it. Your help will be appreciated. Please....


bdl

__________________
bdl

Just curious, why are you using OLE DB for SQL Server?

I dont know why am I using OLE DB for SQL server because this application was created by someone else that I am trying to debug in VS.NET. I am new to .NET. Can we change OLEDB to ADO DB, is there any default setting in .net to change or config?

bdl

Can you post more of your code?

Here is my first two lines of code in my asp page which is giving trouble from my local server.
<object RUNAT="SERVER" ID="conn" PROGID="ADODB.Connection"></object>
<% conn.Open Application("ConnectionString") %>
This file is working OK on the live server. But I have copied all the asp website to local server and created a new ASP.NET web application in VS.NET and trying to run locally by connecting to the SQL server remotly. First it gives file not found..even though the file functions.asp is there in virtual directory ..after I copied the file in default ans change include virtual to include file then I got the OLE BD error that I posted earlier. The same application I have tried in my laptop local server whenre SQL server is local on my laptop, then it worked...So there is something with the connection to the SQL server which is not local..The same server using .NET code I can connect but that code is not object..what is this OBJECT in this asp.file???that I dont know..Please help..

bdl

"functions.asp"

"created a new ASP.NET web application in VS.NET"

You don't want to mix the technologies. If you are going to use ASP.NET, I recommend that you rewrite your classic ASP to ASP.NET.

Hi STU but that site is big application i cant write that in asp.net but I just want to debug and know ehre the problem exists if there is any in the future.i understand your advise but I just want to dubug. Opening a connection should be fine I just want to open connection. But how come the same code works on different system with VS.NET..)(the only difference is SQL server is local to the machine that works)..

bdl