![]()
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oraDBsvr)(PORT=1521))) Listener Log File /u01/app/oracle/diag/tnslsnr/oraDBsvr/listener/alert/log.xml Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production ![]() All rights reserved.Ĭonnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oraDBsvr)(PORT=1521))) (ADDRESS = (PROTOCOL = TCP)(HOST = oraDBsvr)(PORT = 1521)) # Generated by Oracle configuration tools. # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora log]$ cat /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora Np \\RESOLVEIT-PC\pipe\MSSQL$SQLEXPRESS\sql\query ![]() # Try setting 'text size' to a more reasonable limit # is trying to allocate a huge buffer for a TEXT field. # If you get out-of-memory errors, it may mean that your client # (setting this to /tmp is insecure on a multi-user system) # Whether to write a TDSDUMP file for diagnostic purposes # Global settings are overridden by those in a database # For information about the layout of this file and its settings, # name is found in the installation directory. # This file is installed by FreeTDS if no file by the same HS_FDS_SHAREABLE_NAME = /usr/local/lib/libtdsodbc.soĭescription = ODBC Connection via FreeTDSĭiscription = TDS driver (Sybase / MS SQL) #Oracle odbc driver configuration fetch buffer size 64 Bit#Windows 8 (64bit), with system DSN ODBC connection ACME_POS created with 32 bit ODBC set up (This setting still shows up fine in the 64 bit ODBC). I have also read several blogs, hence there might be a few more settings in the configuration files than the formal documentation says, but these have come from blogs that have “Solved” problems for other similar situations. I am trying to take a SQL Server 2008 feed into Oracle Ware house Builder, and think(!) I have read everything and configured it in accordance (but I presume not given 3 days of failed attempts to fix it). I am having difficulty getting ODBC connection between Oracle OWB app with an 11gR2 DB (running on a VirtualBox Linux) and SQL Server 2008 running directly on the host. ORA-28500: connection from ORACLE to a non-Oracle system returned this message: ORA-02063: preceding line from OWB_75
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |