Access DB using ODBC

ladams02

What would be the correct code to use if I'm trying to access an Access DB that is in the same directory as my PHP script?

The Following:

$connection = odbc_connect("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ='E:\users\ladams02\courses\cosc345\tts\data.mdb'", "USER", "PASS");

$sql = "select * from pokerTTS";
$res = odbc_exec($connection, $sql);

Returns:
Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x834 Thread 0x854 DBC 0xc529e4 Jet'., SQL state S1000 in SQLConnect in e:\users\ladams02\courses\cosc345\tts\ttsOutput.php on line 194

... among several other errors. Any ideas??

crazychris

you should be setting up a system dsn in the odbc control panel on the pc, and using it's name as the connect string. worked for me in the past.

ladams02

See I keep reading this all over the place, but I'm setting this up on my school's network, and we don't have any sort of control panel at all. This was a project that I completed successfully on one server we had for the class, and then at the end of the semester I had to move it over to our "personal" server and it hasn't been working since I tried to move it. The server it's on now has PHP capabilities, and I never had any control panel on the other server that it was working on to set such a DSN, so I'm totally lost with this.

I'd like to get this working on my personal server so I can use it in my portfolio when job searching begins next year. Any help appreciated!

crazychris

odbc_connect ( string dsn, string user, string password [, int cursor_type] )

HAS to use a dsn from what I can sell. ODBC config in in your control panel, same on the server as on the pc.

ladams02

There are DSN-Less Connections, but I think that these still require something to be installed on the server to use? Does anyone know any more about DSN-less connections?

crazychris

http://phplens.com/phpeverywhere/node/view/9#dsnless

ladams02

Yeah I was actually checking out that site a while ago, but havn't had any luck with it. I have no way of installing any kind of libraries on this server (that I know of) and have no access to a control panel. So I am wondering if it could just be the syntax of my code, or possibly another line that I am missing.. anyone have any ideas?