Access Database Connection Problems
My company just switched to a new host and I am having a real problem connecting to an Access Database. The site administrator says that Windows 2003 no longer allows DSN-less connections, so they created a DSN to the database. I now need to use DSN syntax instead. I have tried (and tried!) a lot of different codes from other web sites but nothing works.
Here is the old code:
Set MyConn=Server.CreateObject("ADODB.Connection")
connStr="Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\datastores\PlanetHealth.mdb"
Can someone give me a pointer on what the new code should be?
Thanks
jdmeier
|