Difference between revisions of "DB Connection Strings"

From PeformIQ Wiki
Jump to navigation Jump to search
(Created page with '* http://www.codeproject.com/KB/database/connectionstrings.aspx#OLE%20DB%20Visual%20FoxPro =Examples= ==Visual FoxPro== If you are using a database container, the connection s...')
 
(No difference)

Latest revision as of 19:00, 30 January 2011

Examples

Visual FoxPro

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

strConnection = _T("Driver={Microsoft Visual Foxpro Driver};UID=;"
  "SourceType=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");

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.