vikks007
Posts: 1
|
Posted: 08/10/2009, 6:02 PM |
|
Hi Guys,
i am trying to run this code in ASP file named home.asp with System DSN as "client"
<%@language="VBScript"%>
<%
Set con=Server.CreateObject("ADODB.Connection")
con.Open "DSN=client"
Set rs=Server.CreateObject("ADODB.Recordset")
rs.ActiveConnection=con
rs.CursorType=3
rs.CursorLocation=3
rs.Open "Select * from client "
%>
<%
rs.close()
con.close()
%>
and i am getting this Error Message:
Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
(i have vista installed with IIS 7.0 and my code is trying to just connect with Ms-access DB named "client" for which DSN have been created. i tried making user dsn, system dsn and file dsn -all of these while troubleshooting but error is still there. All my other regular asp pages are running well.
I also tried all my level best ways to give Full Control Permissions to IUSR for my MDB file "client.mdb" and to my folder named "client"
i have put this client dir in c:\inetpub\wwwroot\client\ and have both my asp file and mdb file in this client folder in the same folder.
pls. assist me if anybody knows the solution to fix it.
pls. email me :vikks007@yahoo.com or post it here. thanks
|
|
|
Jan K. van Dalen
|
Posted: 08/20/2009, 7:23 AM |
|
http://support.codecharge.com/files/CodeChargeFAQ.html#_Toc517263838
"vikks007" <vikks007@forum.codecharge> wrote in message
news:64a80c30cbb93c@news.codecharge.com...
> Hi Guys,
>
> i am trying to run this code in ASP file named home.asp with System DSN as
> "client"
>
> <%@language="VBScript"%>
> <%
> Set con=Server.CreateObject("ADODB.Connection")
> con.Open "DSN=client"
> Set rs=Server.CreateObject("ADODB.Recordset")
> rs.ActiveConnection=con
> rs.CursorType=3
> rs.CursorLocation=3
> rs.Open "Select * from client "
> %>
> <%
> rs.close()
> con.close()
> %>
>
> and i am getting this Error Message:
>
> Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine
> cannot open the file '(unknown)'. It is already opened exclusively by
> another
> user, or you need permission to view its data.
>
> (i have vista installed with IIS 7.0 and my code is trying to just connect
> with
> Ms-access DB named "client" for which DSN have been created. i tried
> making user
> dsn, system dsn and file dsn -all of these while troubleshooting but error
> is
> still there. All my other regular asp pages are running well.
>
> I also tried all my level best ways to give Full Control Permissions to
> IUSR
> for my MDB file "client.mdb" and to my folder named "client"
>
> i have put this client dir in c:\inetpub\wwwroot\client\ and have both my
> asp
> file and mdb file in this client folder in the same folder.
>
> pls. assist me if anybody knows the solution to fix it.
> pls. email me :vikks007@yahoo.com or post it here. thanks
>
>
>
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|