Re: Oracle 7.2 ODBC and ASP

I have the same enviroment. But my choice is using Oracle OLE in ASP under IIS.
I think since the Oracle Guy are able to run the test program. And you can not connect to oracle in Access97. Chances are the ODBC for your access program has not been set up correctly.
You aslo can use VB to check where is the problem. Add a data control in your vb program, set the data source to your ODBC dns, and try to select the table, check whether the column names will be prompt up for you to select

Gook luck

Rafael Galindo wrote in message ...
>Hi,
>I'm in a project where I have to access some data stored in Oracle 7.2 in a
>IBM RS6000 system, I have NT 4.0 and IIS4.0 to make the Active Server
Pages,
>the Oracle company in may country installed the SQL*net and the ODBC 8, he
>makes some query tests in an aplication that comes with Oracle.
>Now I'm trying to link a table from Oracle into Access97 where the
>aplication for the web will reside, but I'm getting an error telling that
>the conection failed when I try to make the link inside Access.
>
>Someone can help me
>
>Thanks
>
>Rafael
>
>
Received on Tue Jun 29 1999 - 04:06:15 CEST