Hello everyone,
I just downloaded Nusphere ED with debuuger option. Where should I keep my Access file *.mdb to access data. I get following message.
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 H:\deleter.php on line 4

Fatal error: Call to undefined function Error_handler() in H:\deleter.php on line 9
my *.mdb file is in the same direcotry where my source file is. For local server where it needs to be reside.
Help is appreciated.
Thanks
Jack

Dear Jack, your message has nothing to do with the debugger - you need to load the MS Access extension into your PHP interpretor. Please add it to the extension_dir and make sure that it is invoked in your php.ini
hope it helps! Thanks.

I think I have figured out. My ODBC connection was not set up to point to the directory. Once I did that it works as it should. yfactor thanks for your suggestion. I sent yoy direct email so ignore it.
Thanks to all who tried to look into this problem.
Jack

Hello Jack,

I see that your error references ODBC. Make sure that local odbc.ini and odbcinst.ini files are passed to ODBCINI and ODBCINSTINI variables respectively. Make sure that these variables were set when the client application was instantiated. Insure that the application is referencing an ODBC Data Source Name that appears in the actual odbc.ini file. (Match case and spacing on Data Source Names.) And, make sure there are no file or directory permissions issues that would prevent the client application from reading the odbc.ini file.

If the problem persists, you may need to set environment variables somewhere within the application itself. For example, php has a putenv tags like this:

putenv("ODBCINI=/dbs/openlink/v40/bin/odbc.ini");
putenv("ODBCINSTINI=/dbs/openlink/v40/bin/odbcinst.ini");

I am not that familiar with your client application, so I do not know if our how setting these variables is done. Also, insure that PHP and Apache are compiled with the relevant ODBC module. For example, if the iODBC Driver Manager was called, you would compile with --with-iodbc.

-- Netrista