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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-03-22 : 08:41:02
|
| jackie writes "the problem:how to pass the string parameter in SP to DLL? we want stored procedure in sql server communicate with outer process.we have create a dll and revelant stored procedure-sp_socketdll in sql server. in SP,A parameter whose type is char* should be pass to thedll,sql-server only use char() and varchar() in SP.we can't pass the parameter like char*.in ISQLW tools,we try commande.g. exec sp_socketdll '12345' or sp_socketdll "123456". Thereall exist problems.I think the problem is about type coverting. but don't konw the way to slove. The function of dll we create is call socket pass some date.the dll is right, we have proved in other parogramm used BCB an VC." |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-03-22 : 19:29:47
|
| Not really sure what you are asking??BOL describes the type conversion behavior for OLE automation.Check out "Data Type Conversions Using OLE Automation Stored Procedures" in BOL |
 |
|
|
|
|
|
call dll in sp?