Re: dsn connection

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Mike (anonymous_at_discussions.microsoft.com)
Date: 06/16/04 

Date: Wed, 16 Jun 2004 10:54:35 -0400

why do want to do want? Setup a DSN or how i'm doing it now in the code?

'Server=servername;Database=DBName"

If i keep it like it is now doesn't the SQL Server DB have to reside on the
web server? If I create a DSN who cares what servers its on, i just need to
point to a DSN on the web server.

"Kevin Spencer" <kspencer@takempis.com> wrote in message
news:ObFF$C7UEHA.3596@tk2msftngp13.phx.gbl...
> 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

  • re: Stop me before I use DSN again!
    ... >site to my home server that has no such DSN defined. ... >from a query that uses a linked table, ... Set cnNwind= Server.CreateObject ...
    (microsoft.public.frontpage.client)
  • Create a DSN programmatically with network options
    ... I would like to create a brand new system DSN, programmatically, ... Relying on this single registry entry is not enough since it only ... least for SQL Server). ... networking options cannot be set ...
    (microsoft.public.sqlserver.odbc)
  • Re: Trying to get DSN notifications with delayed/failed mail
    ... SMTP Server. ... alerting mail originators if their app has generated badmail, ... You will never get a DSN if the From: ...
    (microsoft.public.inetserver.iis.smtp_nntp)
  • Re: dsn connection
    ... > No - the SQL Server can exist anywhere. ... > connection string. ... Setup a DSN or how i'm doing it now in the code? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: dsn connection
    ... Setup a DSN or how i'm doing it now in the code? ... Why would you want to use an ODBC DSN? ... > If i keep it like it is now doesn't the SQL Server DB have to reside on ...
    (microsoft.public.dotnet.framework.aspnet)