[PHP] ODBC for MS Access
Dear All, I use Linux box + PHP installed on it and want to connect/access MS Access database installed on Windows box. Below are my Questions: 1 What software/driver do I need in Linux box as well as in Windows box? Where to find such a software/driver? 2. Do I need compile PHP to be able to connect to MS Access. 3. Is there manual available for PHP--Access function? Hope to see your reply very soon. Thanks, M. Fikri __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] ODBC for MS Access
[snip] I use Linux box + PHP installed on it and want to connect/access MS Access database installed on Windows box. Below are my Questions: 1 What software/driver do I need in Linux box as well as in Windows box? Where to find such a software/driver? 2. Do I need compile PHP to be able to connect to MS Access. 3. Is there manual available for PHP--Access function? [/snip] Start here http://us4.php.net/odbc and search for MyODBC on Google. Have a pleasant and educational day. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] ODBC to MS-Access View?
I'm trying to connect up w/ an Access database one of our db administrators set up. The Access file has an adp extension...the data is housed in a view, (essentially a read-only dump of some MS SQL Server tables). I've set up the file as a System DSN in ODBC (WinNT) When I issue the following command: $conn_id = odbc_connect($db, $username, $password) or die(); I get the following error: Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data., SQL state S1000 in SQLConnect in C:\Inetpub\wwwroot/seating/sharondb.php on line 36 Any ideas? I am supplying the correct username and password... Thanks Chip Hankley -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]