Workgroup DB Ver 9.0b (NT)
Oracle DataServer Ver 9.0b (NT)
Oracle 8 (Unix)
In our application we have to connect a remote oracle db. But when we try to
do so, we encounter the following problems and situations:
1. When we try to connect oracle db from a client, we get error 1043
(Collation table for code page 1254 and collation name BASIC was not found
in convmap.cp" and error 1451 (Failed to connect to ORACLE database
db_name).
2. We have no problem connecting to oracle on the server where the
dataserver is running. When we try to execute a FIND or FOR statement, it
gives us a warning saying "code page conversion table 1254 to utf-8 was not
found in convmap.p", but it finds and displays the contents of the record
with no other problem.
All startup parameters are set to Turkish (1254). Oracle database code page
is 1254.
I have attached the oracle db information file from the dataserver below. In
that file there is a line saying "Database collation: ?". Am I missing
something here?
If anybody encountered a problem of this kind, his/her help will be greatly
appreciated.
Alper ERDEMIR
Contents of the Information File:
18/01/90 00:49:30 PROGRESS Report
Session Information
Currently Selected Database
Connected DBs: 2
Connected: yes
Physical name: KAT
Logical name: KAT
Schema holder: katalog
Database type: ORACLE
Database version: 7
Restrictions: RECID,PREV,LAST,SETUSERID,SET-CURRENT-VALUE
Database User Id: katalog@katalog
Database code page: 1254
Database collation: ?
PROGRESS and Operating System
Operating System: WIN32
Module type: Full
PRO version: 9.0B
DataServers: PROGRESS,ORACLE,AS400,ODBC
Environment/Startup Parameters
-yy century setting: 1950 Decimal point character: .
-d dmy date setting: dmy Thousands separator: ,
Session stream: 1254
Session charset: 1254
PROPATH = .,C:\Program Files\PROGRESS\gui,
C:\Program Files\PROGRESS\gui\adecomm.pl,
C:\Program Files\PROGRESS\gui\adecomp.pl,
C:\Program Files\PROGRESS\gui\adedesk.pl,
C:\Program Files\PROGRESS\gui\adedict.pl,
C:\Program Files\PROGRESS\gui\adeedit.pl,C:\Program Files\PR
Screen
Screen lines: 15
Message lines: 2
Space-taking: no
Terminal type: WIN3
************************************************************
* Alper ERDEMIR
* Project Manager
* E.K.M. K.ligi
* Golcuk/KOCAELI-TURKIYE
* Email: aerdemir@ekm.tsk.mil.tr, aerdemir@hotmail.com
* Tel:+90 262 4146641 x2898 (PBX)
************************************************************
Oracle DataServer Ver 9.0b (NT)
Oracle 8 (Unix)
In our application we have to connect a remote oracle db. But when we try to
do so, we encounter the following problems and situations:
1. When we try to connect oracle db from a client, we get error 1043
(Collation table for code page 1254 and collation name BASIC was not found
in convmap.cp" and error 1451 (Failed to connect to ORACLE database
db_name).
2. We have no problem connecting to oracle on the server where the
dataserver is running. When we try to execute a FIND or FOR statement, it
gives us a warning saying "code page conversion table 1254 to utf-8 was not
found in convmap.p", but it finds and displays the contents of the record
with no other problem.
All startup parameters are set to Turkish (1254). Oracle database code page
is 1254.
I have attached the oracle db information file from the dataserver below. In
that file there is a line saying "Database collation: ?". Am I missing
something here?
If anybody encountered a problem of this kind, his/her help will be greatly
appreciated.
Alper ERDEMIR
Contents of the Information File:
18/01/90 00:49:30 PROGRESS Report
Session Information
Currently Selected Database
Connected DBs: 2
Connected: yes
Physical name: KAT
Logical name: KAT
Schema holder: katalog
Database type: ORACLE
Database version: 7
Restrictions: RECID,PREV,LAST,SETUSERID,SET-CURRENT-VALUE
Database User Id: katalog@katalog
Database code page: 1254
Database collation: ?
PROGRESS and Operating System
Operating System: WIN32
Module type: Full
PRO version: 9.0B
DataServers: PROGRESS,ORACLE,AS400,ODBC
Environment/Startup Parameters
-yy century setting: 1950 Decimal point character: .
-d dmy date setting: dmy Thousands separator: ,
Session stream: 1254
Session charset: 1254
PROPATH = .,C:\Program Files\PROGRESS\gui,
C:\Program Files\PROGRESS\gui\adecomm.pl,
C:\Program Files\PROGRESS\gui\adecomp.pl,
C:\Program Files\PROGRESS\gui\adedesk.pl,
C:\Program Files\PROGRESS\gui\adedict.pl,
C:\Program Files\PROGRESS\gui\adeedit.pl,C:\Program Files\PR
Screen
Screen lines: 15
Message lines: 2
Space-taking: no
Terminal type: WIN3
************************************************************
* Alper ERDEMIR
* Project Manager
* E.K.M. K.ligi
* Golcuk/KOCAELI-TURKIYE
* Email: aerdemir@ekm.tsk.mil.tr, aerdemir@hotmail.com
* Tel:+90 262 4146641 x2898 (PBX)
************************************************************