|
 |
asp_databases thread: Help! What is missing!
Message #1 by "Ulf Elfving" <ulf.elfving@f...> on Tue, 21 Nov 2000 17:13:15 -0000
|
|
Hi everyone
I have a problem:
Just developed an application that is running fine on a testsystem
When I copy the application to the production server and run my asp-page I
get an error that seems strange:
---------------
Microsoft VBScript compilation error '800a0400'
Expected statement
/include/section_info.asp, line 24
With cmd
^
---------------
The code I run is:
Sub WriteInfo
Dim sString
dim cmd
dim rs
dim param
Set cmd = Server.CreateObject("ADODB.Command")
With cmd
.ActiveConnection = strConnectString
.CommandText = SP_GET_CUSTOMERINFO
and so on......
The error is on the "With cmd" line
Is there some missing dll's on production-server?
We think that the person installed the production server has done
everything in order:
The system:
NT4 + Option Pack
SP 6
On the testserver we have Visual Studio installed, it looks like thats the
only different configuration between production and test server
Hope for help on this problem
TIA
/Uffe
Message #2 by "Ken Schaefer" <ken@a...> on Wed, 22 Nov 2000 16:09:18 +1100
|
|
With is only supported from VBScript v5 onwards.
You need to update the VBScript engine on your server.
You have two options, you can install the standalone VBScript engine
(http://msdn.microsoft.com/scripting)
Or you can install Internet Explorer v5, which also installs an up-to-date
VBScript engine (my guess is that the server has an older version of
Internet Explorer, and your test machine has a newer version.
Cheers
Ken
----- Original Message -----
From: "Ulf Elfving" <ulf.elfving@f...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, November 22, 2000 2:43 PM
Subject: [asp_databases] Help! What is missing!
> Hi everyone
> I have a problem:
> Just developed an application that is running fine on a testsystem
> When I copy the application to the production server and run my asp-page I
> get an error that seems strange:
>
> ---------------
> Microsoft VBScript compilation error '800a0400'
>
> Expected statement
>
> /include/section_info.asp, line 24
>
> With cmd
> ^
> ---------------
>
> The code I run is:
>
> Sub WriteInfo
>
> Dim sString
>
> dim cmd
> dim rs
> dim param
>
> Set cmd = Server.CreateObject("ADODB.Command")
> With cmd
> .ActiveConnection = strConnectString
> .CommandText = SP_GET_CUSTOMERINFO
>
> and so on......
>
> The error is on the "With cmd" line
>
> Is there some missing dll's on production-server?
>
> We think that the person installed the production server has done
> everything in order:
> The system:
>
> NT4 + Option Pack
> SP 6
>
> On the testserver we have Visual Studio installed, it looks like thats the
> only different configuration between production and test server
>
> Hope for help on this problem
>
> TIA
> /Uffe
>
Message #3 by "Ulf Elfving" <ulf.elfving@f...> on Wed, 22 Nov 2000 09:03:12 -0000
|
|
Thanks Ken!
After checking browser version and saw that the versions were identical, I
decided to just install the Scripting engine
This solved the problem!
Best regards
/Uffe
> With is only supported from VBScript v5 onwards.
>
> You need to update the VBScript engine on your server.
>
> You have two options, you can install the standalone VBScript engine
> (http://msdn.microsoft.com/scripting)
>
> Or you can install Internet Explorer v5, which also installs an up-to-date
> VBScript engine (my guess is that the server has an older version of
> Internet Explorer, and your test machine has a newer version.
>
> Cheers
> Ken
>
> ----- Original Message -----
> From: "Ulf Elfving" <ulf.elfving@f...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Wednesday, November 22, 2000 2:43 PM
> Subject: [asp_databases] Help! What is missing!
>
>
> > Hi everyone
> > I have a problem:
> > Just developed an application that is running fine on a testsystem
> > When I copy the application to the production server and run my asp-page I
> > get an error that seems strange:
> >
> > ---------------
> > Microsoft VBScript compilation error '800a0400'
> >
> > Expected statement
> >
> > /include/section_info.asp, line 24
> >
> > With cmd
> > ^
> > ---------------
> >
> > The code I run is:
> >
> > Sub WriteInfo
> >
> > Dim sString
> >
> > dim cmd
> > dim rs
> > dim param
> >
> > Set cmd = Server.CreateObject("ADODB.Command")
> > With cmd
> > .ActiveConnection = strConnectString
> > .CommandText = SP_GET_CUSTOMERINFO
> >
> > and so on......
> >
> > The error is on the "With cmd" line
> >
> > Is there some missing dll's on production-server?
> >
> > We think that the person installed the production server has done
> > everything in order:
> > The system:
> >
> > NT4 + Option Pack
> > SP 6
> >
> > On the testserver we have Visual Studio installed, it looks like thats the
> > only different configuration between production and test server
> >
> > Hope for help on this problem
> >
> > TIA
> > /Uffe
> >
|
|
|
View Cart
