Object does not support this property or method.

**Aaron [SQL Server MVP]** · Jul 19 '05, 01:50 PM

Re: Object does not support this property or method.

> I get the following error message on a line that attempts to create an[color=blue]
> instance of an ADODB connection object.
>
> "Object does not support this property or method: 'Server.CreateO bject' ".[/color]

Can you show the actual line?

--

Expired DNS Hosting Services | DNS Made Easy

http://www.aspfaq.com/

Please contact this domain's administrator as their DNS Made Easy services have expired.

(Reverse address to reply.)

**Rohan Hattangdi** · Jul 19 '05, 01:51 PM

Re: Object does not support this property or method.

Yes.

set con = Server.CreateOb ject("ADODB.Con nection")

This is the line where it fails.

Thanks,

Rohan

"Aaron [SQL Server MVP]" <ten.xoc@dnartr eb.noraa> wrote in message
news:ePH474giEH A.1280@TK2MSFTN GP09.phx.gbl...[color=blue][color=green]
> > I get the following error message on a line that attempts to create an
> > instance of an ADODB connection object.
> >
> > "Object does not support this property or method: 'Server.CreateO bject'[/color][/color]
".[color=blue]
>
> Can you show the actual line?
>
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>[/color]

**Bob Barrows [MVP]** · Jul 19 '05, 01:51 PM

Re: Object does not support this property or method.

We need to see more code. (no html please)

Has it ever worked?

Rohan Hattangdi wrote:[color=blue]
> Yes.
>
> set con = Server.CreateOb ject("ADODB.Con nection")
>
> This is the line where it fails.
>
> Thanks,
>
> Rohan
>
>
> "Aaron [SQL Server MVP]" <ten.xoc@dnartr eb.noraa> wrote in message
> news:ePH474giEH A.1280@TK2MSFTN GP09.phx.gbl...[color=green][color=darkred]
>>> I get the following error message on a line that attempts to create
>>> an instance of an ADODB connection object.
>>>
>>> "Object does not support this property or method:
>>> 'Server.CreateO bject' ".[/color]
>>
>> Can you show the actual line?
>>
>> --
>> http://www.aspfaq.com/
>> (Reverse address to reply.)[/color][/color]

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

**Aaron [SQL Server MVP]** · Jul 19 '05, 01:51 PM

Re: Object does not support this property or method.

Did you try without the Server prefix?

Did you try reinstalling MDAC (not necessarily an upgrade, but more of a
repair)?

--

Expired DNS Hosting Services | DNS Made Easy

http://www.aspfaq.com/

Please contact this domain's administrator as their DNS Made Easy services have expired.

(Reverse address to reply.)

"Rohan Hattangdi" <RohanHattangdi 2003@hotmail.co m> wrote in message
news:u64rO9giEH A.2848@TK2MSFTN GP10.phx.gbl...[color=blue]
> Yes.
>
> set con = Server.CreateOb ject("ADODB.Con nection")
>
> This is the line where it fails.
>
> Thanks,
>
> Rohan
>
>
> "Aaron [SQL Server MVP]" <ten.xoc@dnartr eb.noraa> wrote in message
> news:ePH474giEH A.1280@TK2MSFTN GP09.phx.gbl...[color=green][color=darkred]
> > > I get the following error message on a line that attempts to create an
> > > instance of an ADODB connection object.
> > >
> > > "Object does not support this property or method:[/color][/color][/color]
'Server.CreateO bject'[color=blue]
> ".[color=green]
> >
> > Can you show the actual line?
> >
> > --
> > http://www.aspfaq.com/
> > (Reverse address to reply.)
> >
> >[/color]
>
>[/color]

**Rohan Hattangdi** · Jul 19 '05, 01:51 PM

Re: Object does not support this property or method.

Sure. Code is below. This code had been working for quite some time and then
it stopped for a bit. It seems however that the problem is always solved
during our nightly IIS resets. Naturally this is not a good way of fixing
things ... BTW, some names have been changed below ...

dim con

dim DSN

dim cmd

dim objCMD

dim POutCon

dim JSCon

sub PunchoutConnect ion(rs,sql)

set POutCon = Server.CreateOb ject("ADODB.Con nection")

POutCon.Open "File Name=C:\aigi\yy yyy.udl;"

set rs = POutCon.Execute (sql)

end sub

sub Job_Scheduler(r s,sql)

set JSCon = Server.CreateOb ject("ADODB.Con nection")

JSCon.Open "File Name=C:\aigi\Jo b_Scheduler.udl ;"

set rs = JSCon.Execute(s ql)

end sub

set con = Server.CreateOb ject("ADODB.Con nection")

'DSN = "DSN=udlAAAAAms p;uid=xxxxxx;pw d=xxxxxx;"

con.ConnectionT imeout=500

'con.Open DSN

'con.Open "File Name=C:\aigi\ud lAAAAAmsp.udl;"

con.Open "File Name=C:\aigi\aa aaaa.udl;"

"Bob Barrows [MVP]" <reb01501@NOyah oo.SPAMcom> wrote in message
news:ODbRQ$giEH A.1344@TK2MSFTN GP11.phx.gbl...[color=blue]
> We need to see more code. (no html please)
>
> Has it ever worked?
>
> Rohan Hattangdi wrote:[color=green]
> > Yes.
> >
> > set con = Server.CreateOb ject("ADODB.Con nection")
> >
> > This is the line where it fails.
> >
> > Thanks,
> >
> > Rohan
> >
> >
> > "Aaron [SQL Server MVP]" <ten.xoc@dnartr eb.noraa> wrote in message
> > news:ePH474giEH A.1280@TK2MSFTN GP09.phx.gbl...[color=darkred]
> >>> I get the following error message on a line that attempts to create
> >>> an instance of an ADODB connection object.
> >>>
> >>> "Object does not support this property or method:
> >>> 'Server.CreateO bject' ".
> >>
> >> Can you show the actual line?
> >>
> >> --
> >> http://www.aspfaq.com/
> >> (Reverse address to reply.)[/color][/color]
>
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>[/color]

