Environmental description System environment System: Windows XP IDE: Microsoft Visual C++ 6.0 msado15.dll: File version: 6.2.19041.3570 Product version: 10.0.19041.3570 Data source driver: Oracle in OraClient11g_home1 – Oracle Datebase Client 11g Release 2 (11.2.0.1.0) for Microsoft Windows (32-Bit) Object used msado15.tlh _ConnectionPtr m_pConnection; HRESULT hr = m_pConnection.CreateInstance(“ADODB.Connection”); _RecordsetPtr m_pRecordset; m_pRecordset.CreateInstance(“ADODB.Recordset”); _CommandPtr m_pCommand; m_pCommand.CreateInstance(“ADODB.Command”); _ParameterPtr pInputParam; pInputParam.CreateInstance(__uuidof(Parameter)); […]
Tag: odbc
QT5.12.12 connects to GBase 8s database (CentOS) via ODBC
This example uses the following environment: Hardware platform: x86_64 (amd64) Operating system: CentOS 7.8 2003 Database version (including CSDK): GBase 8s V8.8 3.0.0_1 Why use QT 5.12.10? This version includes QODBC. 1, ODBC installation and configuration of GBase 8s database 1.1, confirm that the operating system has installed unixODBC and unixODBC-devel Check through apt to […]
Install Mysql InnodbCluster cluster under openeuler20.03
Planning: Use four servers, as shown in the following table: IP Mysql MysqlShell Keepalived MysqlRouter 192.168.210.172 main Install 192.168.210.173 Preparation Installation 192.168.210.171 Preparation Installation Main Installation 192.168.210.200 Preparation Installation Note: 171, 172, and 173 install Mysql and MysqlShell respectively. As database server nodes, MysqlShell can be simply understood as MysqlRouter to operate the Mysql database […]
Use pyodbc to parse bookmarks exported by the Chrome browser and save them to a Microsoft Access database
Example blog using wxPython and pyodbc to parse bookmarks and save to a Microsoft Access database: This blog post shows how to use wxPython and the pyodbc library to create a simple application that parses bookmarks from an HTML file and saves them to a Microsoft Access database. Through this example, you can learn how […]
Connect database SQLite, MySQL and ODBC in QT
Directory 1 Introduction 2. QT connects to SQLite 3. QT connects to MySQL 4. QT connects to ODBC 5. QT uses UDL to connect to MySQL 5.1UDL file 5.2QT read UDL 1. Preface Recently, I used QT to operate the database, so I learned some database knowledge, learned how to connect to the database in […]
Insert file information into Access database using Python and pyodbc library
Example of a blog post that inserts file information into an Access database: Introduction: In our daily programming work, we often need to deal with files and folders. Sometimes, we need to traverse all the files in the folder and save the file path, type, file name, modification date and creation date and other information […]
C# data access technology SqlClient/Odbc/OleDb/EF Core
System.Data.SqlClient, System.Data.Odbc and System.Data.OleDb are .NET Framework for data The namespace to access. These namespaces provide different data providers for connecting, manipulating and managing different types of databases. The System.Data.SqlClient namespace provides the classes and interfaces required to connect and operate with SQL Server databases. It is a .NET Framework data provider for SQL Server […]
ORACLE transparent gateway ODBC connection MYSQL
The customer needs oracle to access mysql data, the customer is a single instance of linux7.3 11.2.0.4, the character set is GBK, mysql is 5.7.31, the character set is UTF8, the configuration process is as follows in combination with online documents and own practice 1. Install oracle transparent gateway First install the oracle transparent gateway […]
Python uses odbc to connect to db2 and sqlserver databases
First introduce the installation of odbc driver, if it has been installed, skip the second link 1. Install odbc driver in Linux environment Reference link: linux environment odbc driver installation – Programmer Sought You can also refer to Microsoft’s official website (Windows drivers are also introduced): Install Microsoft ODBC Driver for SQL Server (Linux) – […]
ODBC monitoring method of zabbix
Sorry for any mistakes! This article is only my study notes and is for reference only. If there is any offense, please contact the author to delete it! ! 15.1 Overview ODBC monitoring corresponds to the Database Monitor item type in the Zabbix frontend. ODBC is a middleware API written in C language for accessing […]