[dba-SQLServer] Connections

Here is an almost full EM written in VB6 with SQL-DMO. Versions for for 
MSDE 1 and 2000
Includes full source code useful for learning SQL-DMO

http://www.asql.biz/DbaMgr.shtm

Arthur Fuller wrote:

>I have some DMO-based code that handles this issue. It's part of an app
>that I wrote that assumes you don't have Enterprise Manager etc.
>installed (i.e. you have an MSDE back end). SQL-DMO is pretty simple
>once you inspect its methods and read (gasp) the docs. The code I wrote
>is not rocket science.
>
>Arthur
>
>-----Original Message-----
>From: dba-sqlserver-bounces at databaseadvisors.com
>[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Martin
>Reid
>Sent: Tuesday, June 15, 2004 4:16 PM
>To: dba-sqlserver at databaseadvisors.com
>Subject: [dba-SQLServer] Connections
>
>
>I have a global connection set up in an Access front end to SQL Server.
>When this goes out to the clients it will run on many different client
>servers and we will not know the server name or security model in use
>before it is installed.
>
>How do you folks handle this?
>
>SQL Server 2000
>Access 2000, 2002 and 2003 as the front end.
>
>
>Martin
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada