Having a problem connecting via dsn on windows 2003 x64. Keep getting :
ADODB.Connection error '800a0ea9'
Provider is not specified and there is no designated default provider.

Code works fine on regular server 2003

Check if the Data provider is present on that machine. Like MS Access Drivers etc...

checked that. I am using sql server and it is there

This is exactly the same problem I am having. I have reinstalled the drivers just to make sure they are there. Did anyone resolve this issue?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.