Jenski Posted February 4, 2009 Share Posted February 4, 2009 Hi guys, I have always used MySQL with PHP, but I now need to link to an MS Access database. The MS Access database is on a network drive and the server running PHP needs to access it. How can I connect to it? Link to comment https://forums.phpfreaks.com/topic/143747-ms-access-via-ftp/ Share on other sites More sharing options...
trq Posted February 4, 2009 Share Posted February 4, 2009 Using odbc_connect. Link to comment https://forums.phpfreaks.com/topic/143747-ms-access-via-ftp/#findComment-754206 Share on other sites More sharing options...
Jenski Posted February 4, 2009 Author Share Posted February 4, 2009 Thanks, But what would the connection string look like if it was talking to another server? Link to comment https://forums.phpfreaks.com/topic/143747-ms-access-via-ftp/#findComment-754209 Share on other sites More sharing options...
trq Posted February 4, 2009 Share Posted February 4, 2009 I thought you said it resided on a network drive? Link to comment https://forums.phpfreaks.com/topic/143747-ms-access-via-ftp/#findComment-754210 Share on other sites More sharing options...
Jenski Posted February 4, 2009 Author Share Posted February 4, 2009 it is, but the server running PHP is 'detatched' from it... Link to comment https://forums.phpfreaks.com/topic/143747-ms-access-via-ftp/#findComment-754211 Share on other sites More sharing options...
trq Posted February 4, 2009 Share Posted February 4, 2009 it is, but the server running PHP is 'detatched' from it... Well then you need to attach to it. access is not a db server, you cannot connect to it via a network. Link to comment https://forums.phpfreaks.com/topic/143747-ms-access-via-ftp/#findComment-754214 Share on other sites More sharing options...
Jenski Posted February 4, 2009 Author Share Posted February 4, 2009 Is it possible to do <servername>/<path to file> in the connection string with a username / password? Link to comment https://forums.phpfreaks.com/topic/143747-ms-access-via-ftp/#findComment-754220 Share on other sites More sharing options...
trq Posted February 4, 2009 Share Posted February 4, 2009 If you don't have a dsn you would need to go the COM route I think. Theres a user example on the odbc_connect man page. Link to comment https://forums.phpfreaks.com/topic/143747-ms-access-via-ftp/#findComment-754225 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.