Forums
This topic is locked
ASP/VB access db connection problem
Posted 22 years ago
1
has voted
22 years ago martin linden posted:
I've built ASP/Javascript pages in DMX and the db connection to access worked just fine. Now I'm trying to build a ASP/VB site and I get the following error in IE:Technical Information (for support personnel)
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.
/krijgsman2/TMP1j485deixt.asp, line 8
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
The code in the page is standard stuff generated by DMX for a master/detail page set:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!-- <!--#include file="Connections/krijgsman.asp" --> -->
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset"

Recordset1.ActiveConnection = "MM_krijgsman_string"
Recordset1.Source = "SELECT * FROM products"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Does anyone recognize this issue or even better have a solution?
Thanks in advance.
Replies
Replied 22 years ago
22 years ago Vince Baker replied:
Not sure if this is your problem but it looks incorrect:
Replace <!-- <!--#include file="Connections/krijgsman.asp" --> -->
with
<!--#include file="Connections/krijgsman.asp" -->
Regards
Vince
Visit my home: www.chez-vince.com
VBScript | ASP | HTML | SQL | Oracle | Hosting
Replace <!-- <!--#include file="Connections/krijgsman.asp" --> -->
with
<!--#include file="Connections/krijgsman.asp" -->
Regards
Vince
Visit my home: www.chez-vince.com
VBScript | ASP | HTML | SQL | Oracle | Hosting