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! Quote Link to comment Share on other sites More sharing options...
MatthewJ Posted February 14, 2009 Share Posted February 14, 2009 odbc_connect("DSN name", "", ""); Quote Link to comment 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 Quote Link to comment 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? Quote Link to comment 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. Quote Link to comment 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. Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.