Can you tell me what OS and Version as well as Cache Version you are running ?
What do you realy want to do ?
- Access a Cache Database using iodbc ?
- Access another Database (oracle, sybase, mysql) from Cach� ?
For Linux (Redhat and Fedora) you have a file to configure where to search for shared libraries.
Some ODBC drivers use their own shared libraries and they are not installed in the common directories where the system searches.
You can edit /etc/ld.so.conf and add a line with the path for the shared libraries you want to search.
Be aware about what file Cach� uses to access ODBC. Cach� uses <cacheroot>/mgr/cacheodbc.ini You don't need to setup at /etc/odbc.ini nor /etc/odbcinst.ini
I hope this can help, but the information on top is a MUST for consistent help.
Regard, Nuno
Mike Baker wrote:
Thanks I'll give this a try.
The other links were not very helpful since they seemed to be more geared toward iODBC which in this case won't work for me but does work on my system.
Mike "Nick Gorham" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
Nuno Canas wrote:
Mike and All,
I can't realy remember how many times most of the people reading this newsgroup answered the same way I will now !? But the answer is: 1- First look at a very good tool that is available from Peter Cooper http://www.xiscsp.co.uk/ngp/ 2- Other good source is http://www.mgateway.com/utility.htm
I'm sure that the answer for your question is in both of these sites.
Nuno
Mike Baker wrote:
I am trying to setup unixODBC to use the libcacheodbcw.so file but I don't know what I should use for the setup file. the documentation says to
ask
for help from intersystems. Anyway there was a template for setting this up in the cacheroot/dev/odbc/redist/unixodbc and it shows the driver and setup files being libcacheodbc.so. I have tried this also and still get a error of "could not construct a property list for (Intersystems ODBC)". Could I get some help with this please?
Hi,
AFAIK, there isn't a setup lib, so the ODBCConfig tool won't beable to create a GUI setup. If the cache folk want to tell me what values can go in the ini file I could put together a simple one.
Failing that, edit the odbc.ini file by hand to install the driver info.
For example.
odbcinst.ini
[CACHE] Driver = /home/cache/bin/libcacheodbc.so FileUsage = 1 DontDLClose = 1 UsageCount = 1
odbc.ini
[cache] Driver = CACHE Description = Cache 5.0 ODBC driver Host = localhost Namespace = SAMPLES UID = _SYSTEM Password = SYS Port = 1972 Protocol = TCP Query Timeout = 1 Static Cursors = 0 Trace = off TraceFile = odbctrace.log
-- Nick Gorham Easysoft Limited