**Rohan Hattangdi** · Jul 19 '05, 01:51 PM

Re: Object does not support this property or method.

Have not tried without Server prefix ...

The MDAC thing - would that not affect every website on that box?

Thanks,

Rohan

"Aaron [SQL Server MVP]" <ten.xoc@dnartr eb.noraa> wrote in message
news:O94dxBhiEH A.712@TK2MSFTNG P09.phx.gbl...[color=blue]
> Did you try without the Server prefix?
>
> Did you try reinstalling MDAC (not necessarily an upgrade, but more of a
> repair)?
>
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
>
>
> "Rohan Hattangdi" <RohanHattangdi 2003@hotmail.co m> wrote in message
> news:u64rO9giEH A.2848@TK2MSFTN GP10.phx.gbl...[color=green]
> > Yes.
> >
> > set con = Server.CreateOb ject("ADODB.Con nection")
> >
> > This is the line where it fails.
> >
> > Thanks,
> >
> > Rohan
> >
> >
> > "Aaron [SQL Server MVP]" <ten.xoc@dnartr eb.noraa> wrote in message
> > news:ePH474giEH A.1280@TK2MSFTN GP09.phx.gbl...[color=darkred]
> > > > I get the following error message on a line that attempts to create[/color][/color][/color]
an[color=blue][color=green][color=darkred]
> > > > instance of an ADODB connection object.
> > > >
> > > > "Object does not support this property or method:[/color][/color]
> 'Server.CreateO bject'[color=green]
> > ".[color=darkred]
> > >
> > > Can you show the actual line?
> > >
> > > --
> > > http://www.aspfaq.com/
> > > (Reverse address to reply.)
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]

**Aaron [SQL Server MVP]** · Jul 19 '05, 01:51 PM

Re: Object does not support this property or method.

> The MDAC thing - would that not affect every website on that box?

If you reinstall the same version?

**Rohan Hattangdi** · Jul 19 '05, 01:51 PM

Re: Object does not support this property or method.

No, I mean ... would not an error with the MDAC affect every single website
on that box?

"Aaron [SQL Server MVP]" <ten.xoc@dnartr eb.noraa> wrote in message
news:%23v2Bllhi EHA.3928@TK2MSF TNGP11.phx.gbl. ..[color=blue][color=green]
> > The MDAC thing - would that not affect every website on that box?[/color]
>
> If you reinstall the same version?
>
>[/color]

**Aaron [SQL Server MVP]** · Jul 19 '05, 01:51 PM

Re: Object does not support this property or method.

Maybe, are you saying that this error only happens on one web site, but not
on the others? Have you considered deleting the web site from IIS, and
re-creating it?

--

Expired DNS Hosting Services | DNS Made Easy

http://www.aspfaq.com/

Please contact this domain's administrator as their DNS Made Easy services have expired.

(Reverse address to reply.)

"Rohan Hattangdi" <RohanHattangdi 2003@hotmail.co m> wrote in message
news:OPKsl7hiEH A.1376@TK2MSFTN GP11.phx.gbl...[color=blue]
> No, I mean ... would not an error with the MDAC affect every single[/color]
website[color=blue]
> on that box?
>
> "Aaron [SQL Server MVP]" <ten.xoc@dnartr eb.noraa> wrote in message
> news:%23v2Bllhi EHA.3928@TK2MSF TNGP11.phx.gbl. ..[color=green][color=darkred]
> > > The MDAC thing - would that not affect every website on that box?[/color]
> >
> > If you reinstall the same version?
> >
> >[/color]
>
>[/color]

**Ray Costanzo [MVP]** · Jul 19 '05, 01:51 PM

Re: Object does not support this property or method.

Before doing anything drastic, check to make sure that you don't have a
variable named "server" in your code somewhere. That could cause you to see
the error you're seeing. IE,

Dim server, z
set server = createobject("s cripting.filesy stemobject")
set z = server.createob ject("adodb.con nection")
set z= nothing
set server = nothing

Ray at home

"Rohan Hattangdi" <RohanHattangdi 2003@hotmail.co m> wrote in message
news:e01co2giEH A.2848@TK2MSFTN GP10.phx.gbl...[color=blue]
> I get the following error message on a line that attempts to create an
> instance of an ADODB connection object.
>
> "Object does not support this property or method: 'Server.CreateO bject' ".
>
> Now the strange thing is that other websites on that server work just[/color]
fine.[color=blue]
> Also, this website is hosted across three machines for load-balancing
> purposes - the other websites are kept in sync using a tool that we have[/color]
and[color=blue]
> the files are identical across all three machines. Yet, we get this error[/color]
on[color=blue]
> only one machine.
>
> If all the websites were having trouble I would suspect an update to the
> MDAC. If all three machines were facing problems I would suspect a code
> change of some sort. But the situation that I have I cannot figure out.
>
> If anyone out there has any ideas I would greatly appreciate the[/color]
assistance.[color=blue]
>
> TIA,
>
> Rohan
>
>[/color]

Object does not support this property or method.

Object does not support this property or method.

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment