Hello, I have the following connection in my ASP website for my access database, but have recently converted over to oracle. I'm unsure on how I would go about editing this so it could connect to oracle instead of my access database.
Does anyone know of the syntax (code) which would be used to do this?
Thanks again, MoFish
My orcacle database has the following information to login:
server: OrclServ
username: MoFish
password: OOPS
Does anyone know of the syntax (code) which would be used to do this?
Thanks again, MoFish
My orcacle database has the following information to login:
server: OrclServ
username: MoFish
password: OOPS
Code:
<%
Dim CN, DatabaseName, MdbFilePath
Set CN=Server.CreateObject("ADODB.Connection")
'DatabaseName = "../Files/mofish..mdb"
'MdbFilePath=Server.MapPath(DatabaseName)
'CN.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath &";"
CN.Open "Data Source=" & Server.Mappath("../Files/mofish.mdb") & ";Provider=Microsoft.Jet.OLEDB.4.0;"
%>