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

Reply to this topic