Hi,

At May 29, 2003, 05:49, Elvinas Piliponis wrote:

> Hello,

> i've decided to change some production account sofware platform from
> VisualFOX DB to SQL server. I've had some experience with InterBase so
> i'bve decided to choose FireBird.

> Unfortunately Firebird refuses to accept connection From VisualFOX
> VisualFOX connects to table in such way:
> select * from DB_name.Table_name

With Firebird, you can't use the DB_name in the statements. Your
statement should be:
select * from Table_name

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
to try to do cross-database queries.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)