Hi,

Please i am unable to solve a connection problem with paradox.
I am using vb 6.0 and paradox 4.x. My OP system is windows 2000 professional

1) When I use this string which vb and delphi ADO connection gave me
Provider=MSDASQL.1;Persist Security Info=False;Data Source=testhier;Initial Catalog=D:\TESTHIER

This connection gives an error whenever i run my application for the first time. The error is [Microsoft][ODBC Paradox Driver] Selecting collating sequence not supported by the operating system.
So i have to close it and run it again and then it works.

2) So then i tried using a DSN less connection which is this.
Driver={Microsoft Paradox Driver (*.db)};DriverID=538;Fil=Paradox 4.X;DefaultDir=d:\testhier;Dbq=d:\testhier;CollatingSequence=ASCII;

This gives the error
[Microsoft][ODBC Driver Manager] Data source name not found
and no default driver specified.

Please tell what me to do. I am struggling to find the solution since last one week.
I would appreciate if you can help me out.

Thankyou very much for your time.

Regards
Rajiv