Re: dsn connection

From: Kevin Spencer (kspencer_at_takempis.com)
Date: 06/16/04


Date: Wed, 16 Jun 2004 10:40:27 -0400

Why on earth would you want to do that? You're adding an unnecessary layer
of processing and file IO to accomplish the same thing. All a DSN does is
store information that you can put right into your Connection String. In
addition, it uses ODBC, which is a wrapper for OLE DB, and using the native
SQL Data classes is much faster.

-- 
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
"Mike" <anonymous@discussions.microsoft.com> wrote in message
news:O5oUx56UEHA.1036@TK2MSFTNGP12.phx.gbl...
> In my code i'm pointing to a SQL server name and SQL database name on the
> server, etc.
> Instead of that how can i point to a DSN connection on the web server that
> points to the SQL Server and DB?
>
>
>


Relevant Pages

  • cannot access website
    ... Nerve.com--this started a few weeks ago; I do not get the error message on ... Microsoft OLE DB Provider for ODBC Drivers Error '80040e4d' ... Not defined as a valid user of a trusted SQL Server connection. ... The DSN used to connect to the Commerce database is misconfigured to use ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Changing Sql7 TCP Port
    ... If the website is running on the same machine as the sql server, and the DSN ... connection string in each website has the IP address hard coded and no port ...
    (microsoft.public.sqlserver.security)
  • RE: Invalid authorization specification
    ... Does your application use a DSN to connect to SQL Server? ... DSN is setup correctly on the client machine. ... How to troubleshoot connectivity issues in SQL Server 2000 - ...
    (microsoft.public.sqlserver.connect)
  • Re: Programmatically create DSN usind SQL Server Authentication
    ... Not when you create the DSN programmatically. ... >Server using SQL Server Authentication. ... >is off-topic for my purpose because it only shows Windows authentication. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Understanding SQL Connection
    ... production SQL server being hosted by a 3rd party on an external domain. ... "Rick Brandt" wrote: ... >> the linked table wizard and created a DSN. ... > credentials are automatically passed when the DSN is actually used later on. ...
    (microsoft.public.access.forms)