jjmusicpro Posted February 14, 2009 Share Posted February 14, 2009 I know I know, I am using php to access, my company wont let me install mysql so access has to do now. I am making an application, and wanted to get data from access, however, i was looking at these connection strings, and it asks for a username and password, but i dont have one on my database, how do i get around this, or can i make a username, and password in access and use that? Thanks! Link to comment https://forums.phpfreaks.com/topic/145140-php-access-connection-string/ Share on other sites More sharing options...
MatthewJ Posted February 14, 2009 Share Posted February 14, 2009 odbc_connect("DSN name", "", ""); Link to comment https://forums.phpfreaks.com/topic/145140-php-access-connection-string/#findComment-761786 Share on other sites More sharing options...
MatthewJ Posted February 14, 2009 Share Posted February 14, 2009 also, you should tell your "company" to read up on efficiency... and not to be scared of things they don't understand Link to comment https://forums.phpfreaks.com/topic/145140-php-access-connection-string/#findComment-761792 Share on other sites More sharing options...
jjmusicpro Posted February 14, 2009 Author Share Posted February 14, 2009 odbc_connect("DSN name", "", ""); Will this make it so anyone can pull and get databack out? Link to comment https://forums.phpfreaks.com/topic/145140-php-access-connection-string/#findComment-761793 Share on other sites More sharing options...
allworknoplay Posted February 14, 2009 Share Posted February 14, 2009 Yeah you need to setup ODBC, it will act as an API between PHP and access...it's like PDO... Anyways, I don't know all that much about it, but look into ODBC. Link to comment https://forums.phpfreaks.com/topic/145140-php-access-connection-string/#findComment-761796 Share on other sites More sharing options...
jjmusicpro Posted February 14, 2009 Author Share Posted February 14, 2009 I will be deploying this on a clients machine that is running windows, but allowing iis to run php. Link to comment https://forums.phpfreaks.com/topic/145140-php-access-connection-string/#findComment-761801 Share on other sites More sharing options...
allworknoplay Posted February 14, 2009 Share Posted February 14, 2009 I will be deploying this on a clients machine that is running windows, but allowing iis to run php. Why not just code with ASP then? ASP/IIS and Access with ODBC go well together. Link to comment https://forums.phpfreaks.com/topic/145140-php-access-connection-string/#findComment-761811 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.