vunet wrote:
Quote:
Hello,
I want to create a useful function or sub whichever works great for
database connection to avoid typing same code all over. Earlier I was
using include file for opening and closing adoCon object and
connection. Now I really want to use a function to do it.
Where would you put that function? What is wrong with using an include
file?
Quote:
Can one recommend a good example?
>
I have this sample below which does not work for me because of the
mappath being wrong depending on what file under what directory calls
the file with this function:
>
Sub DB_CONN
This isn't a function, it's a subroutine.
Quote:
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath("./db/web.mdb") & ";"
"/" gets to the root. I don't know what your directory structure is but
something like this should work (you don't need the ending semicolon):
adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("/db/web.mdb")
Quote:
End Sub
>
Sub DB_CONN_CLOSE
Set adoCon = nothing
End Sub
>
Thank you for any advice.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
