-----------------------------------------------------------
New Message on cochindotnet
-----------------------------------------------------------
From: Jignesh Desai
Message 1 in Discussion
The ODBC.NET Data Provider is a native component to the .NET Framework version 1.1.
This component provides access to native ODBC drivers in the same way that the OLE DB
.NET Data Provider provides access to native OLE DB providers.The ODBC.NET Data
Provider is intended to work with all compliant ODBC drivers like eg.
Microsoft SQL ODBC Driver
Microsoft ODBC Driver for Oracle
Microsoft Jet ODBC Driver
Unlike the ODBC .NET data provider addon for .NET Framework 1.0, the namespace for
this version changed from Microsoft.Data.Odbc to System.Data.Odbc. The Connection
strings will be as follows for different data sources.
The connection string for a SQL Server database looks like following:
DRIVER={SQL Server};SERVER=TigerServer;UID=sa;PWD=;DATABASE=northwind;
The connection string for an Oracle database looks like following:
Driver={Microsoft ODBC for Oracle};Server=ORACLE8i;UID=User1;PWD=xxxx
The connection string for a Microsoft Access database looks like following:
Driver={Microsoft Access Driver (*.mdb)};DBQ=D:\Northwind.mdb
The connection string for an Excel database looks like following:
Driver={Microsoft Excel Driver (*.xls)};DBQ=C:\ExcelFile1.xls
The connection string for a text database looks like following:
Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=C:\TextFile1.txt
Regards,
Jignesh Desai
http://dotnetjini.jigneshdesai.com/blogs/
RSS: http://dotnetjini.jigneshdesai.com/rss/rssblogs.aspx
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/cochindotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
