Connection String (ASP - SQL)

[perryair]

Hi,
I have converted the MS Access connection string to SQL,
when I try to access the page thru the SQL connection string I receive the following:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.

Here are the MS Access connection string:
<%
Dim vPath, pPath, ConString
vPath = "database\prod.mdb"
pPath = Server.MapPath( vPath )
ConString = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & pPath & ";" & "JET OLEDBatabase Password=pass"
%>


Here are the converted connection string:
<%
Dim ConString
ConString = "DRIVER={SQL Server};SERVER=server.domain.com;DATABASE=database;UID=user;PWD=password"
%>


Please help. . .

 

[nicklieb]

SERVER=server.domain.com

this is the issue here, you need the name or ip of the sql server, not a domain name.

 

[DotNetGnat]

http://www.connectionstrings.com

-DNG