Re: - dsn-less connections?

Liam Hoekenga wrote:
> I'm trying to get PHP working with UnixODBC w/ DSN-less connection 
> strings.  Acc'd to the information I've found, it looks like that's at 
> least partially dependent on the ODBC manager.  I'm not overly familiar 
> with ODBC, so it's completely possible that I'm doing things wrong..
>
> The PHP website has an example of a DSN-less connection string, which I 
> /think/ is probably meant for a windows box...
>
>     DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=/path/to/file.mdb
>
> I'm guessing that "Microsoft Access Driver..." is maybe the section 
> header from odbcinst.ini, but that doesn't appear to be the case.  My 
> odbcinst.ini looks like:
>
>     [MSAccess]
>     Description             = Read only access to MS Access files
>     Driver          = /usr/local/mdbtools/lib/libmdbodbc.so
>     FileUsage               = 1
>
> My odbc.ini looks like...
>
>     [Northwind]
>     Description = Northwind Sample Database
>     Driver = /usr/local/mdbtools/lib/libmdbodbc.so
>     Database = /home/liamr/Northwind.mdb
>
> And I can connect find to the datasource I set up in odbc.ini using the 
> DSN...
>
>     $db = odbc_connect( "Northwind", '', '' );
>
> but I can't connect w/ the DSN-less connection string - in addition to 
> the one I pasted above, I've tried..
>
>     DRIVER={MSAccess}; DBQ=/path/to/file.mdb
>     DRIVER= /usr/local/mdbtools/lib/libmdbodbc.so; DBQ=/path/to/file.mdb
>
> Is it even possible to do what I'm trying to do?  Suggestions on how it 
> might be done?

Yes its possible, the DRIVER={MSAccess};DBQ= should work but its also 
down to the driver understanding whats going on.

I would hack the code in isql.c to change the SQLConnect to a 
SQLDriverConnect, hard code the above string, then look at the strace 
output to see if its loading the driver, if it is it may be because the 
driver doesn't understand DSN-less connection strings.

--
Nick Gorham

Easysoft Limited
Thorp Arch Grange
Thorp Arch
Wetherby
United Kingdom
LS23 7BA

Telephone : +44 1937 860000
Fax: +44 1937 860001
Website: www.easysoft.com