Technology

Big Pre-Launch iPhone 3G Roundup

2008-07-19T00:12:00.001-07:00

Well, tomorrow’s the big day for the iPhone 3G launch and Apple has unleashed a deluge of exciting new content onto the web in preparation for it. A few other folks have got some neat stuff out, too. Here are the things that have caught my eye and will keep you more than busy waiting for 8 a.m. to roll around on Friday:
The first iPhone 3G reviews are in and they’re all generally positive, though there are some quibbles and it’s apparently still not a perfect phone/internet device (a judgment I expect to share when I get my hands on one). New York Times
Wall Street Journal

USA Today
New York Times
Wall Street Journal
USA Today

The App Store has gone live, with over 500 apps, 90% of which cost $9.99 or less. You’ll need itunes 7.7 and iPhone 2.0 firmware on an iPhone, iPhone 3G, or iPod touch to take advantage of this.
Speaking of, both iTunes 7.7 and iPhone 2.0 can be had right now. ITunes 7.7 can be gotten through Apple’s standard Software Update program. iPhone firmaware 2.0 is available at Apple’s site as a direct download, not yet an iTunes download. As such, it’s really for experts only right now (the iTunes version should appear late tonight or early tomorrow), so I’m not linking to it. If you want it, it’s at Apple’s site.
Another neat program, to be had at the App Store, is Remote. This Apple-authored program makes your iPhone and iPod touch function like a remote control for Macs and the Apple TV over WiFi. It’s a free download that requires iTunes 7.7, Apple TV software 2.1, and iPhone firmware 2.0.

Different Ipods in Market....A brief Review

2008-07-18T23:59:00.000-07:00

iPod (scroll wheel)

iPod (scroll wheel) models have a scroll wheel that physically turns. The controls (Play, Menu, Next, Previous) appear in a circle around the wheel. iPod (scroll wheel) models are referred to as first generation iPod models.

How to tell which model you have

Several external features can help you identify your iPod.

iPod touch

iPod touch features a 3.5-inch (diagonal) widescreen multi-touch display and 8 GB, 16 GB, or 32 GB flash drive. You can browse the web with Safari and watch YouTube videos on the first-ever Wi-Fi iPod. You can also search, preview, and buy songs from the iTunes Wi-Fi Music Store on iPod touch.

iPod classic

The iPod classic is a hard drive-based iPod (80 GB or 160 GB) featuring a large, widescreen color display, a Click Wheel, and the capability of displaying photos and videos. Like other models, it uses USB for syncing. The iPod classic is available in silver and black, and has an anodized aluminum and polished stainless steel enclosure.

You can distinguish the iPod classic from the iPod (5th generation) by the last three digits of the serial number. The iPod classic serial number's last three digits will be one of the following: Y5N, YMU, YMV, and YMX.

iPod nano (3rd generation)

The iPod nano (3rd generation) is available in 4 GB or 8 GB capacity, and comes in 5 colors.

iPod nano (3rd generation) is distinguished from previous iPod nano models by:
Its wider screen
Hold switch location on the bottom
Its ability to play video

You can also distinguish the iPod nano (3rd generation) by the last three digits of the serial number. The iPod nano (3rd generation) serial number's last three digits will be one of the following: YOP, YOR, YXR, YXT, YXV, YXX.

iPod (5th generation late 2006) (also known as iPod with video or Fifth Generation iPod)

You can distinguish the iPod (5th generation late 2006) from the original iPod (5th generation) by the last three digits of the serial number. The iPod (5th generation late 2006) serial number's last three digits will be one of the following: V9K, V9P, V9M, V9R, V9L, V9N, V9Q, V9S, WU9, WUA, WUB, WUC, and X3N. The Fifth Generation U2 Special Edition iPod (30 GB Late 2006) serial number's last three digits are W9G.

iPod (5th generation) (also known as iPod with video or Fifth Generation iPod)

The iPod (5th generation) is a a hard drive-based iPod featuring a large, widescreen color display, a Click Wheel, and the capability of displaying photos and videos. Like iPod nano, it uses USB for syncing and comes in white and black.

iPod nano (Second Generation)

iPod nano (Second Generation) is distinguished from other models by:
Its smaller size.
Its colors.
The dock connector and headphones port are both located on the bottom of the unit.

The iPod nano (PRODUCT) RED Special Edition is an iPod nano (Second Generation) available in red and with a 4 GB or 8 GB drive capacity. With each iPod nano (PRODUCT) RED purchased, $10 from the sale goes directly to the Global Fund to fight AIDS in Africa.

iPod nano

