Some time ago, I made a small tool for information synchronization, and used VC database programming. Writing this log should be a simple note. It can also be used as a reference for beginners.
This article describes how VC connects to the DB2 database through the ODBC/CLI driver and lists someCodeAnd has the following functions:
1. Establish a connection;
2. Execute SQL statements;
3. Search for the list of tables in the database and the stru
ODBC (Open Database Connectivity and Open Database interconnection) is an integral part of the Database in Microsoft's WOSA (Windows Open Services Architecture). It establishes a set of specifications, it also provides a set of standard APIs for database access (application programming interfaces ). These APIs use SQL to complete most of their tasks. ODBC also provides support for the SQL language. You can
Server: Redhat Linux Enterprise 4.0 + Progress restart SP9Client: Windows XP Professional SP2First download the Merant ODBC 3.7 For Progress connector, which is the ODBC driver of Progress, after the installation is complete, you can see the MERANT 3.70 32-bit PROGRESS driver in [Control Panel]-[Administrative Tools]-[ODBC Data Source.: Http://www.blue-eyeds.net/
1. ODBC database class provided by MFC
The MFC base class library of Visual C ++ defines several database classes. When using ODBC programming, cdatabase, crecordset, and crecordview are often used ).
A cdatabase object can be used to connect to a data source.
The crecordset Class Object provides a set of Records extracted from the data source. The crecordset object is usually used in two forms: dynamic row
An ODBC (Open Database Connectivity) is an integral part of the database in Microsoft's Open service architecture (Wosa,windows Open Services Architecture), which establishes a set of specifications , and provides a set of standard APIs (application programming interfaces) for accessing the database. These APIs use SQL to accomplish most of their tasks. ODBC itself also provides support for SQL languages, a
An error occurred while the program was using ODBC to connect to the database:ERROR [IM002] [MICROSOFT][ODBC driver Manager] did not discover the data source name and did not specify a default driver.What causes it?I use the "Delphi+sql server database application instance full resolution" with the routine test, found unable to connect to the database.Prompts the communication module to drive the problem.En
Before specific applications, let's take a look at the working principles of ODBC database access technology:
To access a database, an application must first register a data source using the ODBC Manager. The manager registers a data source based on the database location, database type, ODBC driver, and other information provided by the data source, establish a c
How does PHP use ODBC to access the database environment?
Create a test database first
Create an ODBC Connection
Create another PHP Script for testing
Let's test it.
Environment used
This document describes how to run Windows 9x/NT/2000 in a Win32 environment. you need a computer that runs Windows 9x/NT/and has any web server, PHP3, or PHP4, the PHP Script can be correctly executed. there is more than one
1,JDBC-ODBC driver to access sqlserver2008 Database
Principle of JDBC-ODBC Access Database
JSPProgram--> JBDC-ODBC driver --> ODBC driver ---> database so be sure to install ODBC driver on the Java Server when using JDBC-ODBC
The environment used
Set up a test database first
Then create an ODBC link
and build a test PHP Script.
Let's test it out.
The environment used
This document is mainly described in WIN32 environment, you need to run Windows 9x/nt/2000 Computer, and installed any kind of Web server and PHP3 or PHP4, and correctly execute PHP Script. And there is more than one SQL database software, such as : Access ...
This document is described in the Ms-access data
Oracle connects to the odbc data source, oracleodbc
Connect Oracle to odbc Data Source
Description
There are two ways to connect oracle to the ODBC Data source: hsodbc and dg4odbc. In short, dg4odbc is an upgrade of hsodbc. The two connection methods are roughly the same. The connection steps are described as follows:
Check whether the DG4ODBC driver is installed
It is noteworthy that OLE DB compatibility with ODBC allows OLE DB to access existing ODBC data sources. The advantages are obvious because ODBC is more commonly used relative to OLE DB, so you can get more ODBC drivers than OLE DB. This does not necessarily mean that the driver for the OLE DB can be accessed without i
As an ASP enthusiasts, the author often use ADO object to manipulate the ODBC database in ASP pages, I think it is very convenient to use ASP to create Web application system. Although in the programming career, the author prefers Borland series products, to Microsoft product a bit repel, to ASP is an exception. One day, brainwave, ADO object is a standard OLE object, if in Delphi application can use ADO operation database, should be quite good. Espec
Label:Category: 4. Software Design/Architecture/testing 2010-01-08 17:48 5635 people read reviews (3) favorite reports Loadrunnermysql script Database SQL Server TestRecently did a few weeks of loadrunner test, have some experience, recorded, in order to find later. The LoadRunner test database is a simulated client to connect to the database server, and therefore requires protocol (or driver support). The LoadRunner itself directly supports Oracle, SQL Server databases, which can record scr
Label:DataAdapterSqlDataAdapter internal data acquisition via SqlDataReader SqlDataAdapter da = new SqlDataAdapter ();DataSet dataset=new DataSet ();DataSet. Tables.add ("Z");DataSet. Tables.add ("Z1");Fill Z TableDa. Fill (DataSet, "Z");Fill A2 TableDa. Fill (DataSet, "A2"); . NET Framework. Net Data Provider namespacesSQL Server System.Data.SqlClientOle DB System.Data.OleDbODBC SYSTEM.DATA.ODBCOracle System.Data.OracleClient OleDbConnection can connect to SQL Server,access,oracle,my SQL (requ
64-bit Machine ODBC operation method and 32-bit machine is not the same, if directly from the Control Panel-Administrator tool-ODBC into the user DSN and the System DSN is empty, add when even ODBC driver can not be found, the correct method should be from after the C:\WINDOWS\SysWOW64 enters, locate the odbcad32.exe and open it to see the existing System DSN and
Environment usedCreate a test database firstCreate an ODBC connectionCreate another PHP Script for testingLet's test it.Environment usedThis document describes how to run Windows 9x/NT/2000 in a Win32 environment. You need a computer that runs Windows 9x/NT/and has any web server, PHP3, or PHP4, the PHP Script can be correctly executed. there is more than one type of SQL database software, such as Access...This document describes how to use the MS-Acc
Install ODBC in Linux
1. Modify the odbc. ini and odbcinst. ini files in the/etc directory.The odbc. ini file mainly configures database connections.Configure the database driver file in odbcinst. ini
Root @ wwww.bkjia.com:/etc # more odbc. ini[Fsnhhb]Description = For Nanhai, Foshan's smoke monitorDriver = PostgreSQL#
Unixodbc
UnixODBC-2.3.1.tar.gz
MySQL: MySQL 5.0 Reference Manual: Connector 1.4.5 locking ing a connector/odbc dsn on UNIX
Listen 1.4.5. Bridging ing a connector/odbc dsn on UNIX
OnUNIX, You configure DSN entries directly inODBC. iniFile. Here is a typicalODBC. iniFile that configuresMydbc3As the DSN name for connector/ODBC 3.51:
;
Use of the environment
Build a test Database first
Then create an ODBC link
and build a test PHP Script.
Let's test it out.
Use of the environment
This document is mainly in the context of the WIN32 environment, you need to run Windows 9x/nt/2000 computer, and equipped with any kind of Web server and PHP3 or PHP4, and the correct execution of PHP Script. And there is more than one SQL database software, such as : Access ...
This document is illustra
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.