Hi Everyone
does anyone have experience of 'SQLConfigDataSource'.
I am trying to create SQL server data sources on the fly - but with
difficulty!
I have the following code :
****************
DECLARE INTEGER SQLConfigDataSource IN odbccp32.dll INTEGER,;
INTEGER, STRING, STRING
lcSettings = "SERVER=(local)" + CHR(0)+;
"DESCRIPTION=TAS SQL Data" + CHR(0)+;
"DSN=TASSQL" + CHR(0)+;
"DATABASE=master" + CHR(0)+;
"UID=sa" + CHR(0)+;
"PWD="
?SQLConfigDataSource(0,1,"SQL Server",lcSettings)
****************
SQLConfigDataSource is allways returning 0 (swear!curse!swear!and curse again!!).
There is no sa password on my Windows 98 PC, running SQL Server locally.
I have tried SERVER=HAL (my SQL server name), but still no joy.
If anyone could help I would be very grateful!
Thanks
Brigzy
Brigzy@msn.com