odbc drivers

modom46 · Unread post by **modom46** » Fri Aug 29, 2008 2:38 pm

Hi,

How would I find out if I have ODBC drivers on my server?

I have a client who wants to use Filemaker Pro and needs ODBC drivers to connect to the database.

I believe this are compiled with php but am unfamiliar with what needs to be done so he can use his Filemaker Pro program to upload product changes and such to his ecommerce store.

Any help is greatly appreciated.

Thank you!

Unread post by **scott** » Fri Aug 29, 2008 3:58 pm

These are the ones on C4:

unixODBC.i386 2.2.11-1.RHEL4.1 installed
unixODBC-devel.i386 2.2.11-1.RHEL4.1 installed
MyODBC.i386 2.50.39-25.RHEL4.1 base
freeradius-unixODBC.i386 1.0.1-3.RHEL4.5 base
php-odbc.i386 5.2.6-1.el4.art atomic
postgresql-odbc.i386 7.3-8.RHEL4.1 base
qt-ODBC.i386 1:3.3.3-13.RHEL4 base
unixODBC-kde.i386 2.2.11-1.RHEL4.1 base

modom46 · Unread post by **modom46** » Fri Aug 29, 2008 5:49 pm

Hi,

I have CentOS5.

How would I find out what drivers are installed on my machine?

breun · Unread post by **breun** » Sat Aug 30, 2008 6:31 am

Ask rpm.

Code: Select all

rpm -qa | grep -i odbc

modom46 · Unread post by **modom46** » Sat Aug 30, 2008 10:51 am

ok I don't have any so that settles that.

I just installed:
Installed: php-odbc.i386 0:5.1.6-20.el5_2.1
Dependency Installed: unixODBC.i386 0:2.2.11-7.1
Complete!

There is a listing in /etc/php.d/odbc.ini which has this:
; Enable odbc extension module
extension=odbc.so

In /etc/php.ini there is not a listing for the odbc.so ... is there suppose to be?

This is what is listed in /etc/php.ini:

Code: Select all

[ODBC]
;odbc.default_db    =  Not yet implemented
;odbc.default_user  =  Not yet implemented
;odbc.default_pw    =  Not yet implemented

; Allow or prevent persistent links.
odbc.allow_persistent = On

; Check that a connection is still valid before reuse.
odbc.check_persistent = On

; Maximum number of persistent links.  -1 means no limit.
odbc.max_persistent = -1

; Maximum number of links (persistent + non-persistent).  -1 means no limit.
odbc.max_links = -1

; Handling of LONG fields.  Returns number of bytes to variables.  0 means
; passthru.
odbc.defaultlrl = 4096

; Handling of binary data.  0 means passthru, 1 return as is, 2 convert to char.
; See the documentation on odbc_binmode and odbc_longreadlen for an explanation
; of uodbc.defaultlrl and uodbc.defaultbinmode
odbc.defaultbinmode = 1

Would this work for filemaker pro to connect to my client's store database?

breun · Unread post by **breun** » Sat Aug 30, 2008 10:56 am

Scott listed them above.

Unread post by **scott** » Tue Sep 02, 2008 10:44 am

yum list |grep -i odbc

modom46 · Unread post by **modom46** » Tue Sep 02, 2008 11:03 am

Hi,

Will the setup above I posted allow my client to connect to his store database with filemaker pro?

Unread post by **scott** » Tue Sep 02, 2008 11:46 am

Absolutely.. if I knew what Filemaker Pro actually was.

I assume it makes something. Perhaps files.