Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 ODBC call to external DB from within Stored Proc

Author  Topic 

jns
Starting Member

19 Posts

Posted - 2002-02-25 : 14:52:46
I have a situation where we have one db in SQL 2000 and another in mySQL on a remote server. Is it possible to perform an ODBC call to the mySQL database from within the Stored Procedure? If so, how?

Thanks

yakoo
Constraint Violating Yak Guru

312 Posts

Posted - 2002-02-25 : 14:55:41
Look in BOL under OPENROWSET

Go to Top of Page

jns
Starting Member

19 Posts

Posted - 2002-02-25 : 15:05:21
Very cool, thanks

Go to Top of Page
   

- Advertisement -