Scriptcase on linux trying to connect to MS Access DB - EXTENSION NOT LOADED

Scriptcase 9 General
#1

According to the SC manual http://www.scriptcase.net/docs/en_us…ess-using-odbc

“The Scriptcase automatic Installation already comes with the ODBC extension pre configured, only needing to download the UnixODBC driver to do the connection.”

So I installed UnixODBC on my Centos 7 box, but all I get in SC (even after a server reboot) is “The extensions is not loaded on the php,ini file”.
See picture below.

I looked into /opt/NetMake/v8/components/apache/conf/php.ini but I couldn’t find any reference to an MS access driver.

Does anyone know how to make it work?

. [ATTACH=CONFIG]n73940[/ATTACH]

scriptcase_access.png

#2

Try the chat of scriptcase support. Pretend to be a new user if you have to. It works on windows, but i don’t know much about linux. Sorry.

#3

[QUOTE=robydago;n73939]According to the SC manual http://www.scriptcase.net/docs/en_us…ess-using-odbc

“The Scriptcase automatic Installation already comes with the ODBC extension pre configured, only needing to download the UnixODBC driver to do the connection.”

So I installed UnixODBC on my Centos 7 box, but all I get in SC (even after a server reboot) is “The extensions is not loaded on the php,ini file”.
See picture below.

I looked into /opt/NetMake/v8/components/apache/conf/php.ini but I couldn’t find any reference to an MS access driver.

Does anyone know how to make it work?

. [ATTACH=CONFIG]n73940[/ATTACH]
[/QUOTE

An extension reference for the ODBC driver has to be present in the PHP.INI - similar to: ‘extension = odbc.so’

#4

@aducom

You mean new user as in “I haven’t bought the program yet and I’m evaluating it”?

@klwillis

I know that, but which file?
There are some *odbc,so files in the filesystem but when I try to make apachesc8 load them via its php.ini, I get errors in /opt/NetMake/v8/components/apache/logs/error_log.

E.g.


PHP Warning:  PHP Startup: Unable to load dynamic library '/opt/NetMake/v8/components/apache/ext/odbc.so' - /opt/NetMake/v8/components/apache/ext/odbc.so: wrong ELF class: ELFCLASS64 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/opt/NetMake/v8/components/apache/ext/pdo_odbc.so' - /opt/NetMake/v8/components/apache/ext/pdo_odbc.so: wrong ELF class: ELFCLASS64 in Unknown on line 0

Just wondering if those errors are due to SC being 32 bit (not sure if this is the case) and my CentOS 64 bit?

#5

Formally you can only request support if you have bought support. Which is a silly construction. So yes, I would pretend to be a new user… After all this is a setup issue.

#6

Error looks like your libs are builded for x64 but SC installer comes with a x86 environment. Probably this is the problem, but not sure