See Answer provided by scriptcase technical support

Scriptcase 9 General
#1

[SIZE=21px]View Ticket: #JHO-871-21918[/SIZE]
[SIZE=15px] [TABLE=“border: 0, cellpadding: 0, cellspacing: 0”]
[TR]
[TD] [FONT=inherit] [FONT=inherit][SIZE=30px]Connection problem * .mdb * .accdb on Linux Debian[/SIZE]

		[SIZE=13px]Created: 24 January 2017 09:41 AM    Updated: 24 January 2017 10:01 AM[/SIZE]
		[SIZE=11px] 			[COLOR=#4C5156][SIZE=15px] 			[COLOR=#666666][FONT=inherit][SIZE=14px]Ticket[/SIZE]
		[FONT=inherit]
		1
		2
		3
		4
		5
		[/SIZE][/FONT]
		[/SIZE][/FONT][/COLOR]
		[/FONT]
		[/TD]
	[/TR]
	[TR]
		[TD="bgcolor: #63A3F7"] 			 			 			[FONT=inherit] 			[FONT=inherit][SIZE=11px]OWNER[/SIZE]
		[SIZE=16px]S?rgio Magluf[/SIZE]
		
		 			[SIZE=11px]STATUS[/SIZE]
		 Open Answered Closed Solved Reopened Awaiting Response Analyzing  
		
		 			[SIZE=11px]PRIORITY[/SIZE]
		 Normal Medium High Urgent Emergency Critical  
		
		[/FONT]
		[/FONT]
		[/TD]
	[/TR]
 [/TABLE]

[TABLE=“class: hlineheader, width: 960”]
[TR]
Environment Information [TD] [/TD]
[/TR]
[TR]
[TD=“class: hlinelower”] [/TD]
[/TR]
[/TABLE]
[TABLE=“border: 0, cellpadding: 4, cellspacing: 1”]
[TR]
[TD=“class: zebraodd, width: 200, bgcolor: #ECECEF, align: left”]OS:[/TD]
[TD=“bgcolor: #FFFFFF”]Linux debian jessie[/TD]
[/TR]
[TR]
[TD=“class: zebraodd, width: 200, bgcolor: #ECECEF, align: left”]Database:[/TD]
[TD=“bgcolor: #FFFFFF”].mdb .accdb[/TD]
[/TR]
[TR]
[TD=“class: zebraodd, width: 200, bgcolor: #ECECEF, align: left”]Scriptcase Version:[/TD]
[TD=“bgcolor: #FFFFFF”]SC 8.1[/TD]
[/TR]
[TR]
[TD=“class: zebraodd, width: 200, bgcolor: #ECECEF, align: left”]Scriptcase Release:[/TD]
[TD=“bgcolor: #FFFFFF”]?[/TD]
[/TR]
[TR]
[TD=“class: zebraodd, width: 200, bgcolor: #ECECEF, align: left”]Installation Type:[/TD]
[TD=“bgcolor: #FFFFFF”]Autom?tica / Automatic[/TD]
[/TR]
[TR]
[TD=“class: zebraodd, width: 200, bgcolor: #ECECEF, align: left”]Browser:[/TD]
[TD=“bgcolor: #FFFFFF”]Firefox, chrome …[/TD]
[/TR]
[TR]
[TD=“class: zebraodd, width: 200, bgcolor: #ECECEF, align: left”]PHP Version:[/TD]
[TD=“bgcolor: #FFFFFF”]5.6[/TD]
[/TR]
[TR]
[TD=“class: zebraodd, width: 200, bgcolor: #ECECEF, align: left”]WEB Server:[/TD]
[TD=“bgcolor: #FFFFFF”]apache2[/TD]
[/TR]
[TR]
[TD=“class: zebraodd, width: 200, bgcolor: #ECECEF, align: left”]Diagnosis File:[/TD]
[TD=“bgcolor: #FFFFFF”]- NA -[/TD]
[/TR]
[/TABLE]

  [SIZE=14px]Add Reply[/SIZE]

[FONT=inherit] [FONT=inherit][SIZE=21px]Zliv[/SIZE]

[SIZE=14px]Developer[/SIZE]
[FONT=inherit][SIZE=14px]User[/SIZE]

[/FONT]
[FONT=inherit][SIZE=14px]Posted on: 24 January 2017 09:41 AM [/SIZE]

[FONT=inherit]Connection problem * .mdb * .accdb on Linux Debian, Despite that I applied the tutorial available on Webhelp and knowledgebase without success.

scriptcase is great as tools but the migration of my databases does not suit me.
Is there any solution ?

[/FONT]
[/FONT]

[/FONT]
[FONT=inherit][SIZE=21px]Zliv[/SIZE]
[SIZE=14px]Developer[/SIZE]
[FONT=inherit][SIZE=14px]User[/SIZE]

[/FONT]
[FONT=inherit][SIZE=14px]Posted on: 24 January 2017 09:46 AM [/SIZE]

[FONT=inherit]Diagnosis files Attached

[SIZE=13px] Diagnosis.html (102.39 KB)[/SIZE]

[/FONT]
[/FONT]

[/FONT]
[FONT=inherit][SIZE=21px]S?rgio Magluf[/SIZE]
[SIZE=14px]Scriptcase Support[/SIZE]
[FONT=inherit][SIZE=14px]Staff[/SIZE]

[/FONT]
[FONT=inherit][SIZE=14px]Posted on: 24 January 2017 10:01 AM [/SIZE]

[FONT=inherit]Hello!

As stated on our live chat, the Access connection won’t work on Linux based systems.

Cheers!
S?rgio Magluf
[FONT=inherit][SIZE=12px]Scriptcase Support Analyst[/SIZE]

[/FONT]
[/FONT]
[/FONT]
[/FONT]
[/FONT]
[/SIZE][/FONT][/COLOR]
[SIZE=15px] [FONT=inherit] [FONT=inherit]

[/FONT]
[/SIZE][/FONT]

#2

haha :stuck_out_tongue: Yup I paid for “support” too. Once bitten…:cool:

#3

@NetMake: if you know it won’t work please update the SC manual accordingly.

Right now by reading the manual it seems something easily doable: http://www.scriptcase.net/docs/en_us…ess-using-odbc

#4

Thanks Robydago for answering
I have already Applied all the tutorials available on scriptcase websites and videos
I tried to manually install scriptcase Gives internal error 500 When It is Supposed to start the install … I have Tried to go directly to the .php file system Without success
While knowing that I am neither amateur nor beginner, I have already used scriptcase before and I can say except this pb is great as a tool
The only one test works when I configure the /etc/odbc.ini and /etc/odbcinst.ini files but then I get the following message: Error accessing the database:
Could not parse SQL

HAVE you any ideas please, i can’t nor migrate the databses nor change OS :frowning:

#5

I tried but I failed:

http://www.scriptcase.net/forum/forum/main-category/main-forum/73939-scriptcase-on-linux-trying-to-connect-to-ms-access-db-extension-not-loaded

In the past the only way I was able to access mdb data was: SC on Linux configured to access a mariadb server running on a windows server. The mariadb server on Windows was accessing the mdb file directly via the ODBC drivers for Windows. But it requires two servers (one linux + one windows), it’s time consuming to set up and it has limitations. That’s why I tried to access the mdb file directly on the Linux box.