Subject | Re: [ib-support] Error connecting to Firebird with VisualFOX via ODBC |
---|---|
Author | Elvinas Piliponis |
Post date | 2003-05-29T12:23:51Z |
Daniel Rail wrote:
statement by itself, i.e. adds "DB_name." in front
(Connection test is successful. SQL view wizard gets Table list
successfully)
So it looks like incompatibility between VFP and FB. At least via ODBC
>I've tried to create a Remote SQL view and VisualFOX generates
> And, how is the query generated. All I found in VisualFOX
> documentation on MSDN, was a reference that the DB_name is used if you
> want the query to use a non-current database. So, I would suggest not
statement by itself, i.e. adds "DB_name." in front
(Connection test is successful. SQL view wizard gets Table list
successfully)
So it looks like incompatibility between VFP and FB. At least via ODBC