Runtime error while installing SQL 2005 Standard Edition

Dear All,
I have an instance of SQL 2000 and while Installing another instance of SQL
Server2005 Standard Edition on Windows 2003 with SP1 on Dell Server, I am
getting error
Microsoft Visual C++ Runtime Library
Runtime Error!
Program: C:\WINDOWS\system32\MsiExec.exe
The application has requested the Runtime to terminate it in an
unusual way.
Please contact the application's support team for more information.
All the hardware and software requirements are already there.
Any suggestions!
TIA
KayHi Kay
A couple of this to check
Make sure that you are up-to-date with windows update. Your hardware drivers
are the latest (especially video!). Also check out the SQL Server
installation log files http://msdn2.microsoft.com/en-us/library/ms143702.aspx
John
"Kay" wrote:
> Dear All,
> I have an instance of SQL 2000 and while Installing another instance of SQL
> Server2005 Standard Edition on Windows 2003 with SP1 on Dell Server, I am
> getting error
> Microsoft Visual C++ Runtime Library
> Runtime Error!
> Program: C:\WINDOWS\system32\MsiExec.exe
> The application has requested the Runtime to terminate it in an
> unusual way.
> Please contact the application's support team for more information.
>
> All the hardware and software requirements are already there.
> Any suggestions!
> TIA
> Kay
>
>

Run-time Error Vs. Compile Error!

How to understand whether an error is a run-time error or a compile
error?
Thanks,
ArpanCan you be more specific with your question? A compile error is a syntax
error. A good way to check this is to press the little check mark button in
QA and see if it compiles. Different objects/batches have different compile
requirements. One the code compiles, the next thing is to build a plan, and
the execute. Errors that happen here are considered run-time errors.
Do you have a specific situation that concerns you?
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arpan" <arpan_de@.hotmail.com> wrote in message
news:1123287800.195685.193030@.g44g2000cwa.googlegroups.com...
> How to understand whether an error is a run-time error or a compile
> error?
> Thanks,
> Arpan
>|||Thanks, Louis, for your response. So does compile errors ALWAYS mean
there are some syntax errors i.e. aren't there any other types of
errors (of course, excluding run-time errors) that are considered to be
compile errors?
No, my question is not concerned to any specific situation.
Thanks once again,
Regards,
Arpan|||See the following article by Erland Sommarskog, SQL Server MVP:
http://www.sommarskog.se/error-handling-I.html
(particulary the "Scope Abortion" section)
Razvan|||Definitely read Erland's stuff, but syntax, bad column names, (bad table
names can be ignored for delayed resolution to allow for temporary tables)
that sort of thing. Anything that makes your code unintelligible to SQL
Server. If SQL Server recognizes the syntax like you cannot say IF
condition THEN (it will squawk.) even though IF and THEN are valid in other
places.
Once it feels it likes the syntax, it runs it and everything else is
run-time in that the compiler didn't see the problem, but the query engine
does..
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arpan" <arpan_de@.hotmail.com> wrote in message
news:1123294036.972006.25270@.g14g2000cwa.googlegroups.com...
> Thanks, Louis, for your response. So does compile errors ALWAYS mean
> there are some syntax errors i.e. aren't there any other types of
> errors (of course, excluding run-time errors) that are considered to be
> compile errors?
> No, my question is not concerned to any specific situation.
> Thanks once again,
> Regards,
> Arpan
>

Runtime Error in Site Settings

