Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: MSaccess odbc and oracle Connection error: Help!

Re: MSaccess odbc and oracle Connection error: Help!

From: Andrea Varone <varone_at_snt.it>
Date: 30 Jun 1998 08:04:17 GMT
Message-ID: <01bda3fe$8a73afa0$478216d4@gilda>


Dear Sanbyi,

        I have found the same problem, so please keep in contact.

Until yesterday I used release 2.00.0301 of the 32bit ODBC driver; it had other very strange behaviours in conjunction with Access97, but no problem with attachments.

Then I upgraded to release 2.05.0301 (2.5.3.1.0B in Oracle Installer) of the ODBC driver and "your" problem (togheter with another*) arose.

It seems that an incomplete connection string (PWD field missing) is returned to Access when you connect interactively through ODBC login forms. Note that previous release returned the PWD field.

There is a way to trace what Access is sending to Oracle in terms of ODBC API calls: you have to set to 1 the TraceODBCAPI value in the\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\ODBC registry key. When you open a database containg an Oracle attachment and you try to open the attached table, you'll get the error message and a file named odbcapi.txt will be written, containing something like this:

SQLAllocEnv(phenv0042F5FC);
SQLAllocConnect(henv0042F5FC, phdbc0042FE60); SQLSetConnectOption(hdbc0042FE60, 103, 00000014); SQLDriverConnect(hdbc0042FE60, hwnd000007A8, "DSN=PORA32;UID=DBO;DBQ=PROTEUS;ASY=OFF;", 39, szConnStrOut, 0, pcbConnStrOut, 0);
SQLError(henv0042F5FC, hdbc0042FE60, hstmt00000000, szSqlState, pfNativeError, szErrorMsg, 8192, pcbErrorMsg); SQLError(henv0042F5FC, hdbc0042FE60, hstmt00000000, szSqlState, pfNativeError, szErrorMsg, 8115, pcbErrorMsg); SQLError(henv0042F5FC, hdbc0042FE60, hstmt00000000, szSqlState, pfNativeError, szErrorMsg, 8059, pcbErrorMsg); SQLError(henv0042F5FC, hdbc0042FE60, hstmt00000000, szSqlState, pfNativeError, szErrorMsg, 7937, pcbErrorMsg); SQLFreeConnect(hdbc0042FE60);
SQLFreeEnv(henv0042F5FC);

Note: 'PORA32' is my data-source name, 'DBO' is user name, 'PROTEUS' is my NetEasy configuration name: as you can see there's no PWD field. Of course I checked 'save password'.

*The other problem is case-sensitivity in table names. With previous driver I could attach an Oracle table named 'CUSTOMERS' by VBA code using 'customers' as both the local and the remote table name in the CreateTableDef method: now I get an error ("no such remote table") and I must use upper case for remote table name!

                                        Bye

Sanbyj_at_telkom.co.za wrote in <6mt9pn$la3$1_at_nnrp1.dejanews.com>...
> Hi all
>
> If I link a table in MS Access to Oracle table and choose "save the
password".
> I can look at my data.
>
> Close the Access and reopen the database just closed and try and look at
the
> data, I get a Connection error 3151.
>
> If I leave out the "Save password" when linking the table, I get prompted
for
> the username and password and I can view my data.
>
> ODBC trace log has a ORA-01017 - ( can I monitor what access is sending
to
> odbc?)
>
> I am useing NT4 SP3,
> Office proffesional for 97 with SR1,
> ODBC core components are all 3.0.28.22
>
> ****Extract from Oracle ODBC support assistant********
> Type: SQL*Net v2
> ODBC Driver Vendor: Oracle73
> ODBC Driver DLL: d:\ORANT\ODBC\sqo32_73.dll
> Oracle Home: D:\ORANT
> RSF release: Required Support Files v7.3 for Win95/WinNT (32bit)
> Oracle Interface DLL: ORA73.DLL
> Found at location: D:\ORANT\BIN\ORA73.DLL
> TNSNAMES.ORA file used: D:\ORANT\NETWORK\ADMIN\TNSNAMES.ORA
> Protocol Stack: tcp
> Net Interface DLL: sqltnsnt.dll
> Found at location: D:\ORANT\BIN\sqltnsnt.dll
> Net Adapter DLL: nttnt.dll
> Found at location: D:\ORANT\BIN\nttnt.dll
>
> Any help will be greatly appreciated.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
Received on Tue Jun 30 1998 - 03:04:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US