SQLDMO connects to the wrong database -- sql server connect

Maer
6/29/2006 5:30:24 PM

Hi guys - I am not sure if this is the news group I should be writing
to, but I have been having a weird connection problem with an application
that I wrote in SQLDMO when it tries to access the server.

The server has several databases and my application tries to connect to
the "MyAppDatabase." However periodically, the connection fails because
apparently ODBC tries to connect to a database called "OnCall." However, the
application has no information on this particular database and no reason to
connect to it. Connection fails because the user does not have permission to
it, but the problem is that it should not be trying to connect to that
database in the first place.

What is puzzling is that it comes and goes with no apparent pattern. We
made sure that the database was present nothing seems to be wrong with the
server.

Any ideas?

Any help will be greatly appreciated.

Maer

Gert E.R. Drapers
8/1/2006 6:38:54 PM

What is the default database for the user logging in?
GertD@SQLDev.Net

[quoted text, click to view]

sql server connect : SQLDMO connects to the wrong database