ODBC over a network

Shroder01

I think this should be in the Database forum but its a newbie question.
Bascialy I'm trying to access a microsoft access database over a network (or if its possible I would like to access one remoteing via an ip address).
I've tried setting up odbc correctly on my windows xp machine (set letter z to a computer on my network with the database) but I can't get that to work.
Any ideas? I wouldn't mind getting told where I can read up on this too. Having my question answered would be great but references would be wonderful as well.
Thanks!

bastien

odbc uses DSN naming in the network environment therefore, you need to set up a dsn on the server to point to the db on the network

fromthe manual

odbc_connect
(PHP 3>= 3.0.6, PHP 4 )

odbc_connect -- Connect to a datasource
Description
resource odbc_connect ( string dsn, string user, string password [, int cursor_type])

Returns an ODBC connection id or 0 (FALSE) on error.

The connection id returned by this functions is needed by other ODBC functions. You can have multiple connections open at once. The optional fourth parameter sets the type of cursor to be used for this connection. This parameter is not normally needed, but can be useful for working around problems with some ODBC drivers.

With some ODBC drivers, executing a complex stored procedure may fail with an error similar to: "Cannot open a cursor on a stored procedure that has anything other than a single select statement in it". Using SQL_CUR_USE_ODBC may avoid that error. Also, some drivers don't support the optional row_number parameter in odbc_fetch_row(). SQL_CUR_USE_ODBC might help in that case, too.

hth

Shroder01

I have tried connecting from just the odbc_connect function. I've been getting the following error though:
Warning: SQL error: , SQL state 00000 in SQLConnect in c:\program files\apache group\apache\htdocs\odbc2.php on line 3

Like I wrote before I'm doing this on XP. I've created a dsn named network with a username and password. So I think I have the odbc setup right.
I read up a little on the error and I read that it means that it actually went through fine. I probably am leaving something out.

Shroder01

So I've gotten past that but I'm getting a differnt error.

Error:
SQL error: [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides., SQL state S1009

I've looked into it a little and I see that it could be caused by a null pointer. I don't know what I'm doing wrong though. Here's the code I'm using:

$cx = odbc_connect("dsn"," "," ","SQL_CUR_USE_ODBC");

There is no password for username.
Any help would be appreciated thank you.