ORA-28500 using Transparent gateway for MSSQL - Heterogeneous Connectivity

I'm trying to access a Microsoft Sql server database, using
oracle transparent gateway for MS SQL Server. When I try to
access the MSSQL database from Oracle database I get the
following error:
SQL> /
select * from traffic_news#teste
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system
returned this message:
[Transparent gateway for MSSQL]The specified module could not be
found.
; at FIND_IMAGE_SYMBOL
Cannot connect to shareable hsdbsql. Using dummy functions
PATH =
D:\oracle\ora90\bin;D:\oracle\ora90\Apache\Perl\5.00503
\bin\mswin32-x86;D:\Progr
am Files\Oracle\jre\1.1.8
\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem
Initialization function MSSQL not found
ORA-02063: preceding 7 lines from TESTE
And on the trace file from the gateway I get:
Oracle Corporation --- WEDNESDAY DEC 12 2001 17:10:23.046
Heterogeneous Agent Release
9.0.1.1.1
(0) [Transparent gateway for MSSQL] version: 2.0.4.0.0030
(0) connect string is:
(0) YEAR2000_POLICY=-
1;CONSUMER_API=1;SESSION_BEHAVIOR_FLAGS=4;PARSER_DEPTH=2000;E-
(0) XEC_FLAGS =
(0) 131080;defTdpName=tg4msql;binding=
(tg4msql,MSSQL,"172.16.4.41.Transito",TDP_OW-
(0) NER=dbo);
(0) ORACLE SQL SERVER GATEWAY Log File Started at 12-Dec-01
17:10:23
(0) LoadLibrary(): Failed to load D:\oracle\ora90
\bin\hsdbsql.DLL; The specified
(0) module could not be found.
(0) The specified module could not be found.
; at FIND_IMAGE_SYMBOL
(0) Cannot connect to shareable hsdbsql. Using dummy functions
(0) PATH =
(0) D:\oracle\ora90\bin;D:\oracle\ora90\Apache\Perl\5.00503
\bin\mswin32-x86;D:\Pro-
(0) gram
(0) Files\Oracle\jre\1.1.8
\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem
(0) Initialization function MSSQL not found
(0) The specified module could not be found.
; at FIND_IMAGE_SYMBOL
Cannot
(0) connect to shareable hsdbsql. Using dummy functions
PATH =
(0) D:\oracle\ora90\bin;D:\oracle\ora90\Apache\Perl\5.00503
\bin\mswin32-x86;D:\Pro-
(0) gram
(0) Files\Oracle\jre\1.1.8
\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem
(0) Initialization function MSSQL not found
(0)
(0) Closing log file at WED DEC 12 17:10:23 2001.
I checked and the file D:\oracle\ora90\bin\hsdbsql.DLL exists.
Can you help me on this??

Related

SQL Connection error

