Issue trying to connect oracle to mysql database

10-11  Source: Network gathering  Views:4 

Advertisement
Hi there,
I need some help with the configuration, i'm trying to connect a windows oracle 11g r2 to a linux mysql 5.5, but i'm having a lot of issue, here i will put the configuration.
Thanks for everyone how will try to help me!
here is my tnsname.ora:
# tnsnames.ora Network Configuration File: C:\app\Administrador\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gabriel-103eff2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
ms_connection =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=gabriel-103eff2)(PORT=1521))
(CONNECT_DATA=(SID=ms))
(HS=OK)
here is my listener.ora:
# listener.ora Network Configuration File: C:\app\Administrador\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\Administrador\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrador\product\11.2.0\dbhome_1\bin\oraclr11.dll")
(SID_DESC=
(SID_NAME=ms)
(ORACLE_HOME=C:\app\Administrador\product\11.2.0\dbhome_1)
(PROGRAM=dg4odbc)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = gabriel-103eff2)(PORT = 1521))
ADR_BASE_LISTENER = C:\app\Administrador
here is the init*.ora:
# This is a sample agent init file that contains the HS parameters that are
# needed for the Database Gateway for ODBC
# HS init parameters
HS_FDS_CONNECT_INFO = ms
HS_FDS_TRACE_LEVEL = debug
# Environment variables required for the non-Oracle system
#set <envvar>=<value>
here is the debug:
Oracle Corporation --- SEXTA-FEIRA JAN 04 2013 17:18:13.390
Heterogeneous Agent Release
11.2.0.1.0
Oracle Corporation --- SEXTA-FEIRA JAN 04 2013 17:18:13.390
Version 11.2.0.1.0
Entered hgogprd
HOSGIP for "HS_FDS_TRACE_LEVEL" returned "debug"
Entered hgosdip
setting HS_OPEN_CURSORS to default of 50
setting HS_FDS_RECOVERY_ACCOUNT to default of "RECOVER"
setting HS_FDS_RECOVERY_PWD to default value
setting HS_FDS_TRANSACTION_LOG to default of HS_TRANSACTION_LOG
setting HS_IDLE_TIMEOUT to default of 0
setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"
setting HS_NLS_NCHAR to default of "UCS2"
setting HS_FDS_TIMESTAMP_MAPPING to default of "DATE"
setting HS_FDS_DATE_MAPPING to default of "DATE"
setting HS_RPC_FETCH_REBLOCKING to default of "ON"
setting HS_FDS_FETCH_ROWS to default of "100"
setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"
setting HS_FDS_RSET_RETURN_ROWCOUNT to default of "FALSE"
setting HS_FDS_PROC_IS_FUNC to default of "FALSE"
setting HS_FDS_CHARACTER_SEMANTICS to default of "FALSE"
setting HS_FDS_MAP_NCHAR to default of "TRUE"
setting HS_NLS_DATE_FORMAT to default of "YYYY-MM-DD HH24:MI:SS"
setting HS_FDS_REPORT_REAL_AS_DOUBLE to default of "FALSE"
setting HS_LONG_PIECE_TRANSFER_SIZE to default of "65536"
setting HS_SQL_HANDLE_STMT_REUSE to default of "FALSE"
setting HS_FDS_QUERY_DRIVER to default of "TRUE"
setting HS_FDS_SUPPORT_STATISTICS to default of "FALSE"
Parameter HS_FDS_QUOTE_IDENTIFIER is not set
setting HS_KEEP_REMOTE_COLUMN_SIZE to default of "OFF"
setting HS_FDS_GRAPHIC_TO_MBCS to default of "FALSE"
setting HS_FDS_MBCS_TO_GRAPHIC to default of "FALSE"
Default value of 32 assumed for HS_FDS_SQLLEN_INTERPRETATION
setting HS_CALL_NAME_ISP to "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo"
setting HS_FDS_DELAYED_OPEN to default of "TRUE"
setting HS_FDS_WORKAROUNDS to default of "0"
Exiting hgosdip, rc=0
ORACLE_SID is "ms"
Product-Info:
Port Rls/Upd:1/0 PrdStat:0
Agent:Oracle Database Gateway for ODBC
Facility:hsa
Class:ODBC, ClassVsn:11.2.0.1.0_0008, Instance:ms
Exiting hgogprd, rc=0
Entered hgoinit
HOCXU_COMP_CSET=1
HOCXU_DRV_CSET=178
HOCXU_DRV_NCHAR=1000
HOCXU_DB_CSET=873
HOCXU_SEM_VER=112000
Entered hgolofn at 2013/01/04-17:18:14
Exiting hgolofn, rc=0 at 2013/01/04-17:18:14
HOSGIP for "HS_OPEN_CURSORS" returned "50"
HOSGIP for "HS_FDS_FETCH_ROWS" returned "100"
HOSGIP for "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536"
HOSGIP for "HS_NLS_NUMERIC_CHARACTER" returned ".,"
HOSGIP for "HS_KEEP_REMOTE_COLUMN_SIZE" returned "OFF"
HOSGIP for "HS_FDS_DELAYED_OPEN" returned "TRUE"
HOSGIP for "HS_FDS_WORKAROUNDS" returned "0"
HOSGIP for "HS_FDS_MBCS_TO_GRAPHIC" returned "FALSE"
HOSGIP for "HS_FDS_GRAPHIC_TO_MBCS" returned "FALSE"
Invalid value of 32 given for HS_FDS_SQLLEN_INTERPRETATION
treat_SQLLEN_as_compiled = 1
Exiting hgoinit, rc=0 at 2013/01/04-17:18:14
Entered hgolgon at 2013/01/04-17:18:14
reco:0, name:SYSTEM, tflag:0
Entered hgosuec at 2013/01/04-17:18:14
Exiting hgosuec, rc=0 at 2013/01/04-17:18:14
HOSGIP for "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER"
HOSGIP for "HS_FDS_TRANSACTION_LOG" returned "HS_TRANSACTION_LOG"
HOSGIP for "HS_FDS_TIMESTAMP_MAPPING" returned "DATE"
HOSGIP for "HS_FDS_DATE_MAPPING" returned "DATE"
HOSGIP for "HS_FDS_CHARACTER_SEMANTICS" returned "FALSE"
HOSGIP for "HS_FDS_MAP_NCHAR" returned "TRUE"
HOSGIP for "HS_FDS_RESULTSET_SUPPORT" returned "FALSE"
HOSGIP for "HS_FDS_RSET_RETURN_ROWCOUNT" returned "FALSE"
HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE"
HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"
using SYSTEM as default value for "HS_FDS_DEFAULT_OWNER"
HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
Entered hgocont at 2013/01/04-17:18:14
HS_FDS_CONNECT_INFO = "msodbc"
RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"
Entered hgogenconstr at 2013/01/04-17:18:14
dsn:msodbc, name:SYSTEM
optn:
Entered hgocip at 2013/01/04-17:18:14
dsn:msodbc
Exiting hgocip, rc=0 at 2013/01/04-17:18:14
Exiting hgogenconstr, rc=0 at 2013/01/04-17:18:14
Entered hgopoer at 2013/01/04-17:18:14
hgopoer, line 233: got native error 0 and sqlstate IM002; message follows...
[Microsoft][ODBC Driver Manager] Nome da fonte de dados não encontrado e nenhum driver padrão especificado {IM002}
Exiting hgopoer, rc=0 at 2013/01/04-17:18:14
hgocont, line 2753: calling SqlDriverConnect got sqlstate IM002
Exiting hgocont, rc=28500 at 2013/01/04-17:18:15 with error ptr FILE:hgocont.c LINE:2773 ID:Something other than invalid authorization
Exiting hgolgon, rc=28500 at 2013/01/04-17:18:15 with error ptr FILE:hgolgon.c LINE:781 ID:Calling hgocont
Entered hgoexit at 2013/01/04-17:18:15
Exiting hgoexit, rc=0
when i use tnsping ms_connection
C:\Documents and Settings\Administrador>tnsping ms_connection
TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 07-JAN-2
013 09:04:29
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Arquivos de parÔmetros usados:
Usado o adaptador TNSNAMES para resolver o apelido
Tentativa de contatar (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=gabriel-103eff2
)(PORT=1521)) (CONNECT_DATA=(SID=ms)) (HS=OK))
OK (0 ms)
Thank you so much!!!
Hi Klaus,
DG40DBC is installed in windows XP 32bit, tje DG4ODBC its installed in the oracle 11g EE r2, automatic right?
The ODBC driver i had installed was mysql-connector-odbc-5.2.2-win32.exe
Here is the registry key:
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC File DSN]
"DefaultDSNDir"="C:\\Arquivos de programas\\Arquivos comuns\\ODBC\\Data Sources"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Conversor de página de código MS]
"Translator"="C:\\WINDOWS\\system32\\MSCPXL32.dll"
"Setup"="C:\\WINDOWS\\system32\\MSCPXL32.dll"
"UsageCount"=dword:00000002
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Driver da Microsoft para arquivos texto (*.txt; *.csv)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
"Setup"="C:\\WINDOWS\\system32\\odtext32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.,*.asc,*.csv,*.tab,*.txt,*.csv"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Driver do Microsoft Access (*.mdb)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
"Setup"="C:\\WINDOWS\\system32\\odbcjt32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="2"
"FileExtns"="*.mdb"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Driver do Microsoft dBase (*.dbf)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
"Setup"="C:\\WINDOWS\\system32\\oddbse32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.ndx,*.mdx"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Driver do Microsoft Excel(*.xls)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
"Setup"="C:\\WINDOWS\\system32\\odexl32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.xls"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Driver do Microsoft Paradox (*.db )]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
"Setup"="C:\\WINDOWS\\system32\\odpdx32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.db"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Driver para o Microsoft Visual FoxPro]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\vfpodbc.dll"
"Setup"="C:\\WINDOWS\\system32\\vfpodbc.dll"
"APILevel"="0"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.cdx,*.idx,*.fpt"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Access Driver (*.mdb)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
"Setup"="C:\\WINDOWS\\system32\\odbcjt32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="2"
"FileExtns"="*.mdb"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Access-Treiber (*.mdb)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
"Setup"="C:\\WINDOWS\\system32\\odbcjt32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="2"
"FileExtns"="*.mdb"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft dBase Driver (*.dbf)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
"Setup"="C:\\WINDOWS\\system32\\oddbse32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.ndx,*.mdx"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft dBase VFP Driver (*.dbf)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\vfpodbc.dll"
"Setup"="C:\\WINDOWS\\system32\\vfpodbc.dll"
"APILevel"="0"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.cdx,*.idx,*.fpt"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft dBase-Treiber (*.dbf)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
"Setup"="C:\\WINDOWS\\system32\\oddbse32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.ndx,*.mdx"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Excel Driver (*.xls)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
"Setup"="C:\\WINDOWS\\system32\\odexl32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.xls"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Excel-Treiber (*.xls)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
"Setup"="C:\\WINDOWS\\system32\\odexl32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.xls"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft FoxPro VFP Driver (*.dbf)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\vfpodbc.dll"
"Setup"="C:\\WINDOWS\\system32\\vfpodbc.dll"
"APILevel"="0"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.cdx,*.idx,*.fpt"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft ODBC for Oracle]
"UsageCount"=dword:00000001
"Driver"="C:\\WINDOWS\\system32\\msorcl32.dll"
"Setup"="C:\\WINDOWS\\system32\\msorcl32.dll"
"SQLLevel"="1"
"FileUsage"="0"
"DriverODBCVer"="02.50"
"ConnectFunctions"="YYY"
"APILevel"="1"
"CpTimeout"="120"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Paradox Driver (*.db )]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
"Setup"="C:\\WINDOWS\\system32\\odpdx32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.db"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Paradox-Treiber (*.db )]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
"Setup"="C:\\WINDOWS\\system32\\odpdx32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.db"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Text Driver (*.txt; *.csv)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
"Setup"="C:\\WINDOWS\\system32\\odtext32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.,*.asc,*.csv,*.tab,*.txt,*.csv"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Text-Treiber (*.txt; *.csv)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
"Setup"="C:\\WINDOWS\\system32\\odtext32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.,*.asc,*.csv,*.tab,*.txt,*.csv"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Visual FoxPro Driver]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\vfpodbc.dll"
"Setup"="C:\\WINDOWS\\system32\\vfpodbc.dll"
"APILevel"="0"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.cdx,*.idx,*.fpt"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Visual FoxPro-Treiber]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\vfpodbc.dll"
"Setup"="C:\\WINDOWS\\system32\\vfpodbc.dll"
"APILevel"="0"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.cdx,*.idx,*.fpt"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\MS Code Page Translator]
"Translator"="C:\\WINDOWS\\system32\\MSCPXL32.dll"
"Setup"="C:\\WINDOWS\\system32\\MSCPXL32.dll"
"UsageCount"=dword:00000002
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\MS Code Page-Übersetzer]
"Translator"="C:\\WINDOWS\\system32\\MSCPXL32.dll"
"Setup"="C:\\WINDOWS\\system32\\MSCPXL32.dll"
"UsageCount"=dword:00000002
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\MySQL ODBC 5.2w Driver]
"UsageCount"=dword:00000001
"Driver"="C:\\Arquivos de programas\\MySQL\\Connector ODBC 5.2\\Unicode\\myodbc5w.dll"
"Setup"="C:\\Arquivos de programas\\MySQL\\Connector ODBC 5.2\\Unicode\\myodbc5S.dll"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Core]
"UsageCount"=dword:00000001
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers]
"SQL Server"="Installed"
"Microsoft Access Driver (*.mdb)"="Installed"
"Microsoft Text Driver (*.txt; *.csv)"="Installed"
"Microsoft Excel Driver (*.xls)"="Installed"
"Microsoft dBase Driver (*.dbf)"="Installed"
"Microsoft Paradox Driver (*.db )"="Installed"
"Microsoft Visual FoxPro Driver"="Installed"
"Microsoft FoxPro VFP Driver (*.dbf)"="Installed"
"Microsoft dBase VFP Driver (*.dbf)"="Installed"
"Microsoft Access-Treiber (*.mdb)"="Installed"
"Microsoft Text-Treiber (*.txt; *.csv)"="Installed"
"Microsoft Excel-Treiber (*.xls)"="Installed"
"Microsoft dBase-Treiber (*.dbf)"="Installed"
"Microsoft Paradox-Treiber (*.db )"="Installed"
"Microsoft Visual FoxPro-Treiber"="Installed"
"Driver do Microsoft Access (*.mdb)"="Installed"
"Driver da Microsoft para arquivos texto (*.txt; *.csv)"="Installed"
"Driver do Microsoft Excel(*.xls)"="Installed"
"Driver do Microsoft dBase (*.dbf)"="Installed"
"Driver do Microsoft Paradox (*.db )"="Installed"
"Driver para o Microsoft Visual FoxPro"="Installed"
"Microsoft ODBC for Oracle"="Installed"
"Oracle em OraDb11g_home1"="Installed"
"MySQL ODBC 5.2w Driver"="Installed"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Translators]
"MS Code Page Translator"="Installed"
"MS Code Page-Übersetzer"="Installed"
"Conversor de página de código MS"="Installed"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Oracle em OraDb11g_home1]
"APILevel"="1"
"CPTimeout"="60"
"ConnectFunctions"="YYY"
"Driver"="C:\\app\\Administrador\\product\\11.2.0\\dbhome_1\\BIN\\SQORA32.DLL"
"DriverODBCVer"="03.51"
"FileUsage"="0"
"Setup"="C:\\app\\Administrador\\product\\11.2.0\\dbhome_1\\BIN\\SQORAS32.DLL"
"SQLLevel"="1"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\SQL Server]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Setup"="C:\\WINDOWS\\system32\\sqlsrv32.dll"
"SQLLevel"="1"
"FileUsage"="0"
"DriverODBCVer"="03.50"
"ConnectFunctions"="YYY"
"APILevel"="2"
"CPTimeout"="60"
Thanks Klau!
Edited by: 980258 on 07/01/2013 03:38
Related articles
  • Issue trying to connect oracle to mysql database 10-11

    Hi there, I need some help with the configuration, i'm trying to connect a windows oracle 11g r2 to a linux mysql 5.5, but i'm having a lot of issue, here i will put the configuration. Thanks for everyone how will try to help me! here is my tnsname.o

  • I am trying to connect oracle develper suit form with oracle 10g database 11-30

    i am trying to connect oracle develper suit form with oracle 10g database but when i pass username and password this message apperars ORA-12560:TNS:protocol adapter error every time even i try to connect Report or Designer each time same problem maki

  • Can APEX/ORACLE connect to a mysql database? 11-30

    Hi Just wondered whether APEX and ORACLE could connect to mysql database. I may have a requirement to link to a mysql database and retrieve the data and wondered if APEX could do this. ThanksHi Apex sits within the Oracle database. Oracle can connect

  • Connect to a mysql database with Oracle 9i 11-30

    Hello, how can I connect to a non_oracle-database in "Oracle 9i". I created a ODBC data source. In Oracle8 I needed OCA. But in 9i I believe the OCA is replaced by another thing. I wanted to connect in SQL*PLUS with: username/[email protected]:mysql

  • Connecting to a Mysql database using a ColdFusion server 10-11

    can't create a mysql datasource in CF Administrator. If I use the following datasource settings in CF Administrator: JDBC URL: jdbc:mysql://localhost:3306/test Drive Class: MySQL Connector J AND (note the emphasis) I set my local and remote folders i

  • How to connect to a MySQL database in another server 10-11

    Dear friends, I am using Oracle SQL Developer 1.5.3 and I need to connect to a MySQL database located in another server. I am trying to create a new connection, informing connection name, username and password. Supposing that "Hostname" is the I

  • Connecting to a Mysql database using CF Administrator and DW 10-11

    I can't create a mysql datasource in CF Administrator. If I use the following datasource settings in CF Administrator: JDBC URL: jdbc:mysql://localhost:3306/test Drive Class: MySQL Connector J AND (note the emphasis) I set my local and remote folders

  • Connecting to a MySQL Database 10-11

    I just installed the XAMPP control panal that gives me the graphic user interface for Mysql server. I'm trying to connect Dreamweaver to a database I created on my local server using XAMPP. In Dreamweaver when I try to connect to the mysql server (an

  • Can't Connect to the Mysql Database using J2SE jdk1.5 10-11

    Can anyone tell me why this error occurs ???????????????????? Following are the codes ; package dbconnect2; import java.sql.*; public class dbconn2 { public static final String URL = "jdbc:mysql://localhost:3306/test"; public static final String

  • Getting Error when trying to connect to the Primavera database. PPM V7 SP3 10-11

    Hi Guys, Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'mailService' defined in class path resource [com/primavera/bre//com/primavera/bre/integration/intgconf.xml]: Invalid destruction signature; ne

  • PHP Connection to a MySQL database "An unidentified err has occurred" 11-30

    This is driving me up the wall.... With my hosting provider at work I cannot make a connection to a MySQL database with dreamweaver using the new connection in the databases tab. "an unidentified error has occurred" I am certain that I am enteri

  • How do I connect to a mysql database? 10-11

    I am trying to write a small program with Java to do some operation on a Mysql database. The first step is to connect to the database. Can anybody give me some information about how to connect to it with JDBC? Thank you in advance!// SQL jdbc driver

  • How to connect Oracle 7.x database using weblogic 11g 11-30

    Hi, For one of my requirement, I need to connect to a Oracle 7.x database using weblogic 11g Application server. Any idea?Tried as per the suggestion from the link : http://jvzoggel.wordpress.com/2011/07/26/weblogic-ojdbc-driver/ It worked.Read other

  • Creating a connection to a mysql database 11-30

    New to CQ5. Version: CQ5_5 Running a local instance on my desktop. Trying to connect to localhost:3306 mysql database I downloaded the mysql driver and used the instructions here to create and build an OSGI bundle. http://cq-ops.tumblr.com/post/21893

  • Need help connecting a remote MySql database from Iphone 10-11

    Hi, i need to connect to a remote MySql DataBase in windows from IPhone but..... i'm a noob with Xcode and Objective-C. Can someone help me or explain me the way to do it plz? Message was edited by: Krovax87 Message was edited by: Krovax87I do not th

  • Problem creating connection pool to mysql database 11-30

    Please, do not ignore this message and help me, if you have any Idea I have Sun Java System Application Server 8.1 installed on my computer, I installed also MySQL Connector/J to access MySql Databases through JDBC But now when I try to create new co

  • Not able to connect to remote MySQL database using Connector/J 11-30

    I have an application that uses a connection pool for database access. It is initialized with this context.xml entry: The db server is running on port 3307.      <Resource name="jdbc/DB" auth="Container"                     type=&qu

  • Trying to connect GUI to access database 10-11

    i need alittle help i have this GUI that i created and i am trying to hook it up to a database in MS ACCESS and i am have so many problems trying to get my second table called billings to pull and show up in my GUI please take a look at my code and t

  • Intermittent error while trying to connect oracle through shell script 11-30

    Hi All, I am getting following error Intermittently while connecting to oracle database. ERROR: ORA-03113: end-of-file on communication channel SP2-0306: Invalid option. Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] where <logon> ::= <username&g

  • How to connect JSP with MySql Database? 11-30

    HI All... I want to know or How to connect Mysql with JSP or JSF any other software is available? please help me.....I want to know or How to connect Mysql with JSP or JSF any other software isavailable? please help me.....First you need to find 25 m