Using linked servers in SQL 2000 for some reason changes the commit mode
when doing an INSERT or UPDATE. That means that journaling needs to be
active on the tables that I am access on the 400. The 400 people have
said no. If I do a straight ODBC connection, not through linked
servers, everything works flawlessly.
From SQL server, what is the best means of utilizing ODBC to issue an
INSERT to our 400 WITHOUT using Linked Servers?
DTS works, but doesnt seem to be the answer. Is it possible to open an
ODBC connection in a stored procedure?
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!See "Openrowset" in Books Online.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Will that type of connection support distributed transactions (commit, rollb
ack)?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment