Questions tagged [unixodbc]

unixODBC is an open source project that implements the ODBC API on non windows platforms.

ODBC is an open specification for providing application developers with a predictable API with which to access data sources.

The ODBC API was outlined by X/Open and ISO, and it is available on all major platforms. Microsoft platforms include many enhancements to this specification.

unixODBC is an open source project that implements the ODBC API (including all the enhancements made by Microsoft) on non windows platforms.

630 questions
-1
votes
0 answers

pyodbc in cloud function

I am trying to import pyodbc to use in my cloud function to access SQL Server. I have added pyodbc and unixODBC in requirements.txt and importing in main.py files. I could not deploy cloud function due to some import issues. ERROR: Could not find a…
Sekhar
  • 627
  • 4
  • 14
  • 34
-1
votes
0 answers

Setup ODBC Informix in Linux

I have successfully installed Informix Client SDK and unixODBC in Linux. I tested the connection with isql and it can connect and do queries. How I currently do the setup: SQLhost: /opt/informix/etc/sqlhost odbc.ini:…
-1
votes
1 answer

Can't locate DBD/ODBC.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor.)

#!/usr/bin/perl use strict; use DBI; use warnings; my $user = "database_user"; my $pass = "database_password"; my $server = "ip"; my $database_name = "db"; my $connectString = "driver={GBase ODBC 8.3…
-1
votes
1 answer

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

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…
Louis
  • 9
  • 4
-1
votes
4 answers

Asterisk, Mysql, Odbc (Unknown column 'data' in 'field list')

I use Asterisk 16.5.0, Mysql 5.7.28 and MySQL ODBC 8.0 Unicode Driver. I configured connection with MySql via ODBC connection. After some time Asterisk shows warning like that. [2019-12-11 15:34:06] WARNING[1995]: res_odbc.c:538…
Ramin Darvishov
  • 1,043
  • 1
  • 15
  • 30
-1
votes
1 answer

Connect Python to SQL Server 2017 on Docker

I'm trying to set up a new development environment on my Mac Development OS: MacOS 10.13.2 Python: 3.6 pyodbc: 4.0.21 driver manager: unixODBC 2.3.4 driver: FreeTDS 1.00.79 DB: MS SQL Server 2017 Developer [Microsoft SQL Server 2017 14.0.3008.27…
cc-
  • 3
  • 1
  • 2
-1
votes
1 answer

pyodbc cannot find db id of existing database after another database has been dropped

Another user is using a database she has created in a python session, lets call it user_db. I, in SSMS, delete a different database, lets call it other_db. After I delete other_db, her scripts claim they are unable to find the db id for user_db. If…
-1
votes
2 answers

unix shell script : How can I get just the number from the variable contain numbers and characters?

How can I get just the number from the variable contain numbers and characters?? for example: card=3Hearts How can I get just the number (3) from the variable $card ?
Ako
  • 1
  • 1
-1
votes
1 answer

Get the latest date in UNIX

I have data like this: Code Date(YYYYDDMM) VNM 20141202 VNM 20141203 VNM 20141204 BHR 20141203 BHR 20141204 RUS 20150312 RUS 20142312 Now I want to select the VNM which is having latest date using UNIX command. How I can do that?
anonymous
  • 3
  • 1
-1
votes
1 answer

data type mismatch in criteria expression vb.net access

This My Code Public Function simpan() As Integer Dim sql As String Dim cmmd As OleDbCommand sql = "INSERT INTO disposisi (nodisposisi,noagendamasuk,idseksi,intruksi,tgldisposisi,nosurat,perihal,nama)" & _ …
-1
votes
1 answer

DBD::ODBC package for fedora 17

DBD::ODBC package is not available in repo. How to install the DBD::ODBC in fedora 17?. How to achieve the ODBC DB connectivity using DBI->connect () module. Thanks.
Parthiban
  • 2,130
  • 2
  • 14
  • 27
-1
votes
1 answer

Use Window XP ODBC connection on UNIX System

I would like to know is there any methods to test windows ODBC connection on UNIX.I have installed ODBC drive on UNIX.
user1324392
  • 7
  • 1
  • 6
-1
votes
2 answers

ODBC error in php?

Hi I was wondering what the following error means and why am I getting it? [unixODBC][Driver Manager]Data source name not found, and no default driver specified My arguements for odbc_conntect() - "Driver={SQL Server Native Client…
camelCaseD
  • 2,483
  • 5
  • 29
  • 44
-1
votes
1 answer

What relational database management system RDBMS for small read-only DB on a linux web server with unixODBC?

What can be considered the best RDBMS for a web application to query database tables located on the web server host machine, which has linux OS with unixODBC installed? The database tables are small and need just read-only access. SQLite3 or mySQL…
user1069609
  • 863
  • 5
  • 16
  • 30
-3
votes
1 answer

Issue with saving cyrillic symbols to MSSQL via unixODBC and FreeTDS

My environment is quite qimilar to this All non-unicode data from database are displayed correctly. I am able to save some data to database (both ascii and cyrillic). Standard ascii characters are then displayed correctly, but Cyrillic data…
Ultrin
  • 11
  • 2
1 2 3
41
42