php and ODBC

php and ODBC

am 04.09.2009 19:37:21 von Marc Fromm

--_000_B0D7C0A3F35FE144A70312D086CBCA9B03A8B888AEExchMailbox 2u_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I am trying to figure out how to use ODBC with PHP.
Specifically I need to connect a php script to a SunGard Banner table
I know I need to set up some type of DNS connection, but I am not sure what=
exactly that is.

[root@dev ~]$ odbcinst -j
unixODBC 2.2.11
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
USER DATA SOURCES..: /root/.odbc.ini

/etc/odbcinst.ini
1 # Example driver definitinions
2 #
3 #
4
5 # Included in the unixODBC package
6 [PostgreSQL]
7 Description =3D ODBC for PostgreSQL
8 Driver =3D /usr/lib/libodbcpsql.so
9 Setup =3D /usr/lib/libodbcpsqlS.so
10 FileUsage =3D 1
11
12
13 # Driver from the MyODBC package
14 # Setup from the unixODBC package
15 #[MySQL]
16 #Description =3D ODBC for MySQL
17 #Driver =3D /usr/lib/libmyodbc.so
18 #Setup =3D /usr/lib/libodbcmyS.so
19 #FileUsage =3D 1

Thanks,

Marc


--_000_B0D7C0A3F35FE144A70312D086CBCA9B03A8B888AEExchMailbox 2u_--