Problem moving from IIS5 to 4

[Phil]

Hi there,

I've recently developed a fairly simple site to start learning ASP. I
developed the site on a windows 2000 machine with IIS5 and MSDE, and it all
appears to be working fine.

I then tried to move the site to my server, which is an NT4 box running IIS4
and MSDE. The database appeared to import to the server from the
development machine fine, but whenever I try to view a page from the server
I get the error message :

Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method: 'open'
/shownewest.asp, line 27

I believe the code that causes the problem is fine as it works on the other
machine, and the database has the exact same name and location on the server
as on the development machine:

Dim strConnect, objConn, objRS, objCommand
strConnect ="Provider=SQLOLEDB;Persist Security Info=False;" &_
"User ID=sa;Initial Catalog=reports;" &_
"initial File Name=c:\mssql7\data\reports.mdf"
set objConn = server.CreateObject("ADODB.Connection")
set objRS = server.CreateObject("ADODB.Recordset")
set objCommand = server.CreateObject("ADODB.Command")
objConn.open = strConnect

Any ideas what the problem is? Am I using something thats not supported in
IIS4, or is it more likely to be a configuration error on my server?

Thanks

Phil

[Bob Lehmann]

Should this -
objConn.open = strConnect

Be this -
objConn.open strConnect

Bob Lehmann

"Phil" <don't@even.think.about.it> wrote in message
news:3f3d3a42$0$11377$cc9e4d1f@news.dial.pipex.com ...

> Hi there,
>
> I've recently developed a fairly simple site to start learning ASP. I
> developed the site on a windows 2000 machine with IIS5 and MSDE, and it

all

> appears to be working fine.
>
> I then tried to move the site to my server, which is an NT4 box running

IIS4

> and MSDE. The database appeared to import to the server from the
> development machine fine, but whenever I try to view a page from the

server

> I get the error message :
>
> Microsoft VBScript runtime error '800a01b6'
> Object doesn't support this property or method: 'open'
> /shownewest.asp, line 27
>
> I believe the code that causes the problem is fine as it works on the

other

> machine, and the database has the exact same name and location on the

server

> as on the development machine:
>
> Dim strConnect, objConn, objRS, objCommand
> strConnect ="Provider=SQLOLEDB;Persist Security Info=False;" &_
> "User ID=sa;Initial Catalog=reports;" &_
> "initial File Name=c:\mssql7\data\reports.mdf"
> set objConn = server.CreateObject("ADODB.Connection")
> set objRS = server.CreateObject("ADODB.Recordset")
> set objCommand = server.CreateObject("ADODB.Command")
> objConn.open = strConnect
>
> Any ideas what the problem is? Am I using something thats not supported in
> IIS4, or is it more likely to be a configuration error on my server?
>
> Thanks
>
> Phil
>
>

[Phil]

"Bob Lehmann" <bob@activeinet.com> wrote in message
news:OEqx2P3YDHA.2648@TK2MSFTNGP09.phx.gbl...

> Should this -
> objConn.open = strConnect
>
> Be this -
> objConn.open strConnect

Yes, of course it should. Now I'm a bit confused as to why it works on my
development machine, but never mind, I won't dwell on it.

Thanks