HomeSite Scripting with ADO

[Howard Owens]

So I've spent most of the day trying to figure out (and doing lots of searches on the web) on how to use Scripting to access SQL Server (again, I'm trying to run this through HomeSite+ scripting).

If I do something like

var objConn = Server.CreateObject(ADODB.Connection);

I get an error that Server isn't defined.

So I tried every way I could think of or get a clue to define Server.

Among those I tried were:

Server = ActiveXObject(ADODB.Connection);

And

var Server= "Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=articles;Data Source=me" ;

And a million other variations, probably.

Anybody have any idea how to do this?

H.

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---