odbc-driver | ODBC Driver to interactive with Kylin Engine | Database library

by KylinOLAP C++ Version: Current License: Apache-2.0

X-Ray Key Features Code Snippets Community Discussions(10)Vulnerabilities Install Support

kandi X-RAY | odbc-driver Summary

odbc-driver is a C++ library typically used in Database applications. odbc-driver has no bugs, it has no vulnerabilities, it has a Permissive License and it has low support. You can download it from GitHub.

ODBC Driver to interactive with Kylin Engine. Download driver exe at Folder and their contents are listed. This will give you can an idea of what to find where. More details are available in the CPP files of the respective projects. The projects have been built using Visual Studio 2012. The entry of the project is KylinODBC.sln. Mind the VS version. Make sure you have the following header files, import libraries and DLLs on your system 1. SQL.H 2. SQLTYPES.H 3. SQLEXT.H 4. ODBCINST.H 5. ODBC32.LIB & ODBC32.DLL 6. ODBCCP32.LIB & ODBCCP32.DLL. You can obtain these from Microsoft site as a part of Platform SDK or MDAC kit.

Support

Quality

Security

License

Reuse

Support

odbc-driver has a low active ecosystem.

It has 9 star(s) with 10 fork(s). There are 16 watchers for this library.

It had no major release in the last 6 months.

There are 0 open issues and 2 have been closed. On average issues are closed in 5 days. There are no pull requests.

It has a neutral sentiment in the developer community.

The latest version of odbc-driver is current.

Quality

odbc-driver has no bugs reported.

Security

odbc-driver has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

License

odbc-driver is licensed under the Apache-2.0 License. This license is Permissive.

Permissive licenses have the least restrictions, and you can use them in most projects.

Reuse

odbc-driver releases are not available. You will need to build from source code and install.

Installation instructions are not available. Examples and code snippets are available.

Top functions reviewed by kandi - BETA

kandi's functional review helps you automatically verify the functionalities of the libraries and avoid rework.
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of odbc-driver

Get all kandi verified functions for this library.

odbc-driver Key Features

No Key Features are available at this moment for odbc-driver.

odbc-driver Examples and Code Snippets

No Code Snippets are available at this moment for odbc-driver.

Community Discussions

Trending Discussions on odbc-driver

How to create ODBC "DSN" for cross-platform testing?

Laravel Sail/Docker - Unable to locate package msodbcsql17

Shiny Azure WebApp Authenticate as user to Azure SQL Server

How To Connect PHP7.3, sql server & Nginx Debian10

Getting error while migrating laravel 7 to 8

Getting error while connecting sybase laravel

RHEL 8 Container MSSQL ODBC Driver e2fsprogs

How to Read .mdb file using python 64 bit?

Unable to set up SQL Server backend using pyodbc for airflow on a Centos 7 server

UTF-8 SELECT IBM i DB2 throught unixODBC php PDO Debian 9 in CLI php

QUESTION

How to create ODBC "DSN" for cross-platform testing?

Asked 2021-Jun-06 at 02:22

I need a simple ODBC test scenario on WIN which I can configure very simply and be assured it is working in support of another question at Unix.SE.

In a nutshell I'm trying to setup a PyODBC/Python script connection from Debian 10 (192.168.1.2) to Windows 10 in KVM/QEMU virtual system (192.168.1.12).

First, on the Windows 10/KVM, I see the ODBC Data Source Administrator has a tab File DSN and Microsoft Text Driver. Can I use FileDSN to test Python PyODBC connection to ODBC using a simple CSV file in place of Server?? (My research with ODBC only finds running server instances).

Next, what I tried:

On Debian I installed ODBC Microsoft driver for Linux.
Shutdown the Windows 10 firewall, and I can ping in both directions:

$nmap -p 22 192.168.1.12 # Deb to Win

> Test-NetConnection 192.168.1.2 -p 22 # Win to Deb
On Windows 10/KVM I added a FileDSN with Microsoft Text Driver. I created a CSV file (odbc_test_01.csv) with simple header and one row of data (IE. {'ID' : 1, 'NAME' : 'FOO'})
Created a Jupyter Notebook to make testing easier. Here is my connection string and the results:
...

ANSWER

Answered 2021-May-02 at 13:25

An ODBC "File DSN" is not a driver for accessing data in a file. It is a way to specify a DSN (connection information for a target database) as values in a standalone file instead of in a standard configuration file on Linux (e.g., /etc/odbc.ini) or in the Windows registry.

If you need to "clone" a Windows DSN entry for use in a Linux environment then you may find my dump_dsn utility helpful. It retrieves an ODBC DSN from the Windows registry and presents it in a form that you could use to recreate the DSN on Linux.

For example, say I had a DSN named "mssql199" on Windows and when I ran dump_dsn.to_text("mssql199") on it I got

Source https://stackoverflow.com/questions/67351368

QUESTION

Laravel Sail/Docker - Unable to locate package msodbcsql17

Asked 2021-May-25 at 06:27

