Re: ODBC connection..

I don't know about a "user" DSN, but I do know it's possible to create an ODBC connection, using the ODBC functions. Check out the manual: http://us4.php.net/manual/en/ref.odbc.php Andrew Kwiczola wrote:

Heya, I was wondering if its possible to create a odbc connection with php, using a User DSN.. (not a system DSN)? Everytime I try to connect with this code.. $connect = odbc_connect("userdsnhere", "user", "password") or die(odbc_errormsg());; I get... [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Like it doesn't exist.. Im trying to connect to a datasource that has been setup over the network as a user dsn to retrieve data, anyone have any ideas? I can retrieve the data via an excel odbc query, but this doesn't seem to work as expected.. can anyone help? Andy