>>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]
Mark McCasland
Midlothian, TX USA