Re: Problem: Excel97 - ODBC - Oracle

schaup_at_zid.tu-graz.ac.at wrote:
>
> mark tomlinson schrieb:
> >
> > I have used that Driver without any problem in that configuration,
> > turn on an ODBC trace and see what the actual error is that the driver
> > is reporting, most likely MSQuery isn't reporting the real error.
>
> There is no chance to get an connection with MS-Query.
> The driver reports Ora01017 wrong username/password?
>
> With Access97 (without MSQuery) there is no problem to get the
> connection to the tables.
>
> Any ideas?
>
> MSQRY32 ad:47 EXIT SQLError with return code 0 (SQL_SUCCESS)
> HENV 0x008306f0
> HDBC 0x00838100
> HSTMT 0x00000000
> UCHAR * 0x000773f8 (NYI)
> SDWORD * 0x0003e10c (0)
> UCHAR * 0x00079c68 [ 84] "[Microsoft][ODBC Driver
> Manager] SQLSetConnectAttr-Aufruf für Treiber fehlgeschlagen"
> SWORD 512
> SWORD * 0x0003e114 (84)

Have you run the 32-bit ODBC Administrator to set up a data source for your Oracle database?

Try building an Access "Link Table" referencing an Oracle table or view. I have successfully run 32-bit ODBC and Access 97.

Good luck!

cmellott_at_flash.net Received on Fri May 15 1998 - 14:03:08 CEST