can't access my access database anymore

[irisk]

I had running a asp script in HS.1.7 wich was using an access database.
Now I have installed HS2, it won't run anymore.
The error message is:
Script error: Object doesn't support this property or method: 'Server.CreateObject' Set adoCon = Server.CreateObject("ADODB.Connection") adoCon.open "dsn=homeautomation"

If I switch back to HS1.7 it run ok again. (So nothing is changed in the ODBC settings).

Can someone help me please.

Iris

[krasnerw]

Same Problem

I am having the sam problem with asp on HS2.

Script error: Object doesn't support this property or method: 'Server.CreateObject'

Set hs = Server.CreateObject("HomeSeer.Application")


Have you solved your problem yet

[krasnerw]

Reading some of the threads on this issue, may have something to do with dcom settings. Made recommended changes to dcom settings, didn't help

[Rupp]

I am having the sam problem with asp on HS2.

Script error: Object doesn't support this property or method: 'Server.CreateObject'

Set hs = Server.CreateObject("HomeSeer.Application")


Have you solved your problem yet

You now need to use the following to create the homeseer application object.

Set hsi = CreateObject("homeSeer2.application")
hsi.Connect()
Set hs = hsi.GetHSRef

[krasnerw]

As usual Rupp you are right on! worked like a charm! Thank you

[Rupp]

Excellent and your welcome.

Greg

[wes]

Ok, to go back to the original question in this post, before it was hijacked to something different. seeing as I'm now having the same problem as irisk.

How do we get an ADODB connection in the web server in HS2????


i originally had this code
----------------------------
Set cnnSimple = Server.CreateObject("ADODB.Connection")
=--------------------------

tried changing it to look somewhat like Rupp's answer to the following
----------------
Set cnnSimple = CreateObject("ADODB.Connection")
cnnSimple.Connect()
------------------

[Rupp]

Wes,
Drop the server. from the create object statement and it should work with HS 2.0. I'm not sure why though. The object should be created using the server asp object.