Subject Re: [ib-support] Error connecting to Firebird with VisualFOX via ODBC
Author Elvinas Piliponis
Daniel Rail wrote:


>
> 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

I've tried to create a Remote SQL view and VisualFOX generates
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