Having Connection Problem and viewing problem

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Having Connection Problem and viewing problem

Logged in as: Guest

arrSession:exec spGetSession 2,3,25423

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> ASP >> Having Connection Problem and viewing problem
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Having Connection Problem and viewing problem - 9/1/2005 12:12:13 AM

gmag47

Posts: 1
Score: 0
Joined: 9/1/2005
Status: offline

I am creating a web tracking form using asp/vbscript in dream weaver and using microsoft access as my date base, the problem I am having is that I can not connect to the data base with ODBC and view the web page. Can someone look at my code and tell me wher the problem lies;

<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_HCMAP_STRING

Set MyConn = Server.CreateObject("ADODB.Connection")
strConn = "Driver={Microsoft Access Driver (*.mdb)};DriverID=25;DBQ="
strConn = strConn & Server.MapPath("HCMAP.mdb")
strConn = strConn & ";FIL=MS Access;MaxBufferSize=512;PageTimeout=5;"
MyConn.Open strConn
%>