Database Connection String

[Andrew]

I'm creating an app that a company will use to connect to an Access database
on a central server using ADO (REASON: Might be converted to SQL Server/Oracle).
My question is what is the best, or most common, connection string use to
point to the database? Is using a DSN popular or a registry entry or even
an INI file? The users, and even the client, are not real savvy so I would
like it to be a simple as possible.

Thanks!

[Douglas J. Steele]

I'd avoid the DSN, because of the headaches deploying it. Go DSN-less, and
store the connection string in either the registry or an INI, whichever
you're more comfortable with.

BTW, a good source of connection string information can be found at
http://www.able-compute.com

--

Doug Steele, Microsoft Access MVP
Beer, Wine and Database Programming. What could be better?
Visit "Doug Steele's Beer and Programming Emporium"
http://I.Am/DougSteele/


Andrew <mclellan_a@nospanYahoo.com> wrote in message
news:390dbc42$1@news.devx.com...
>
> I'm creating an app that a company will use to connect to an Access
database
> on a central server using ADO (REASON: Might be converted to SQL
Server/Oracle).
> My question is what is the best, or most common, connection string use to
> point to the database? Is using a DSN popular or a registry entry or even
> an INI file? The users, and even the client, are not real savvy so I
would
> like it to be a simple as possible.
>
> Thanks!