Problem with ODBC connection

[Jackson86]

Hello. I'm trying to get connection to dBase file by using ODBC. I'm trying to use code like this: CDatabase cdb; cdb.OpenEx( _T("DBQ=F:\\database\\a.dbf;DefaultDir=F:\\database\\;DRIVER=Microsoft dBASE Driver (*.dbf);DriverId=533;MaxBufferSize=2048;PageTimeout=5;")); But i get message: string F:\database\a.dbf is an invalid path. But this file exactly exists!!! I'm using Visual Studio 2005. How should I solve the problem please?

[led mike]

Create a DSN in the ODBC Data Source Administrator. That way you can create the connection settings and test it right there.

led mike

[Mark Salsbery]

It looks like the smiley-face-tongue-sticking-out may be the problem. Otherwise, what led mike said. Mark

[David Crow]

It's just a guess, but do you need to put ODBC; before DBQ?

---

"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15

"Judge not by the eye but by the heart." - Native American Proverb

[David Leyva]

Hi Only for test purposes try to change the location. I guess that file is in a network path. Regards David Leyva

[Hamid Taebi]

did you create a DSN ?

---

WhiteSky

---

[Jackson86]

No. If I will create DSN, will my application run at the other computer?

[David Crow]

Jackson86 wrote:

...the other computer?

What other computer?

---

"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15

"Judge not by the eye but by the heart." - Native American Proverb

[Jackson86]

I meant that, if i will create my DSN in ODBC Administrator in my computer, I sure that in another computer will be another DSN. Bu t I've already done with my problem. I got ODBC connection,using connection string. I understood my error. It's necessary after "DBQ=" in connection string to write path of folder, not of file.

[David Crow]

Jackson86 wrote:

It's necessary after "DBQ=" in connection string to write path of folder, not of file.

That must be a dBase thing. I used the following for a DSN-less connection to an Access database:

"ODBC;Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\somefolder\\dataaccess\\ADO\\nwind.mdb;"

---

"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15

"Judge not by the eye but by the heart." - Native American Proverb

[Jackson86]

Yes, you are right. It's dBase thing. But it was main problem for me. ODBC interprets dBase database as folder, where dbf files are located, and dbf files as tables of this database.