iPod nano is smaller than iPod mini and has a color screen and a Click Wheel but has flash memory instead of a hard drive. Song and photo syncing only occurs over USB 2 (not FireWire). iPod nano comes in white and black. The capacity of the iPod nano is engraved on the back of the case (1 GB, 2 GB, or 4 GB).

iPod shuffle (2nd generation)
iPod shuffle (2nd generation) is smaller than the original iPod shuffle and has no USB connector.

You can distinguish the iPod shuffle (2nd generation Early 2008) 2 GB from previous models by the last three characters of the serial number. The iPod shuffle (2nd generation Early 2008) 2 GB serial number’s last three characters will be one of the following: 1ZH, 1ZK, 1ZM, 1ZP, 1ZR.

iPod shuffle
iPod shuffle is smaller than iPod mini and has no display. There are LED lights on the front and back. The capacity of the drive is engraved on the front USB connector.

iPod mini is distinguished from other models by:

Its smaller size.
Its colors.
The Hold switch, which is on the top-left side.

iPod with color display
iPod and iPod photo are now one and the same, with every white iPod boasting a full-color display. They continue to have the same controls as iPod (Click Wheel) but now all models have a color display like iPod photo - ideal for viewing album artwork and playing slideshows. These are considered fourth generation models along with iPod (Click Wheel).

iPod (Click Wheel)
iPod (Click Wheel) models have a Click Wheel like the iPod mini, but are larger and the hold switch is on the top-right side. iPod (Click Wheel) models have a monochrome display. iPod (Click Wheel) is referred to as the fourth generation iPod.

iPod Special Edition U2
The iPod Special Edition U2 is a standard iPod model with certain external differences including: Black plastic exterior, red Click Wheel, signatures of the U2 band members engraved on the back, and "iPod Special Edition U2" engraved on the back. The first model was based an iPod (Click Wheel) with a 20 GB hard drive. In June 2005 a new version of the iPod Special Edition U2 was introduced that was based on an iPod with color display Generation iPod . These are both also considered fourth generation iPod models. In June 2006, a new version of the iPod Special Edition U2 was introduced that is based on a Fifth Generation iPod (also known as iPod with video) with a 30 GB hard drive. In Sept 2006 a model based on the Fifth Generation iPod (30 GB Late 2006) was introduced. You can distinguish Fifth Generation U2 Special Edition iPod (Late 2006) from the Fifth Generation U2 Special Edition iPod by the last three digits of the serial number. The Fifth Generation U2 Special Edition iPod (30 GB Late 2006) serial number's last three digits are W9G.

The first model was based an iPod with color display with a 20 GB hard drive. In October 2005 a new version of the iPod Special Edition Harry Potter was introduced that was based on an Fifth Generation iPod with a 30 GB hard drive.

iPod photo (also known as iPod with color display)
iPod photo models are functionally and visually identical to the iPod with color display (see above photo).

iPod (dock connector)

iPod (dock connector) models have a dock connector as illustrated here.

Newer iPod models like iPod (Click Wheel) and iPod mini also have a dock connector, but the iPod (dock connector) has a touch wheel instead of a Click Wheel and the four control buttons are above the touch wheel. iPod (dock connector models are referred to as third generation iPod models.

iPod (touch wheel)

All iPod (touch wheel) models have a FireWire port cover. Scroll wheel models don't, and dock connector models don't have a FireWire port. The iPod (touch wheel) model controls look similar to the iPod (scroll wheel) but the touch wheel itself does not turn. iPod (touch wheel) models are considered second generation iPod models. The top of an iPod (touch wheel) model is shown here:

iPod (scroll wheel)

iPod (scroll wheel) models have a scroll wheel that physically turns. The controls (Play, Menu, Next, Previous) appear in a circle around the wheel. iPod (scroll wheel) models are referred to as first generation iPod models.

1. FireWire port cover
2. FireWire port
3. Headphones port
4. Hold switch

iPod Special Edition Harry Potter
The iPod Special Edition Harry Potter is a standard iPod model with the Hogwarts Crest engraved on the back:

iPod (Click Wheel)

iPod (Click Wheel) models have a Click Wheel like the iPod mini, but are larger and the hold switch is on the top-right side. iPod (Click Wheel) models have a monochrome display. iPod (Click Wheel) is referred to as the fourth generation iPod.

iPod (scroll wheel)

iPod (scroll wheel) models have a scroll wheel that physically turns. The controls (Play, Menu, Next, Previous) appear in a circle around the wheel. iPod (scroll wheel) models are referred to as first generation iPod models.

Microsoft Virtual Tech Days 2008

2008-04-24T02:11:00.000-07:00

Hi all,
I participated in Microsoft Virtual Tech days Contest which was organized on April 9 and 10 2008.
I am uploading the participation certificate of the Contest.

I also won a prize in the contest " MS PressBook".
That prize certificate will be given soon so i will upload that also.

I have received the prize from Microsoft.

For more details about the tech days and the contest please visit http://www.microsoft.com/india/virtualtechdays/

Thanks,
Vinod Gupta

Great Indian Developer Awards 2008

2008-04-22T23:58:00.000-07:00

Hi all,
I voted in the Great India Developer Awards 2008.

I will update you with the status of the Awards Contest.
For details please visit http://www.developersummit.com/

Thanks,
Vinod Gupta

Andrus Development: Upgrading from .Net Framework 1.0 to 3.5

2008-04-17T06:40:00.000-07:00

Andrus Development: Upgrading from .Net Framework 1.0 to 3.5: "# First upgrade your code from .NET 1.0 to .NET 1.1 using Visual Studio 2003. It has a project upgrade tool with some assistance."

गूगल आरती- Google Pooja

2008-01-14T05:27:00.000-08:00

गूगल आरती

ॐ जय गूगल हरे, स्वामी जय गूगल हरे
फ़्रस्ट (frustrated]) जनों के संकट, त्रस्त जनों के संकट
क्लिक में दूर करे
ॐ जय गूगल हरे…