Hi, Experts,
I have setup a test server and also configured the ODBC in order for Essbase to get data from Oracle Database.
After ODBC configuration, I can see our Database names in Window "Open SQL data sources" within Essbase. However, when I try to retrieve data, it shows me this error:
"Failed to Establish Connection With SQL Database Server. See log file for more information."
In log file, it shows:
".....
[Tue Dec 02 15:47:26 2008]Local/CA/Ca/megger/Info(1021006)
SELECT Statement [SELECT * FROM v_essb_uatp_struk] is generated
[Tue Dec 02 15:47:26 2008]Local/CA/Ca/megger/Info(1021013)
ODBC Layer Error: [IM004] ==> [[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed]
[Tue Dec 02 15:47:26 2008]Local/CA/Ca/megger/Info(1021014)
ODBC Layer Error: Native Error code [0]
[Tue Dec 02 15:47:26 2008]Local/CA/Ca/megger/Error(1021001)
Failed to Establish Connection With SQL Database Server. See log for more information
[Tue Dec 02 15:47:26 2008]Local/CA/Ca/megger/Warning(1080014)
Transaction [ 0x6000f( 0x49354a7e.0x222e0 ) ] aborted due to status [1021001].
...."
My question is, is this an error related to Essbase or to ODBC connection?
Thanks in advance
Linda

Oracle connect to Mysql with DBLINK

I use Heterogeneous Services and Generic Connectivity to connect Oracle to MySql with DBLINK. I define ODBC Data Source for the Mysql Database. the Data Source is OK! mysql database is on remote machine.
If the remote machine is windows, I can select table in mysql db within SQLPLUS.
If the remote machine is Linux, I can't select table of mysql db with SQLPLUS. it prompt me the table doesn't exist, But ODBC Data Source is OK!
the trace file is as follow:
Oracle Corporation --- ÐÇÆÚÈý 2ÔÂ 25 2004 13:49:16.125
Version 9.2.0.1.0
(0) [Generic Connectivity Using ODBC] version: 3.3.00.00.0030
(0) connect string is: defTdpName=mysql;SYNTAX=(ORACLE8_HOA, BASED_ON=ORACLE8,
(0) IDENTIFIER_QUOTE_CHAR="",
(0) CASE_SENSITIVE=CASE_SENSITIVE_QUOTE);BINDING=<navobj>
<binding>
<datasources>
(0) <datasource name='mysql' type='ODBC' connect='mysql'>
(0) <driverProperties/></datasource></datasources><environment>
<misc
(0) year2000Policy='-1' consumerApi='1' sessionBehavior='4'/><queryProcessor
(0) parserDepth='2000' noInsertParameterization='true' noThreadedReadAhead='true'
(0) noCommandReuse='true'/></environment></binding></navobj>
(0) ORACLE GENERIC GATEWAY Log File Started at 25-Feb-04 13:49:16
(0) [G000] Failed to notify driver of changed property ISOLATION_LEVEL for TDP
(0) MYSQL
(0) hoadtab(26); Entered.
(0) Table 1 - DB
(0) [MySQL][ODBC 3.51 Driver][mysqld-4.0.14-standard]Table 'mysql.DB' doesn't
(0) exist (SQL State: HY000; SQL Code: 1146)
(0) (Last message occurred 2 times)
(0)
(0) hoapars(15); Entered.
(0) Sql Text is: SELECT * FROM "DB"
(0) [M000] Invalid memory deallocation operation in module trying
(0) 'P:\src\HOANAV\hoastmt.c' line 1685.
(0) [MySQL][ODBC 3.51 Driver][mysqld-4.0.14-standard]Table 'mysql.DB' doesn't
(0) exist (SQL State: HY000; SQL Code: 1146)
(0) (Last message occurred 2 times)
(0)
(0) [A00D] Failed to open table MYSQL:DB
(0)
(0) hoadtab(26); Entered.
(0) Table 1 - DB4.0.14
(0) [MySQL][ODBC 3.51 Driver][mysqld-4.0.14-standard]Table 'mysql.DB' doesn't
(0) exist (SQL State: HY000; SQL Code: 1146)
(0) (Last message occurred 2 times)
(0)
(0) hoapars(15); Entered.
(0) Sql Text is: SELECT * FROM "DB"
(0) [M000] Invalid memory deallocation operation in module trying
(0) 'P:\src\HOANAV\hoastmt.c' line 1685.
(0) [MySQL][ODBC 3.51 Driver][mysqld-4.0.14-standard]Table 'mysql.DB' doesn't
(0) exist (SQL State: HY000; SQL Code: 1146)
(0) (Last message occurred 2 times)
(0)
(0) [A00D] Failed to open table MYSQL:DB
(0)
try put the table_name in ""
ex.
select * from "test"#mysql; 
MySQL is by default case sensitive whereas Oracle isn't - Oracle by default translates every object to capital letters. If you now want to access a case sensitive database like MySQl you need to surround each object (column,table and view by double quotes in Oracle to preserver the case.
BTW, did you know that HSODBC up to release 10.2 was desupport many years ago (HSODBC 10.2 for example in March 2008 )? So please be aware that when you hit any new bug where no fix exists you won't get a patch for this problem anymore. I would strongly recommend you to use a newer release.

ODBC error when inserting.

Does anyone have a solution for this problem?
Thanks in advance.
Sanjay
We have Forte version 2.0.F.2 running on Windows NT version 3.51. We use
ODBC to connect to SQL Server version 6.5. When we try to insert a row
into a table and one of the columns exceeds the size specified in the
table definition we get an exception. If the same statement is executed
using ISQL it inserts successfully and SQL Server automatically truncates
the column to the maximum size.
Error stack (from trace window):
USER ERROR: Execute failed for SQL statement in project testDB, class
tstUpdate1, method save, methodId 4, line 1, error from database is:
ODBC SQLExecute failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]Column 'FirstName' of
table
'LibStarProd.dbo.Passenger' cannot accept 15 bytes (10 max).
Class: qqdb_ValueException with ReasonCode: DB_ER_CONVERSION
Detected at: qqdb_OdbcModify::VendorExecute at 20
Last TOOL statement: method tstUpdate1.save, line 1
Error Time: Wed Apr 30 17:01:34
ODBC SQLSTATE: 22001, ODBC error: 8152, Server: LibStarProdODBC,
UserName:
Demo
Database Statement: insert into Passenger ( FileNumber ,
ItineraryNumber ,
PassengerID , FirstName ) values ( 'TESTING001' , 1 , 1 , 'A VERY
BIG
NAME' )
Exception occurred (remotely) on partition "testDB_CL0_Part1",
(partitionId = D9CD8C45-6E21-11D0-BD41-FE9384C6AA77:0x1210:0x15,
taskId =
[D9CD8C45-6E21-11D0-BD41-FE9384C6AA77:0x121c:0xf.125]) in
application
"Forte Runtime", pid 470 on node DEVELOPMENT02 in environment
centrale.

Getting the below error when trying to fetch the data from SQL sources (DB2

Getting the below error when trying to fetch the data from SQL sources (DB2 UDB database) thru Essbase Load rule.
'Failed to connect to SQL Databases'
When trying to connect to database using the example in the merant driver location, the following error is coming:'
As suggested in the esb_sql_interface.pdf, the odbc.ini file in $MERANT_HOME fiolder been updated to include the relational data sources and this file is being copied to $ESSBASEPATH/bin '/home/hyperion/Oracle/Middleware/EPMSystem11R1/products/Essbase/EssbaseServer/bin) folder as .odbc.ini and symbolically linked to /home/hyperion/.odbc.ini file
After the above is done, I tried to test the connectivity by executing the example software that come with the package. Below is the error.
Can somebody please provide steps to resolve this? Appreciate your help. Thanks,
-----------------------
eaqhyp02a:{arbor}:/home/hyperion/Oracle/Middleware/EPMSystem11R1/common/ODBC-64/Merant/6.0/example>
$./example
./example DataDirect Technologies, Inc. ODBC Example Application.
Enter the data source name : dolq001
Enter the user name : db2ol1
Enter the password : **********
SQLSTATE = S1000
NATIVE ERROR = -1001
MSG = [DataDirect][ODBC DB2 Wire Protocol driver][DB2]Unknown error: SQLCODE -1001
SQLConnect: Retrying Connect.
SQLSTATE = S1000
NATIVE ERROR = -1001
MSG = [DataDirect][ODBC DB2 Wire Protocol driver][DB2]Unknown error: SQLCODE -1001
SQLConnect: Retrying Connect.
SQLSTATE = S1000
NATIVE ERROR = -1001
MSG = [DataDirect][ODBC DB2 Wire Protocol driver][DB2]Unknown error: SQLCODE -1001
SQLConnect: Retrying Connect.
eaqhyp02a:{arbor}:/home/hyperion/Oracle/Middleware/EPMSystem11R1/common/ODBC-64/Merant/6.0/example>
$cd $ESSBASEPATH/bin
eaqhyp02a:{arbor}:/home/hyperion/Oracle/Middleware/EPMSystem11R1/products/Essbase/EssbaseServer/bin> 
You cannot believe the weiredest thing. I believe the instruction is wrong. It happened to us from Essbase when we tried to load the rules file an hour ago.
We were able to see on the log file that it gave the path of diffrent from $ESSBASEPATH which is at the products directory.
However it is looking for the path in
home/hyperion/Oracle/Middleware/user_projects/epmsystem1/EssbaseServer/essbaseserver1/bin/.odbc.ini
We copied the .odbc.ini file to this directory and were good to go !!
Hope that helps.
Application Log File when we got error showed
[Fri Sep 24 11:16:56 2010]Local/RevFlash/RevFlash/admin#Native Directory/Info(1013091)
Received Command [OtlQueryMbrs] from user [admin#Native Directory]
[Fri Sep 24 11:17:05 2010]Local/RevFlash/RevFlash/admin#Native Directory/Info(1013091)
Received Command [SQLListDsn] from user [admin#Native Directory]
[Fri Sep 24 11:17:05 2010]Local/RevFlash/RevFlash/admin#Native Directory/Info(1021020)
Cannot read SQL driver name for [PDWH1] from [home/hyperion/Oracle/Middleware/user_projects/epmsystem1/EssbaseServer/essbaseserver1/bin/.odbc.ini]
[Fri Sep 24 11:17:05 2010]Local/RevFlash/RevFlash/admin#Native Directory/Info(1021020)
Cannot read SQL driver name for [ps] from [home/hyperion/Oracle/Middleware/user_projects/epmsystem1/EssbaseServer/essbaseserver1/bin/.odbc.ini]
Jullin

Connection problem on Linux with ODBC Drivers for Oracle

Hello,
I have downloaded the ODBC Drivers for Oracle from the DD driect site. i have intalled the Evalution version on Linuxbox succesfully.
But now I am facing the problem as below :
----------------------------------------------------------------
[root#hyrlnx04 example]# ./example
./example DataDirect Technologies, Inc. ODBC Example Application.
Enter the data source name : oracle
Enter the user name : SYSTEM
Enter the password : abcdef
SQLSTATE = IM003
NATIVE ERROR = 0
MSG = [DataDirect][ODBC lib] Specified driver could not be loaded
SQLConnect: Retrying Connect.
SQLSTATE = IM003
NATIVE ERROR = 0
MSG = [DataDirect][ODBC lib] Specified driver could not be loaded
SQLConnect: Retrying Connect.
SQLSTATE = IM003
NATIVE ERROR = 0
MSG = [DataDirect][ODBC lib] Specified driver could not be loaded
SQLConnect: Retrying Connect.
-----------------------------------------------------------------
----------------------------------------------------------------
From the the installed path bin folder i have executed below command it is also showing like this :
------------------------------------------------------------------------------------------------------------
#./ivtestlib /opt/odbc32v52/ivor822.so
Load of /opt/odbc32v52/ivor822.so failed: /opt/odbc32v52/ivor822.so: cannot open shared object file: No such file or directory
--------------------------------------------------------------------------------------------------------------
Below are my env settings :
-------------------------------------------------------------------------------------------------------------
LD_LIBRARY_PATH="/home/oracle:/opt/odbc32v52:/opt/odbc32v52/lib:/usr/lib:."
ODBCINI=/opt/odbc32v52
----------------------------------------------------------------------------------------------------------------
Please provide me some solution for this .....
Is there any thing that i need to set apart from this.......
Thanks ,
Sridhar.

Categories

Resources