Geodatasource layer based on MS Access?
Posted: Wed Dec 17, 2014 3:09 pm
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:
Just a little snippet:
my local installation is based on a MS SQL SERVER and is running fine with the following database connection style:
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
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
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" />The application itself should run without any changes (no guarantee
)Best regards
Bernd