Tag Archives: ODBC

Solution to the error of ODBC driver in windows installation of Postgres database

Solution to the error of ODBC driver in windows installation of Postgres database

Installing postgressql driver on Windows reports an error “the specified module cannot be found”

terms of settlement

Find another system of the same version, which can install the modified drive computer normally. Paste the contents of the two folders in the windows folder of drive C into the system that cannot be installed

copy the two folders in the above figure to the problem computer. Select duplicate files, ignore them, and do not select replacement, so as not to affect the use of the system

Java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver [How to Solve]

Java.lang.classnotfoundexception: sun.jdbc.odbc.jdbcodbcdriver error reporting solution

Error report description problem description cause analysis solution operation results

Error reporting description

java.lang.classnotfoundexception: sun.jdbc.odbc.jdbcodbcdriver reports an error

Problem description

when learning the contents of Java database, because the old version of teaching materials are used, and the Java version has been updated and some functions have been deleted, an error message prompted by java.lang.classnotfoundexception: sun.jdbc.odbc.jdbcodbcdriver appears when reading the database: 

try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        } catch (ClassNotFoundException e) {
            System.out.println(e);
        }

Error message: java.lang.classnotfoundexception: sun.jdbc.odbc.jdbcodbcdriver

Cause analysis

since JDK1.8, the JDBC ODBC bridge has been deleted, so the ODBC driver cannot be used </ font>

Solution

 

    1. Step 1: install the old version of JDK. I install the download link of version 1.7 here: just click the next step for the jdk1.7 installation step. Step 2: change the Java environment

 

    1. friends using eclipse can refer to this blog:

 

    1. java.lang.classnotfoundexception: sun.jdbc.odbc.jdbcodbcodbcdriver solution 2.1 I use the integrated development environment of idea, The method is as follows:

 

    1. in file – project structure

    1. in project settings, select the JDK version downloaded for you by project SDK (here is 1.7)

 

    1. and click apply to run

Operation results

run smoothly ^ ^

Ubuntu ODBC MySQL 8 OPTION NOT Work [How to Solve]

Error due to FreeSWITCH using ODBC requirements
If you are using mysql, make sure you are using MYODBC 3.51.18 or higher and enable FLAG_MULTI_STATEMENTS

# vim /etc/odbc.ini
[freeswitch]
Driver = MySQL
SERVER = localhost
PORT = 3306
DATABASE = myDatabase
OPTION = 67108864

Note: option = 67108864   Start SQL batch, freeswitch   ODBC mode must be on

ODBC does not configure SQL preprocessing, resulting in an error when executing multiple SQL statements at the same time

ubuntu20.04

Download and install ODBC driver from MySQL website

Note that the version option of 8x is invalid after setting,

Solution demotion

mysql-connector-odbc-5.3.14-linux-ubuntu19.10-x86-64bit.tar.gz

Verification supports preprocessing methods, which are not described here for ODBC configuration

isql -v freeswitch

delete from sip_ registrations where sub_ host is null and hostname=’VM-0-13-ubuntu’ and network_ ip like ‘%’ and network_ port like ‘%’ and sip_ u

Install MySQL ODBC connector prompt error 1918 perfect solution (non installation of VC + + library method)

Local environment:
operating system – windows7 32 bit
MYSQL version – MYSQL Ver 14.14 Distrib 5.7.25, for Win32 (AMD64)
Execution process:

    start – control panel – systems and security – management tools – data source (ODBC) wanted to add MYSQL, found that MYSQL could not be found. An error was reported during the installation of mysql-Connector-ODBc-8.0.15-Win32 (mysql 5.7 supported) on the official website.

Error contents:

Error installing ODBC driver MySQL ODBC5.3 ANSI
Driver,ODBC error 13:Unable to load MySQL ODBC5.3 ANSI Driver ODBC driver
Installation routine, because there is a system error code 126: ... \Myodbc5S.dll) cannot find the specified module.

Solutions:
Solution 1: general online solution: install Microsoft Visual C++ 2013 Redistributable Package above. Verification results: Installing mysql-Connector-ODBC still prompts for the same error message after the following three versions are installed on the machine.

Microsoft Visual C++ 2015 Redistributable Package
Microsoft Visual C++ 2013 Redistributable Package
Microsoft Visual C++ 2010 Redistributable Package

Solution 2: Replace the lower version of mysql-Connector-ODBC. Try installing mysql-connector-odbc-5.1.13-win32.msi verification solution :(the current environment has all three versions of vc++ installed) install the lower version (5.1.13) successfully! The ODBC data source manager was able to successfully create the user data source.