Stack Overflow
Stack Overflow

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
0
votes
1 answer

Is their any way to connect to oracle database via UNIX shell without using sqlplus

is there any command string in unix which will provide access to oracle database. i dont want to use sqlplus command. thanks for help...
user34225
0
votes
0 answers

nvarchar unicode accessing via php pdo odbc display empty

I'm support my project multi language in yii framework. In SQL Server the translated column datatype is nvarchar(max). If i select the translated message it shows empty in php pdo connecting via pdo odbc. The query i'm using SELECT translation…
Aruljothi
  • 497
  • 1
  • 6
  • 14
0
votes
1 answer

odbc_connect not working on unixODBC (LINUX)

I’ve included this code in my functions.php of current active theme and works perfectly (i.e: I upload the .mdb file on the server first and then read the tables from the file) on WINDOWS PLATFORM. It’s just as easy as we’re using MySQL DB. $dbName…
user3164310
  • 3
  • 1
0
votes
1 answer

SQLSTATE[HY000] - PDOException - Laravel 4

I'm using Laravel 4 with CentOS 5 and PHP 5.4. When i try to run a query, i got this: PDOException SQLSTATE[HY000] Attempt to set unknown LOGINREC field (severity 7) Just a simple query like : User::find(1); (with Eloquent ORM). My FreeTDS…
Eduardo Stuart
  • 2,869
  • 18
  • 22
0
votes
3 answers

How are databases typically implemented in SCO Unix versions of Business Basic?

We have an older reservation application written in BASIC implemented on an SCO Open Server Unix box. It is Release 5 from 2004 (version info from uname -a is "SCO_SV churchil 3.2 5.0.7 i386"). The reservation application is written in BASIC, which…
Jonathan Elkins
  • 455
  • 5
  • 21
0
votes
1 answer

Php pdo unixOBDC to sqlserver 2008: String data, length mismatch when execute prepared stmt

I have the following setup: Apache / php 5.3 / pdo with odbc with installed Microsoft SQL Server ODBC Driver 1.0 for Linux on server. My script rises an error with the following stacktrace when trying to execute a statement: (UTC) 2013-12-16…
Eugeny
  • 53
  • 6
0
votes
1 answer

Unable to get unixODBC working on Mac

I am trying to connect to Microsoft MySQL server from a Mac.Debugging it step by step (I basically follow this post)I see that freeTDS works fine.But isql shows an error - [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source …
Manish
  • 1,729
  • 5
  • 32
  • 47
0
votes
1 answer

Location of odbc library on ubuntu

I can't find the location of library for odbc on Ubuntu 13.10. I have installed unixodbc with this command : sudo apt-get install unixODBC unixODBC-dev But under /usr/local i can't find nothing. Someone know the correct location of library?
Emanuele Pavanello
  • 785
  • 1
  • 9
  • 22
0
votes
2 answers

Unix FreeTDS Isolation Level Sybase

According to the Sybase Documentation (http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.sqlanywhere.12.0.1/dbusage/udtisol.html) there is one paragraph: [...] The default isolation level is 0, except for [...] and TDS connections,…
Max
  • 33
  • 6
0
votes
2 answers

Locating libdbodbc.so for Sybase on linux

I'm trying to connect to Sybase database from the web server using UnixODBC. Sybase is installed on windows server while the web server is on Unix Server. In order to connect to Sybase I'm using UnixODBC which requires the file libdbodbc.so for…
user239440
0
votes
1 answer

ODBC can't connect libmyodbc3-3.51.27.so not found

I keep getting that error. However, I see the file there under the directory pointed by the error. I don't understand why it thinks it is not there. I am running CentOS 64 bit and trying to install storegrid on it. I've looked at the other machines…
ODelibalta
  • 2,194
  • 1
  • 18
  • 28
0
votes
2 answers

FreeBSD equivalent to unixodbc-dev

I'm trying to compile Erlang on FreeBSD, and I want to include the odbc licenses. On Ubuntu, if you add the unixodbc-dev package, that ensures that odbc gets compiled with Erlang, however, I can't find a package that works equivalently with…
chops
  • 2,572
  • 1
  • 16
  • 25
0
votes
1 answer

unixODBC/FreeTDS results truncated to 255 character

UPDATE 2 I turned on tracing and ran my sample query. Here is the trace. I do see the statement Strlen Or Ind = 0x7fff9c84ee88 -> 255. The indicator variable is defined as SQLLEN indicator; Is this not initialized…
dseiple
  • 598
  • 2
  • 6
  • 17
0
votes
1 answer

How to specify DATETIME format for a database connection?

Currently I connect to a MSSQL database by activerecord-sqlserver-adapter on top of dbd-odbc and tiny_tds. INSERT is working, except for DATETIME field. The datetime field returned from a SELECT: rows =…
ohho
  • 50,879
  • 75
  • 256
  • 383
0
votes
2 answers

Encoding is not proper when query from Apache/PHP

I have some problem with connection to my Vertica. I use PHP and PDO ODBC driver (thrue unixODBC). When I connect to Vertica via isql and select records from table all data are fine encoded - fields with UTF-8 (non ASCII symbols, for example…
Mike
  • 21
  • 3
1 2 3
…
41 42