[SOLVED] Easiest way to open database connection!

Monie · Sep 27th, 2007, 09:05

Hai,

I was wondering if you guys have a "short-cut" or "simplest easiest way" on how to connect to the database and declare the recordset!

Typically, people will do like this:

Code: Select all

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/db/northwind.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "Select * from Customers", conn
%>
<body>
..
..
</body>
<%
rs.close
conn.close
%>

or maybe some thing like this:

External Connection:

Code: Select all

<%
Dim MM_connInvoice_STRING
MM_connInvoice_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../db/product.mdb")
%>

index.asp

Code: Select all

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<!--#include file="../Connections/connInvoice.asp" -->

<%
Dim rsCustomers
Dim rsCustomers_cmd
Dim rsCustomers_numRows

Set rsCustomers_cmd = Server.CreateObject ("ADODB.Command")
rsCustomers_cmd.ActiveConnection = MM_connInvoice_STRING
rsCustomers_cmd.CommandText = "SELECT * FROM tblCustomer ORDER BY CName ASC" 
rsCustomers_cmd.Prepared = true

Set rsCustomers = rsCustomers_cmd.Execute
rsCustomers_numRows = 0
%>

Thanks..

thriftyspider · Oct 19th, 2007, 08:39

I tend to use the same type of code as youv'e indicated and don't know of a better method.
Rob

Monie · Oct 19th, 2007, 08:43

Thanks Rob,

Well, I have done my own research and now I understand which one to use.

[ Here ]

thriftyspider · Oct 20th, 2007, 11:04

Hi again, just found this site http://www.connectionstrings.com/ might come in handy should you decide to use sql server, mySql etc.

Rob

Monie · Nov 1st, 2007, 07:35

I don't have problem with the connection string actually..
Just a question in doing some effective way of coding certain things..

Thanks by the way for that link.