SQL Temp table in ado connection = Error Msg

**kuraitori** · 12-07-2010, 04:10 PM

Query compiles in sql just fine, but when I run the vba sub, I receive this error msg

Run-time error '3704':
Operation is not allowed when the object is closed

And as you'll notice, I have included SET NOCOUNT ON in the sSQL string. Can anyone help me with this?

Please Login or Register  to view this content.

**romperstomper** · 12-07-2010, 04:53 PM

Have you tried opening a connection object first, then executing the Set NoCount On and then opening your recordset?

**kuraitori** · 12-07-2010, 07:24 PM

How would I specify the "Set NoCount On" in someplace other than the cmdline (or sSQL)

**romperstomper** · 12-08-2010, 03:56 AM

Create a connection and then execute:

Please Login or Register  to view this content.

for example.

**kuraitori** · 12-09-2010, 06:24 PM

Tried it, same error message except the cnn.execute line is highlighted

**romperstomper** · 12-09-2010, 06:30 PM

Did you open a connection first? What code did you use?

Re: SQL Temp table in ado connection = Error Msg