I have setup a new server WS2003, I have a "System DSN" that points to an Access database.
When I try to access the DB I get the following Error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
/erfinderclubs/asp/db_erfcl.asp, line 15
|
The code that is causing the problem is:
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "erfinder","","" 'Error here!!
sql = "SELECT Erfindungen.Titel, Erfindungen.ErfindungsNr FROM [Erfindungen] order by Titel"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, conn, 3, 3
|
Can anyone help me please? it all worked on the other server but I didn't set that one up and I have never had problems like this before.
Have I forgotten to include something?
Topic Options
Post Options
Thanks(0)
