Hello Jose,


I would suggest you to define two DSN for two diffrent databases. You can use following function to create DSN from VFP's program.

I did it for oracle but not tried for Paradox. You may find some changes in paramters.

DECLARE Integer SQLConfigDataSource in odbccp32.dll ;
Integer, Integer, String, String
settings="DSN=My Oracle DB"+chr(0)+;
"Description=Oracle 73 Test"+chr(0)+;
"Server=MyDbName"
clear
Success=SQLConfigDataSource(0,1,"Oracle73",settings)
?
? success

The another way of doing is creating File DSN, which creates .dsn file under
Program Files\Common Files\Odbc\Data Source. you can simply copy this file on to the target machine under the same directory.

Bye
Jayesh



>Hi Jayesh
>It works!!!, thanks for your help.
>
>I have another questions for you.
>
>If I had two directories on the server with paradox files, Should I define two DSN for each directory, or Could I change the directory via foxpro???
>
>How can I define the DSN automatically when I install the application program?
>
>Bye
>José...
>
>>Hello Jose,
>>
>> Go to Start-Control Panel-32-bit ODBC Admin.
>>and define a DSN (Data Source Name) based on Paradox ODBC driver. Pardox ODBC driver is installed with VFP. You just have to create a DSN of that driver.
>>After creating DSN,connect to it using SQLCONNECT() function in VFP. see help of
>>SQLCONNECT() for more details.
>>
>>Bye
>>Jayesh
>>
>>
>>
>>>Hi Jayesh,
>>>I've never used the ODBC driver before, could you tell me where can I get more help about how to do this?
>>>
>>>Thank you
>>>Jose...
>>>
>>>>Hi Jose,
>>>>
>>>> I think you need ODBC driver for Paradox. Create Paradox DSN and use it to create remote views in VFP.
>>>>
>>>>Bye
>>>>Jayesh
>>>>
>>>>>I need to access a Paradox Database from an Accounts Payable Package, I have used Microsoft Access to make some queries and reports and it works finel, but now, I'm making an interfase between the accounts Payable package and a Visual Foxpro's Purchase Orders system. Could any one help me???, Where can I get Help???
>>>>>(I need read and write on this table). Please
>>>>>
>>>>>
>>>>>Thank you....
>>>>>José...