Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access Database Connection

Status
Not open for further replies.

JohnWoo

Programmer
Dec 6, 2002
5
CA
I can't establish a database connection between asp files and ms-access database... Can anyone help me with this code?

<%
//*****************
//GENERAL FUNCTIONS
//*****************

//open the db connection
function dbOpen() {
var db = Server.CreateObject(&quot;ADODB.Connection&quot;);
db.open(&quot;DSN=ec&quot;);
return db;
}

......

%>

 
Either this is new to me or you are mixing javascript with vbscript.


<%
Sub GetConnectionSub()

Set objConn = Server.CreateObject(&quot;ADODB.Connection&quot;)

objConn.Open &quot;MyDSN&quot;

End Sub

%>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top