जो ध्यावै सो पावै
दूर होवै शंका, स्वामी दूर होवै शंका
सब इन्फ़ो (information]) घर आवै, सब इन्फ़ो घर आवै
कष्ट मिटै मन का
ॐ जय गूगल हरे…

नेट पिता तुम मेरे
शरण गहूं किसकी, स्वामी शरण गहूं किसकी
तुम बिन और न दूजा, तेरे बिन और न दूजा
होप करूं किसकी
ॐ जय गूगल हरे…

तुम पूरन हो खोजक
तुम वेबसाइटयामी, स्वामी तुम वेबसाइटयामी
पार नेट परमेश्वर, पार नेट परमेश्वर
तुम सबके स्वामी
ॐ जय गूगल हरे…

तुम आई.टी. के फ़ादर
तुम ही इक सर्चा, स्वामी तुम ही इक सर्चा
मैं मूरख हूं सर्चर, मैं मूरख हूं सर्चर
कृपा करो भरता
ॐ जय गूगल हरे…

तुम सर्वर के सर्वर
सबके डाटापति, स्वामी सबके डाटापति
किस विधि एन्टर मारूं, किस विधि एन्टर मारूं
तुममें मैं कुमति
ॐ जय गूगल हरे…

दीनबंधु दु:खहर्ता
खोजक तुम मेरे, स्वामी शोधक तुम मेरे
अपने फ़ण्डे दिखाओ, एल्गोऽरिथम लगाओ
साइट खड़ा तेरे
ॐ जय गूगल हरे…

इग्नोरेंस मिटाओ
टेंशन हरो देवा, स्वामी टेंशन हरो देवा
गूगल अकाउण्ट बनाओ
और खाओ मेवा
ॐ जय गूगल हरे…

ॐ जय गूगल हरे, स्वामी जय गूगल हरे
फ़्रस्ट जनों के संकट, त्रस्त जनों के संकट
क्लिक में दूर करे
ॐ जय गूगल हरे…

ॐ जय गूगल हरे, स्वामी जय गूगल हरे…

Connection String

2007-11-28T03:09:00.000-08:00

