Re: problem with ORACLE, OLE-DB, ASP

I couldn't figure out how to use old-db either and tried to use the same connection as you have.

I did manage to figure out how to do an ODBC connection though using 2: as the database name, which means use the local oracle server:

Create an odbc connection called ora7 with an sql*net connection string of 2:

Then use this for the asp connection:
dbConn="data source=Ora7;dbq=2:;user id=" & strUserID & ";password=" & strPassword & ";"

Theres probably a much better way to connect, but this one works for me and I haven't had the time to investigate it further.

Cheers

Russ

"Maru" <marucanc_at_tin.it> wrote in message news:8p7ovc$dda$1_at_fe1.cs.interbusiness.it...
> Hi everyone. I am new in programming.. I do need help!!!
> I have a problem connecting an Oracle db using ASP tecnology and OLE-DB.
> In my asp page I put:
>
> dbConn="Provider=MSDAORA.1;Data
> Source=source_name;Database=database_name;User
> ID=user_id;Password=password;"
> set rs = Server.CreateObject("ADODB.Recordset")
> rs.Open ......., dbConn
>
> This page will run on a server with windows 2000 and IIS 5.0.
> The connection doesn' work.
> Do I have to install something special on my server? somthing like an
 oracle
> client?
> Please! Help me :)
>
> Marusca
>
>
Received on Thu Sep 07 2000 - 08:34:44 CDT