Re: ConnectionString using DSN not working

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Apr 18, 8:40 pm, Paul Clement
<UseAdddressAtEndofMess...@xxxxxxxxxxxxxx> wrote:
On 17 Apr 2007 09:46:55 -0700, Fendi Baba <effe...@xxxxxxxxxxxxxx> wrote:

¤ Ok, But when I created tableAdapters to use connectionstring created
¤ usingDSN, it work normally. While not doubting whatyou've said, I am
¤ jsut trying to figure out what to tell my bosses why I cant useDSN...
¤

ODBC is legacy technology. The only reason to support it is if you have legacy code or no native
.NET provider for the database that you are working with. Native .NET provider libraries do not
typically support theDSNfeature, which was developed for ODBC.

If the reason for using aDSNis to hide the details of the connection, you can encrypt the
connection string information and read it from a .config file instead.

Paul
~~~~
Microsoft MVP (Visual Basic)


Paul

Thanks for the answers. Could you lead me to a resource which states
this? My infrastructure folks is concerned about moving away from ODBC
and has asked me for a documentation.

Regards

.

Relevant Pages

  • Re: Alternative to using DSN to connect to database
    ... The ODBC .net provider is supposed to work on top of any ODBC native driver. ... The "right" way is to use a managed .NET provider targeted for a database; ... connection string in a configuration file (eventually encrypt the connection ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ConnectionString using DSN not working
    ... ¤ ... ..NET provider for the database that you are working with. ... typically support the DSN feature, ... If the reason for using a DSN is to hide the details of the connection, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ConnectionString using DSN not working
    ... ODBC is outdated technology and should only be used if there are no ... ¤ usingDSN, it work normally. ... If the reason for using aDSNis to hide the details of the connection, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ConnectionString using DSN not working
    ... ¤ On Apr 18, 8:40 pm, Paul Clement ... which was developed for ODBC. ... ¤> connection string information and read it from a .config file instead. ... ¤> Paul ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OLEDB connection from ActiveX DLL
    ... ¤ I have written an ActiveX DLL that does lookups in a SQL Server ... ¤ Express 2005 via ODBC. ... The connection string for OLEDB: ...
    (microsoft.public.vb.database)