|
| |
|
|
yisraelharris
Posts: 7
Joined: 1/3/2004
Status: offline
 |
Connecting to my MS-SQL Database - 2/25/2004 12:19:06
I have built MS-Access-based websites, and have had no problem establishing a connection to them. Here is typical code:
myConnection = Server.CreateObject("ADODB.Connection")
connectionString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="Server.MapPath("company.mdb")
myConnection.Open(connectionString)
However, I am currently working on an MS-SQL-based website, and am unable to achieve the connection. I've been using different variations of this (with and without the single quotes, etc.):
myConnection = Server.CreateObject("ADODB.Connection")
connectionString="DRIVER={SQLServer};SERVER='mssql2.myserver.com';UID='mylogin';PWD='d3fbc3';DATABASE='company.mdb'"
myConnection.Open(connectionString)
I get this error message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/test.asp, line 6
I do not know what needs to be done. I would be grateful for assistance.
Thank you.
|
|
|
|
Doug G
Posts: 1189
Joined: 12/29/2001
From: SoCal
Status: offline
|
RE: Connecting to my MS-SQL Database - 2/25/2004 17:19:21
Here is a great spot for connection string help
http://www.able-consulting.com/ADO_Conn.htm
_____________________________
======
Doug G
======
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
