which column(s) isn't found? Would it happen to be any of the columns
you're using a function on? I ask because aliasing those might help.
I can confirm that passing the full db name will work with ASP through a
recordset. I've set them up like this:
Set objConnRead = Server.CreateObject("ADODB.Connection")
objConnRead.ConnectionString = "...connection string to one of the
db's..."
objConnRead.Open
Set objRS = Server.CreateObject("ADODB.Recordset")
strSQL = "...fully qualified sql string..."
objRS.Open strSQL, objConnRead
Just need to make sure the user has read access to the selected tables
on both.
Kathy Mazur Worden
Senior Associate Web Services
Prairie Area Library System
________________________________
From: brent [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 08, 2006 9:58 AM
To: Mazur Worden, Kathy
Cc: mysql@lists.mysql.com
Subject: Re: Query two databases
Mazur Worden, Kathy wrote:
I've had success using the fully qualified db, table and
column name in
a single query like yours below. Have you tried sending
strSQLCombo
through either strConnProd or strConnSales already?
K. Mazur Worden
I was afraid that wouldn't work. Got the old: Item cannot be
found in the collection corresponding to the requested name or ordinal.
But it was worth a shot...
Thanks for the suggestion.
