dee bee connection

[JimMuglia]

Greetings,

Hey, i'm trying to set aconnectin string wth the database with this command:

Set cnn = Server.CreateObject("ADODB.Connection")


I get the error 424"object Required" on that line.

I do have the compoonent

Microsoft ADO Data Control 6.0 (SP4)(OLEDB)

selected,as well as the reference files


Microsoft Active X Data objects (Multi-dimensional)2.5 Library
Microsoft Active X Data objects 2.5 Library

CAn someone please clarify my understanding, or tell me what i'm dong wrong.

Thank you,
Jim

[mlewis]

"Set cnn = Server.CreateObject("ADODB.Connection")" is ASP code. You need to use VB code instead:

Set cnn = CreateObject("ADODB.Connection")

VB does not have a Server object.

[JimMuglia]

Originally posted by mlewis
"Set cnn = Server.CreateObject("ADODB.Connection")" is ASP code. You need to use VB code instead:

Set cnn = CreateObject("ADODB.Connection")

VB does not have a Server object.

I do believe you are THEE man. Thank you!!! Be on alert for more database questions, in this thread, in the very near future as I figure out the rest of successfully connecting to a database.
Jim

[James Stanich]

Dim cnn as New ADODB.Connection
 
cnn.Open ' Add path here

[JimMuglia]

Originally posted by James Stanich

Dim cnn as New ADODB.Connection
 
cnn.Open ' Add path here

Been there done that, thank's for the anticipation. That make me in the mood for heinz ketchup; remeber the song "Anticipation" for the commercial? Ahh... I'm off subject. Thanks though, odds are I'll have more dee bee quetions as I try to hash out the program this weekend.
Take care,
Jim

[James Stanich]

Originally posted by JimMuglia
Been there done that, thank's for the anticipation. That make me in the mood for heinz ketchup; remeber the song "Anticipation" for the commercial? Ahh... I'm off subject. Thanks though, odds are I'll have more dee bee quetions as I try to hash out the program this weekend.
Take care,
Jim

What do you mean here? To slow for you?

[JimMuglia]

Originally posted by James Stanich
What do you mean here? To slow for you?

Jim,

I was making a joke about the song "Anticiapation", by Carly Simon, as it was used in a Heinz ketchup commercial back in the 70s.

Also, I was saying that I may have more database questions this weekend, realted to my VB project, as I do my program some more.

Thank you,
Jim

[James Stanich]

Sorry, misunderstood what you meant...

[JimMuglia]

Originally posted by James Stanich
Sorry, misunderstood what you meant...

I dunno, it might take me awhile to get over it.