You are not logged in.

Problem with Access component - CE 3.2

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

laloune

Sage

  • "laloune" started this thread

Posts: 216

Date of registration: Dec 2nd 2009

Location: Berlin

Hobbies: Born to work :-)

  • Send private message

1

Tuesday, August 30th 2011, 10:47am

Problem with Access component - CE 3.2

Hi everyone,

I encounter a problem with the Access connector in Palo Suite CE 3.2. When trying to test the connection component, I get the following error:

Source code

 
1
2
3
4
5
6
7
8

The component "Access" is tested with errors:


 Failed to open Relational connection Access with URL 
jdbc:odbc:Driver={MicroSoft Access Driver 
(*.mdb)};DBQ=/home/database.mdb. Please check your connection 
specification. [unixODBC][Driver Manager]Data source name not found, and
 no default driver specified


any idea ?
laloune

"To understand recursion, one must understand recursion"

kais

Master

Posts: 64

Date of registration: Mar 4th 2009

  • Send private message

2

Monday, September 19th 2011, 9:43am

The "Access" connection uses the ODBC driver
MicroSoft Access Driver (*.mdb) that is installed usually when the Windows office is installed, So practically, you can't use this from a Unix system unless you find a way to install these on your unix system (which I doubt it's possible).

But even on Windows machine, things like 32/64 bit or locale, should be taken into consideration when using "Access" Connection.

Similar threads

Rate this thread