Converting Connection string to SQLOLEDB

Question

Connection Code:

set conx = Server.CreateObject("ADODB.connection")
conx.Open Application("connectionString")

set cmdx = server.CreateObject("ADODB.command")
cmdx.ActiveConnection = conx
cmdx.CommandText = "dbo.sproc"
cmdx.CommandType = &H0004

set rsx = Server.CreateObject("ADODB.Recordset")
rsx.open cmdx

resarray = rsx.getrows

This connection string works:

connectionString = "DRIVER=SQL Server;UID=User;Address=000.000.000.000;Network=DBMSSOCN;DATABASE=Database;SERVER=server;Password=password;"

This doesn't...

connectionString = "Provider=SQLOLEDB;Data Source=000.000.000.000;UID=User;Address=000.000.000.000;Network=DBMSSOCN;DATABASE=Database;SERVER=server;Password=password;"

The error I get is:

ADODB.Recordset error '800a0e78'

Operation is not allowed when the object is closed.

What am I missing?

AnthonyWJones · Accepted Answer · 2008-12-09 11:17:31Z

3

Just a punt here, but the way OLEDB drivers handle Row count informationals differs from ODBC.

I very much suspect that if you add SET NOCOUNT ON at the top of the Stored Procedure the problem will go away.

answered Dec 9, 2008 at 11:17

AnthonyWJones

190k35 gold badges236 silver badges307 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

xoxo · Accepted Answer · 2008-12-08 10:54:14Z

-1

Sounds like a permissions problem in the database!

answered Dec 8, 2008 at 10:54

xoxo

5777 silver badges25 bronze badges

1 Comment

NikolaiDante Over a year ago

It's the same database, just a different way of reaching it.

Collectives™ on Stack Overflow

Converting Connection string to SQLOLEDB

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related