In the process of learning Dameng database, install ODBC driver process record.
Operating system environment: Qilin 6.0 server

1. UNIX ODBC installation
tar – xzvf UNIX odbc-2.3.0 tar.gz
CD unixodbc-2.3.0
./configure — enable GUI = no
make
make install
all the way down OK, there are two configuration files for ODBC configuration ODBC.ini and odbcinst.ini By default, you can log in and edit in/usr/local/etc
root user, as shown in the figure:


3. Test the ODBC connection
Su – dmdba
execute ISQL Dm7
report an error, [ISQL] error: could not SQLConnect

in order to see the cause of the error, execute ISQL – V Dm7, prompt:

according to the cause of the error, guess that there is an error in the configuration file. After careful inspection, it is found that:

after the problem is solved, execute ISQL Dm7, the correct result comes out:

Read More:

• Solution to the error of ODBC driver in windows installation of Postgres database
• Dm7 Dameng database dmrman reports an error OS_ pipe2_ conn_ Server open failed solution
• Solve the database connection failure of Discuz! Database error (1045) notconnect Forum
• Talking about the errors encountered in installing MySQL ODBC (error 1918)
• Could not create connection to database server. Attempted reconnect 3 times. Giving
• Qt development, using ODBC interface, query mysql, appear qsqlquery:: Value: not positioned on a valid record
• When the source side of Dameng synchronization tool HS starts the service, it prompts that the so file does not exist: libdmoci.so
• In the XML configuration file of spring jdbc.properties The connection to the database failed due to garbled code
• Vscode remote connection server reports an error: could not establish connection to “XXXXXX” [resolved]
• node.js Server MySQL database connection timeout (error: connect etimeout)
• The connection pool of SSM project database cannot be connected. The project can run normally and the database cannot be connected
• ERROR 1045 (28000): Access denied for user’ODBC’@localhost (using password: NO)209150;’211503;’
• The problem of MySQL database connection failure errno: 1049 error
• MySQL startup problem (ERROR 1045 (28000): Access denied for user’ODBC’@’localhost’ (using password: NO))
• PHP connection to MySQL database error: call to undefined function MySQL_ connect()
• The Excel connection manager is not supported in the 64-bit version of SSIS [Switch]
• Connection error:Cannot connect to redis-server. Details are available in connection log.
• failed: Error in connection establishment: net::ERR_CONNECTION_REFUSED
• JDBC connect to Sql Server to connect to the database–The TCP/IP connection to the host localhost, port 1433 has failed
• Chrome your connection is not a private connection solution