vb paradox connection string problem

[rajivg]

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

[Hack]

Have you tried the Paradox web site, or MSDN?

[rajivg]

Hack,

I did try on the msdn but not much information available.
I have tried extensive search on google too but no solution.

2) Now that my vb dll code is over. I try run one of my application tools, its just takes too much of time just to open an file.

For eg. First I import a existing xml file into the paradox database.
Then i try to open the database from an hierarchy interface tool. The file is 2300Kb. When i try to open its just taking too much of a time. I did it smaller files and it opens up quiet neatly.

Please can u suggest what can i do. I have indexes on all the tables.

thanks your advise but please i have to sort this problem asap.

rajiv