Re: [PHP-WIN] odbc_connect unknown error

2007-09-20 Thread John Mertic
You can if the user that runs the web server process has access to that file then yes. Or you could set an ODBC bridge, but to be honest it's much faster and easier ( depending upon the application's requirements of course ) to export it to a SQLite or MySQL DB on the webserver. John On 9/20/07,

RE: [PHP-WIN] odbc_connect unknown error

2007-09-20 Thread Alexander Fradiani
> 1) Does the user running the web process have access to the file using> the > path provided?> 2) Did you set the DSN as a System DSN?> 3) Try using a > DSN-less connection, namely:> > $dsn = "Driver={Microsoft Access Driver > (*.mdb)}; DBQ=" + $fullpathtodb;> $con = odbc_connect($dsn,$user,$p

Re: [PHP-WIN] odbc_connect unknown error

2007-09-20 Thread John Mertic
I'd check the following in order... 1) Does the user running the web process have access to the file using the path provided? 2) Did you set the DSN as a System DSN? 3) Try using a DSN-less connection, namely: $dsn = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" + $fullpathtodb; $con = odbc_co

[PHP-WIN] odbc_connect unknown error

2007-09-20 Thread Alexander Fradiani
Hello!. I have a problem when trying to connect to an access database: $con = odbc_connect($dsn,$user,$pass) or die(odbc_error()); the error message i get is just this: IM002 the $dsn var only contains the name of a data source previously created from the windows control panel. i already