On 20-Apr-2006 Simon Windsor wrote: > Hi > > I have been asked to add a few reports using data from several Solid > databases to a Solaris Webserver that I manage. > > I have access to Solid SDK 3.7FE and 4.5. > > I have checked DBD::Solid and it does not appear to support versions > greater than 3.5. > > I have tried unixODBC and DBD::ODBC, but I keep getting > > [IM002][unixODBC][Driver Manager]Data source name not found > [ISQL]ERROR: Could not SQLConnect > > Can anyone provide any help/advice on how to get DBD::Solid working for > 3.7Fe, or on configuring unixODBC(odbcinst.ini ?). > > All the best > > Simon > > ps Sorry this is slightly off topic >
What does odbcinst -j output? How have you added a solid entry to your odbcinst.ini file and where is your odbcinst.ini file? Where is your odbc.ini file and what does it look like? Instead of using Perl, why not just run: isql -v my_dsn_name my_username my_password (it will be easier to diagnose the problem). Have you set and exported LD_LIBRARY_PATH such that any shared objects required by the shared object named in Driver = xxx in your odbcinst.ini file are found. What does ldd on the shared object named by Driver = xxx report? Martin -- Martin J. Evans Easysoft Ltd, UK http://www.easysoft.com
