I have an Oracle Server 11.2.0.2.0 Enterprise Edition installed on a 64-bit Windows Server 2008 R2 Standard. I need to be able to connect from it to MS-Access and have an Oracle stored procedure run DML commands on tables in an Access database. Motiondv Studio 5.6e For Windows 7.

Oracle 10 DB link to SQL Server not working. Up vote 0 down vote favorite. We are using DB link from Oracle 11g to SQL Server. (PROGRAM = hsodbc) ) DB link in.

Following some advice I found on the Net, I did the following steps, all on the Oracle server itself: 1 I created a new System DSN ODBC called PristineDSN with the 'Microsoft Access Driver', using the abovementioned MS-Access database. Note that I did not use the one under Start->'Administrative Tools'->'Data Sources (ODBC)' because it did not have the 'Microsoft Access Driver'. I ran odbcad32.exe under C: Windows SysWOW64 instead. 2 I created a file called initPristineDSN.ora under $ORACLE_HOME hs admin containing the following three lines.

TNS Ping Utility for 64-bit Windows: Version 11.2.0.2.0 - Production on 05-DEC-2011 13:46:47 Copyright (c) 1997, 2010, Oracle. All rights reserved. Used parameter files: E: ORACLE product 11.2.0 d b network admin sqln et.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION= (ADDRESS_LIST = (ADDRESS=(PROTOCOL=tcp)(HO ST=localho st)(PORT=1 521))) (CONNECT_DATA=(SID=Pristin eDSN)) (HS=OK)) OK (20 msec) 6 I connected to a schema and ran the folowing command to create a database link. ERROR at line 1: ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from DBL_PRISTINE The procedure above worked on a previous machine I had, running Oracle Server 10.2.0.1.0 Enterprise Edition on a 32-bit Windows Server 2003 SP2. What am I doing wrong?

Perhaps there is a simpler way to connect from Oracle 11g to MS-Access? Note: All instances of $ORACLE_HOME in the steps above have been substituted for E: ORACLE product 11.2.0 d b which is the value of ORACLE_HOME under the HKEY_LOCAL_MACHINE SOFTWAR E ORACLE K EY_OraDb11 g_home1 key in the server's registry. Also, Microsoft Access is not installed on the server; only the Microsoft Access Driver is. Did you modify your sqlnet.ora to the following?: SQLNET.AUTHENTICATION_SERV ICES= (NONE) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) - after the changes above, restart the listener. If its still not working, i think my team have a similar issue when setting up HS recently. On Oracle 11g, there is no longer hsodbc. Instead you have to setup Database gateway for ODBC - dg4odbc.