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 |
|
alexg
Starting Member
2 Posts |
 Posted - 2002-06-14 : 08:29:59
|
| Hello!Does anybody know how to send a recordset to an external function in DLL from T-SQL script? And how to recieve it from an external function to update a table?Is it possible to open a table(s) from the external function to fetch data?I will appreciate any info and links.Thank you! |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2002-06-14 : 08:32:21
|
| Yes, it is possible...Which language did you have in mind for developing under?PeaceRick |
 |
|
|
alexg
Starting Member
2 Posts |
Posted - 2002-06-14 : 09:02:09
|
quote:
Which language did you have in mind for developing under?
Visual C++ 6.0, SQL Server 7.0Thank you! |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-06-14 : 13:42:00
|
| I have not used Visual C++, so I can't give you specific syntax, but the idea is to use ADO / OLE-DB to issue commands from your dll to the SQL Server to retrieve / update data or better yet, to call SQL Stored Procedures to retrieve / update data.In VB, you would start out by defining and instantiating ADODB.Connection and ADODB.RecordSet objects.HTHEdited by - AjarnMark on 06/14/2002 13:42:55 |
|
|
|
|
|
|
OLE Automation - passing datasets in and out