Board index » delphi » Problem querying a linked SQL Server through ADO
Jeff Burgoon
![]() Delphi Developer |
Sat, 17 Jul 2004 23:51:54 GMT
Problem querying a linked SQL Server through ADO
I have one SQL Server Database (dbA) which links to another (dbB). This
link works just fine with query analyzer. However I am having a problem utilizing this link from a delphi program. I create an ADO connection to dbA and then create a query which pulls data from dbB in the form select * from [ServerName].[dbB].[user].[tablename] This query works perfectly in query analyzer. I can connect to dbA and run Access violation at address XXXXXXXX in module 'MSVCRT.DLL'. Read of Then I figured maybe ADO was having a problem interpreting the link so I |