SQLDMO connects to the wrong database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Maer" <maer@xxxxxxxxxxxxxxxxx>
Date: Thu, 29 Jun 2006 17:30:24 -0400

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

.

Prev by Date: Re: Create SQL 2000 user accounts with a script
Next by Date: Re: Create SQL 2000 user accounts with a script
Previous by thread: Re: Create SQL 2000 user accounts with a script
Next by thread: Cursor type changed?
Index(es):
- Date
- Thread

Relevant Pages

Re: ADO Connection Timeout
... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
(microsoft.public.data.ado)
Complicated Connection Problems bewteen ADP and SQL Server
... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
(microsoft.public.access.adp.sqlserver)
Complicated Connection Problem between ADP and SQL Server
... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
(microsoft.public.sqlserver.connect)
Re: ADO Connection Timeout
... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
(microsoft.public.data.ado)
Re: ADO Connection Timeout
... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
(microsoft.public.data.ado)