Re^3: Win32/DBD::ODBC: works from cmd.exe, not works from apache (xampp)

Replies are listed 'Best First'.
Re^4: Win32/DBD::ODBC: works from cmd.exe, not works from apache (xampp) by alexander_lunev (Pilgrim) on Nov 28, 2016 at 18:07 UTC
The same error: `Content-Type: text/html; charset=utf-8 ERROR ODBC: [Microsoft][ODBC dBase Driver] Disk or network error. (SQL +-HY000)` [download]	[reply] [d/l]
Re^5: Win32/DBD::ODBC: works from cmd.exe, not works from apache (xampp) by Corion (Patriarch) on Nov 29, 2016 at 08:27 UTC
This means that when your Apache server / user runs your program, something in the permissions or environment or whatever (`$ENV{PATH}`?) is different from when you run the program manually. I don't know what knobs and levers there are to the Apache configuration, but if it is run under the same interactive user as when you start the program manually, it's either `%ENV` or something that should be documented somewhere in the Apache documentation...	[reply] [d/l] [select]
Re^6: Win32/DBD::ODBC: works from cmd.exe, not works from apache (xampp) by alexander_lunev (Pilgrim) on Nov 29, 2016 at 10:55 UTC
Thank you! Thank you very much! It seems that ODBC needs just TMP environment variable to work. When I set it, code started to work! `$ENV{'TMP'} = 'C:\\DOCUME~1\\lan\\LOCALS~1\\Temp\\2';`	[reply] [d/l]
Re^5: Win32/DBD::ODBC: works from cmd.exe, not works from apache (xampp) by Anonymous Monk on Nov 28, 2016 at 22:10 UTC
check your connection string, and db password/ip restrictions	[reply]