Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  SQL Server Administration (2008)  Having connection problem from ASP to sql server

Author  Topic  Ish Starting Member 11 Posts Posted - 2010-07-16 : 11:46:04 Hi I have sql server express 2008 running on local laptop. I have classic ASP page for testing connection to the server. Here is the code. <% 'open the connection Dim Connect, myRecordSet Set Connect = Server.CreateObject("ADODB.Connection") Connect.Open = "Provider=MSDASQL; Driver={SQL Server}; Server=local; Database=VMENew; Uid=sa; Pwd=ismail;" If Connect.errors.count = 0 Then Response.Write "Connected OK" End If %> I am getting following error; Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. I am very new to sql server. Please could someone help me this problem to get started. Many thanks