ADODB.Command creation problems

[Guest]

Hello,
I am trying to create an instance of the ADODB.Command object using
javascript on one of my webpages.

var oCon;
var oCmd

oCon = new ActiveXObject("ADODB.Connection");
oCmd = new ActiveXObject("ADODB.Command");

The oCon creates succesfully, the oCmd returns an unable to create object
error.

For info, I have MDAC 2.7 installed.

Thanks for any help.

 

[Uri Dor]

maybe you need to create an instance that is provider-specific?
(OLEDB/Sql Server/etc.)

 

[Guest]

Already do with the line:

oCon.ConnectionString="PROVIDER=SQLOLEDB; Data Source=<myserver>;
UID=<myid>; Password=<mypassword>; Initial Catalog=DS32_IRL";

 

[Uri Dor]

did you assign the connection string before creating the command?

 

[Guest]

The connection has been established before attempting to create this object.

 

[Uri Dor]

Sorry, I'm out of ideas

The connection has been established before attempting to create this object.

: