|
|
|
|
Ghost in the data source?
Hi All
This is a strange one, but hopefully you will know why.
Basically we use an ODBC connection for our program to connect to SQL
database - nothing more sinister as that.
However what seems to happen from time to time is that even though we
haven't touched the ODBC data source since it's conception, the Default
Database checkbox becomes checked and a database is set. By default, we
leave this parameter unchecked and send our database, username and password
through our app.
This causes confusion in our app, because we sometimes get a login failed
message back and find that because the ODBC has it's own database setting it
is trying to log into a completely different DB to the one that we have
entered in our app. Luckily the login details are different for each db so
this stops us from working with the wrong DB.
Do you know why this does this (we use WinXP Pro, Win2003 Server and Win2000
Server) and how we can stop it from happening?
Thanks
Robbie
Tue, 11 Jan 2005 14:10:24 -0000
"Astra"
|
|