DataBase	Connection String
Access	Access ODBC Connection String Driver {Microsoft Access Driver (*.mdb)};Dbq=C:\demo.mdb;Uid=Admin;Pwd=; Access OLEDB Connection String Driver Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\directory\demo.mdb;User Id=admin;Password=;
DB2	DB2 ODBC Connection String driver={IBM DB2 ODBC DRIVER};Database=demodb;hostname=myservername;port=myPortNum;protocol=TCPIP; uid=myusername; pwd=mypasswd DB2 OLEDB Connection String Provider=IBMDADB2;Database=demodeb;HOSTNAME=myservername;PROTOCOL=TCPIP;PORT=50000;uid=myusername;pwd=mypasswd;
DBase	DBase ODBC Connection String Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\directory; DBase OLEDB Connection String Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\directory;Extended Properties=dBASE IV;User ID=Admin;Password=
Excel	Excel ODBC Connection String Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\MyExcel.xls;DefaultDir=c:\directory; Excel OLEDB Connection String Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties='"Excel 8.0;HDR=Yes;IMEX=1"'
Exchange	Exchange OLEDB Connection String oConn.Provider = "EXOLEDB.DataSource" oConn.Open = "http://myServerName/myVirtualRootName"
Firebird	Firebird ODBC Connection String DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=mypasswd;DBNAME=c:\directory\demo.fdb Firebird OLEDB Connection String User=SYSDBA;Password=mypasswd;Database=demo.fdb;DataSource=localhost;Port=3050;Dialect=3;Charset=NONE;Role=;Connection lifetime=15;Pooling=true;MinPoolSize=0;MaxPoolSize=50;Packet Size=8192;ServerType=0
FoxPro	FoxPro ODBC Connection String Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=c:\demo.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO FoxPro OLEDB Connection String Provider=vfpoledb.1;Data Source=c:\directory\demo.dbc;Collating Sequence=machine
Informix	Informix ODBC Connection String Driver={Informix-CLI 2.5 (32 Bit)};Server=demoservername;Database=demodb;Uid=myusername;Pwd=mypasswd Informix OLEDB Connection String Provider=Ifxoledbc.2;User ID=myusername;password=mypasswd;Data Source=demodb@demoservername;Persist Security Info=true
MySQL	MySQL ODBC Connection String DRIVER={MySQL ODBC 3.51 Driver};SERVER=myservername;PORT=3306;DATABASE=mydemodb; USER=myusername;PASSWORD=mypasswd;OPTION=3; MySQL OLEDB Connection String Provider=MySQLProv;Data Source=mydemodb;User Id=myusername;Password=mypasswd;
Oracle	Oracle ODBC Connection String Driver={Microsoft ODBC for Oracle};Server=myservername;Uid=myusername;Pwd=mypassword; Oracle OLEDB Connection String Provider=msdaora;Data Source=mydemodb;User Id=myusername;Password=mypasswd; Oracle .Net Connection String Data Source=mydemodb;User Id=myusername;Password=mypasswd;Integrated Security=no;
SQL Server	SQL Server ODBC Connection String - Database Login Driver={SQL Server};Server=myservername;Database=mydemodb;Uid=myusername;Pwd=mypasswd; SQL Server ODBC Connection String - Trusted Connection Driver={SQL Server};Server=mysername;Database=mydemodb;Trusted_Connection=yes; SQL Server OLEDB Connection String - Database Login Provider=sqloledb;Data Source=myservername;Initial Catalog=mydemodb;User Id=myusername;Password=mypasswd; SQL Server OLEDB Connection String - Trusted Connection Provider=sqloledb;Data Source=myservername;Initial Catalog=mydemodb;Integrated Security=SSPI; SQL Server .Net Connection String - Database Login Server=myservername;Database=mydemodb;User ID=myusername;Password=mypasswd;Trusted_Connection=False SQL Server .Net Connection String - Trusted Connection Server=myservername;Database=mydemodb;Integrated Security=SSPI;
Sybase	Sybase ODBC Connection String Driver={SYBASE ASE ODBC Driver};Srvr=myservername;Uid=myusername;Pwd=mypasswd Sybase OLEDB Connection String Provider=Sybase.ASEOLEDBProvider;Server Name=myservername,5000;Initial Catalog=mydemodb;User Id=myusername;Password=mypassword

DB Connection String: ADO

2007-11-27T23:19:00.000-08:00

Overview
DSN-Less Connection
DSN Connection
- ODBC DSN
OLE DB Provider
OLE DB Data Link Connections
- Data Link File - UDL

Overview

Generally, one of the first steps when you are trying to work with databases is open it. You can find several types of those, and each have a different mode of connection. When you try to connect with your database sometimes, you don't know the correct connection string that you must use. It is for that I wrote this article. I wanted to compile the connection strings to the majority of known databases...

ODBC DSN Less Connection

ODBC Driver for dBASE

strConnection = _T("Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;"
              "Dbq=c:\\DatabasePath;");

Note: You must specify the filename in the SQL statement... For example:

CString strQuery = _T("Select Name, Address From Clients.dbf");

ODBC Driver for Excel

