Tibor,
I think I had post this matter before. Never forget to look @ http://www.xiscsp.co.uk/ngp/
If you had search the bodies for "odbc.ini" you would get the thread: MySQL access from Cache on Solaris.
It's there too.
Nuno
Tibor Dekany wrote:
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
