php and odbc

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
mrmr
Forum Newbie
Posts: 1
Joined: Fri Feb 14, 2003 4:34 am

php and odbc

Post 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
User avatar
Stoker
Forum Regular
Posts: 782
Joined: Thu Jan 23, 2003 9:45 pm
Location: SWNY
Contact:

Post 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..
Post Reply