|
 |
asptoday_discuss thread: Re: '80004005' Connection error between access database and excel, everything on same server
Message #1 by "Joe Hughes" <JoeHughes@M...> on Wed, 31 Oct 2001 22:47:00 -0000
|
|
Hi Trevor,
Do you or someone else have the spreadsheet open when you are running the
ASP pages, if so - this would be why you cannot access it via ADO.
Joe Hughes
[JoeHughes@M...]
----- Original Message -----
From: "Trevor Mosher" <lil_huge@h...>
To: "ASPToday Discuss" <asptoday_discuss@p...>
Sent: Wednesday, October 31, 2001 9:26 PM
Subject: [asptoday_discuss] '80004005' Connection error between access
database and excel, everything on same server
> Unfortunetly still no go. what we have now is a problem between the
> database and the excel sheets that it is linked to. Everything is now on
> the webserver itself. the Access DB and even the Excel sheets in the same
> folder. the links have been remade using the \\ldo\ type path. The error
> though remains the same this time it reads the Database (tested with a
> normal table out of the database that was not linked to excel)but the
> error now comes at the level of the spreadsheets and says
>
> [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
> engine cannot open the
> file '\\ldoa311a\inetpub\wwwroot\SEK\CurrentFY\TestExcel.xls'. It is
> already opened exclusively by another user, or you need permission to view
> its data.
>
> here is my command code maybe something wrong with it and frontpage made a
> connection string here it is this is in the application_onstart
>
> Dim FrontPage_UrlVars(1)
> '--Project Data Connection
> Application("ScoreCardDB_ConnectionString") = "DRIVER
> {Microsoft Access Driver (*.mdb)};DBQ=URL=CurrentFY/ScoreCardDB.mdb"
> FrontPage_UrlVars(0) = "ScoreCardDB_ConnectionString"
> Application("ScoreCardDB_ConnectionTimeout") = 15
> Application("ScoreCardDB_CommandTimeout") = 30
> Application("ScoreCardDB_CursorLocation") = 3
> Application("ScoreCardDB_RuntimeUserName") = ""
> Application("ScoreCardDB_RuntimePassword") = ""
> '--
> Application("FrontPage_UrlVars") = FrontPage_UrlVars
>
> Set connDB = Server.CreateObject ("ADODB.Connection")
> connDB.Open Application("ScoreCardDB_ConnectionString")
>
> set cmdBuyer = server.CreateObject("ADODB.Command")
> cmdBuyer.ActiveConnection = Application
> ("ScoreCardDB_ConnectionString")
> cmdBuyer.CommandType = 4 ' Stored Procedure Type
> cmdBuyer.CommandText = "TestExcelQ"
> ' cmdBuyer.Parameters.Refresh
> set recBuyer = server.createObject("ADODB.RECORDSET")
> set recBuyer = cmdBuyer.Execute
>
> This is a major delay and help is greatly appreciated
>
$subst('Email.Unsub')
Message #2 by "Trevor Mosher" <lil_huge@h...> on Thu, 1 Nov 2001 13:30:56
|
|
Hi Joe
I wish it was that simple, but unfortunetly its not. Everything is closed
I run it straight out of the browser and i get that error. But if i use a
table out of the same database but that is not linked to an excel sheet it
works fine. I was thinking for some strange reason it might be i need to
connect a driver for Excel maybe. or something to do with permissions to
the temp files, but we opened the permissions on the temp file to full for
everyone so. I'm kind of reaching now and this is a major project that is
due very shortly. Any further suggestions
Trevor
lil_huge@h...
> Hi Trevor,
>
> Do you or someone else have the spreadsheet open when you are running the
> ASP pages, if so - this would be why you cannot access it via ADO.
>
> Joe Hughes
> [JoeHughes@M...]
>
> ----- Original Message -----
> From: "Trevor Mosher" <lil_huge@h...>
> To: "ASPToday Discuss" <asptoday_discuss@p...>
> Sent: Wednesday, October 31, 2001 9:26 PM
> Subject: [asptoday_discuss] '80004005' Connection error between access
> database and excel, everything on same server
>
>
> > Unfortunetly still no go. what we have now is a problem between the
> > database and the excel sheets that it is linked to. Everything is now
on
> > the webserver itself. the Access DB and even the Excel sheets in the
same
> > folder. the links have been remade using the \\ldo\ type path. The
error
> > though remains the same this time it reads the Database (tested with a
> > normal table out of the database that was not linked to excel)but the
> > error now comes at the level of the spreadsheets and says
> >
> > [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
> > engine cannot open the
> > file '\\ldoa311a\inetpub\wwwroot\SEK\CurrentFY\TestExcel.xls'. It is
> > already opened exclusively by another user, or you need permission to
view
> > its data.
> >
> > here is my command code maybe something wrong with it and frontpage
made a
> > connection string here it is this is in the application_onstart
> >
> > Dim FrontPage_UrlVars(1)
> > '--Project Data Connection
> > Application("ScoreCardDB_ConnectionString") = "DRIVER
> > {Microsoft Access Driver (*.mdb)};DBQ=URL=CurrentFY/ScoreCardDB.mdb"
> > FrontPage_UrlVars(0) = "ScoreCardDB_ConnectionString"
> > Application("ScoreCardDB_ConnectionTimeout") = 15
> > Application("ScoreCardDB_CommandTimeout") = 30
> > Application("ScoreCardDB_CursorLocation") = 3
> > Application("ScoreCardDB_RuntimeUserName") = ""
> > Application("ScoreCardDB_RuntimePassword") = ""
> > '--
> > Application("FrontPage_UrlVars") = FrontPage_UrlVars
> >
> > Set connDB = Server.CreateObject ("ADODB.Connection")
> > connDB.Open Application("ScoreCardDB_ConnectionString")
> >
> > set cmdBuyer = server.CreateObject("ADODB.Command")
> > cmdBuyer.ActiveConnection = Application
> > ("ScoreCardDB_ConnectionString")
> > cmdBuyer.CommandType = 4 ' Stored Procedure Type
> > cmdBuyer.CommandText = "TestExcelQ"
> > ' cmdBuyer.Parameters.Refresh
> > set recBuyer = server.createObject("ADODB.RECORDSET")
> > set recBuyer = cmdBuyer.Execute
> >
> > This is a major delay and help is greatly appreciated
Message #3 by Marcus Pina - JUVX <marpia@J...> on Wed, 7 Nov 2001 10:50:09 -0700
|
|
Does anyone have an idea how to fix this?
-----Original Message-----
From: Joe Hughes [mailto:JoeHughes@M...]
Sent: Wednesday, October 31, 2001 3:47 PM
To: ASPToday Discuss
Subject: [asptoday_discuss] Re: '80004005' Connection error between
access database and excel, everything on same server
Hi Trevor,
Do you or someone else have the spreadsheet open when you are running the
ASP pages, if so - this would be why you cannot access it via ADO.
Joe Hughes
[JoeHughes@M...]
----- Original Message -----
From: "Trevor Mosher" <lil_huge@h...>
To: "ASPToday Discuss" <asptoday_discuss@p...>
Sent: Wednesday, October 31, 2001 9:26 PM
Subject: [asptoday_discuss] '80004005' Connection error between access
database and excel, everything on same server
> Unfortunetly still no go. what we have now is a problem between the
> database and the excel sheets that it is linked to. Everything is now on
> the webserver itself. the Access DB and even the Excel sheets in the same
> folder. the links have been remade using the \\ldo\ type path. The error
> though remains the same this time it reads the Database (tested with a
> normal table out of the database that was not linked to excel)but the
> error now comes at the level of the spreadsheets and says
>
> [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
> engine cannot open the
> file '\\ldoa311a\inetpub\wwwroot\SEK\CurrentFY\TestExcel.xls'. It is
> already opened exclusively by another user, or you need permission to view
> its data.
>
> here is my command code maybe something wrong with it and frontpage made a
> connection string here it is this is in the application_onstart
>
> Dim FrontPage_UrlVars(1)
> '--Project Data Connection
> Application("ScoreCardDB_ConnectionString") = "DRIVER
> {Microsoft Access Driver (*.mdb)};DBQ=URL=CurrentFY/ScoreCardDB.mdb"
> FrontPage_UrlVars(0) = "ScoreCardDB_ConnectionString"
> Application("ScoreCardDB_ConnectionTimeout") = 15
> Application("ScoreCardDB_CommandTimeout") = 30
> Application("ScoreCardDB_CursorLocation") = 3
> Application("ScoreCardDB_RuntimeUserName") = ""
> Application("ScoreCardDB_RuntimePassword") = ""
> '--
> Application("FrontPage_UrlVars") = FrontPage_UrlVars
>
> Set connDB = Server.CreateObject ("ADODB.Connection")
> connDB.Open Application("ScoreCardDB_ConnectionString")
>
> set cmdBuyer = server.CreateObject("ADODB.Command")
> cmdBuyer.ActiveConnection = Application
> ("ScoreCardDB_ConnectionString")
> cmdBuyer.CommandType = 4 ' Stored Procedure Type
> cmdBuyer.CommandText = "TestExcelQ"
> ' cmdBuyer.Parameters.Refresh
> set recBuyer = server.createObject("ADODB.RECORDSET")
> set recBuyer = cmdBuyer.Execute
>
> This is a major delay and help is greatly appreciated
>
$subst('Email.Unsub')
marpia@j...
$subst('Email.Unsub')
|
|
|
View Cart
