[AccessD] Connection class?

Drew Wutka DWUTKA at marlow.com
Fri Feb 28 09:13:01 CST 2003


Why would this show up in the Intellisense?  They properties are there,
right?  So if you assign the connection string to the connection object, you
should be able to just check the individual properties.  Or vice versa, if
you set the properties, the connection string should be filled in.

Drew

-----Original Message-----
From: Arthur Fuller
To: accessd at databaseadvisors.com
Sent: 2/28/03 8:02 AM
Subject: RE: [AccessD] Connection class?

It may well do so, and you'd think the class would provide this most
basic functionality, but I don't see it in the class browser or in
intellisense. So at the moment I'm parsing the connection string and
grabbing the components myself. The code is just simple arithmetic and
all the GETs call the same function, just passing a different string in
(i.e. "Initial Catalog=") and getting back the word(s) after that string
up to the next semi-colon. But it does seem odd that I have to write it
myself.

A.

 

-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: February 28, 2003 12:56 AM
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] Connection class?

 

Just out of curiousity Arthur, are you talking about an ADO Connection
object?  Can't you just get the properties from the object itself, or
doesn't it split the 'components' when you give it a connection string?
(I would think it would, but I usually create and open my connection by
their individual properties anyways....)

 

Drew

-----Original Message-----
From: Arthur Fuller [mailto:artful at rogers.com]
Sent: Thursday, February 27, 2003 5:27 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Connection class?

Thanks a lot. I think your new nick is ChayLo :-)

 

 

-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: February 27, 2003 3:08 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Connection class?

 

Be our guest, Arthur!  I'll download and steal your code when you finish
it.<VBG>  

 

Charlotte Foust

-----Original Message-----
From: Arthur Fuller [mailto:artful at rogers.com] 
Sent: Thursday, February 27, 2003 10:54 AM
To: AccessD
Subject: [AccessD] Connection class?

Is there a convenient way to extract the components of a connection
string? I wrote some code to do it, using substring extractions, but
hell, there has to be a built-in way that's better than that!
Alternatively, has anyone written such a class? If not, I'll do it and
post it.

 

TIA,

Arthur




More information about the AccessD mailing list