Ah, thank you VERY much, it works! I think I would never had found out
about this! With your help I spent "only" one week.
Thanks and bye,
Tibor
Nuno Canas wrote:
Hi Tibor,
I think you are working at the same error level I was.
For me it was not well explained and I spent about two weeks hitting on
the same error.
In Cache you have "cacheodbc.ini"
Every odbc package for *nix you have to configure /etc/odbc.ini or some
file in /usr/local. It's writen in every document (Not in Cache case -
The error is there)
So, go to your CACHE_DIR, edit cacheodbc.ini and put there the
connection you need.
For example, in my case to connect to MySql
[SHM]
Driver = /usr/local/lib/libmyodbc3.so
Description = Connector/ODBC 3.51 Driver DSN
SERVER = orion
PORT =
USER = root
Password =
Database = SHM
OPTION = 3
SOCKET =
And It's working.
No need to setup @ /etc level files.
Regards
Nuno
Tibor Dekany wrote:
Hi all
I'm running Cache on a Linux Server, where I should be able to connect
to another database table. I'd like to link that table with the Cache
SQLManager.
I tried 2 ODBC drivers, one is an ODBC2ODBC Bridge and the other is
MDBtools which can read MS Access files under Linux.
I added both ODBC DSN's in the Cache Configuration Manager to the
SQLGateway. Then I tried to create the link with the SQLManager:
Filemenu: link table: the list with both connection appears. But then,
when I select one, just an error appears:
Error #5532 Connection Error!
Now what can I do? I have no idea where to search for the error.
Thank you
Tibor
