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.
| Author |
Topic |
|
majnoon
Starting Member
26 Posts |
 Posted - 2001-12-11 : 09:52:30
|
| Has anyone written SQL script that calls a COM object (VB or otherwise) and invokes one of its functions??I am having problems getting SQL2000 to query a linked Cache database, but I have found a work around by creating a COM object in VB which uses ADO to query the Cache database and having that object called from SQL. However I am having problems calling the object using the sp_OA... SPROCsAny help would be greatly appreciatedWishing you a peaceful journey |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2001-12-11 : 09:55:17
|
| Well, I'm assuming you search the site first. But just in case you didn't here's some articles that might be interesting for you:http://www.sqlteam.com/SearchResults.asp?SearchTerms=sp_oa===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
 |
|
|
majnoon
Starting Member
26 Posts |
Posted - 2001-12-11 : 10:00:14
|
Sorry about that, I was a little lazy, although I has started to search when your reply came in. Thanks before, during and after the fact and I hope to return the favourquote:
Well, I'm assuming you search the site first. But just in case you didn't here's some articles that might be interesting for you:http://www.sqlteam.com/SearchResults.asp?SearchTerms=sp_oa===============================================Creating tomorrow's legacy systems today.One crisis at a time.
Wishing you a peaceful journey |
|
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2001-12-11 : 10:46:10
|
| I know the FTP article and/or the support files for it shows you the method as it's written with VB and it's TSQL equivalent. I had trouble working that out at first myself. It gets easier with some practice, I promise.Mike "A program is a device used to convert data into error messages." |
|
|
|
|
|
|
COM