forum.vdsworld.com

X-Tools

Hi,

does somebody know how to setup a dbf (dbase) connection and how to query such files through vdsdb.dll ?

I know Windows has a DSN for Dbase, but I dont know how to setup it

db setup,"Microsoft dBase Driver (*.dbf)",DSN=netfax,UID=admin,PWD=,DataDirectory=,DBQ=

And how do I have to query such files. As I know they have only one table in a file, so select * from .... should not work ???

Thanks for your help.

Bye, Fabian

X-Tools · Posted: Sun Mar 14, 2004 9:28 am Post subject:

I found some documentation on the web

http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForDBASE

http://www.winscripter.com/WSH/Database/66.aspx

Now I know how to setup and how to query dbase (select * from filename.dbf), but I get error 27 on the query line. The errormessage from @db(error) looks like some numeric characters and a "|" sign.

Vic D'Elfant · Posted: Sun Mar 14, 2004 12:01 pm Post subject:

You mean an error message like this: '|234234234' ?
If so, than it will probably be a VDS error, or some kind of an error which vdsdb.dll can't handle. You could try removing the errortrap, and running the code again (or removing the errortrap just before you call that query)

Regards,
Vic

X-Tools · Posted: Sun Mar 14, 2004 3:37 pm Post subject:

Hi Vic,

yes. I am talking about such an error. If I remove the errortrap there is still an error on the line select * from file.dbf

Do you know what the problem is ?

Vic D'Elfant · Posted: Sun Mar 14, 2004 8:16 pm Post subject:

Hmm... there could be a problem with that dbf driver, you could send Tommy a PM. Perhaps he can help you.

But it's strange that you have to call a query like 'SELECT * FROM <database name>. Usually this should be 'SELECT * FROM <table>' Confused

Regards,
Vic