It turns out there was a couple of new reports written that had USE Banana in
the query. With that and Maintain connections across client requests enabled
in the CF Admin, we were magically swapping what the DSN pointed to.
Thanks again for the help.
-Matt
Is the problem random or
Basics: Windows 2003 server, CF 7.0.2, SQL Server 8
Multiple datasources, but lets specifically look at the ones named Apple and
Banana. They point to separate databases on the same SQL server, connecting to
db Apple and db Banana respectively, as expected. However, occasionally,
datasource
Is the problem random or reproducible? Is dbBanana used anywhere by the Web
site, or should that database not be used at all? If it should not be used
at all, do a site-wide search for dbBanana to make sure it does not show up
anywhere in the code. Are the two databases allowed to talk to each
Never happened to me. I think this setup is very common (having a
single SQLSERVER, and creating multiple DSNs to different databases),
someone would have run into it.
Try dumping SELECT @@SERVERNAME, DB_NAME() to see if you really are
connected to the correct DB
Do you have code that do
Is the problem random or reproducible?
Random, but when it happens, it seems to stay that way for a while. A CF
service restart will correct it for a while.
Is dbBanana used anywhere by the Web
site, or should that database not be used at all?
It is used. Both are used by the site with the
Is the problem random or reproducible?
Random, but when it happens, it seems to stay that way for a while. A CF
service restart will correct it for a while.
This behavior is consistent with a connection in the database connection
pool switching active databases. There might be one
6 matches
Mail list logo