>>>>Hi,
>>>>
>>>>How can i register a ODBC?(Control Panel ODBC)
>>>>
>>>>Thanks
>>>>Bye,
>>>
>>>An ODBC driver or DSN? Creating an ODBC DSN I can help with. An ODBC driver is usually installed with an install program that comes with the driver. Other than that, you would have to look in the registery to see what a typical one looks like.
>>
>>I need to create a System DSN manually through code.
>>Any Help?
>>
>>Thanks :>
>
>See my article in KB (purple book): Articles, Client/Server
>
>This will give you the API code to do this in VFP.
I tried what the article was saying but have a little problem,
If i try this code :
lcSettings = "DSN=New"+CHR(0)+;
"Description=New Driver"+CHR(0)+;
"Server=SALSA"+CHR(0)+;
"DefaultDatabase=SALSADB"+CHR(0)+;
"UID=username"+CHR(0)+;
"PWD=password"
DECLARE Integer SQLConfigDataSource IN ODBCCP32 Integer,Integer,String,String
? SQLConfigDataSource(0,4,"SQL Server",lcSettings)
It returns 0 and the SYSYEM DSN is not created
If i try this code :
lcSettings = "DSN=New"+CHR(0)+;
"Description=New Driver"+CHR(0)+;
"Server=SALSA"
DECLARE Integer SQLConfigDataSource IN ODBCCP32 Integer,Integer,String,String
? SQLConfigDataSource(0,4,"SQL Server",lcSettings)
It returns 1 and the SYSYEM DSN is created
I need to specify the Database of SQL.
In the sysem registry if i create it manually it save the Keyword 'Database' with 'SalsaDB'
Any ideas?
Nick,
Thanks
Where
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only