strConnection = _T("Driver={Microsoft Excel Driver (*.xls)};DriverId=790;"
bq=C:\\DatabasePath\\DBSpreadSheet.xls;DefaultDir=c:\\databasepath;");

ODBC Driver for Text

strConnection = _T("Driver={Microsoft Text Driver (*.txt; *.csv)};"
   "Dbq=C:\\DatabasePath\\;Extensions=asc,csv,tab,txt;");

If you are using tab delimited files, you must create the schema.ini file, and you must inform the Format=TabDelimited option in your connection string.

Note: You must specify the filename in the SQL statement... For example:

CString strQuery = _T("Select Name, Address From Clients.csv");

Visual FoxPro

If you are using a database container, the connection string is the following:

strConnection = _T("Driver={Microsoft Visual Foxpro Driver};UID=;"
ourceType=DBC;SourceDB=C:\\DatabasePath\\MyDatabase.dbc;Exclusive=No");

If you are working without a database container, you must change the SourceType parameter by DBF as in the following connection string:

strConnection = _T("Driver={Microsoft Visual Foxpro Driver};UID=;"
"SourceType=DBF;SourceDB=C:\\DatabasePath\\MyDatabase.dbc;Exclusive=No");

ODBC Driver for Access

strConnection = _T("Driver={Microsoft Access Driver (*.mdb)};"
   "Dbq=c:\\DatabasePath\\dbaccess.mdb;Uid=;Pwd=;");

If you are using a Workgroup (System database): you need to inform the SystemDB Path, the User Name and its password. For that, you have two solutions: inform the user and password in the connection string or in the moment of the open operation. For example:

strConnection = _T("Driver={Microsoft Access Driver (*.mdb)};"
   "Dbq=C:\\VC Projects\\ADO\\Samples\\AdoTest\\dbTestSecurity.mdb;"
   "SystemDB=C:\\Program Files\\Microsoft Office\\Office\\SYSTEM.mdw;"
   "Uid=Vinod Gupta;Pwd=vinod123");

or may be:

strConnection = _T("Driver={Microsoft Access Driver (*.mdb)};"
   "Dbq=C:\\VC Projects\\ADO\\Samples\\AdoTest\\dbTestSecurity.mdb;"
   "SystemDB=C:\\Program Files\\Microsoft Office\\Office\\SYSTEM.mdw;");
if(pDB.Open(strConnection, "DatabaseUser", "DatabasePass"))
{
DoSomething();
pDB.Close();
}

If you want to open in Exclusive mode:

strConnection = _T("Driver={Microsoft Access Driver (*.mdb)};"
   "Dbq=c:\\DatabasePath\dbaccess.mdb;Exclusive=1;");

ODBC Driver for SQL Server

For Standard security:

strConnection = _T("Driver={SQL Server};Server=MyServerName;"
   "Trusted_Connection=no;"
   "Database=MyDatabaseName;Uid=MyUserName;Pwd=MyPassword;");

For Trusted Connection security (Microsoft Windows NT integrated security):

strConnection = _T("Driver={SQL Server};Server=MyServerName;"
"Database=myDatabaseName;Uid=;Pwd=;");

Also, you can use the parameter Trusted_Connection that indicates that you are using the Microsoft Windows NT Authentication Mode to authorize user access to the SQL Server database. For example:

strConnection = _T("Driver={SQL Server};Server=MyServerName;"
"Database=MyDatabaseName;Trusted_Connection=yes;");

If the SQL Server is running in the same computer, you can replace the name of the server by the word (local) like in the following sample:

strConnection = _T("Driver={SQL Server};Server=(local);"
   "Database=MyDatabaseName;Uid=MyUserName;Pwd=MyPassword;");

If you want to connect with a remote SQL Server, you must inform the address, the port, and the Network Library to use:

The Address parameter must be an IP address and must include the port. The Network parameter can be one of the following:

dbnmpntw Win32 Named Pipes
dbmssocn Win32 Winsock TCP/IP
dbmsspxn Win32 SPX/IPX
dbmsvinn Win32 Banyan Vines
dbmsrpcn Win32 Multi-Protocol (Windows RPC)

For more information, see Q238949.

strConnection = _T("Driver={SQL Server};Server=130.120.110.001;"
"Address=130.120.110.001,1052;Network=dbmssocn;Database=MyDatabaseName;"
"Uid=myUsername;Pwd=myPassword;");

ODBC Driver for Oracle

For the current Oracle ODBC driver from Microsoft:

strConnect = _T("Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;"
   "Uid=MyUsername;Pwd=MyPassword;");

For the older Oracle ODBC driver from Microsoft:

strConnect = _T("Driver={Microsoft ODBC Driver for Oracle};"
"ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPassword;");

ODBC Driver for MySQL

If you want to connect to a local database, you can use a connection string like the following:

strConnect = _T("Driver={MySQL ODBC 3.51 Driver};Server=localhost;"
"Database=MyDatabase;User=MyUserName;Password=MyPassword;Option=4;");

If you want to connect with a remote database, you need to specify the name of the server or its IP in the Server parameter. If the Port is distinct to 3306 (default port), you must specify it.

strConnect = _T("Driver={mySQL ODBC 3.51 Driver};Server=MyRemoteHost;"
"Port=3306;Option=4;Database=MyDatabase;Uid=MyUsername;Pwd=MyPassword;");

The parameter Option can be one or more of the following values:

1 - The client can't handle that MyODBC returns the real width of a column.
2 - The client can't handle that MySQL returns the true value of affected rows. If this flag is set then MySQL returns 'found rows' instead. One must have MySQL 3.21.14 or newer to get this to work.
4 - Make a debug log in c:\myodbc.log. This is the same as putting MYSQL_DEBUG=d:t:O,c::\myodbc.log in AUTOEXEC.BAT.
8 - Don't set any packet limit for results and parameters.
16 - Don't prompt for questions even if driver would like to prompt.
32 - Enable or disable the dynamic cursor support. This is not allowed in MyODBC 2.50.
64 - Ignore use of database name in 'database.table.column'.
128 - Force use of ODBC manager cursors (experimental).
256 - Disable the use of extended fetch (experimental).
512 - Pad CHAR fields to full column length.
1024 - SQLDescribeCol() will return fully qualified column names.
2048 - Use the compressed server/client protocol.
4096 - Tell server to ignore space after function name and before '(' (needed by PowerBuilder). This will make all function names keywords!
8192 - Connect with named pipes to a MySQLd server running on NT.
16384 - Change LONGLONG columns to INT columns (some applications can't handle LONGLONG).
32768 - Return 'user' as Table_qualifier and Table_owner from SQLTables (experimental).
65536 - Read parameters from the client and ODBC groups from my.cnf.
131072 - Add some extra safety checks (should not be needed but...).

If you want to have multiple options, you should add the above flags! For example: 16 + 1024 = 1030 and use Option= 1030;.

For more information, go to MyODBC Reference Manual.

ODBC Driver for AS400

strConnect = _T("Driver={Client Access ODBC Driver (32-bit)};System=myAS400;"
 "Uid=myUsername;Pwd=myPassword;");

ODBC Driver for SyBase

strConnect = _T("Driver={Sybase System 10};Srvr=MyServerName;Uid=MyUsername;"
  "Pwd=myPassword;");

ODBC Driver for Sybase SQL AnyWhere

strConnect = _T("ODBC;Driver=Sybase SQL Anywhere 5.0;"
"DefaultDir=C:\\DatabasePath\;Dbf=C:\\SqlAnyWhere50\\MyDatabase.db;"
"Uid=MyUsername;Pwd=MyPassword;Dsn=\"\";");

DSN Connection

ODBC DSN

strConnect = _T("DSN=MyDSN;Uid=MyUsername;Pwd=MyPassword;");

OLE DB Provider

OLE DB Provider for SQL Server

For Standard security:

strConnect = _T("Provider=sqloledb;Data Source=MyServerName;"
   "Initial Catalog=MyDatabaseName;"
   "User Id=MyUsername;Password=MyPassword;");

For Trusted Connection security (Microsoft Windows NT integrated security):

strConnect = _T("Provider=sqloledb;Data Source=MyServerName;"
   "Initial Catalog=MyDatabaseName;"
   "Integrated Security=SSPI;");

If you want to connect to a "Named Instance" (SQL Server 2000), you must to specify Data Source=Servere Name\Instance Name like in the following example:

strConnect = _T("Provider=sqloledb;Data Source=MyServerName\MyInstanceName;"
"Initial Catalog=MyDatabaseName;User Id=MyUsername;Password=MyPassword;");

If you want to connect with a SQL Server running on the same computer, you must specify the keyword (local) in the Data Source like in the following example:

strConnect = _T("Provider=sqloledb;Data Source=(local);"
   "Initial Catalog=myDatabaseName;"
   "User ID=myUsername;Password=myPassword;");

To connect to SQL Server running on a remote computer (via an IP address):

strConnect = _T("Provider=sqloledb;Network Library=DBMSSOCN;"
   "Data Source=130.120.110.001,1433;"
   "Initial Catalog=MyDatabaseName;User ID=MyUsername;"
   "Password=MyPassword;");

OLE DB Provider for MySQL (By Todd Smith)

strConnection = _T("Provider=MySQLProv;Data Source=test");

Where test is the name of MySQL database. Also, you can replace the name of the database by the following connection string: server=localhost;DB=test.

OLE DB Provider for AS400

strConnect = _T("Provider=IBMDA400;Data source=myAS400;User Id=myUsername;"
"Password=myPassword;");

For more information, see: Using the OLE DB Provider for AS/400 and VSAM.

OLE DB Provider for Active Directory

strConnect = _T("Provider=ADSDSOObject;User Id=myUsername;Password=myPassword;");

For more information, see: Microsoft OLE DB Provider for Microsoft Active Directory Service.

OLE DB Provider for DB2

If you are using a TCP/IP connection:

strConnect = _T("Provider=DB2OLEDB;Network Transport Library=TCPIP;"
   "Network Address=130.120.110.001;"
   "Initial Catalog=MyCatalog;Package Collection=MyPackageCollection;"
   "Default Schema=MySchema;User ID=MyUsername;Password=MyPassword;");

If you are using APPC connection:

strConnect = _T("Provider=DB2OLEDB;APPC Local LU Alias=MyLocalLUAlias;"
   "APPC Remote LU Alias=MyRemoteLUAlias;Initial Catalog=MyCatalog;"
   "Package Collection=MyPackageCollection;Default Schema=MySchema;"
   "User ID=MyUsername;Password=MyPassword;");

For more information, see: Using the OLE DB Provider for DB2.

OLE DB Provider for Microsoft Jet

Connecting to an Access file using the JET OLE DB Provider:

Using Standard security:

strConnect = _T("Provider=Microsoft.Jet.OLEDB.4.0;"
   "Data Source=C:\\DatabasePath\\MmDatabase.mdb;"
   "User Id=admin;Password=;");

If you are using a Workgroup (System database):

strConnect = _T("Provider=Microsoft.Jet.OLEDB.4.0;"
   "Data Source=C:\\DataBasePath\\mydb.mdb;"
   "Jet OLEDB:System Database=MySystem.mdw;");
pRs.Open(strConnect, "MyUsername", "MyPassword");

Connecting to an Excel Spreadsheet using the JET OLE DB Provider:
```
strConnect = _T("Provider=Microsoft.Jet.OLEDB.4.0;"
   "Data Source=C:\\DatabasePath\\DBSpreadSheet.xls;"
   "Extended Properties=\"\"Excel 8.0;HDR=Yes;\"\";");
```
Note: If "HDR=Yes", the provider will not include the first row of the selection into the recordset. If "HDR=No", the provider will include the first row of the cell range (or named ranged) into the recordset.

For more information, see: Q278973.

Connecting to a Text file using the JET OLE DB Provider:

strConnect =
   _T("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\DatabasePath\\;"
   "Extended Properties=\"\"text;"
   "HDR=Yes;FMT=Delimited;\"\";");

Note: You must specify the filename in the SQL statement... For example:

CString strQuery = _T("Select Name, Address From Clients.txt");

For more information, see: Q262537.

Connecting to an Outlook 2000 personal mail box using the JET OLE DB Provider: (By J. Cardinal)
```
strConnect = _T("Provider=Microsoft.Jet.OLEDB.4.0;Outlook 9.0;"
 "MAPILEVEL=;DATABASE=C:\\Temp\\;")
```
Replace c:\temp with any temporary folder. It will create a schema file in that folder when you open it which shows all the fields available. Blank MAPILEVEL indicates top level of folders).
Connecting to an Exchange mail box through JET: (By J. Cardinal)
```
strConnect = _T("Provider=Microsoft.Jet.OLEDB.4.0;Exchange 4.0;"
 "MAPILEVEL=Mailbox - Pat Smith|;DATABASE=C:\\Temp\\;")
```
You must replace c:\temp with any temporary folder.

Replace Pat Smith with the name of the mail box and you must keep vertical pipe character | to indicate top level of folders. Place sub folder after vertical pipe if accessing specific folder.

Note: you can enter queries against the mail store just like a database... For example:
```
CString strQuery = _T("SQL "SELECT Contacts.* FROM Contacts;");
```
For more information, see: The Jet 4.0 Exchange/Outlook IISAM.

OLE DB Provider for ODBC Databases

If you want to connect with a Microsoft Access database:

strConnect = _T("Provider=MSDASQL;Driver={Microsoft Access Driver (*.mdb)};"
   "Dbq=c:\\DatabasePath\\MyDatabase.mdb;Uid=MyUsername;Pwd=MyPassword;");

If you want to connect with a SQL Server database:

strConnect = _T("Provider=MSDASQL;Driver={SQL Server};Server=MyServerName;"
   "Database=MyDatabaseName;Uid=MyUsername;Pwd=MyPassword;");

If you want to use DSN:

strConnect = _T("Provider=MSDASQL;PersistSecurityInfo=False;"
   "Trusted_Connection=Yes;"
   "Data Source=MyDSN;catalog=MyDatabase;");

For more information, see: Microsoft OLE DB Provider for ODBC.

OLE DB Provider for OLAP

Microsoft® OLE DB for Online Analytical Processing (OLAP) is a set of objects and interfaces that extends the ability of OLE DB to provide access to multidimensional data stores.

strConnect = _T("Provider=MSOLAP;Data Source=MyOLAPServerName;"
"Initial Catalog=MyOLAPDatabaseName;");

Connection using HTTP:

This feature enables a client application to connect to an Analysis server through Microsoft® Internet Information Services (IIS) by specifying a URL in the Data Source property in the client application's connection string. This connection method allows PivotTable® Service to tunnel through firewalls or proxy servers to the Analysis server. A special Active Server Pages (ASP) page, Msolap.asp, enables the connection through IIS. The directory in which this file resides must be included as part of the URL when connecting to the server (for example, http://www.myserver.com/myolap/).

Using a URL

strConnect = _T("Provider=MSOLAP;Data Source=http://MyOLAPServerName/;"
"Initial Catalog=MyOLAPDatabaseName;");

Using SSL

strConnect = _T("Provider=MSOLAP;Data Source=https://MyOLAPServerName/;"
"Initial Catalog=MyOLAPDatabaseName;");

For more information, see: OLE DB for OLAP, Connecting Using HTTP.

OLE DB Provider for Oracle

OLE DB Provider for Oracle (from Microsoft)

The Microsoft OLE DB Provider for Oracle allows ADO to access Oracle databases.

strConnect = _T("Provider=MSDAORA;Data Source=MyOracleDB;User Id=myUsername;"
"Password=myPassword;");

For more information, see: Microsoft OLE DB Provider for Oracle.

OLE DB Provider for Oracle (from Oracle).

For Standard security:

strConnect = _T("Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;"
   "User Id=myUsername;Password=myPassword;");

For a Trusted connection:

OS Authenticated connect setting user ID to "/":

strConnect = _T("Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;"
"User Id=/;Password=;");

OS Authenticated connect using OSAuthent:
```
strConnect = _T("Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;")
```
Note: "Data Source=" must be set to the appropriate Net8 name which is known to the naming method in use. For example, for Local Naming, it is the alias in the tnsnames.ora file; for Oracle Names, it is the Net8 Service Name.

For more information, see: Oracle Provider for OLE DB Developer's Guide.

OLE DB Provider for Visual FoxPro

strConnect = _T("Provider=vfpoledb;"
"Data Source=C:\\DatabasePath\\MyDatabase.dbc;");

For more information, see: Microsoft OLE DB Provider for Visual FoxPro.

OLE DB Provider for Index Server (By Chris Maunder)

strConnect = _T("provider=msidxs;Data Source=MyCatalog;");

For more information, see: Microsoft OLE DB Provider for Microsoft Indexing Service.

OLE DB Data Link Connections

Data Link File - UDL

strConnection = _T("File Name=c:\\DataBasePath\\DatabaseName.udl;");

If you want to create a Data Link File, you can make a new empty text file, change its extension by .udl, then double click over the file, and the operating system calls for you the Data Link app.

About Vinod Gupta

Vinod Gupta is a software engineer working in DEShaw india Software Pvt Ltd..especially on .net Technologies in C# and ASP.net. He graduated from IIT Roorkee in 2007 in CSE .

For More Details:visit : http://vinodgupta85.googlepages.com

Technology

Big Pre-Launch iPhone 3G Roundup

Different Ipods in Market....A brief Review

Microsoft Virtual Tech Days 2008

Great Indian Developer Awards 2008

Andrus Development: Upgrading from .Net Framework 1.0 to 3.5

गूगल आरती- Google Pooja

Connection String

Access ODBC Connection String Driver

Access OLEDB Connection String Driver

DB2 ODBC Connection String

DB2 OLEDB Connection String

DBase ODBC Connection String

DBase OLEDB Connection String

Excel ODBC Connection String

Excel OLEDB Connection String

Exchange OLEDB Connection String

Firebird ODBC Connection String

Firebird OLEDB Connection String

FoxPro ODBC Connection String

FoxPro OLEDB Connection String

Informix ODBC Connection String

Informix OLEDB Connection String

MySQL ODBC Connection String

MySQL OLEDB Connection String

Oracle ODBC Connection String

Oracle OLEDB Connection String

Oracle .Net Connection String

SQL Server ODBC Connection String - Database Login

SQL Server ODBC Connection String - Trusted Connection

SQL Server OLEDB Connection String - Database Login

SQL Server OLEDB Connection String - Trusted Connection

SQL Server .Net Connection String - Database Login

SQL Server .Net Connection String - Trusted Connection

Sybase ODBC Connection String

Sybase OLEDB Connection String

DB Connection String: ADO

OLE DB Provider for MySQL (By Todd Smith)

Connection using HTTP:

Using a URL

Using SSL

OLE DB Provider for Oracle (from Microsoft)

OLE DB Provider for Oracle (from Oracle).