ODBC Connection to Paradox DB problem

Adam

Oct 6 2009 11:03 AM

14.4k

Environment: Microsoft Visual C# 2008 Express Edition

Windows Edition: Vista

I'm trying to connect to a Paradox DB using ODBC. The connection string I am using is:-

string sConn= "Driver={Microsoft Paradox Driver(*.db )};DriverID=538;Fil=Paradox 5.X;DefaultDir=" +sPath+ ";Data Source=" +sPath+ ";CollatingSequence=ASCII;";

However, when trying to execute the above connection string I receive the following error:-

"ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"

I have done a lot of trawling through the net and haven't been able to find a solution to the problem. Can anyone please provide any info on how to solve this?

Thanks