Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [odbc]

172 questions
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
  • 2,900
  • 2
  • 11
  • 33
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
  • 448
  • 6
  • 17
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
  • 432
  • 1
  • 9
  • 21
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
  • 8
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
  • 838
  • 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
0
votes
2 answers

Only allow ability to read the views for a particular SQL Server user over ODBC

Newbie question: I have a designer who reads information from a SQL Server [2008] database. I've setup a few views for him to pull his data from and granted his user a member of the db_dataread role. His program uses an ODBC connection to grab…
Feckmore
  • 145
  • 2
  • 3
  • 7
0
votes
1 answer

Microsoft Access Duplicates Auto Incremented MySQL Record When Info Identical

I've recently run into one of the most frustrating bugs I've seen with a Microsoft Access integration with MySQL. What happens is that if you type something in a record, and then quickly move to the next record and type the exact same thing, the…
Madison Knight
  • 121
  • 5
0
votes
1 answer

Testing MySQL 32-bit ODBC connection via CMD

I'm going to make a batch script to do some basic troubleshooting. Among other things, I want to test 32-bit MySQL ODBC's for connectivity. This script will run locally on each workstation. There doesnt appear to be any option in odbcconf.exe for…
Ken Ash
  • 11
  • 1
1 2 3
…
11 12