The scene is..
system 1-
IIS/ASP
Mapped F:\ ----- system2\c:\database\
F:\db1.mdb
system 2
Access database file
Eg.C:\database\db1.mdb
I m using ASP connection to access database form 1 to 2
in system one I have mapped a drive to database folder on 2.
system 1 is having all rights for database folder on 2
I have tried using Dsn,udl,jet to connect to mdb file using ASP.
I cudn't..
The Script--------------------------->>
<%@ Language=VBScript%>
<%Option Explicit%>
<%Response.buffer="true"%>
<HTML>
<HEAD>
<TITLE>Connect </TITLE>
</HEAD>
<BODY>
<%
Dim adOpenForwardOnly, adLockReadOnly, adCmdTable
adOpenForwardOnly=0
adLockReadOnly=1
adCmdTable=2
Dim objConn, objRS
Set objConn= Server.CreateObject("ADODB.Connection")
Set objRS=server.CreateObject("ADODB.Recordset")
'With Jet
'objconn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Inetpub\test\db1.mdb;Persist Security Info=False"
'with UDL
'objConn.open "File Name=C:\test\connect1.udl"
'DSN
objConn.open "DSN=dsn2"
'DSNLESS
'objconn.open "Driver={Microsoft Access driver (*.mdb)}; DBQ=F:\db1.mdb"
objRS.Open "Authors", objConn, adOpenForwardOnly, adLockReadOnly,
adCmdTable
Response.write "FirstName:" & " " & "LastName" &"<Br>"
While Not objRS.EOF
Response.write objRS("fname")& " " & objRS("lname") &"<BR>"
objRS.MoveNext
Wend
objRS.Close
objConn.Close
Set objRS=nothing
Set objConn=nothing
%>
</BODY>
</HTML>
Neo
View Cart
