Are there any ADO issues with Access2000? On NT4/IIS4/Access98 the
connection was:
oConn.Open "DSN=myDB1; UserId=abcdef; pwd=ghijk"
I'm being told that Access2000/Windows2000 does not support UserId and
Password and that the DSN and connection should be:
oConn.Open ("myDB1_999999")
The "_999999" is a unique number added by the provider to whatever I name my
DSN.
Problem: When I try and access the DB, regardless of the connection string,
I get this error:
Microsoft OLE DB Provider for ODBC Drivers Error 80004005
[Microsoft][ODBC Microsoft Access Driver]Cannot open database '(unknown)'.
It may not be a database that your application recognizes, or the file may
be corrupt.
They claim to have a highly custom/proprietary installation of Windows. My
feeling is that if you can't run a text book example, then it's not much use
to the programming public.
Thanks for any ideas or information?
CFB