>>>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?
>>
>Try including it exactly how it is registered. e.g., "Server=SalsaDB Database" [if I interpretted your message correctly]
In the registry it is saved as "Database=SalsaDB"
I tried this but not luck. I am using ODBC 3.0, does this matter?