I'm trying to get a Laravel Sail Docker to be compatible with sqlsrv (MSSQL). I've come a long way with the config and got it to install sqlsrv and the pdo_sqlsrv. So now I need to install msodbcsql17. For that I'm following the microsoft guide (https://docs.microsoft.com/nl-nl/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15) for Ubuntu 20.04 (as that is my version).

That specific documentation says to download and run. Translating that to the Sail Dockerfile, that part of my Dockerfile looks like this:

...

ANSWER

Answered 2021-May-21 at 06:34

By default most docker images have an empty package lists to save on image size. This is why you need to apt-get update first. This will not update any software (that would be apt-get upgrade) but just updates the package list. The command is actually also in Microsoft's instructions you linked.

Source https://stackoverflow.com/questions/67618911

QUESTION

Shiny Azure WebApp Authenticate as user to Azure SQL Server

Asked 2021-May-17 at 16:06

I'm building a WebApp with a SQL DB as Backend. I'm Deploying the both parts on Azure, as Azure Webapp and SQL Server.

The SQL server is sercured with Azure AD (AAD). So only Users in a Group can access the DB.

So I'm trying to setup a workflow where the Webapp login the user and collect his Access token. And then uses the token to Query the SQL server.

I've registreted the App in AAD, where it is authorized to read the user ID and impersonate as the user.

I've the following code which is working local. But I can't get it to work deployed locally in a Docker Image.

...

ANSWER

Answered 2021-May-17 at 16:06

Connecting to SQL Server with an OAuth token requires use of a pre-connection attribute (basically a pointer to the token string). There is an open feature request at the odbc Github repo for this. I encourage you to upvote it, hopefully if it's popular enough it will get implemented.

Source https://stackoverflow.com/questions/67570465

QUESTION

How To Connect PHP7.3, sql server & Nginx Debian10

Asked 2021-Feb-18 at 18:03

Please help me....

I've created a web server using OS Debian 10, Nginx and PHP7.3 and everything is running well. but when it will connect to the sql server, it cannot connect.

I've done several tutorials such as:

pecl install sqlsrv pdo_sqlsrv
Follow steps mentioned on https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15
File .ini driver root@debian:~# ls /etc/php/7.3/fpm/conf.d/*sqlsrv.ini /etc/php/7.3/fpm/conf.d/20-sqlsrv.ini /etc/php/7.3/fpm/conf.d/30-pdo_sqlsrv.ini root@debian:~#
my php info:
my script and result in browser like :

so please help me to solve this problem, Thank you Very Much

...

ANSWER

Answered 2021-Feb-18 at 18:03

If you are having issues with the client on Debian 10 with OpenSSL1.1.1 the fix is to revert to the previously default weaker key length. To do so:

Modify

Source https://stackoverflow.com/questions/66074522

QUESTION

Getting error while migrating laravel 7 to 8

Asked 2021-Feb-03 at 07:06

I am using library upeg/sybase 2.1. when I am upgrading laravel 8 , i am getting below error. How can I resolve this error?

Getting error while applyig command composer update

composer.json

...

ANSWER

Answered 2021-Feb-03 at 07:06

use latest version

try "uepg/laravel-sybase": "^2.4.0" then run composer update

Source https://stackoverflow.com/questions/66022463

QUESTION

Getting error while connecting sybase laravel

Asked 2020-Nov-08 at 17:03

Below error I'm getting while connecting sybase with laravel.

PHP Warning: PHP Startup: Unable to load dynamic library 'pdo_mysql' (tried: /usr/lib/php/20190902/pdo_mysql (/usr/lib/php/20190902/pdo_mysql: cannot open shared object file: No such file or directory), /usr/lib/php/20190902/pdo_mysql.so (/usr/lib/php/20190902/pdo_mysql.so: undefined symbol: mysqlnd_allocator)) in Unknown on line 0

Warning: PHP Startup: Unable to load dynamic library 'pdo_mysql' (tried: /usr/lib/php/20190902/pdo_mysql (/usr/lib/php/20190902/pdo_mysql: cannot open shared object file: No such file or directory), /usr/lib/php/20190902/pdo_mysql.so (/usr/lib/php/20190902/pdo_mysql.so: undefined symbol: mysqlnd_allocator)) in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library 'pdo_oci' (tried: /usr/lib/php/20190902/pdo_oci (/usr/lib/php/20190902/pdo_oci: cannot open shared object file: No such file or directory), /usr/lib/php/20190902/pdo_oci.so (/usr/lib/php/20190902/pdo_oci.so: cannot open shared object file: No such file or directory)) in Unknown on line 0

Warning: PHP Startup: Unable to load dynamic library 'pdo_oci' (tried: /usr/lib/php/20190902/pdo_oci (/usr/lib/php/20190902/pdo_oci: cannot open shared object file: No such file or directory), /usr/lib/php/20190902/pdo_oci.so (/usr/lib/php/20190902/pdo_oci.so: cannot open shared object file: No such file or directory)) in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library 'pdo_odbc' (tried: /usr/lib/php/20190902/pdo_odbc (/usr/lib/php/20190902/pdo_odbc: cannot open shared object file: No such file or directory), /usr/lib/php/20190902/pdo_odbc.so (/usr/lib/php/20190902/pdo_odbc.so: undefined symbol: pdo_parse_params)) in Unknown on line 0

