Geodatasource layer based on MS Access?

Deals with generic topics such as logging, framework and so on. If you are not sure where to place your topic just put it here.
Post Reply
User avatar
Bernd Welter
Site Admin
Posts: 2564
Joined: Mon Apr 14, 2014 10:28 am
Contact:

Geodatasource layer based on MS Access?

Post by Bernd Welter »

Hello community,

in the recent weeks several contacts asked me how to migrate the Access based geodatasource layers from old xServers (32bit) to state-of-the-art servers (1.18). The answer is simple:

MS Access is no longer supported!

As it is mentioned on the Developer Zone the following databases are supported by now:
  • Oracle ojdbc<version>.jar
  • IBM DB2 db2jcc.jar
  • Microsoft SQL Server jtds-<version>.jar
  • MySQL mysql-connector-java-<version>-bin.jar
  • SQLite sqlitejdbc-<version>.jar
  • Apache Derby (bundled) derbyclient-<version>.jar
So you have to migrate your data from Access to one of these containers and then reconfigure your server's geodatasource files.

Just a little snippet:
my local installation is based on a MS SQL SERVER and is running fine with the following database connection style:

Code: Select all

<Datasource driver="sun.jdbc.odbc.JdbcOdbcDriver" url="jdbc:sqlserver://localhost:1433;databaseName=MyDatabasename" user="MySQLServerUsername" password="MySQLServerPassword" />
As long as the structure of your data didn't change this should be the only action that is required.
The application itself should run without any changes (no guarantee ;-) )

Best regards

Bernd
Post Reply