Hi,
I get a runtime error messsage when I go into Site Settings and click on
Apply. The message reads: "A Runtiime Error has occured. Do you wish to
debug? Line 39: Error: 'undefined' is undefined"
Thank you in advance.Hmm, shouldn't be an error, undefined IS undefined. :)
Seriously though, is there any more information in the
RSWebAplication<date>.log file? Did you do anything special with the VRoots
(i.e. turn on anonymous access, move them to another website)?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Johan" <Johan@.discussions.microsoft.com> wrote in message
news:4E753FB5-E3AC-4F60-A052-7091C49D695E@.microsoft.com...
> Hi,
> I get a runtime error messsage when I go into Site Settings and click on
> Apply. The message reads: "A Runtiime Error has occured. Do you wish to
> debug? Line 39: Error: 'undefined' is undefined"
> Thank you in advance.|||Hi Daniel,
I have not changed anything. I got this message directly after I installed
the software.
When I click "Yes" to debug when the error message appears, the following is
displayed (Settings.aspx file with the last line (if-statement) highlighted
in yellow)
function confirmSnapshotLimit(source, arguments){
var oldEffectivePolicy = -1;
var oldSystemPolicy = -1;
var needConfirmation = false;
if ( document.all('ui_btnSystem') != undefined && document.all
'ui_btnSystem').checked ) {
Here is the contents of the ReportServerWebApp log file:
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>South Africa Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerWebApp__08_20_2004_09_39_55.log</Path>
<SystemName>GKTESTSQL</SystemName>
<OSName>Microsoft Windows NT 5.0.2195.0</OSName>
<OSVersion>5.0.2195.0</OSVersion>
</Header>
aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
MaxScheduleWait to default value of '1' second(s) because it was not
specified in Configuration file.
aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
DatabaseQueryTimeout to default value of '30' second(s) because it was not
specified in Configuration file.
aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
InstanceName to default value of 'MSSQLSERVER.1' because it was not
specified in Configuration file.
aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
ProcessRecycleOptions to default value of '0' because it was not specified
in Configuration file.
aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
RunningRequestsScavengerCycle to default value of '30' second(s) because it
was not specified in Configuration file.
aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
RunningRequestsDbCycle to default value of '30' second(s) because it was not
specified in Configuration file.
aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
RunningRequestsAge to default value of '30' second(s) because it was not
specified in Configuration file.
aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
CleanupCycleMinutes to default value of '10' minute(s) because it was not
specified in Configuration file.
aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
SecureConnectionLevel to default value of '1' because it was not specified
in Configuration file.
aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
DisplayErrorLink to 'True' as specified in Configuration file.
aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was not
specified in Configuration file.
aspnet_wp!resourceutilities!1798!8/20/2004-16:24:49:: i INFO: Reporting
Services starting SKU: Evaluation
aspnet_wp!resourceutilities!1798!8/20/2004-16:24:49:: i INFO: Eval SKU: 118
days left
Thanks
-Johan
"Daniel Reib [MSFT]" wrote:
> Hmm, shouldn't be an error, undefined IS undefined. :)
> Seriously though, is there any more information in the
> RSWebAplication<date>.log file? Did you do anything special with the VRoots
> (i.e. turn on anonymous access, move them to another website)?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Johan" <Johan@.discussions.microsoft.com> wrote in message
> news:4E753FB5-E3AC-4F60-A052-7091C49D695E@.microsoft.com...
> > Hi,
> >
> > I get a runtime error messsage when I go into Site Settings and click on
> > Apply. The message reads: "A Runtiime Error has occured. Do you wish to
> > debug? Line 39: Error: 'undefined' is undefined"
> >
> > Thank you in advance.
>
>|||Was this an upgrade from Beta 2? Can you try deleting your IE temporary
files and see if that helps.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Johan" <Johan@.discussions.microsoft.com> wrote in message
news:3AA144AC-0384-4293-8103-4B01456F442F@.microsoft.com...
> Hi Daniel,
> I have not changed anything. I got this message directly after I installed
> the software.
> When I click "Yes" to debug when the error message appears, the following
is
> displayed (Settings.aspx file with the last line (if-statement)
highlighted
> in yellow)
> function confirmSnapshotLimit(source, arguments){
> var oldEffectivePolicy = -1;
> var oldSystemPolicy = -1;
> var needConfirmation = false;
> if ( document.all('ui_btnSystem') != undefined && document.all
> 'ui_btnSystem').checked ) {
> Here is the contents of the ReportServerWebApp log file:
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.878.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>South Africa Standard Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServerWebApp__08_20_2004_09_39_55.log</Path>
> <SystemName>GKTESTSQL</SystemName>
> <OSName>Microsoft Windows NT 5.0.2195.0</OSName>
> <OSVersion>5.0.2195.0</OSVersion>
> </Header>
> aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
file.
> aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> MaxScheduleWait to default value of '1' second(s) because it was not
> specified in Configuration file.
> aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> DatabaseQueryTimeout to default value of '30' second(s) because it was not
> specified in Configuration file.
> aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> InstanceName to default value of 'MSSQLSERVER.1' because it was not
> specified in Configuration file.
> aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> ProcessRecycleOptions to default value of '0' because it was not
specified
> in Configuration file.
> aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> RunningRequestsScavengerCycle to default value of '30' second(s) because
it
> was not specified in Configuration file.
> aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> RunningRequestsDbCycle to default value of '30' second(s) because it was
not
> specified in Configuration file.
> aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> RunningRequestsAge to default value of '30' second(s) because it was not
> specified in Configuration file.
> aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> CleanupCycleMinutes to default value of '10' minute(s) because it was not
> specified in Configuration file.
> aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> SecureConnectionLevel to default value of '1' because it was not
specified
> in Configuration file.
> aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> DisplayErrorLink to 'True' as specified in Configuration file.
> aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> WebServiceUseFileShareStorage to default value of 'False' because it was
not
> specified in Configuration file.
> aspnet_wp!resourceutilities!1798!8/20/2004-16:24:49:: i INFO: Reporting
> Services starting SKU: Evaluation
> aspnet_wp!resourceutilities!1798!8/20/2004-16:24:49:: i INFO: Eval SKU:
118
> days left
>
> Thanks
> -Johan
>
> "Daniel Reib [MSFT]" wrote:
> > Hmm, shouldn't be an error, undefined IS undefined. :)
> >
> > Seriously though, is there any more information in the
> > RSWebAplication<date>.log file? Did you do anything special with the
VRoots
> > (i.e. turn on anonymous access, move them to another website)?
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Johan" <Johan@.discussions.microsoft.com> wrote in message
> > news:4E753FB5-E3AC-4F60-A052-7091C49D695E@.microsoft.com...
> > > Hi,
> > >
> > > I get a runtime error messsage when I go into Site Settings and click
on
> > > Apply. The message reads: "A Runtiime Error has occured. Do you wish
to
> > > debug? Line 39: Error: 'undefined' is undefined"
> > >
> > > Thank you in advance.
> >
> >
> >|||Hi Daniel,
This was a new installation from the 120 day evaluation CD and I also
installed SP1. I deleted the temp Internet files but to no avail.
"Daniel Reib [MSFT]" wrote:
> Was this an upgrade from Beta 2? Can you try deleting your IE temporary
> files and see if that helps.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Johan" <Johan@.discussions.microsoft.com> wrote in message
> news:3AA144AC-0384-4293-8103-4B01456F442F@.microsoft.com...
> > Hi Daniel,
> >
> > I have not changed anything. I got this message directly after I installed
> > the software.
> >
> > When I click "Yes" to debug when the error message appears, the following
> is
> > displayed (Settings.aspx file with the last line (if-statement)
> highlighted
> > in yellow)
> >
> > function confirmSnapshotLimit(source, arguments){
> > var oldEffectivePolicy = -1;
> > var oldSystemPolicy = -1;
> > var needConfirmation = false;
> > if ( document.all('ui_btnSystem') != undefined && document.all
> > 'ui_btnSystem').checked ) {
> >
> > Here is the contents of the ReportServerWebApp log file:
> >
> > <Header>
> > <Product>Microsoft SQL Server Reporting Services Version
> > 8.00.878.00</Product>
> > <Locale>en-US</Locale>
> > <TimeZone>South Africa Standard Time</TimeZone>
> > <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\LogFiles\ReportServerWebApp__08_20_2004_09_39_55.log</Path>
> > <SystemName>GKTESTSQL</SystemName>
> > <OSName>Microsoft Windows NT 5.0.2195.0</OSName>
> > <OSVersion>5.0.2195.0</OSVersion>
> > </Header>
> > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
> file.
> > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > MaxScheduleWait to default value of '1' second(s) because it was not
> > specified in Configuration file.
> > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > DatabaseQueryTimeout to default value of '30' second(s) because it was not
> > specified in Configuration file.
> > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > InstanceName to default value of 'MSSQLSERVER.1' because it was not
> > specified in Configuration file.
> > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > ProcessRecycleOptions to default value of '0' because it was not
> specified
> > in Configuration file.
> > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > RunningRequestsScavengerCycle to default value of '30' second(s) because
> it
> > was not specified in Configuration file.
> > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > RunningRequestsDbCycle to default value of '30' second(s) because it was
> not
> > specified in Configuration file.
> > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > RunningRequestsAge to default value of '30' second(s) because it was not
> > specified in Configuration file.
> > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > CleanupCycleMinutes to default value of '10' minute(s) because it was not
> > specified in Configuration file.
> > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > SecureConnectionLevel to default value of '1' because it was not
> specified
> > in Configuration file.
> > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > DisplayErrorLink to 'True' as specified in Configuration file.
> > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > WebServiceUseFileShareStorage to default value of 'False' because it was
> not
> > specified in Configuration file.
> > aspnet_wp!resourceutilities!1798!8/20/2004-16:24:49:: i INFO: Reporting
> > Services starting SKU: Evaluation
> > aspnet_wp!resourceutilities!1798!8/20/2004-16:24:49:: i INFO: Eval SKU:
> 118
> > days left
> >
> >
> > Thanks
> > -Johan
> >
> >
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> > > Hmm, shouldn't be an error, undefined IS undefined. :)
> > >
> > > Seriously though, is there any more information in the
> > > RSWebAplication<date>.log file? Did you do anything special with the
> VRoots
> > > (i.e. turn on anonymous access, move them to another website)?
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "Johan" <Johan@.discussions.microsoft.com> wrote in message
> > > news:4E753FB5-E3AC-4F60-A052-7091C49D695E@.microsoft.com...
> > > > Hi,
> > > >
> > > > I get a runtime error messsage when I go into Site Settings and click
> on
> > > > Apply. The message reads: "A Runtiime Error has occured. Do you wish
> to
> > > > debug? Line 39: Error: 'undefined' is undefined"
> > > >
> > > > Thank you in advance.
> > >
> > >
> > >
>
>|||Are you a local admin to the box that has ReportServer? Have you changed
any of your system permissions? Perhaps you have stumbled on a permissions
bug.
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Johan" <Johan@.discussions.microsoft.com> wrote in message
news:14181F51-DCB2-4226-BFB9-B35CC523F180@.microsoft.com...
> Hi Daniel,
> This was a new installation from the 120 day evaluation CD and I also
> installed SP1. I deleted the temp Internet files but to no avail.
>
> "Daniel Reib [MSFT]" wrote:
> > Was this an upgrade from Beta 2? Can you try deleting your IE temporary
> > files and see if that helps.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Johan" <Johan@.discussions.microsoft.com> wrote in message
> > news:3AA144AC-0384-4293-8103-4B01456F442F@.microsoft.com...
> > > Hi Daniel,
> > >
> > > I have not changed anything. I got this message directly after I
installed
> > > the software.
> > >
> > > When I click "Yes" to debug when the error message appears, the
following
> > is
> > > displayed (Settings.aspx file with the last line (if-statement)
> > highlighted
> > > in yellow)
> > >
> > > function confirmSnapshotLimit(source, arguments){
> > > var oldEffectivePolicy = -1;
> > > var oldSystemPolicy = -1;
> > > var needConfirmation = false;
> > > if ( document.all('ui_btnSystem') != undefined && document.all
> > > 'ui_btnSystem').checked ) {
> > >
> > > Here is the contents of the ReportServerWebApp log file:
> > >
> > > <Header>
> > > <Product>Microsoft SQL Server Reporting Services Version
> > > 8.00.878.00</Product>
> > > <Locale>en-US</Locale>
> > > <TimeZone>South Africa Standard Time</TimeZone>
> > > <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > > Services\LogFiles\ReportServerWebApp__08_20_2004_09_39_55.log</Path>
> > > <SystemName>GKTESTSQL</SystemName>
> > > <OSName>Microsoft Windows NT 5.0.2195.0</OSName>
> > > <OSVersion>5.0.2195.0</OSVersion>
> > > </Header>
> > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > MaxActiveReqForOneUser to '20' requests(s) as specified in
Configuration
> > file.
> > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > MaxScheduleWait to default value of '1' second(s) because it was not
> > > specified in Configuration file.
> > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > DatabaseQueryTimeout to default value of '30' second(s) because it was
not
> > > specified in Configuration file.
> > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > InstanceName to default value of 'MSSQLSERVER.1' because it was not
> > > specified in Configuration file.
> > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > ProcessRecycleOptions to default value of '0' because it was not
> > specified
> > > in Configuration file.
> > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > RunningRequestsScavengerCycle to default value of '30' second(s)
because
> > it
> > > was not specified in Configuration file.
> > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > RunningRequestsDbCycle to default value of '30' second(s) because it
was
> > not
> > > specified in Configuration file.
> > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > RunningRequestsAge to default value of '30' second(s) because it was
not
> > > specified in Configuration file.
> > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > CleanupCycleMinutes to default value of '10' minute(s) because it was
not
> > > specified in Configuration file.
> > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > SecureConnectionLevel to default value of '1' because it was not
> > specified
> > > in Configuration file.
> > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > DisplayErrorLink to 'True' as specified in Configuration file.
> > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > WebServiceUseFileShareStorage to default value of 'False' because it
was
> > not
> > > specified in Configuration file.
> > > aspnet_wp!resourceutilities!1798!8/20/2004-16:24:49:: i INFO:
Reporting
> > > Services starting SKU: Evaluation
> > > aspnet_wp!resourceutilities!1798!8/20/2004-16:24:49:: i INFO: Eval
SKU:
> > 118
> > > days left
> > >
> > >
> > > Thanks
> > > -Johan
> > >
> > >
> > >
> > > "Daniel Reib [MSFT]" wrote:
> > >
> > > > Hmm, shouldn't be an error, undefined IS undefined. :)
> > > >
> > > > Seriously though, is there any more information in the
> > > > RSWebAplication<date>.log file? Did you do anything special with
the
> > VRoots
> > > > (i.e. turn on anonymous access, move them to another website)?
> > > >
> > > > --
> > > > -Daniel
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > >
> > > > "Johan" <Johan@.discussions.microsoft.com> wrote in message
> > > > news:4E753FB5-E3AC-4F60-A052-7091C49D695E@.microsoft.com...
> > > > > Hi,
> > > > >
> > > > > I get a runtime error messsage when I go into Site Settings and
click
> > on
> > > > > Apply. The message reads: "A Runtiime Error has occured. Do you
wish
> > to
> > > > > debug? Line 39: Error: 'undefined' is undefined"
> > > > >
> > > > > Thank you in advance.
> > > >
> > > >
> > > >
> >
> >
> >|||I was not in the Administrator group but my login id has been to this group
now. I'm still getting the error though. Do I need to reboot? We are running
on Windows 2000 Advanced Server.
"Daniel Reib [MSFT]" wrote:
> Are you a local admin to the box that has ReportServer? Have you changed
> any of your system permissions? Perhaps you have stumbled on a permissions
> bug.
>
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Johan" <Johan@.discussions.microsoft.com> wrote in message
> news:14181F51-DCB2-4226-BFB9-B35CC523F180@.microsoft.com...
> > Hi Daniel,
> >
> > This was a new installation from the 120 day evaluation CD and I also
> > installed SP1. I deleted the temp Internet files but to no avail.
> >
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> > > Was this an upgrade from Beta 2? Can you try deleting your IE temporary
> > > files and see if that helps.
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "Johan" <Johan@.discussions.microsoft.com> wrote in message
> > > news:3AA144AC-0384-4293-8103-4B01456F442F@.microsoft.com...
> > > > Hi Daniel,
> > > >
> > > > I have not changed anything. I got this message directly after I
> installed
> > > > the software.
> > > >
> > > > When I click "Yes" to debug when the error message appears, the
> following
> > > is
> > > > displayed (Settings.aspx file with the last line (if-statement)
> > > highlighted
> > > > in yellow)
> > > >
> > > > function confirmSnapshotLimit(source, arguments){
> > > > var oldEffectivePolicy = -1;
> > > > var oldSystemPolicy = -1;
> > > > var needConfirmation = false;
> > > > if ( document.all('ui_btnSystem') != undefined && document.all
> > > > 'ui_btnSystem').checked ) {
> > > >
> > > > Here is the contents of the ReportServerWebApp log file:
> > > >
> > > > <Header>
> > > > <Product>Microsoft SQL Server Reporting Services Version
> > > > 8.00.878.00</Product>
> > > > <Locale>en-US</Locale>
> > > > <TimeZone>South Africa Standard Time</TimeZone>
> > > > <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > > > Services\LogFiles\ReportServerWebApp__08_20_2004_09_39_55.log</Path>
> > > > <SystemName>GKTESTSQL</SystemName>
> > > > <OSName>Microsoft Windows NT 5.0.2195.0</OSName>
> > > > <OSVersion>5.0.2195.0</OSVersion>
> > > > </Header>
> > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > > MaxActiveReqForOneUser to '20' requests(s) as specified in
> Configuration
> > > file.
> > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > > MaxScheduleWait to default value of '1' second(s) because it was not
> > > > specified in Configuration file.
> > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > > DatabaseQueryTimeout to default value of '30' second(s) because it was
> not
> > > > specified in Configuration file.
> > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > > InstanceName to default value of 'MSSQLSERVER.1' because it was not
> > > > specified in Configuration file.
> > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > > ProcessRecycleOptions to default value of '0' because it was not
> > > specified
> > > > in Configuration file.
> > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > > RunningRequestsScavengerCycle to default value of '30' second(s)
> because
> > > it
> > > > was not specified in Configuration file.
> > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > > RunningRequestsDbCycle to default value of '30' second(s) because it
> was
> > > not
> > > > specified in Configuration file.
> > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > > RunningRequestsAge to default value of '30' second(s) because it was
> not
> > > > specified in Configuration file.
> > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > > CleanupCycleMinutes to default value of '10' minute(s) because it was
> not
> > > > specified in Configuration file.
> > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > > SecureConnectionLevel to default value of '1' because it was not
> > > specified
> > > > in Configuration file.
> > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > > DisplayErrorLink to 'True' as specified in Configuration file.
> > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > > WebServiceUseFileShareStorage to default value of 'False' because it
> was
> > > not
> > > > specified in Configuration file.
> > > > aspnet_wp!resourceutilities!1798!8/20/2004-16:24:49:: i INFO:
> Reporting
> > > > Services starting SKU: Evaluation
> > > > aspnet_wp!resourceutilities!1798!8/20/2004-16:24:49:: i INFO: Eval
> SKU:
> > > 118
> > > > days left
> > > >
> > > >
> > > > Thanks
> > > > -Johan
> > > >
> > > >
> > > >
> > > > "Daniel Reib [MSFT]" wrote:
> > > >
> > > > > Hmm, shouldn't be an error, undefined IS undefined. :)
> > > > >
> > > > > Seriously though, is there any more information in the
> > > > > RSWebAplication<date>.log file? Did you do anything special with
> the
> > > VRoots
> > > > > (i.e. turn on anonymous access, move them to another website)?
> > > > >
> > > > > --
> > > > > -Daniel
> > > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > > >
> > > > >
> > > > > "Johan" <Johan@.discussions.microsoft.com> wrote in message
> > > > > news:4E753FB5-E3AC-4F60-A052-7091C49D695E@.microsoft.com...
> > > > > > Hi,
> > > > > >
> > > > > > I get a runtime error messsage when I go into Site Settings and
> click
> > > on
> > > > > > Apply. The message reads: "A Runtiime Error has occured. Do you
> wish
> > > to
> > > > > > debug? Line 39: Error: 'undefined' is undefined"
> > > > > >
> > > > > > Thank you in advance.
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>|||I wouldn't think a reboot would help. What Report Server system permissions
do you have?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Johan" <Johan@.discussions.microsoft.com> wrote in message
news:AC2AEBA4-62FA-4D60-BF1C-284B4702F7F8@.microsoft.com...
> I was not in the Administrator group but my login id has been to this
group
> now. I'm still getting the error though. Do I need to reboot? We are
running
> on Windows 2000 Advanced Server.
>
> "Daniel Reib [MSFT]" wrote:
> > Are you a local admin to the box that has ReportServer? Have you
changed
> > any of your system permissions? Perhaps you have stumbled on a
permissions
> > bug.
> >
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Johan" <Johan@.discussions.microsoft.com> wrote in message
> > news:14181F51-DCB2-4226-BFB9-B35CC523F180@.microsoft.com...
> > > Hi Daniel,
> > >
> > > This was a new installation from the 120 day evaluation CD and I also
> > > installed SP1. I deleted the temp Internet files but to no avail.
> > >
> > >
> > > "Daniel Reib [MSFT]" wrote:
> > >
> > > > Was this an upgrade from Beta 2? Can you try deleting your IE
temporary
> > > > files and see if that helps.
> > > >
> > > > --
> > > > -Daniel
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > >
> > > > "Johan" <Johan@.discussions.microsoft.com> wrote in message
> > > > news:3AA144AC-0384-4293-8103-4B01456F442F@.microsoft.com...
> > > > > Hi Daniel,
> > > > >
> > > > > I have not changed anything. I got this message directly after I
> > installed
> > > > > the software.
> > > > >
> > > > > When I click "Yes" to debug when the error message appears, the
> > following
> > > > is
> > > > > displayed (Settings.aspx file with the last line (if-statement)
> > > > highlighted
> > > > > in yellow)
> > > > >
> > > > > function confirmSnapshotLimit(source, arguments){
> > > > > var oldEffectivePolicy = -1;
> > > > > var oldSystemPolicy = -1;
> > > > > var needConfirmation = false;
> > > > > if ( document.all('ui_btnSystem') != undefined && document.all
> > > > > 'ui_btnSystem').checked ) {
> > > > >
> > > > > Here is the contents of the ReportServerWebApp log file:
> > > > >
> > > > > <Header>
> > > > > <Product>Microsoft SQL Server Reporting Services Version
> > > > > 8.00.878.00</Product>
> > > > > <Locale>en-US</Locale>
> > > > > <TimeZone>South Africa Standard Time</TimeZone>
> > > > > <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > > > >
Services\LogFiles\ReportServerWebApp__08_20_2004_09_39_55.log</Path>
> > > > > <SystemName>GKTESTSQL</SystemName>
> > > > > <OSName>Microsoft Windows NT 5.0.2195.0</OSName>
> > > > > <OSVersion>5.0.2195.0</OSVersion>
> > > > > </Header>
> > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > > > MaxActiveReqForOneUser to '20' requests(s) as specified in
> > Configuration
> > > > file.
> > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > > > MaxScheduleWait to default value of '1' second(s) because it was
not
> > > > > specified in Configuration file.
> > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > > > DatabaseQueryTimeout to default value of '30' second(s) because it
was
> > not
> > > > > specified in Configuration file.
> > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > > > InstanceName to default value of 'MSSQLSERVER.1' because it was
not
> > > > > specified in Configuration file.
> > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > > > ProcessRecycleOptions to default value of '0' because it was not
> > > > specified
> > > > > in Configuration file.
> > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > > > RunningRequestsScavengerCycle to default value of '30' second(s)
> > because
> > > > it
> > > > > was not specified in Configuration file.
> > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > > > RunningRequestsDbCycle to default value of '30' second(s) because
it
> > was
> > > > not
> > > > > specified in Configuration file.
> > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > > > RunningRequestsAge to default value of '30' second(s) because it
was
> > not
> > > > > specified in Configuration file.
> > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > > > CleanupCycleMinutes to default value of '10' minute(s) because it
was
> > not
> > > > > specified in Configuration file.
> > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > > > SecureConnectionLevel to default value of '1' because it was not
> > > > specified
> > > > > in Configuration file.
> > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > > > DisplayErrorLink to 'True' as specified in Configuration file.
> > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO: Initializing
> > > > > WebServiceUseFileShareStorage to default value of 'False' because
it
> > was
> > > > not
> > > > > specified in Configuration file.
> > > > > aspnet_wp!resourceutilities!1798!8/20/2004-16:24:49:: i INFO:
> > Reporting
> > > > > Services starting SKU: Evaluation
> > > > > aspnet_wp!resourceutilities!1798!8/20/2004-16:24:49:: i INFO: Eval
> > SKU:
> > > > 118
> > > > > days left
> > > > >
> > > > >
> > > > > Thanks
> > > > > -Johan
> > > > >
> > > > >
> > > > >
> > > > > "Daniel Reib [MSFT]" wrote:
> > > > >
> > > > > > Hmm, shouldn't be an error, undefined IS undefined. :)
> > > > > >
> > > > > > Seriously though, is there any more information in the
> > > > > > RSWebAplication<date>.log file? Did you do anything special
with
> > the
> > > > VRoots
> > > > > > (i.e. turn on anonymous access, move them to another website)?
> > > > > >
> > > > > > --
> > > > > > -Daniel
> > > > > > This posting is provided "AS IS" with no warranties, and confers
no
> > > > rights.
> > > > > >
> > > > > >
> > > > > > "Johan" <Johan@.discussions.microsoft.com> wrote in message
> > > > > > news:4E753FB5-E3AC-4F60-A052-7091C49D695E@.microsoft.com...
> > > > > > > Hi,
> > > > > > >
> > > > > > > I get a runtime error messsage when I go into Site Settings
and
> > click
> > > > on
> > > > > > > Apply. The message reads: "A Runtiime Error has occured. Do
you
> > wish
> > > > to
> > > > > > > debug? Line 39: Error: 'undefined' is undefined"
> > > > > > >
> > > > > > > Thank you in advance.
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >|||Yes, but do you have any special system roles. Look at the 'Configure
site-wide security' link.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Johan" <Johan@.discussions.microsoft.com> wrote in message
news:7909811D-745B-4841-96A9-B871C4620DFD@.microsoft.com...
> I'm a Content Manager and have access to every item within the Content
> Manager role.
>
> "Daniel Reib [MSFT]" wrote:
> > I wouldn't think a reboot would help. What Report Server system
permissions
> > do you have?
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Johan" <Johan@.discussions.microsoft.com> wrote in message
> > news:AC2AEBA4-62FA-4D60-BF1C-284B4702F7F8@.microsoft.com...
> > > I was not in the Administrator group but my login id has been to this
> > group
> > > now. I'm still getting the error though. Do I need to reboot? We are
> > running
> > > on Windows 2000 Advanced Server.
> > >
> > >
> > >
> > > "Daniel Reib [MSFT]" wrote:
> > >
> > > > Are you a local admin to the box that has ReportServer? Have you
> > changed
> > > > any of your system permissions? Perhaps you have stumbled on a
> > permissions
> > > > bug.
> > > >
> > > >
> > > > --
> > > > -Daniel
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > >
> > > > "Johan" <Johan@.discussions.microsoft.com> wrote in message
> > > > news:14181F51-DCB2-4226-BFB9-B35CC523F180@.microsoft.com...
> > > > > Hi Daniel,
> > > > >
> > > > > This was a new installation from the 120 day evaluation CD and I
also
> > > > > installed SP1. I deleted the temp Internet files but to no avail.
> > > > >
> > > > >
> > > > > "Daniel Reib [MSFT]" wrote:
> > > > >
> > > > > > Was this an upgrade from Beta 2? Can you try deleting your IE
> > temporary
> > > > > > files and see if that helps.
> > > > > >
> > > > > > --
> > > > > > -Daniel
> > > > > > This posting is provided "AS IS" with no warranties, and confers
no
> > > > rights.
> > > > > >
> > > > > >
> > > > > > "Johan" <Johan@.discussions.microsoft.com> wrote in message
> > > > > > news:3AA144AC-0384-4293-8103-4B01456F442F@.microsoft.com...
> > > > > > > Hi Daniel,
> > > > > > >
> > > > > > > I have not changed anything. I got this message directly after
I
> > > > installed
> > > > > > > the software.
> > > > > > >
> > > > > > > When I click "Yes" to debug when the error message appears,
the
> > > > following
> > > > > > is
> > > > > > > displayed (Settings.aspx file with the last line
(if-statement)
> > > > > > highlighted
> > > > > > > in yellow)
> > > > > > >
> > > > > > > function confirmSnapshotLimit(source, arguments){
> > > > > > > var oldEffectivePolicy = -1;
> > > > > > > var oldSystemPolicy = -1;
> > > > > > > var needConfirmation = false;
> > > > > > > if ( document.all('ui_btnSystem') != undefined &&
document.all
> > > > > > > 'ui_btnSystem').checked ) {
> > > > > > >
> > > > > > > Here is the contents of the ReportServerWebApp log file:
> > > > > > >
> > > > > > > <Header>
> > > > > > > <Product>Microsoft SQL Server Reporting Services Version
> > > > > > > 8.00.878.00</Product>
> > > > > > > <Locale>en-US</Locale>
> > > > > > > <TimeZone>South Africa Standard Time</TimeZone>
> > > > > > > <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > > > > > >
> > Services\LogFiles\ReportServerWebApp__08_20_2004_09_39_55.log</Path>
> > > > > > > <SystemName>GKTESTSQL</SystemName>
> > > > > > > <OSName>Microsoft Windows NT 5.0.2195.0</OSName>
> > > > > > > <OSVersion>5.0.2195.0</OSVersion>
> > > > > > > </Header>
> > > > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO:
Initializing
> > > > > > > MaxActiveReqForOneUser to '20' requests(s) as specified in
> > > > Configuration
> > > > > > file.
> > > > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO:
Initializing
> > > > > > > MaxScheduleWait to default value of '1' second(s) because it
was
> > not
> > > > > > > specified in Configuration file.
> > > > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO:
Initializing
> > > > > > > DatabaseQueryTimeout to default value of '30' second(s)
because it
> > was
> > > > not
> > > > > > > specified in Configuration file.
> > > > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO:
Initializing
> > > > > > > InstanceName to default value of 'MSSQLSERVER.1' because it
was
> > not
> > > > > > > specified in Configuration file.
> > > > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO:
Initializing
> > > > > > > ProcessRecycleOptions to default value of '0' because it was
not
> > > > > > specified
> > > > > > > in Configuration file.
> > > > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO:
Initializing
> > > > > > > RunningRequestsScavengerCycle to default value of '30'
second(s)
> > > > because
> > > > > > it
> > > > > > > was not specified in Configuration file.
> > > > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO:
Initializing
> > > > > > > RunningRequestsDbCycle to default value of '30' second(s)
because
> > it
> > > > was
> > > > > > not
> > > > > > > specified in Configuration file.
> > > > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO:
Initializing
> > > > > > > RunningRequestsAge to default value of '30' second(s) because
it
> > was
> > > > not
> > > > > > > specified in Configuration file.
> > > > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO:
Initializing
> > > > > > > CleanupCycleMinutes to default value of '10' minute(s) because
it
> > was
> > > > not
> > > > > > > specified in Configuration file.
> > > > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO:
Initializing
> > > > > > > SecureConnectionLevel to default value of '1' because it was
not
> > > > > > specified
> > > > > > > in Configuration file.
> > > > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO:
Initializing
> > > > > > > DisplayErrorLink to 'True' as specified in Configuration
file.
> > > > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO:
Initializing
> > > > > > > WebServiceUseFileShareStorage to default value of 'False'
because
> > it
> > > > was
> > > > > > not
> > > > > > > specified in Configuration file.
> > > > > > > aspnet_wp!resourceutilities!1798!8/20/2004-16:24:49:: i INFO:
> > > > Reporting
> > > > > > > Services starting SKU: Evaluation
> > > > > > > aspnet_wp!resourceutilities!1798!8/20/2004-16:24:49:: i INFO:
Eval
> > > > SKU:
> > > > > > 118
> > > > > > > days left
> > > > > > >
> > > > > > >
> > > > > > > Thanks
> > > > > > > -Johan
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > "Daniel Reib [MSFT]" wrote:
> > > > > > >
> > > > > > > > Hmm, shouldn't be an error, undefined IS undefined. :)
> > > > > > > >
> > > > > > > > Seriously though, is there any more information in the
> > > > > > > > RSWebAplication<date>.log file? Did you do anything special
> > with
> > > > the
> > > > > > VRoots
> > > > > > > > (i.e. turn on anonymous access, move them to another
website)?
> > > > > > > >
> > > > > > > > --
> > > > > > > > -Daniel
> > > > > > > > This posting is provided "AS IS" with no warranties, and
confers
> > no
> > > > > > rights.
> > > > > > > >
> > > > > > > >
> > > > > > > > "Johan" <Johan@.discussions.microsoft.com> wrote in message
> > > > > > > > news:4E753FB5-E3AC-4F60-A052-7091C49D695E@.microsoft.com...
> > > > > > > > > Hi,
> > > > > > > > >
> > > > > > > > > I get a runtime error messsage when I go into Site
Settings
> > and
> > > > click
> > > > > > on
> > > > > > > > > Apply. The message reads: "A Runtiime Error has occured.
Do
> > you
> > > > wish
> > > > > > to
> > > > > > > > > debug? Line 39: Error: 'undefined' is undefined"
> > > > > > > > >
> > > > > > > > > Thank you in advance.
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >|||I'm sorry but I am not sure what the problem is. Everything seems correct.
Can you send me the source file the html page? Just send it directly to me
(remove the online in my address) Maybe something in there will help me
figure this out.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Johan" <Johan@.discussions.microsoft.com> wrote in message
news:F3FAD55A-FF12-4CBB-A228-0CC519E157F0@.microsoft.com...
> I'm a System Administrator there. In this Role "View report server
> properties" and "View shared schedules" were not ticked. I selected these
> items but the error still occurs.
> Johan
>
> "Daniel Reib [MSFT]" wrote:
> > Yes, but do you have any special system roles. Look at the 'Configure
> > site-wide security' link.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Johan" <Johan@.discussions.microsoft.com> wrote in message
> > news:7909811D-745B-4841-96A9-B871C4620DFD@.microsoft.com...
> > > I'm a Content Manager and have access to every item within the Content
> > > Manager role.
> > >
> > >
> > > "Daniel Reib [MSFT]" wrote:
> > >
> > > > I wouldn't think a reboot would help. What Report Server system
> > permissions
> > > > do you have?
> > > >
> > > > --
> > > > -Daniel
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > >
> > > > "Johan" <Johan@.discussions.microsoft.com> wrote in message
> > > > news:AC2AEBA4-62FA-4D60-BF1C-284B4702F7F8@.microsoft.com...
> > > > > I was not in the Administrator group but my login id has been to
this
> > > > group
> > > > > now. I'm still getting the error though. Do I need to reboot? We
are
> > > > running
> > > > > on Windows 2000 Advanced Server.
> > > > >
> > > > >
> > > > >
> > > > > "Daniel Reib [MSFT]" wrote:
> > > > >
> > > > > > Are you a local admin to the box that has ReportServer? Have
you
> > > > changed
> > > > > > any of your system permissions? Perhaps you have stumbled on a
> > > > permissions
> > > > > > bug.
> > > > > >
> > > > > >
> > > > > > --
> > > > > > -Daniel
> > > > > > This posting is provided "AS IS" with no warranties, and confers
no
> > > > rights.
> > > > > >
> > > > > >
> > > > > > "Johan" <Johan@.discussions.microsoft.com> wrote in message
> > > > > > news:14181F51-DCB2-4226-BFB9-B35CC523F180@.microsoft.com...
> > > > > > > Hi Daniel,
> > > > > > >
> > > > > > > This was a new installation from the 120 day evaluation CD and
I
> > also
> > > > > > > installed SP1. I deleted the temp Internet files but to no
avail.
> > > > > > >
> > > > > > >
> > > > > > > "Daniel Reib [MSFT]" wrote:
> > > > > > >
> > > > > > > > Was this an upgrade from Beta 2? Can you try deleting your
IE
> > > > temporary
> > > > > > > > files and see if that helps.
> > > > > > > >
> > > > > > > > --
> > > > > > > > -Daniel
> > > > > > > > This posting is provided "AS IS" with no warranties, and
confers
> > no
> > > > > > rights.
> > > > > > > >
> > > > > > > >
> > > > > > > > "Johan" <Johan@.discussions.microsoft.com> wrote in message
> > > > > > > > news:3AA144AC-0384-4293-8103-4B01456F442F@.microsoft.com...
> > > > > > > > > Hi Daniel,
> > > > > > > > >
> > > > > > > > > I have not changed anything. I got this message directly
after
> > I
> > > > > > installed
> > > > > > > > > the software.
> > > > > > > > >
> > > > > > > > > When I click "Yes" to debug when the error message
appears,
> > the
> > > > > > following
> > > > > > > > is
> > > > > > > > > displayed (Settings.aspx file with the last line
> > (if-statement)
> > > > > > > > highlighted
> > > > > > > > > in yellow)
> > > > > > > > >
> > > > > > > > > function confirmSnapshotLimit(source, arguments){
> > > > > > > > > var oldEffectivePolicy = -1;
> > > > > > > > > var oldSystemPolicy = -1;
> > > > > > > > > var needConfirmation = false;
> > > > > > > > > if ( document.all('ui_btnSystem') != undefined &&
> > document.all
> > > > > > > > > 'ui_btnSystem').checked ) {
> > > > > > > > >
> > > > > > > > > Here is the contents of the ReportServerWebApp log file:
> > > > > > > > >
> > > > > > > > > <Header>
> > > > > > > > > <Product>Microsoft SQL Server Reporting Services Version
> > > > > > > > > 8.00.878.00</Product>
> > > > > > > > > <Locale>en-US</Locale>
> > > > > > > > > <TimeZone>South Africa Standard Time</TimeZone>
> > > > > > > > > <Path>C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting
> > > > > > > > >
> > > > Services\LogFiles\ReportServerWebApp__08_20_2004_09_39_55.log</Path>
> > > > > > > > > <SystemName>GKTESTSQL</SystemName>
> > > > > > > > > <OSName>Microsoft Windows NT 5.0.2195.0</OSName>
> > > > > > > > > <OSVersion>5.0.2195.0</OSVersion>
> > > > > > > > > </Header>
> > > > > > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO:
> > Initializing
> > > > > > > > > MaxActiveReqForOneUser to '20' requests(s) as specified in
> > > > > > Configuration
> > > > > > > > file.
> > > > > > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO:
> > Initializing
> > > > > > > > > MaxScheduleWait to default value of '1' second(s) because
it
> > was
> > > > not
> > > > > > > > > specified in Configuration file.
> > > > > > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO:
> > Initializing
> > > > > > > > > DatabaseQueryTimeout to default value of '30' second(s)
> > because it
> > > > was
> > > > > > not
> > > > > > > > > specified in Configuration file.
> > > > > > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO:
> > Initializing
> > > > > > > > > InstanceName to default value of 'MSSQLSERVER.1' because
it
> > was
> > > > not
> > > > > > > > > specified in Configuration file.
> > > > > > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO:
> > Initializing
> > > > > > > > > ProcessRecycleOptions to default value of '0' because it
was
> > not
> > > > > > > > specified
> > > > > > > > > in Configuration file.
> > > > > > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO:
> > Initializing
> > > > > > > > > RunningRequestsScavengerCycle to default value of '30'
> > second(s)
> > > > > > because
> > > > > > > > it
> > > > > > > > > was not specified in Configuration file.
> > > > > > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO:
> > Initializing
> > > > > > > > > RunningRequestsDbCycle to default value of '30' second(s)
> > because
> > > > it
> > > > > > was
> > > > > > > > not
> > > > > > > > > specified in Configuration file.
> > > > > > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO:
> > Initializing
> > > > > > > > > RunningRequestsAge to default value of '30' second(s)
because
> > it
> > > > was
> > > > > > not
> > > > > > > > > specified in Configuration file.
> > > > > > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO:
> > Initializing
> > > > > > > > > CleanupCycleMinutes to default value of '10' minute(s)
because
> > it
> > > > was
> > > > > > not
> > > > > > > > > specified in Configuration file.
> > > > > > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO:
> > Initializing
> > > > > > > > > SecureConnectionLevel to default value of '1' because it
was
> > not
> > > > > > > > specified
> > > > > > > > > in Configuration file.
> > > > > > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO:
> > Initializing
> > > > > > > > > DisplayErrorLink to 'True' as specified in Configuration
> > file.
> > > > > > > > > aspnet_wp!library!130c!8/20/2004-09:39:55:: i INFO:
> > Initializing
> > > > > > > > > WebServiceUseFileShareStorage to default value of 'False'
> > because
> > > > it
> > > > > > was
> > > > > > > > not
> > > > > > > > > specified in Configuration file.
> > > > > > > > > aspnet_wp!resourceutilities!1798!8/20/2004-16:24:49:: i
INFO:
> > > > > > Reporting
> > > > > > > > > Services starting SKU: Evaluation
> > > > > > > > > aspnet_wp!resourceutilities!1798!8/20/2004-16:24:49:: i
INFO:
> > Eval
> > > > > > SKU:
> > > > > > > > 118
> > > > > > > > > days left
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Thanks
> > > > > > > > > -Johan
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > "Daniel Reib [MSFT]" wrote:
> > > > > > > > >
> > > > > > > > > > Hmm, shouldn't be an error, undefined IS undefined. :)
> > > > > > > > > >
> > > > > > > > > > Seriously though, is there any more information in the
> > > > > > > > > > RSWebAplication<date>.log file? Did you do anything
special
> > > > with
> > > > > > the
> > > > > > > > VRoots
> > > > > > > > > > (i.e. turn on anonymous access, move them to another
> > website)?
> > > > > > > > > >
> > > > > > > > > > --
> > > > > > > > > > -Daniel
> > > > > > > > > > This posting is provided "AS IS" with no warranties, and
> > confers
> > > > no
> > > > > > > > rights.
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > > "Johan" <Johan@.discussions.microsoft.com> wrote in
message
> > > > > > > > > >
news:4E753FB5-E3AC-4F60-A052-7091C49D695E@.microsoft.com...
> > > > > > > > > > > Hi,
> > > > > > > > > > >
> > > > > > > > > > > I get a runtime error messsage when I go into Site
> > Settings
> > > > and
> > > > > > click
> > > > > > > > on
> > > > > > > > > > > Apply. The message reads: "A Runtiime Error has
occured.
> > Do
> > > > you
> > > > > > wish
> > > > > > > > to
> > > > > > > > > > > debug? Line 39: Error: 'undefined' is undefined"
> > > > > > > > > > >
> > > > > > > > > > > Thank you in advance.
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >

Runtime error data provider or other service provided an efail status

Anyone knows what would cause this?When Enterprise Manager is used to open a table
Runtime error data provider or other service provided an efail status"Vincento Harris" <wumutek@.yahoo.com> wrote in message
news:2fa13ee7.0409220419.1d9dc812@.posting.google.c om...
> Anyone knows what would cause this?When Enterprise Manager is used to open
> a table
> Runtime error data provider or other service provided an efail status

It would be useful to know the exact error, however Google suggests that a
corrupt DLL may be one cause:

http://groups.google.com/groups?q=s...f=1&sa=N&tab=wg

Probably the easiest thing to do is uninstall then reinstall the client
tools, then apply the latest servicepack.

Simon

Runtime Error after some pause

Hello,

My users often view some report for some minutes and after that want to return to parent report.
If they did it after small time (~less than minute), everything is OK. But if this pause is above 1 minute they receive "Runtime Error" message and can only to go to homepage.

I think that this is some session time or something like that.
Am I right? How can fix it?

Thank youAfter setting customError=off we receive "Back call without drillthrough report" error|||Did you find a fix for the problem? Can anyone help? I get the same problem.|||

Back call without drillthrough report

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Back call without drillthrough report

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: Back call without drillthrough report]

Microsoft.Reporting.WebForms.ReportViewer.Toolbar_Back(Object sender, EventArgs e) +229

Microsoft.Reporting.WebForms.ToolbarControl.OnBack(Object sender, EventArgs e) +25

Microsoft.Reporting.WebForms.BackGroup.BackButton_Click(Object sender, EventArgs e) +40

Microsoft.Reporting.WebForms.ScriptSwitchImage.EnabledImage_Click(Object sender, ImageClickEventArgs e) +25

System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +105

System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +115

System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7

System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11

System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

|||

I am also receiving this error but there is no delay. As soon as the report is loaded, I click back to goto the previous report and I get this error.

It is interesting because charts are also not loading. I dont receive an error message but in the event log this is entered: "The stream cannot be found."

This only happens when I drill-through.

|||

I'm having this issue also. Did anyone ever find a solution? thanks

|||Hey guys I think that this issue has something to do with some other problems I have been having due to SP1. I notice that the back button wasn't the only thing messing up, and it was only doing it in the ReportViewer (not when I went to the report directly in VS)

check out this article
http://www.eggheadcafe.com/software/aspnet/29672997/back-call-without-drillth.aspx

-nonoandy|||

i am also facing this problem...

any solutions for this?

|||Just checking if anyone has any luck with this? I spend more time on these forums than i do developing SSRS. Come across issues on a seemingly endless basis.|||Did you check out this link
http://www.eggheadcafe.com/software/aspnet/29672997/back-call-without-drillth.aspx
?
I had two things that was giving me the same problem one was a Ajax update panel around it and the other was because of the bad release of VS2005 SP1. The "Microsoft.ReportViewer.* assemblies" where messing it up so I had to un-install them from my GAC and find the older "File version"
(To find out what file version of the assemblies you have right click and hit properties. Don't look at the Version tab in the windows explore.)

But you don't have to do that now Microsoft came out with new assemblies in and you can download them in a redistributable package.

Read this
http://support.microsoft.com/default.aspx/kb/933137
and download

Thanks!
Andysql

Runtime Error after some pause

Hello,

My users often view some report for some minutes and after that want to return to parent report.
If they did it after small time (~less than minute), everything is OK. But if this pause is above 1 minute they receive "Runtime Error" message and can only to go to homepage.

I think that this is some session time or something like that.
Am I right? How can fix it?

Thank youAfter setting customError=off we receive "Back call without drillthrough report" error|||Did you find a fix for the problem? Can anyone help? I get the same problem.|||

Back call without drillthrough report

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Back call without drillthrough report

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: Back call without drillthrough report] Microsoft.Reporting.WebForms.ReportViewer.Toolbar_Back(Object sender, EventArgs e) +229 Microsoft.Reporting.WebForms.ToolbarControl.OnBack(Object sender, EventArgs e) +25 Microsoft.Reporting.WebForms.BackGroup.BackButton_Click(Object sender, EventArgs e) +40 Microsoft.Reporting.WebForms.ScriptSwitchImage.EnabledImage_Click(Object sender, ImageClickEventArgs e) +25 System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +105 System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +115 System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

|||

I am also receiving this error but there is no delay. As soon as the report is loaded, I click back to goto the previous report and I get this error.

It is interesting because charts are also not loading. I dont receive an error message but in the event log this is entered: "The stream cannot be found."

This only happens when I drill-through.

|||

I'm having this issue also. Did anyone ever find a solution? thanks

|||Hey guys I think that this issue has something to do with some other problems I have been having due to SP1. I notice that the back button wasn't the only thing messing up, and it was only doing it in the ReportViewer (not when I went to the report directly in VS)

check out this article
http://www.eggheadcafe.com/software/aspnet/29672997/back-call-without-drillth.aspx

-nonoandy|||

i am also facing this problem...

any solutions for this?

|||Just checking if anyone has any luck with this? I spend more time on these forums than i do developing SSRS. Come across issues on a seemingly endless basis.|||Did you check out this link
http://www.eggheadcafe.com/software/aspnet/29672997/back-call-without-drillth.aspx
?
I had two things that was giving me the same problem one was a Ajax update panel around it and the other was because of the bad release of VS2005 SP1. The "Microsoft.ReportViewer.* assemblies" where messing it up so I had to un-install them from my GAC and find the older "File version"
(To find out what file version of the assemblies you have right click and hit properties. Don't look at the Version tab in the windows explore.)

But you don't have to do that now Microsoft came out with new assemblies in and you can download them in a redistributable package.

Read this
http://support.microsoft.com/default.aspx/kb/933137
and download

Thanks!
Andy

Runtime Error '9' subscript out of range

Our company uses MSDE2000 for a Document Creation System. When a user
gets the [runtime error '9' subscript out of range]I have found no fix
without reinstalling the OS. I have not found the cause for the error.
Backups are unable to complete once this error occures. We have un
installed MSDE and reinstalled (also uninstall the software and
reinstalled it)
The five times I have seen this error everything work until the merge
proccess this along with unable to backup makes me think it is MSDE
related.
HELP
Joe Bullington
TechnologySupport
National Network Technology TEAM
One Valmont Plaza - Fourth Floor
Omaha, NE 68154
Toll Free: (888) 837-9709 ext. 3859
Local: (402) 964-3859
Email: joeb@.nnepa.com
General Support Email: support@.nnepa.comJoe NNEPA (joeb@.nnepa.com) writes:
> Our company uses MSDE2000 for a Document Creation System. When a user
> gets the [runtime error '9' subscript out of range]I have found no fix
> without reinstalling the OS. I have not found the cause for the error.
> Backups are unable to complete once this error occures. We have un
> installed MSDE and reinstalled (also uninstall the software and
> reinstalled it)
> The five times I have seen this error everything work until the merge
> proccess this along with unable to backup makes me think it is MSDE
> related.
This sounds like a Visual Basic error to me, so poking with MSDE
may not resolve the problem easily. You should probably debug
the document-creation system, or talk to the vendor if it is a
3rd party product.
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

runtime error 80040e37

hi:

i m new to VB.thatswhy i have some problem in connecting VB with sql server.actually i m able to connect but it would nt run the query,giving me the run time error "invalid object name <tablename>".
in the begining i thought i have probelm with the name but i changed the name.
then i thought it might have something to do with database permissions.i did checke that but for some reason the error would nt go away.
here is the code

Private Sub btnSubmit_Click()

Dim Conn As New ADODB.Connection
Dim RecSet As New ADODB.Recordset
Dim SQLQuery

Fname = txtFname.Text 'getting var from text box
Lname = txtLname.Text

'The database is on romote server

SQLQuery = "Insert into introduction (fname,lname) values ('" & Fname & "','" & Lname & "')"
Conn.Open "Provider=SQLOLEDB.1;UID=someID;PWD=myPWD;Intitial Catalog=test;Data Source=MYserver"
RecSet.Open SQLQuery, Conn

Conn.Close
Set RecSet = Nothing

End Sub

This code runs under a command button click.i m getting the values from the text boxes and try to insert them in the database.but i m getting this weird error.
Please help!!!!Who's the schema owner of your INTRODUCTION table? I suspect it's someone other than DBO.|||...pressed on the button too early :)

Preceed the table name with the schema owner in your INSERT:

insert into user_name.introduction ...|||thanks for prompt reply.but the problem still persists.
i checked on ownership of the table .it is DBO.
any ideas!!|||The problem is, that your SQL statements isn't a query, but a DML statement. How do you expect to get a recordset by issueing an INSERT statement?!

Change your line
RecSet.Open SQLQuery, Conn

into
Conn.Execute SQLQuery

and it will work fine.|||Thanks for ur reply.
i did try that ,change the line to "Conn.Execute SQLQuery",and still its giving me the same error

any other suggestions...|||hi

Actually i solved the problem.it was not working with DSN less connection as i was trying to do.
so i created DSN,test the connection,and then used it in my code,and it worked fine.

although i still dont know why it was not working with DSN less connection. i used the same parameters as i was doing it in DSN less,and it worked.
but hey as long it works i happy.

thanks guys

Runtime error 713

Dear Gurus,

I have developed a package with VB6 & crystal report10. While installing it in Client machines i get error as "Run time Error 713".
I searched for it but only found that it is " Appication - Defined or Object define error 713"..Help me to solve this asap..

Thanx in Advance,
RevolutionWhen creating the Package did you add all the required dlls?
Also search here for your solution
http://support.businessobjects.com/

Runtime error 3704

Hi,

I've created an application that runs on several pc's. However, on one particular pc, when I run the following code to test the connection to the SQL server, it generates the error "Runtime error '3704'" and it happens only when it hits the Form1.Users.Movefirst section.

I've checked all the user permissions on the server and dont seem to find any difference there.

code:-

Option Explicit
Public Db As New ADODB.Connection
Public Users As New ADODB.Recordset

Private Sub Command1_Click()

If Not Form1.Users.BOF Then
Form1.Users.MoveFirst
End If

With Form1.Users
Do While Not Form1.Users.EOF
Debug.Print Form1.Users.Fields(0)
Form1.Users.MoveNext
Loop
End With

End Sub

Private Sub Form_Load()

On Error Resume Next
Set Db = Nothing

Db.Open _
"Provider=SQLOLEDB.1;Server=File;" & _
"Database=Cash Management;Trusted_Connection=Yes"

'Open the recordsets
With Form1.Users
.CursorLocation = adUseClient
.CursorType = adOpenDynamic
.LockType = adLockOptimistic
.ActiveConnection = Form1.Db
.Source = "Select * from Users order by userid"
.Open "SET NOCOUNT ON"
End With

End Sub

ThanksIt is very simple. You are running "SET NOCOUNT ON" only. What MDAC version do you use?|||Hi.. Thanks for your reply. Normally, my .open has nothing after it. Only after I searched on the net, did I add that "Set NoCount On", but it didn't help. Sorry to sound ignorant, but how do I tell what ver of MDAC I'm using ?

Carl|||Q1. What MDAC version am I using?
A1. Use regedit.exe, see branch "HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess" node "FullInstallVer"|||It looks like 2.70.7713.4.

Tks..|||You added "SET NOCOUNT ON" for test purposses only, remove it.
In your code, after the part where you try to open a connection,
add a check (+msgbox) to know if it is really connected.
It can be a domain security problem.|||Ok - I checked the registry on the pc that I was installing on and I see the version of MDAC is 2.53.6200.1. This is the same as another pc that is working.

If this is not the problem, I suspect that it is a permissions problem, but I have no idea where to check as this user has been registered exactly the same as the other users that work.

Thanks|||Run (for W9x)
command /K net config
from Start->Run commandline on the client machine and you will see his logon info (or ask him to do it and send results).|||My email address is alkemac@.hotmail.com. Can you please send an email and I will reply with screen shots of the different screens, including the SQL Svr user registration screen ?

Thanks|||It was a user default database problem. The user solved it by himself.|||What do you mean by "default database problem"? Can you explain how the user solved it himself? We have a similar problem with a VB application that opens an Access database. It runs on most computers, but not some. One gets the 3704 runtime error. Thanks.sql

runtime error 3265: item cannot be found in this collection

Hello!

I connected to sqlserver 7 db from vb6.I got one record displayed from my db table as rs.fields(0).If i give rs.fields(1) , it gives me the error, item cannot be found in this collection.When i dispalyed the record count as msgbox rs.recordcount it shows -1.what may be the error, pls help.

LydiaPlease provide your sql statement within vb - and which cursorlocation are you setting (client or server). It sounds like your sql statement is only returning 1 column. When you use rs.fields(1) accesses the 2nd column returned by your sql query - not the next record in the recordset.|||Hello!

Thank you very much, i fixed the error as soon as i written to you.That is the same thing that you replied.It's coz i am quite new to VB and am learning.

Two more issues - i need ur help

1. But still i am getting the record count as -1 . why is it? but i am getting all my records in the record set.

2. I created a function to fill up the list box as

Function FillList(Listitem as Listbox, FieldName as Field, TableName as Table)

--Code--Goes here

End Function

when i tried to call the function as

FillList(List1, m_email,members)

it is returning error as : ByVal ref argument type mismatch

how should i refer the values with the arguments in the function?

Pls help

Lydia|||Which cursorlocation are you using ?|||Originally posted by rnealejr
Which cursorlocation are you using ?

What do you mean by cursor location? i gave the code like this:

--some code here--
opened the record set as AdopenforwardOnly|||Both the connection and recordset objects contain a property called cursorlocation. If you are not setting it, go into debug and view the properties of the object and examine the cursorlocation property.|||Thank you very much, After setting the cursor location, i got the correct record count.|||Happy to help.|||I have a function to fill up list box with a DB Field values as

Public Function FillList(ListItem As ListBox, FieldName As Field,TableName as Table)
Dim i As Integer
i = 0
DbConnect
strSQL = "select FieldName from TableName"

'without using the connection object
ObjRs.Open strSQL, strConn

' Add Items in the list box
ObjRs.MoveFirst
Do While Not ObjRs.EOF
ListItem.AddItem ObjRs(0), i
ObjRs.MoveNext
i = i + 1
Loop

'Be sure you close and destroy your objects.

ObjRs.Close
ObjConn.Close
Set ObjConn = Nothing
Set ObjRs = Nothing
End Function

' Then i called the function as

call FillList(List1,"M_email","Members")

It gives me error as : Type Mismatch

What is the mistake in the code?|||Please post the code before the FillList. How are the Field and Table referenced ( like through adodb ...) ?|||Yes, I connected to the DB as ADODB.Connection|||How are you able to reference "Table" ? Also, you should be explicit in your declarations (Adodb.Field).

The problem is that you are trying to pass a string to a function expecting an object. Both the field/table should be strings - so you would build your sql statement like:

strSQL = "select " & FieldName & " from " & TableName

Runtime error 3155 inserting to linked SQL tables from Access

Sorry, I should have mentioned at the outset that the really odd thing about
this is that the error is:
"ODBC--insert on a linked table 'Logins' failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]INSERT permission denied on
object 'Logins', database 'data', owner 'dbo'.
(#229)"
Needless to say, it occurs at the statement
DoCmd.RunSQL sqlstr
That's why it's odd that it works OK when run directly from the code window,
but not when it is called from the autoexec macro. It is attempting to insert
just a single record.
Thanks
Alistair
"Van T. Dinh" wrote:

> Have you identified which line of code produced the error?
> Error 3155 is "Application-defined or object-defined error" so I suspect the
> error is in the statement:
>
I am using SQL authentication. The login/ password is not currently stored in
the dsn: the tables are either linked manually before opening the database,
or using a button which runs a macro from within the database. The odd thing
is that you could open the database with autoexec, and get the Insert error
message. If you then opened it again without autoexec, kept the tables linked
as they were, then ran the code manually it worked.
"Van T. Dinh" wrote:

> Are you using Windows Authentication or SQL Server Authentication?
> If the later, do you store the LoginID / Password in the ODBC DSN?
> --
> HTH
> Van T. Dinh
> MVP (Access)
>
> "Alistair Taylor" <AlistairTaylor@.discussions.microsoft.com> wrote in
> message news:6E8412D8-15BE-47C0-83D0-07878DEC7921@.microsoft.com...
>
>
|||Thanks for your suggestions.
I added this code just before the code which attempts to Insert to the
database. The passthrough query works perfectly, but the Insert still fails.
A manual Insert attempted subsequently does work, however. I have also
discovered that if I re-link the table into the database, I am then unable to
Insert to it even manually, until I have closed and re-opened the database.
"Van T. Dinh" wrote:

> I does sound that when you execute the insert in the AutoExec, the database
> has not establish a connection to the SQL Server BE.
> Perhaps, you should run code to create a dummy recordset just to establish
> the connection to the BE before your insert action.
> Stefan Hoffman posted this procedure in another newsgroup
>
> ****
> Create a passthrough query, call it "qryLogin". Use a simple SELECT
> statement like
> SELECT * FROM dbo.Table WHERE 0=1
> ..
> This code should do the login:
> Dim db As DAO.Database
> Set db = CurrentDb
> db.QueryDefs.Item("qryLogin").Connect = _
> db.TableDefs.Item("linkedTable").Connect & _
> ";UID=username;PWD=password"
> db.OpenRecordset("qryLogin")
> ****
> --
> HTH
> Van T. Dinh
> MVP (Access)
>
> "Alistair Taylor" <AlistairTaylor@.discussions.microsoft.com> wrote in
> message news:08E0025C-A6C9-4780-84F3-DDB878288B4F@.microsoft.com...
>
>
|||Refreshing the link immediately before the insert statements does seem to
work consistently, thanks. While the root cause of the insert problem is
still unknown, I am very grateful to have a working solution now.
Thanks
Alistair
"Van T. Dinh" wrote:

> I suspect that the Table Logins is still not linked correctly when the
> insert code is executed.
> Try using the RefreshLink method (check Access VB Help) on this Table and
> then 1 or 2 DoEvents statements beore your DoCmd.RunSQL.
> --
> HTH
> Van T. Dinh
> MVP (Access)
>
> "Alistair Taylor" <AlistairTaylor@.discussions.microsoft.com> wrote in
> message news:6F567ABE-4307-4F49-A3D4-56CE7A0A6729@.microsoft.com...
>
>