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 = ODBC for PostgreSQL 8 Driver = /usr/lib/libodbcpsql.so 9 Setup = /usr/lib/libodbcpsqlS.so 10 FileUsage = 1 11 12 13 # Driver from the MyODBC package 14 # Setup from the unixODBC package 15 #[MySQL] 16 #Description = ODBC for MySQL 17 #Driver = /usr/lib/libmyodbc.so 18 #Setup = /usr/lib/libodbcmyS.so 19 #FileUsage = 1 Thanks, Marc
