[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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030228/aa323bb2/attachment-0001.html>