Okay, in my ASP, I need to write one SQL statement that brings back data from two separate databases (not two tables in the same database). My connect statements are:
Set objRS2 = Server.CreateObject("ADODB.Recordset"😉
Set objConn2 = Server.CreateObject("ADODB.Connection"😉
strConnection2="Driver={SQL Server};Server=Maverick;Database=salesreports;;UID=sa"
objConn2.Open strConnection2
However, I want to connect to another database called 'location' and then bring back data values from both databases where the value in field A in 'sales reports' equals the value in field B in 'location'. Anyone know how to change the strConnection2 statement above to accomodate for two separate databases???? Please help!
Set objRS2 = Server.CreateObject("ADODB.Recordset"😉
Set objConn2 = Server.CreateObject("ADODB.Connection"😉
strConnection2="Driver={SQL Server};Server=Maverick;Database=salesreports;;UID=sa"
objConn2.Open strConnection2
However, I want to connect to another database called 'location' and then bring back data values from both databases where the value in field A in 'sales reports' equals the value in field B in 'location'. Anyone know how to change the strConnection2 statement above to accomodate for two separate databases???? Please help!
