Page 1 of 1

php and odbc

Posted: Fri Feb 14, 2003 4:34 am
by mrmr
Hi,

I'm trying to connect from PHP to a database via a ODBC driver.
I got confused from the manual they are speaking about normal ODBC and unified ODBC. 8O

When I'm trying to do a odbc_connect ("thedsn"); I get a pop up window from the odbc driver "connection failed because you attempted a a DSN less connection ...". When I'm giving the dsnless connection string to odbc_connect it also goes wrong.

My questions are: :?:
1. Can you connect to any ODBC driver from PHP?
2. What's the difference between normal ODBC and unified ODBC?
3. Has anybody a sollution for me (except for using iODBC, I'm not going to pay $650+ for a ODBC driver)?

I'm trying to connect to a pervasive database on a PC with Win2k, php4.3.0 and IIS5.0.

Thanx for all your answers,
Marcel Rokers

Posted: Fri Feb 14, 2003 11:02 am
by Stoker
iODBC is a driver manager, and you need a driver manager to do odbc connections.. ANother option is UnixODBC, but that won't help much as far as the driver goes, you still need a driver for whichever database you are using..

As far as I know iODBC is free? You may be refering to the openlink drivers? Some of the openlink drivers are free, or at least they used to be, I am running a setup here with UnixODBC, Openlink Generic Driver and PHP. I am using ODBC to ODBC bridge to a Bill Gates server where I run the Opelink request broker.. It all works pretty good for what I am doing here, som read only stuff..

However as I have mentioned in another thread before, this setup towards an Access fil with the MS-Jet stuff or whatever Steve Ballmer calls it is not work very well in write operations.. According to the PHP manual they support iODBC, there is no mention of UnixODBC so I assume this could be part of the cause..