ASP Oracle connection

[Guest_imported]

Can someone, please explain to me how to access oracle database with asp?
I am an oracle guy but recently, have been trying to move to more front-end processing with jdbc and asp.
More important, is the process of setting up the access path.
Thanks in advance.

 

[TWillard]

Check out this FAQ first!!

faq333-178

 

[clofton]

<%
Dim DBAliasName, myConnectionName
DBAliasName = &quot;Provider=MSDAORA;Persist Security Info=False;Data Source=databasePhysicalName;User ID=ThisIsMyUserID;Password=ThisIsMyPassword&quot;
Set myConnectionName = Server.CreateObject(&quot;ADODB.Connection&quot;)
myConnectionName.Open DBAliasName
%>

OK, the second line is actually DBAliasName = "Prov.........ord=ThisIsMyPassword"

The screen split it into multiple lines, hopefully you will be able to put it back together easily.

DBAliasName is just a name you would refer to when doing a select or whatever command you would do.

databasePhysicalName is the name of the database as it resides on the server.

myConnectionName is the name of the connection to the database from ASP.

I am rather new with ASP and could not find much on this, it took a while to get it to work for me since I could not find a lot of info on it, but hopefully this can get you started. Of course this would open the connection to the database and you would definitely need to close it later.

 

[Guest_imported]

Thanks TWillard and clofton for your quick and useful responses.
I guess my biggest problem is connecting to the database?.
For instance, do I need an IIS as a bridge between odbc, asp and oracle.
Second, with jdbc,(i finally was able to connect to an oracle today with jdbc and odbc) but with jdbc, I can either user applets or standalone java as long as I navigate to jdk bin directory.

How do I test a code snippet like:
"Driver={SQL Server}; Server=(local); Database=Northwind; UID=sa; PWD=;"
to see if it is making connection to the database?
If I can get this part, I will be very appreciative.

 

[Guest_imported]

can someone else please help me out here?
I need to know how to verify that access has been made to the database.
Do I use IIS, and if yes, how do I determine that I have IIS and how do I set it up and test it.
Thanks in advance.