Re: dsn connection
From: Kevin Spencer (kspencer_at_takempis.com)
Date: 06/16/04
- Next message: Cliff Harris: "Re: Register javascript block globally..."
- Previous message: Wardeaux: "sessionstate = SQLServer"
- In reply to: Mike: "dsn connection"
- Next in thread: Mike: "Re: dsn connection"
- Reply: Mike: "Re: dsn connection"
- Messages sorted by: [ date ] [ thread ]
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? > > >
- Next message: Cliff Harris: "Re: Register javascript block globally..."
- Previous message: Wardeaux: "sessionstate = SQLServer"
- In reply to: Mike: "dsn connection"
- Next in thread: Mike: "Re: dsn connection"
- Reply: Mike: "Re: dsn connection"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|