After AD Admin added a SQL server SPN using the setspn tool, the linux server is not able to use the SPN using MS SQL Server ODBC Driver 18 with error “[HY000] [Microsoft][ODBC Driver 18 for SQL Server]SSPI Provider: Server not found in Kerberos database” I have a working kerberos based authentica…
Tag: odbc
Connection to SQL Server from Julia on Ubuntu Linux using ODBC.jl won’t connect
I have tried every permutation I can find on the web but still no luck. I know the connection is possible because it works easily from R, dbeaver, and command line sqlcmd, but I can not get it to work from Julia using ODBC.jl However in Julia 1.7.0 I just get this error: I think it might have something to
Locating ODBC Driver 13.0 for SQL Server on Ubuntu Azure VM
I have a python script that requires ODBC Driver 13.1 for SQL Server to connect and write to a SQL Server. I am trying to setup the script on a Linux VM running Ubuntu 16.04 on Azure. I am having trouble locating the location of the driver to use in my script. I have followed the instructions here on installi…
[unixODBC][Driver Manager]Can’t open lib ‘/usr/lib/x86_64-linux-gnu/odbc/psqlodbca.so’ : file not found
I have installed Postgresql 9.4 on Ubuntu 16.04, and installed postgresql ODBC and Unix ODBC drivers. When I test the ODBC connection with isql it works fine. Also, I am able to connect to the databases using pgadmin III from local and remote locations. But, when I am trying to install a software which will c…
Unable to connet to SQL server using soci library
I am beginner in c++,my problem on Linux for connecting to SQL Server with soci library, my code this but I have error and I don’t found solution for my problem, my code this: I have error: Here is the code: Answer Your ODBC connection string in incorrect, your first parameter specifies a datasource cal…
Ubuntu-16.04 + PHP-7.0.22 + ODBC not working
I have been trying to connect MSSQL from my ubantu 16.04 and i had use below tutorial: https://askubuntu.com/questions/578934/mssql-connection-from-ubuntu There is one problem while i am running below command from terminal is: It display below errors: I have follow instruction given by below link answer as we…
ODBC Error Connecting Teradata
I have installed Teradata ODBC driver on Debian via alien. Dependencies checked via ldd and are fufiled.. But when attempting to connect to the DB I am getting following errors (with Debug) Any idea how to get rid of those errors? It seems to be a root cause of failing connections Architecture X64 OS Debian 7…
Error during insert with parameter(s) over 30 characters
Issue Performing an insert using prepared statements with PDO and an ODBC driver gives the following error when at least one of the parameters is over 30 characters: Inserts work for any bound string that is <= 30 characters in length. I have no issues with SELECT queries. Using INSERT with isql and sqlcmd…
Pervasive ODBC connection from Linux Ubuntu 64bit – DSNADD not found
I’m trying to connect to Pervasive via ODBC from an Ubuntu 64bit server. I did the following things: Installed unixodbc with apt-get command. Downloaded the Pervasive SQL 64bit Client 11.20 from the Pervasive site (don’t know if this is the correct one I have to install) Extracted the archive and …