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…
![](../../users/profiles/335183.webp)
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…
![](../../users/profiles/347114.webp)
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…
![](../../users/profiles/157599.webp)
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…
![](../../users/profiles/341677.webp)
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…
![](../../users/profiles/340318.webp)
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…
![](../../users/profiles/293416.webp)
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,…
![](../../users/profiles/319191.webp)
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…
![](../../users/profiles/5402.webp)
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…
![](../../users/profiles/109742.webp)
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?
![](../../users/profiles/233434.webp)
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…
![](../../users/profiles/290370.webp)
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…
![](../../users/profiles/21210.webp)
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…
![](../../users/profiles/234418.webp)
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…
![](../../users/profiles/234467.webp)
Ken Ash
- 11
- 1