Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [odbc]

179 questions
0
votes
2 answers

Ubuntu 16.04 PHP 7 & Microsoft ODBC Driver for SQL Server on Linux - odbc_connect undefined

I'm new to Linux. I have provisioned a new Ubuntu 16.04 server, added LAMP via Tasksel, and added PhpMyAdmin. I added my web app to the html folder, and ran my MySQL scripts. This part works fine. I have a PHP page that queries a remote SQL Server.…
Jamie Symonds
  • 1
  • 1
  • 1
  • 2
0
votes
1 answer

Accessing Mysql Database through ssh tunnel in SQL Server

I've had a look around for an answer to this online without much luck. I want to connect a MYSQL Database to SQL Server Management Studios through a ssh tunnel ODBC connection. I have usernames & passwords for this (ssh passwords and mysql…
Mr H
  • 3
  • 1
  • 3
0
votes
1 answer

How to avoid information message of sqlcmd?

I'm writing script to connect database & execute store procedures, which works fine. But sqlcmd prints extra information message/ invalid characters to command line. Sqlcmd version 13.0.0000.0 Linux is used. Refer following error message, for…
Pravin
  • 121
  • 2
0
votes
1 answer

Access to SQL 2008 Server with ODBC

what do you think about using an SQL-ODBC-driver (SQLSRV32.DLL) with the name 'SQL SERVER' for accessing a SQL Server 2008 Server database? A first look shows that it works but is there something like upward combatibility? Peace Ice
Ice
0
votes
1 answer

ODBC--connection to 'systemDSN' failed

We have a Microsoft Access 2010 database (ACCDB). This ACCDB file is just a front end to a Microsoft SQL Server 2008 database. Authentication to the database is accomplished by Windows integrated authentication. I have created a System DSN on the…
user5870571
  • 3,094
  • 2
  • 12
  • 35
0
votes
1 answer

SSRS 2012 ODBC Driver architecture mismatch on remote computer, works locally

I have an SSRS 2012 server (Windows 2012) with Ingres ODBC drivers installed, ODBC entries have been configured in the 32 bit (SysWOW64) ODBC manager. Reports ran locally on the server run without a problem and are speedy. When I run the reports…
dansh
  • 11
  • 5
0
votes
1 answer

Ubuntu - SQL Server 2012 - Microsoft ODBC Driver 13 - Error: 18456, Severity: 14, State: 8

I have been attempting to get "Microsoft ODBC Driver 13 for SQL Server" running in Ubuntu for two days now, and I am out of ideas / have exhausted Google. My test machine is a vagrant VM, and these are the relevant pieces of the bash script that is…
David
  • 13
  • 4
0
votes
1 answer

Problems connecting to SQL Server using ODBC

Since three days ago I have problems connecting to SQL Server on a local network using our Access based application which uses linked tables. It happened suddenly and it only happens on my PC which I use for development. All other clients on the…
s.s.
  • 1
  • 1
  • 3
0
votes
1 answer

Setting up End-User Connection to ODBC Data Source

I need to connect my MS Access (front-end) database to SQL Server 2008 (back-end), using my ODBC connection, for all of my team to view the data in the MS Access reports, forms, etc. My MS Access front-end database contains linked tables to a…
HeatherD
  • 1
0
votes
0 answers

Conflicting libodbc.so for Teradata and Hive on solaris

We seem to have a situation where the ODBC drivers for solaris of Teradata (v 14.10 from Teradata) and the Simba Hive ODBC (v 2.0.3) are requiring different versions of the shared objects: libodbc.so and libodbcinst.so. Individually each driver…
user55570
  • 458
  • 6
  • 18
0
votes
1 answer

Is it possible to connect to a PostgreSQL server using FreeTDS driver and tsql?

Can I make a connection to a PostgreSQL server using FreeTDS, more specifically tsql command? I've been trying for a few days now, using many different configurations. Even though I am able to connect to the DB using isql and PostgreSQL odbc driver,…
brunodea
  • 3
  • 2
0
votes
1 answer

Connect via ODBC to Progress 9.1D database running on SCO Unix

We are looking to take a database dump of a really old database from a Progress DB system we have running at our office, however we've come up against a brick wall trying to connect to the system using an ODBC driver from OpenLink. here's a rundown…
Kristiaan
  • 442
  • 1
  • 9
  • 22
0
votes
2 answers

Centos, PHP encrypted connection through freeTDS/ODBC to Microsoft SQL Server

I would like to connect from PHP to a Microsoft SQL Server through an encrypted connection. PHP scripts will run from a CentOS release 6.7 (Final) I want to connect to a Microsoft SQL Server 2014 running on a Microsoft Windows Server 2012…
nulll
  • 505
  • 1
  • 5
  • 9
0
votes
1 answer

32Bit ODBC DSN "Server does not exist or access denied" but 64 bit ODBC OK connecting to SQL Server 2014

Using a new SQL Server 2014 Connecting via 32bit ODBC fails giving the error "Server does not exist or access denied" Connecting via 64 bit ODBC is successful What might cause this?
ZZ9
  • 888
  • 3
  • 16
  • 47
0
votes
1 answer

What is needed for a remote ODBC connection via PARKWAY ConnectWare for Micro Focus Files

Recently I got the task of building a PHP application, that connects to a remote ODBC driver. We got the ODBC driver and set up a test environment. Since it's my first time working with ODBC drivers, I have no idea what to do, to be able to connect…
itd
  • 131
  • 1
  • 5
1 2 3
…
11 12