Server.CreateObject Error, Invalid Class String 1

[webIntern]

Hi all,

I'm using ASP and ADO to connect to a SQL Server database. I get an error of "Server object, ASP 0177 (0x800401F3)
Invalid class string" on the line:

Set rsField = Server.CreateObject("ADODB.field")

I've installed MDAC 2.8. Can anyone help me?

Thanks

 

[onpnt]

do you mean
Set rsField = Server.CreateObject("ADODB.recordset")



___________________________________________________________________
[sub]

http://www.onpnt.com

The answer to your ??'s may be closer then you think.
Check out Tek-Tips knowledge bank by clicking the FAQ link at the top of the page faq333-3811[/sub]

 

[onpnt]

and if you are attempting to get the column names by that ADODB.Field you would loop the RS as
Dim Fld
For Each Fld In rsField.Fields
Response.Write("Fieldname: " & Fld.Name & "<br>")
Next

maybe a bit of details on what you're doing will help out

___________________________________________________________________
[sub]

http://www.onpnt.com

The answer to your ??'s may be closer then you think.
Check out Tek-Tips knowledge bank by clicking the FAQ link at the top of the page faq333-3811[/sub]

 

[webIntern]

Thanks, that's exactly what I was trying to do. I didn't realize you can do it after opening the recordset, without instantiating an ADODB.Field object. My code now works with your example.

That's why I'm an intern!

 

[onpnt]

Glad you got it going!

___________________________________________________________________
[sub]

http://www.onpnt.com

The answer to your ??'s may be closer then you think.
Check out Tek-Tips knowledge bank by clicking the FAQ link at the top of the page faq333-3811[/sub]