CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

 Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Print topic Send  topic

Author Message
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



View profile  Send private message
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/
>

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.