OPENROWSET in SP -- sql server odbc

Sue Hoegemeier
10/8/2003 10:09:58 AM

MSDTS is Microsoft Distributed Transaction Coordinator or
sometimes you will see it listed as just Distributed
Transaction Coordinator. You need to make sure this service
is running on server XJ. You can find it in the SQL Server
Services Manager or in the services applet on the server.

-Sue

On Wed, 8 Oct 2003 03:31:09 -0700, "xj"
[quoted text, click to view]

xj yian
10/11/2003 12:44:18 AM

yes , u are right, thanks man, actually my purpose is write a SP to link
up two different DB together, and i try to use the openrowset, and
because i need to pass in like user name, pwd into the SPs, so i need to
declare one varchar(300) to become the Query string, then use the exec
to get the information, but have some issue i cant use the Openrowset,
like i need to set ANSI_NULLS ON and etc, and also i cant use Tran, do u
have any simple example ? pls advise, thanks a lot.

*** Sent via Developersdex http://www.developersdex.com ***

Sue Hoegemeier
10/14/2003 5:45:22 PM

Could you post an example of what you are trying to do and
the errors you are getting?

-Sue

On Sat, 11 Oct 2003 00:44:18 -0700, xj yian
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server odbc

sql server odbc : OPENROWSET in SP