Re: Does connection string need anything on system?
- From: "gerryR" <gerryr@xxxxxxxxx>
- Date: Tue, 15 Sep 2009 08:46:45 +0100
Thanks for the detailed explanation Scott.
Moving away from ODBC now.
"Scott M." <s-mar@xxxxxxxxxxxxx> wrote in message news:uMVC7PWNKHA.3192@xxxxxxxxxxxxxxxxxxxxxxx
Open DataBase Connectivity (ODBC) is a Microsoft standard (albeit an old one) that allowed a developer to set up a Data Source Name (DSN) within the operating system. This DSN needed to be configured to know which database driver was going to be needed and which actual data source was being used. This is what the ODBC Manager tool in Control Panel > Admin Tools is for...setting up a DSN. The DSN must then be set up on EACH machine where the DSN would be called from executing code..
OLEDB Providers (a.k.a. DSN-less connections) superceded ODBC some time ago and allow for you to take the middle man (the ODBC Mananger) and the machine-specific DSN's created by it out of the picture. With OLEDB, you code directly against the provider and, as long as the provider is present on the target machine, the code can talk to it. This results in better performance and is why OLEDB is preferred to ODBC.
Greg's advice to try it and see if it breaks (or the optimist's view: try it and see if it works) is probably the easiest way to know if you have the needed provider in an application that will run from a server (since you don't want to be running around and checking every user's machine to see if it breaks/works. If it works on your server (where the app is running), you're all set! If not, you can contact the data source vendor (in this case Microsoft) to obtain the necessary provider. Microsoft's various OS's do come from the factory with many providers baked right it, but JET (which is uesed in older MS products) is no longer a standard part of the MDAC (Microsoft Data Access Controls) download. However, it can be found as a standalone download from various sources.
-Scott
"gerryR" <gerryr@xxxxxxxxx> wrote in message news:O6q8$XVNKHA.1232@xxxxxxxxxxxxxxxxxxxxxxxHi,
We're using older .xls files, will the method mentioned there support that?
Also, is a Data Source required to be setup on the client if using an ODBC connection? Even if I don't go down that route I'd like to know, I'm curious as to what the Data Source tool is used for.
Thanks
gR
"Mark Rae [MVP]" <mark@xxxxxxxxxxxxxxxxx> wrote in message news:eGn1EVVNKHA.1280@xxxxxxxxxxxxxxxxxxxxxxx"gerryR" <gerryr@xxxxxxxxx> wrote in message news:u4cz3JVNKHA.4964@xxxxxxxxxxxxxxxxxxxxxxx
I'm setting up a connection string to an Excel file which will be stored in the same location as the asp.net page (wwwroot)
Do I need to setup something on the system's Data Source Tool (Administrative Tools-->Data Sources (ODBC)) to correspond with that connection string?
Forget ODBC...
Thanks for any help, fairly new to all this!
http://www.connectionstrings.com/excel-2007
--
Mark Rae
ASP.NET MVP
http://www.markrae.net
- References:
- Does connection string need anything on system?
- From: gerryR
- Re: Does connection string need anything on system?
- From: Mark Rae [MVP]
- Re: Does connection string need anything on system?
- From: gerryR
- Re: Does connection string need anything on system?
- From: Scott M.
- Does connection string need anything on system?
- Prev by Date: Re: Javascript causing CSS margin bug in IE
- Next by Date: Re: Does connection string need anything on system?
- Previous by thread: Re: Does connection string need anything on system?
- Next by thread: Re: Does connection string need anything on system?
- Index(es):
Relevant Pages
|
