I have 2 database servers running on the same machine each having a copy of my database. It's a basic Live and Development environment. Using OLEDB I can connect just fine to my live server but not the development one.
mydb@live_serv_soc works just fine.
mydb@dev_serv_soc gives me: Test connection failed because of an error initializing provider. XIX000:-111:ISAM Error: no record found.
I can acces both databases with odbc using the same userid and password.