Official site of geoinformation system (GIS) ObjectLandOfficial site of geoinformation system (GIS) ObjectLand
   
 
SEARCH ON SITE:
google.com
SITE MAP
 
home / support
E-MAIL:PASSWORD: 
registration

ODBC data source configuration for ObjectLand 2.7

Tested configurations and recommended settings for using external databases.

DBMSDBMS versionODBC driver vendorODBC driver versionRecommended changes of ODBC data source configuration (relatively default)
Microsoft AccessAccess 2003 (11.6355.8107) SP1Microsoft Corporation4.00.6304.00'ExtendedAnsiSQL'=1
Microsoft AccessAccess 2007Microsoft Corporation12.00.4518.1014'ExtendedAnsiSQL'=1
Microsoft SQL ServerMicrosoft SQL Server 2000 Enterprise Edition (8.00.194)Microsoft Corporation2000.85.1117.00-
Microsoft SQL ServerMicrosoft SQL Server 2005 Express Edition (9.00.1399.06)Microsoft Corporation2005.90.1399.00-
OracleOracle 9i Enterprise Edition (9.2.0.1.0)Oracle Corporation9.02.00.80-
OracleOracle Database 10g Express Edition (Western European)Oracle Corporation10.02.00.01-
OracleOracle Database 10g Express Edition (Universal)Oracle Corporation10.02.00.01Database administrator must execute the statement:
ALTER SYSTEM SET NLS_LENGTH_SEMANTICS=CHAR SCOPE=BOTH
MySQLMySQL 5.0.27 community-ntMySQL AB3.51.21.00'Enable auto_increment NULL search' = ON
'Pad Char To Full Length' = ON
'Return Table Names For SQLDescribeCol' = ON
If you use specific code page:
'initial Statement' = 'SET CHARACTER SET <CODE_PAGE_ID>', e.g. 'initial Statement' = 'SET CHARACTER SET cp1251'
MySQLMySQL 5.6.10 community-ntOracle Corporation5.02.04.00Pad CHAR to full length with space = ON
If you use specific code page:
Character set = <CODE_PAGE_ID>, e.g. Character set = cp1251
PostgreSQLPostgreSQL 8.3.0PostgreSQL Global Development Group8.03.01.00'Use Declare/Fetch' = ON
'Server side prepare' = ON
InterBaseInterBase WI-06.0.1.6IBPhoenix Inc2.00.00.142'Character Set' — the same as the database character set.
'Dialect' = 3
'Quoted Identifier' = ON
'Sensitive Identifier' = ON
Recommended page size at creating new database ≥ 8Kb
FirebirdFirebird-2.0.3.12981-1IBPhoenix Inc2.00.00.142'Character Set' — the same as the database character set.
'Dialect' = 3
'Quoted Identifier' = ON
'Sensitive Identifier' = ON
Recommended page size at creating new database ≥ 8Kb
DB2IBM DB2 Express-C 9.5.0.808IBM9.5.0.808'LongDataCompat' = 1 (as LONGVAR data)
 
Copyright © 1999–2017 GIS ObjectLand
GIS ObjectLand ® “Radom-T”
Licenses information
home | product | download | purchase | support | news