Subject | Error connecting to Firebird with VisualFOX via ODBC |
---|---|
Author | Elvinas Piliponis |
Post date | 2003-05-29T08:49:29Z |
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
I'm getting an error, complainin aboun invalid character at position
(number), where number is "." symbol position.
I've tried two ODBC drivers (XTG ar Firebid ISC), tried to change SQL
dialect. No effect :(
Is there any work around or have I to chose another DB?
MySQL works without any complaining but lacks stored procedures (this
woud be ) and triggers.
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
I'm getting an error, complainin aboun invalid character at position
(number), where number is "." symbol position.
I've tried two ODBC drivers (XTG ar Firebid ISC), tried to change SQL
dialect. No effect :(
Is there any work around or have I to chose another DB?
MySQL works without any complaining but lacks stored procedures (this
woud be ) and triggers.