Using a .csv to create an ODBC connection.

5 pts.
Tags:
CSV file format
ODBC
odbc connection
wfhc halifax 1.2
I am using an ODBC drive to read a .cvs.dsn file and establish to folders where other .csv files are located and converted into .phb file. The software is WFHC Halifax version 1.2. . CSV file.

 [ODBC]DRIVER=Microsoft Text Driver (*.txt; *.csv)UID=admin UserCommitSync=YesThreads=3SafeTransactions=0PageTimeout=5MaxScanRows=8MaxBufferSize=2048FIL=textDriverId=27DefaultDir=P:FAXDBQ=P:FAX The problem is that this string on most machines will be converted to:

ODBC;DBQ=P:FAX;DefaultDir=P:;Driver={Microsoft Text Driver (*.txt; *.csv)};DriverId=27;FIL=text;FILEDSN=P:faxdominion.csv.dsn;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes; Witch points the correct locations of other .csv file.

 But on some machines it gets converted to: ODBC;DBQ=P:FAX;DefaultDir=P:FAX;Driver={Microsoft Text Driver (*.txt; )};DriverId=27;Extensions=txt,csv,tab,asc;FIL=text;FILEDSN=P:faxdominion.csv.dsn;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes;

 When this happens the software being used can’t find the location of the folder where the other .csv files are located. So the question is what causes the difference in the string. Thanks for any direction.



Software/Hardware used:
WFHC Halifax
ASKED: May 13, 2010  2:56 PM
UPDATED: May 13, 2010  4:55 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    Is it the DefaultDir difference what is causing the problem ? In the original file, DefaultDir is set to P:\FAX, so it is the first conversion (which works) the one that looks incorrect.
    65,110 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following