Search results for query: *

sorted out:) I have found a way to join two data sources in one Statement, I used OPENROWSET query from MS SQL Server 2000. in my example: Dim MyCommand AsNew SQLCommand("SELECT T1.Col1,T2.Col4 FROM T2, OPENROWSET('Microsoft.Jet.OLEDB.4.0',' C:\Database1.mdb";;, T1) as T1 WHERE T1.Col1...

I am tying to build a COMMAND that joins two tables from two different databases, one database is stored in SQL Server, the other one is stored in MS Access, the problem is I can not make the SQL statement in one command, since the connections are different. Example: Dim MyCommand AsNew...