COM DLL ACCESSING FROM MSSQL
Posted on 2006-04-06
I wrote COM DLL(test.dll) using VC++ 6 to communicate with WAS.
If i invoke functions in COM DLL ( test.dll) using Visual Basic application , No issues everything is working fine
if i invoke the same functions in MSSQL using Stored Procedure - not working.
In VB defining variables as String
in SQL defining varibales as Varchar
In COM DLL - function ( BSTR, BSTR , BSTR) - using BSTR and converting them internally char * and working , return type BSTR( converting Back). i am using W2A function to convert BSTR to Char *.
COM DLL is compiled with _MBCS in settings options.
Any Ideas ?