ODBC Default Database won't stick!! UGH!

[Denda]

I'm setting up an ODBC System DSN on an XPsp2 system to connect to the local SQL 2000 sp3 database. It will test fine, but as soon as I hit "OK" after configuring it, the default database selection does not stay, hence when my application starts to connect to the database, I get all kinds of ODBC errors. Any way I can force this another way outside of the Data Sources(ODBC) tool.

Just an fyi, the database I am trying to connect to was restored & I have checked all of my permissions to make sure they are the same. If I try to connect to any other database on the server, it sticks.

 

[Denda]

Well, in regedt32, within ODBC, the specific datasource that I am having issues with via the Data Source (ODBC) tool, looks like it's setup OK. The database is showing the default database I'm wanting. Back to the drawing board on why I'm getting ODBC errors on my connection.

 

[SonOfEmidec1100]

Can you post your connection string.

 

[SQLBill]

What errors are you getting? Do you see any login errors in the SQL Server Error Log?

-SQLBill

Posting advice: FAQ481-4875