|
|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2009-09-13 18:51 UTC] gezine at hotmail dot com
Description: ------------ Locally on my computer my connection to the database works fine but the moment I upload my file to the web server, and submit a form I receive the error. Webserver Information ----------------------- Operating System: Windows PHP Version: PHP 5.x IIS Version: IIS 7.0 code tried but no luck ---------------------- http://us3.php.net/manual/en/function.odbc-connect.php Reproduce code: --------------- function connect_to_database($dsn, $user, $password) { //create a connection to the database $conn = odbc_connect($dsn, $user, password,SQL_CUR_USE_DRIVER); //if the connection failed display the appropriate message if(!$conn) { output_error(); die(); }//end if(_); else { //return connection has been established. return $conn; }//end else }//end connect_to_database(_); Expected result: ---------------- I expected a successful return since every thing on the webserver(Godaddy) is setup correctly according to their test. Actual result: -------------- "Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in " PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||
Copyright © 2001-2024 The PHP GroupAll rights reserved. |
Last updated: Sat Dec 21 15:01:29 2024 UTC |
Kalle, Thank you for taking the time to write a response. WebServer Solution ------------------ //where $path = C:/a_path/on/my_web_server/my_db_folder/ $path = $_SERVER["DOCUMENT_ROOT"]) . "\\db\\database.mdb"; $dbq = str_replace("/", "\\", $path ); if(!file_exists($dbq)) { output_error(); die(); } else { $conn = odbc_connect("Driver={Microsoft Access Driver (*.mdb)}; Dbq=$dbq;", 'test', '1234'); if(!$conn) { output_error(); die(); }//end if(_); } else { //SQL Command //sends sql command to the server $rs = odbc_exec($conn,$sql); }//end else //closes the connection to the database odbc_close($conn); }//end else Question -------- After trying it in my webserver with the domain name along with the correct directory this doesn't work. 1. Is this a permission issue itself on the folder/file since it works now with the correct path not with my.domainname.com/html_path/my_database_folder/ or something else? 2. Any documents you have on this would be of great importance to me. 3. Is this actually a driver issue since it works now? 4. I will try your advice and post my result.