I was using OLEDB for Access connection string before. Today I need to open

the connection to our SQL Server Database. I tried the following string but

got error message. Would anyone please help me with this? Thanks a bundle.

Ping



Dim objConn

Set objConn = Server.CreateObject("ADODB.Connection")



strConnect = "Provider=SQLOLEDB; Data Source=Hope;" &_

	          "Database=MyData; User ID=WebTest; Password=Test;

APP=ASPPage"



objConn.Open strConnect



erro message:

--------------------

Microsoft OLE DB Provider for SQL Server (0x80040E14)

Syntax error or access violation