ODBC connection to Foxpro

[dsqspro]

Can some one help me with connecting FoxPro dbf files on windows server from DataStage on UNIX with ODBC stage

and work with .odbc.ini and uvodbc.config

[dsqspro]

Hi,
I was able to successfully read data from sample file on local machine.

But not able to connect to remote server file location.

Before I try connecting Windows server, I am trying to connect to another UNIX box.

Code for .odbc.ini:
[dBase]
QEWSD=39906
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMdbf22.so
Description=DataDirect dBaseFile(*.dbf) Driver
ApplicationUsingThreads=1
CacheSize=4
CreateType=dBASE5
Database=/IP/User_Name/Passwd/tmp/Test_ODBC IntlSort=0
Locking=RECORD
UseLongNames=0
UseLongQualifiers=
DataFileExtension=DBF
ExtensionCase=UPPER
FileOpenCache=0
LockCompatibility=dBASE

Please let me know the highlighted is correct

[chulett]

I don't know FoxPro but I sincerely doubt that is correct. Database is just typically the name itself and shouldn't contain any user/password info if that's what you are doing - that would come as part of the stage setup, the credentials needed to make that connection at runtime.

[Mike]

Since dbase is a file-based database and not a database server, I would doubt that you can access it remotely. You'll probably have to mount the remote file system using NFS, Samba, or similar so that it appears to be local.

Mike

[chulett]

Ah, yes... so basically just a ".dbf" file, if I recall correctly?

[nasimul]

How can I read the .dbf files even though it's placed on DataStage server? Don't I need to create DSN? If so, how? Please suggest.

[nasimul]

Hi - Can you please suggest how read .dbf files placed on local machine thru datastage? I am unable read the file through ODBC because we are not going to deal with Foxpro database. Only .dbf files would be transferred to DataStage server and we need to read them.

Please help. It's urgent!

[ray.wurlod]

If it's urgent sign up with your official support provider for priority service.

DSXchange is an all-volunteer site whose members post as and when they can.

[chulett]

Those "dbf" files are the database.

[nasimul]

Thanks Craig.