January 9, 2004 at 5:22 am
Dear all,
I have the following scenario:
- Centralized Database on MS SQL Server 2000
- Users work independently on their workstations using MSDE 2000
- Database was developed on the Central Server from where it got dettached and then attached on the MSDE instance of my users
- At some point the users need to connect to the Central Server and perform some kind of synchronization
- Front-End is VB6
I want to have a SP that will access tables on my remote server (SQL2K Server) and bring this data into my local tables (MSDE 2K) and vice versa.
I have tried using the OPENROWSET command which works fine in the case where both databases reside on MS SQL Server 2000 but it gives me the following error in my scenario (MS SQL Server 2000 & MSDE 2000):
Server: Msg 7405, Level 16, State 1, Line 1
Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query.
Any ideas on what I am doing wrong? Your help will be greatly appreciated.
Thanks,
Andreas
January 9, 2004 at 6:29 am
Try adding
;ANSINPW=OFF
to the OPENROWSET connection string.
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply