This topic is locked

Database connexion

4/14/2004 8:51:10 AM
ASPRunnerPro General questions
S
superkat author

Hi,
I have installed ASp Runner but it seems it cannot connect to my DB on the server. I guess i have to change something in the connection script.
here is what is says now:
<%

strConnection = "Provider=MSDataShape;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("/pit/Public/Prozesse/KPI/kpi-db.mdb") & ";UID=;PWD="

%>
and it doesn't work.
Here is a connection script that was part of something else, but that works. How could i have this in my ASp Runner?
<%

' Declaring variables

Dim Proc_Name, Proc_Mgr, data_source, con
' Receiving values from Form

Proc_Name = ChkString(Request.Form("Proc_Name"))

Proc_Mgr = ChkString(Request.Form("Proc_Mgr"))

datasource = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &

Server.MapPath("/pit/public/prozesse/kpi/kpi-db.mdb")
' Creating Connection Object and opening the database

Set con = Server.CreateObject("ADODB.Connection")

con.Open data_source
Thanks for any help!
Bets regards,

katja

S
superkat author 4/14/2004

ok, i'm very sorry, forget it i made it work ;-)