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 Rhinorhino 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
Joined
Dec 6, 2002
Messages
5
Location
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