Information générale
Titre:
ODBC connectivity error: Firebird and VFP
Versions des environnements
Network:
Windows 2003 Server
I'm not quite sure where to post this message. So, if this seems like the wrong place, please suggest an alternative.
I am getting a very strange error.
I am attempting to use the VFP 9 View Designer to create a view into a Firebird database.
The Firebird database is on my computer, the same computer where I am running the VFP View designer.
I am accessing the Firebird database using Firebird ODBC driver.
I can use the FlameRobin utility to connect to the Firebird database through the ODBC data source without any problems.
In VFP9, I try to create a new view. I select the ODBC data source that I have set up to connect to the Firebird database. The View Designer presents me with a list of tables in the Firebird database. Regardless of which table I select, and click the Add button, I get the same error message:
Connectivity error: [ODBC Firebird Driver][Firebird]Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 21
What is particularly odd about this error is that it is the same error that I got a few months ago when I first started working on this project. Turns out one of the Firebird tables used a UDF call in the definition of its column 21. Once I made sure that that UDF was available, this error went away.
It is almost like this problem is cached somewhere. I tried rebooting the computer, but the problem persists.
Incidentally, if I use the CREATE SQL VIEW command in the command window, I can create a view of the Firebird database without a problem.
Thanks in advance for your help.
Jim
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement