php and ODBC
| From: | Marc Fromm | Date: | Fri, 04 Sep 2009 17:37:21 +0000 |
| Subject: | php and ODBC | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-297684@lists.php.net to get a copy of this message | ||
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