Email Password Remember me?  Lost your password?

• Overview
• DSN-Less Connection
  • dBASE
  • Excel
  • Text File
  • Visual FoxPro
  • Access database
  • SQL Server
  • Oracle
  • MySQL
  • AS400
  • Sybase
  • Sybase SQL AnyWhere
• DSN Connection
  • ODBC DSN
• OLE DB Provider
  • SQL Server
  • MySQL
  • AS400
  • Active Directory
  • DB2
  • Microsoft Jet
  • ODBC Databases
  • OLAP
  • Oracle
  • Visual FoxPro
  • Index Server
• 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=Carlos Antollini;Pwd=carlos");

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.

You must Sign In to use this message board.

Per page 102550

FirstPrevNext

FIELDS NAMES - AS/400 ODBC [modified] DomenicoGIACCHERO 1:20 23 Oct '09   I use an ODBC connection to an AS/400 with VisualFoxPro 8.0. I have problems when I have to use fields names starting (or containing) the § character. For the NAME of the TABLE I use 'ALIAS', but I don't know how to do with fields names. Somebody can help me? Thank you modified on Friday, October 23, 2009 6:31 AM Sign In·View Thread·PermaLink execute select query if data available sukeshtech 1:38 28 Sep '09   execute select query if data available if not than execute insert query(not enter data second times) Sign In·View Thread·PermaLink 2.00/5 ShowCase ODBC Driver for AS400 Syed Habeeb Ullah Quadri 2:34 31 Aug '09   I am a newbie for dot net as i was from PowerBuilder recently migrated. Working on DB2 VS2008 Please provide me connection lines for ShowCase ODBC driver Sign In·View Thread·PermaLink problem with oledb connection...URGENT Shashikant_2006 21:13 29 Jun '09   I'm connecting to Oracle 11g server using a vb code when "Provider=MSDAORA.1; it's successfully connected to database... but when "Provider=oraOLEDB.Oracle; It's giving me an error.. "Provider cannot be found. It may not be properly installed. error no. 3706".What can I do to resolve the error? Never complain,never explain,just do your work. Sign In·View Thread·PermaLink Re: problem with oledb connection...URGENT rht341 3:48 16 Oct '09   The MSDAORA provider for Oracle is installed with .NET; The Oracle provider (ODP.Net) has to be installed. Do a search for ODP.Net, should be able to find it. Rich Sign In·View Thread·PermaLink ODBC Connection String for Excel 2007 with Macros kjgamble 7:24 7 Nov '08   I can not seem to get the open to except a connection string for a ".xlsm" file. I am using VS 2008 C++ I have tried : m_sDsn.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=%s;External Properties=\"Excel 12.0 Macro;HDR=YES\"", m_sFile); I get : Invalid connection string attribute External Properties Invalid connection string attribute HDR I need to know how to set the external properties or just how to tell the driver I have a header row and macros. Any suggestions? Sign In·View Thread·PermaLink Connectionstring Thao Nam 17:53 21 Oct '08   My project is VC++ 6.0. How can I connect to SQLEXPRESS 2005 DB. althought i had tried all cennection tring in "OLE DB Provider for SQL Server" catalogue but it not work. please help me Sign In·View Thread·PermaLink 1.50/5 how can you use this to connect access database? yulin11 17:43 1 Oct '08   Hi, recently I need to write a code to connect access database. how can I use this to connect access database? codeuu,source code Sign In·View Thread·PermaLink 1.00/5 Need Help Urgently Pavlikas 3:55 23 Sep '08   Maybe enybody know how to join MS Access database and MS SQL 2005 database, that if I write or delete data in one database(for example in Access) it exactly will do in MS SQL and back end. What technology to use. Start from where? Thanks for your help Sign In·View Thread·PermaLink A simple method to get DB connection string paul10001 23:05 6 Sep '08   1. create a new text file where you like. 2. rename the name of you created to *.udl 3. double click the file. And then configure what database you want to connect. 4. when finished the configuration, open the file( udl ) with windows notepad. see result. Sign In·View Thread·PermaLink 3.50/5 Is there any way to consume Web Based SQL Server Jitku 4:48 4 Sep '08   Hi, I have a Window Application which is running perfectly. Now we want to make a WebBased SQL Server with Hosting Company(like godaddy) and The Window Application will Access/Modify/Delete on web. Is there any way to do so. Thanx & regards, jitendra Kumar Sign In·View Thread·PermaLink 1.00/5 How to create a MSSQL ( or MSSQL2005 Express) database using ADO ( Not ADO.NET )? Member 2427692 21:33 24 Aug '08   I will appreciate any answer. Sign In·View Thread·PermaLink 1.33/5 Connection String to an Embedded MS Access Database Member 2265148 21:04 13 Aug '08   Hi, I have a Windows database application that uses MS Access for the database. I decided to embed the database into the application and now can't connect to the mdf file. The connection string I used before I embedded it is: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + APath.Replace("bin\\Release", "") + "\\Database\\Bix.mdb;Jet OLEDB:Database Password=Password; (APath is Program.AppPath) Can anybody tell me how I should modify the connection string so that I can connect? I presume that it would be the "Data Source" portion. I've tried looking up the syntax but haven't found anything that works. Thanks in advance for the assistance. Sign In·View Thread·PermaLink Re: Connection String to an Embedded MS Access Database PosiRob 3:16 20 Aug '08   I had the same problems, so I found the knowledge base article how to build a connection string programmaticaly [^]. You can get the actual connection string used to connect by requesting ADOcon.ConnectionString in the immediate window. The connectionstring generated contained a lot of junk, but when edited the -only- difference with my own connectionstring was the order of the parameters. I use a security file and I found the order of the parameters must be: string ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Password=Secret;User ID=Ego;Data Source=c:\\datadirectory\\database.mdb;Jet OLEDB:System database=c:\\securitydirectory\\workgroup.mdw"; I hope this will put you back on track Rob Sign In·View Thread·PermaLink connection to access database using UDL Qobacha 12:42 19 Jul '08   hey good peolple, i developed an application using vb 2005 and access.the application was running fine when the database was on the local machine. Now the database will be accessed remotely. So here is the problem, I made a udl file for connecting to the database. This connection was made using ODBC and after that tested connection and it was successful. The problem is between the application and the UDL.May be its because i dont know the connection string to use for UDL. Here is how i tried it in my code: Imports System.Data.OleDb Imports System.Data.Odbc Module ModMain Public cndata As OleDbConnection Public Sub opendb() Dim Conn = "File Name = " & Application.StartupPath & "\Test.udl;" cndata = New OleDbConnection(Conn) cndata.Open() End Sub and i got the following error: The .Net Framework Data Provider for OLEDB (System.Data.OleDb) does not support the Microsoft OLE DB Provider for ODBC Drivers (MSDASQL). Use the .Net Framework Data Provider for ODBC (System.Data.Odbc) Sign In·View Thread·PermaLink 1.00/5 how to save,search,delete and edit a record into the database using visual foxpro arnel sagapsapan 17:25 12 Jul '08   plz help me.. please help me on how to search,save,delete and edit a record onto the database using visual foxpro because im a beginner in visual foxpro.Please give a sample code on it. Sign In·View Thread·PermaLink 1.00/5 how to connect vc++ with mysql x_men072000 7:31 18 May '08   hi all, plz help . can anyone help me with the code to connect MYSQL with vc++6/vc++ 2008. plz also help as how to inclde the dlls or libraries. plz mention the the whole process from using MYSQL to connecting mysql. i m a begginer in this. it will be a great help. thank you. Sign In·View Thread·PermaLink 2.14/5 Re: how to connect vc++ with mysql [modified] superblue 13hrs 52mins ago  I had the same problem, the solution is: ------ CString sql, strConnect = _T("Driver={MySQL ODBC 3.51 Driver};Server=localhost;" "Port=3306;Option=4;Database=mysql;Uid=root;Pwd=;"); CDatabase db1; if(db1.OpenEx(strConnect)) { //do something //i.e. CODBCRecordset* rec2; rec2 = new CODBCRecordset(&db1); sql = _T("SELECT USER,HOST,PASSWORD FROM USER"); if(rec2->Open(sql,CRecordset::forwardOnly)) { while(!rec2->IsEOF()) { MessageBox(rec2->Field("HOST").AsString()); rec2->MoveNext(); } rec2->Close(); } delete rec2; ... sql = _T("INSERT INTO USER(HOST,USER) VALUES('localhost','anyone')"); db1.ExecuteSQL(sql); //and subsequently make other operations .... db1.Close(); } ----- Remember, you need to install the myodbc connector, version 3.51, in this url is the version: http://dev.mysql.com/downloads/connector/odbc/3.51.html not use the 5.1 version, in my experience don't work well with queries and... Sorry for my english, i'm mexican and don´t talk english very well. The best way to make a query is using the CODBCRecordset class. Search for it. modified on Friday, November 20, 2009 7:58 PM Sign In·View Thread·PermaLink database connection with sqllite with vc++ x_men072000 20:28 15 May '08   plz help. how do i connect to sqllite expert with vc++2008. plz mention dsn less and through dsn. also mention a generic way of connecting other databases like berkely db or mysql. it would be a great help Sign In·View Thread·PermaLink 2.33/5 Connect DBF database AnhTin 4:20 9 Dec '07   i have problem when connect DBF database file when i connect database with oledb in .net 2.0(asp.net) i see if name file DBF smaller than 8 character is Okay if lager 8 character is exception The Microsoft Jet database engine could not find the object 'demodemodemo.dbf'. Make sure the object exists and that you spell its name and the path name correctly. How can i connect DBF database file so not depend with name file ???? Sign In·View Thread·PermaLink 1.50/5 Re: Connect DBF database Evan Stein 7:28 9 Dec '07   Hi. The problem is that the old drivers are expecting DOS names -- someone forgot to upgrade them. For names larger than 8 characters, you want something like DEMODE~1.DBF. The code below will do that for you: [DllImport("Kernel32", CharSet = CharSet.Auto)] static extern Int32 GetShortPathName( String path, // input string StringBuilder shortPath, // output string Int32 shortPathLength); // StringBuilder.Capacity public static string ConvertLongPathToShort(string longPathName) { StringBuilder shortNameBuffer; int size; shortNameBuffer = new StringBuilder(); size = GetShortPathName(longPathName, shortNameBuffer, shortNameBuffer.Capacity); if (size >= shortNameBuffer.Capacity) { shortNameBuffer.Capacity = size + 1; GetShortPathName(longPathName, shortNameBuffer, shortNameBuffer.Capacity); } return shortNameBuffer.ToString(); } Good luck! Sign In·View Thread·PermaLink 1.00/5 i can't connect to firebird db nasim 20:06 8 Dec '07   i install ibprovider v3 free version and copy "gds32.dll" in to system32 directory but when i run my program show this error: Message 1: [dbobj] Loading client library "gds32.dll". The specified module could not be found. plz help me end reply 2 me ASAP. best regards; Sign In·View Thread·PermaLink 2.67/5 http://www.connectionstrings.com/ Robin Debnath 8:44 17 Nov '07   Sign In·View Thread·PermaLink 3.00/5 Re: http://www.connectionstrings.com/ Jim in Arizona 15:48 16 Oct '09   My thoughts exactly. I've been using connectionstrings.com for a good seven years now. This article seems strangely similar but glad to see it posted. I'm always amazed at how many people are unaware of connectionstrings.com and rely on other articles like this to find what they're looking for. Sign In·View Thread·PermaLink Does System.Data.OracleClient support switch schema while connecting to Oracle? Kent Liu 17:31 14 Nov '07   Hi, I am using OS Authentication mode in Oracle, and after OracleConnection.Open method, I need to call OracleCommand.Execute ("alter session set current_schame=xxx") command to switch the schema to the application schema (not the logon user schema). Is there any way to specfied something in connection string or a callback after OracleConnection.Open executed to run the alter session command? Because System.Data.OracleClient.OracleConnection is sealed, so I can't make one new class to inherit it. Do you have any good ideas ? Thanks! Do or do not, there is no try. Sign In·View Thread·PermaLink

Last Visit: 2:18 21 Nov '09     Last Update: 2:18 21 Nov '09 12345678 Next »