DB2 ODBC.ini questions - please help

From: Shannon Sumner (ssumner_at_countrycurtains.com)
Date: 03/24/04 

Date: Wed, 24 Mar 2004 09:03:52 -0500

Hello all,

I'm using Bryan Mills post located at
http://bryanmills.net:8086/archives/000099.html to connect PHP on my
Linux Server to an Access database located on my network. I'm having no
problems installing UnixODBC and MDBTools. I can get MDBTools to
connect to the database so I know it's not a network issue. I've
completed Bryan Mills installation steps word for word and yet have not
been able to get PHP to access the data. Here's the error I get:

odbc_connect(): SQL error: [IBM][CLI Driver] SQL1013N The database alias
name or database name "GAL" could not be found. SQLSTATE=42705 , SQL
state 08001 in SQLConnect in /home/mis/access.php on line 2

I'm convinced that since I have IBM DB2 Connect personal addition
installed on my server and use the PHP function odbc_connect to access
data on my AS400 that I cannot use this function to access databases of
another type. I'm also convinced that the DB2 Connect installation has
altered my system so that ODBC.ini no longer contains the information
about ODBC drivers.

Does anyone know how to fix this problem? Does anyone know what file
IBM DB2 connect uses to access it's database drivers? If I had this
information - perhaps I could alter this file as I would the ODBC.ini
and receive the correct data.

As you can see I'm totally lost. Any help would be appreciated.

Thanks,

Shannon Sumner

Relevant Pages

  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)
  • Re: Techniques for Vulneability discovery
    ... in mind) so i searched the net for some free database driven software and came ... the first thing i did was grab some info about PHP programming and some MySQL ... I did some more reasearch on different types of web based "input validation" ... PHP and SQL docs, etc.. ...
    (Vuln-Dev)
  • Re: Techniques for Vulneability discovery
    ... in mind) so i searched the net for some free database driven software and came ... the first thing i did was grab some info about PHP programming and some MySQL ... I did some more reasearch on different types of web based "input validation" ... PHP and SQL docs, etc.. ...
    (Security-Basics)
  • Re: MySQL and Mac OSX
    ... I have PHP installed on my Mac Tiger and it works fine. ... In my efforts to understand and work with a database, ... the installation of MySQL is successful? ... A database server (some sort of software that somehow stores ...
    (alt.php)
  • Re: CSS + xhtml static site - going dynamic?
    ... PHP then fills each content area. ... A better alternative is to have PHP pull the content off a database. ... management - menus and page linking need to be done by hand. ... So the second part is to formally build the linking structure into the ...
    (uk.net.web.authoring)