Warning: PHP Startup: Unable to load dynamic library 'pdo_odbc' (tried: /usr/lib/php/20190902/pdo_odbc (/usr/lib/php/20190902/pdo_odbc: cannot open shared object file: No such file or directory), /usr/lib/php/20190902/pdo_odbc.so (/usr/lib/php/20190902/pdo_odbc.so: undefined symbol: pdo_parse_params)) in Unknown on line 0

I edited php.ini file.

using below dependency in composer.json

...

ANSWER

Answered 2020-Nov-08 at 17:03

Error says it is because of pdo_mysql. I solved the problem this way:

Source https://stackoverflow.com/questions/63932431

QUESTION

RHEL 8 Container MSSQL ODBC Driver e2fsprogs

Asked 2020-Aug-05 at 10:46

I'm trying to build a custom docker container using the RHEL 8 UBI. As part of this I want to install the MSSQL 17 ODBC driver. I've followed the steps outlined in Microsofts Documentation here: https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15#redhat17

And added the Microsoft repo to my yum.repos.d directory however when I try to build the container I get the following error: nothing provides e2fsprogs needed by msodbcsql17-17.6.1.1-1.x86_64

When I dug a bit further into this it looks as though it looks as though for RHEL-7 Microsoft suggest installing e2fsprogs manually you can see that here: https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15#offline-installation

This unfortunately isn't possible in RHEL-8 as e2fsprogs-static has been removed: https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/8/html-single/considerations_in_adopting_rhel_8/index#removed-packages_changes-to-packages

The full output from the build is:

...

ANSWER

Answered 2020-Aug-05 at 10:46

I found a work around that I hope will help the next person to hit this. Rather than running yum install -y msodbcsql17 I instead used yum to download the RPM yum download -y msodbcsql17 then used rpm -Uvh --nodeps msodbcsql17*rpm to install it.

You can use this docker file:

Source https://stackoverflow.com/questions/63262668

QUESTION

How to Read .mdb file using python 64 bit?

Asked 2020-Jun-16 at 13:51

i am getting filenot found error in pandasaccess

MDB tools are also not working

mdb-tables : The term 'mdb-tables' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At line:1 char:1 + mdb-tables .\Classes\Test-results.mdb

Pyodbc is working only on win 32 bit

But still no answer for both

...

ANSWER

Answered 2020-Jun-16 at 13:51

pandas_access is a thin wrapper around MDBTools and MDBTools is really only intended for non-Windows platforms.

If you want to use pandas to work with an .mdb file in 64-bit Python under Windows then you need to install the 64-bit version of the Access Database Engine and use the sqlalchemy-access dialect for SQLAlchemy.

Source https://stackoverflow.com/questions/62405946

QUESTION

Unable to set up SQL Server backend using pyodbc for airflow on a Centos 7 server

Asked 2020-Jun-11 at 15:03

I'm trying to set up SQL Server backend for airflow. But getting this timeout error, when I do airflow initdb:

sqlalchemy.exc.OperationalError: (pyodbc.OperationalError) ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0) (SQLDriverConnect)')

My connection string in airflow.cfg looks like:

...

ANSWER

Answered 2020-Jun-09 at 14:15

I'd look to your connection string.

For a start there's a typo in the example you've given a comma before defining your PORT variable.... but it looks like there's a different shape to connection strings based on your chosen SQL Server driver. And you look like you are using pymssql format rather than pyodbc despite using the ODBC driver.

From SQLALchemy docs https://docs.sqlalchemy.org/en/13/core/engines.html#microsoft-sql-server

Source https://stackoverflow.com/questions/62272031

QUESTION

UTF-8 SELECT IBM i DB2 throught unixODBC php PDO Debian 9 in CLI php

Asked 2020-Jun-03 at 07:13

I have a problem, very very picky.

I have a LAMP server which is connected to an IBM i (AS400) throught unixODBC. PHP execute sql on IBM i throught ODBC connection on IBM i.

I want to do a simple SELECT in my databse. It's work very well when the script is executed by a navigator (apache), but when the script is executed by CLI (php example.php) and when i have special characters like : Ô ô é à @ etc in my record PDO return NULL. And when i execute the script in my Web browser all the special characters are okay.

I don't understand why. I put 'CHARSET=UTF-8' in my DSN PDO connection.

I think this bug is related to : iSeries Access ODBC Driver with unixodbc on Debian - Invalid UTF-8 characters being returned from iSeries because when I SELECT with HEX(field) i have the hexa from browser and CLI.

PHP latest version (7.4.6), Debian 9.

...

ANSWER

Answered 2020-Jun-03 at 07:13

As per comment thread, the cause of the issue was that when running from the command-line shell and php CLI, the shell was not correctly configured for UTF-8 for the correct locale (country etc).

Source https://stackoverflow.com/questions/62152171

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install odbc-driver

You can download it from GitHub.

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: