Illegal assignment: 'adCmdText'
I have this swapsheet type page that was created before me. It has worked perfectly until a few days ago and I don't know what's going on. Nothing has been touched in the code for 8 months, so I don't believe it has anything to do with the asp.net.
When going to the page, you get this error.
Microsoft VBScript runtime error '800a01f5'
Illegal assignment: 'adCmdText'
D:\INETPUB\INTRANET\NEWSWAPSHEET\../inc.asp, line 3
It appears to be the include page, where it connects to the server/database table. And if you go further into it (compiler output), this is what it is telling me.
D:\Inetpub\Intranet\inc.asp(3) : error BC30451: Name 'adCmdText' is not declared.
adCmdText = 1
~~~~~~~~~
D:\Inetpub\Intranet\inc.asp(4) : error BC30451: Name 'adCmdTable' is not declared.
adCmdTable = 2
~~~~~~~~~~
D:\Inetpub\Intranet\inc.asp(5) : error BC30451: Name 'adCmdStoredProc' is not declared.
adCmdStoredProc = 4
~~~~~~~~~~~~~~~
D:\Inetpub\Intranet\inc.asp(6) : error BC30451: Name 'adCmdUnknown' is not declared.
adCmdUnknown = 8
~~~~~~~~~~~~
D:\Inetpub\Intranet\inc.asp(9) : error BC30451: Name 'adOpenForwardOnly' is not declared.
adOpenForwardOnly = 0 '# (Default)
~~~~~~~~~~~~~~~~~
D:\Inetpub\Intranet\inc.asp(10) : error BC30451: Name 'adOpenKeyset' is not declared.
adOpenKeyset = 1
~~~~~~~~~~~~
D:\Inetpub\Intranet\inc.asp(11) : error BC30451: Name 'adOpenDynamic' is not declared.
adOpenDynamic = 2
~~~~~~~~~~~~~
D:\Inetpub\Intranet\inc.asp(12) : error BC30451: Name 'adOpenStatic' is not declared.
adOpenStatic = 3
~~~~~~~~~~~~
D:\Inetpub\Intranet\inc.asp(15) : error BC30451: Name 'adLockReadOnly' is not declared.
adLockReadOnly = 1
~~~~~~~~~~~~~~
D:\Inetpub\Intranet\inc.asp(16) : error BC30451: Name 'adLockPessimistic' is not declared.
adLockPessimistic = 2
~~~~~~~~~~~~~~~~~
D:\Inetpub\Intranet\inc.asp(17) : error BC30451: Name 'adLockOptimistic' is not declared.
adLockOptimistic = 3
~~~~~~~~~~~~~~~~
D:\Inetpub\Intranet\inc.asp(18) : error BC30451: Name 'adLockBatchOptimistic' is not declared.
adLockBatchOptimistic = 4
~~~~~~~~~~~~~~~~~~~~~
D:\Inetpub\Intranet\inc.asp(21) : error BC30451: Name 'adApproxPosition' is not declared.
adApproxPosition = 16384
~~~~~~~~~~~~~~~~
D:\Inetpub\Intranet\inc.asp(29) : error BC30807: 'Let' and 'Set' assignment statements are no longer supported.
Set conn = Server.CreateObject("ADODB.Connection")
~~~
D:\Inetpub\Intranet\inc.asp(29) : error BC30451: Name 'conn' is not declared.
Set conn = Server.CreateObject("ADODB.Connection")
~~~~
D:\Inetpub\Intranet\inc.asp(30) : error BC30451: Name 'conn' is not declared.
conn.ConnectionTimeout = 1
~~~~
D:\Inetpub\Intranet\inc.asp(31) : error BC30451: Name 'conn' is not declared.
conn.CommandTimeout = 30
~~~~
D:\Inetpub\Intranet\inc.asp(32) : error BC30451: Name 'conn' is not declared.
conn.Open "Driver={SQL Server};" & _
~~~~
D:\Inetpub\Intranet\inc.asp(32) : error BC30800: Method arguments must be enclosed in parentheses.
conn.Open "Driver={SQL Server};" & _
~~~~~~~~~~~~~~~~~~~~~~
D:\Inetpub\Intranet\inc.asp(37) : error BC30807: 'Let' and 'Set' assignment statements are no longer supported.
Set cmdTemp = Server.CreateObject("ADODB.Command")
~~~
D:\Inetpub\Intranet\inc.asp(37) : error BC30451: Name 'cmdTemp' is not declared.
Set cmdTemp = Server.CreateObject("ADODB.Command")
~~~~~~~
D:\Inetpub\Intranet\inc.asp(38) : error BC30451: Name 'cmdTemp' is not declared.
cmdTemp.CommandType = adCmdText
~~~~~~~
D:\Inetpub\Intranet\inc.asp(38) : error BC30451: Name 'adCmdText' is not declared.
cmdTemp.CommandType = adCmdText
~~~~~~~~~
D:\Inetpub\Intranet\inc.asp(39) : error BC30807: 'Let' and 'Set' assignment statements are no longer supported.
Set cmdTemp.ActiveConnection = conn
~~~
D:\Inetpub\Intranet\inc.asp(39) : error BC30451: Name 'cmdTemp' is not declared.
Set cmdTemp.ActiveConnection = conn
~~~~~~~
D:\Inetpub\Intranet\inc.asp(39) : error BC30451: Name 'conn' is not declared.
Set cmdTemp.ActiveConnection = conn
~~~~
It appears that something is wrong with the server(?) but I've never seen this type of error before, so I'm not sure what's going on. Like I said, I don't believe it is coding, but where do I start looking for an answer???
Help!!
|
