Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [odbc]

In computing, ODBC (Open Database Connectivity) is a standard C programming language interface for accessing database management systems (DBMS).

In computing, ODBC (Open Database Connectivity) is a standard C programming language interface for accessing database management systems (DBMS). The designers of ODBC aimed to make it independent of database systems and operating systems. An application can use ODBC to query data from a DBMS, regardless of the operating system or DBMS it uses.

Questions with the odbc tag regards use of ODBC with databases.

Reference: http://en.wikipedia.org/wiki/ODBC

260 questions
26
votes
3 answers

How do I resolve this error, "ERROR 1298 (HY000): Unknown or incorrect time zone: 'UTC'"?

When I run the following command I get an error, however one of my scripts requires it. SET time_zone = 'UTC'; ERROR 1298 (HY000): Unknown or incorrect time zone: 'UTC'
Evan Carroll
  • 65,432
  • 50
  • 254
  • 507
15
votes
1 answer

ODBC Data Source SQL Server Connection - Login Failed For User

I have moved my database from an SQL 2005 to a server with SQL 2008. I am now trying to create an ODBC Data Source. I am using "With SQL Server authentication using a login ID and password entered by the user" and have entered my Login and…
jpsnow72
  • 411
  • 1
  • 4
  • 10
13
votes
4 answers

Avoiding "Row by row" fetch method when dealing with source LOB columns

I have a legacy PostgreSQL database source (ODBC) that I'm attempting to migrate to new SQL Server schema using SSIS. I'm getting a warning saying: 'Row by Row' fetch method is enforced because the table has LOB column(s). Column content is…
Chris Pratt
  • 311
  • 2
  • 3
  • 12
8
votes
1 answer

Does SSMS use ODBC?

I am running SSMS V18.2 and connecting to SQL 2008 - 2019 instances. I am researching various multiple subnet connection scenarios. I learned that ODBC 13.1+ includes TransparentNetworkIPResolution which alters the way connections are made with…
James Jenkins
  • 6,318
  • 6
  • 49
  • 88
6
votes
2 answers

How can I set up a read only odbc connection?

I have a user that needs to do queries on an SQL Server 2008 database that I administrate. They have rights to edit the data, but I'd rather they weren't able to do it directly against the table (i.e., I'd prefer they'd use the application that they…
BIBD
  • 174
  • 2
  • 10
6
votes
1 answer

What is the HY number (HY000) in MySQL Error messages?

When I get an error some of them have an HY code, ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory") What is HY000 in the above context. See this question for…
Evan Carroll
  • 65,432
  • 50
  • 254
  • 507
6
votes
0 answers

Create an SSL connection with ODBC driver to MySQL(5.6) using openSSL

I want to create an asymmetric SSL connection from MySQL to an ODBC driver but don't fully know how to generate the keys and certificates (I'm using openSSL as recommended here:…
TCulos
  • 115
  • 1
  • 2
  • 6
5
votes
1 answer

How to configure connection accessing Sybase Anywhere from Sybase IQ via ODBC on Linux

I'm trying to access an ASA16 server from IQ16 via ODBC driver. Both servers are installed on the same Linux box. I've installed unixodbc-bin and added a file .odbc.init into home of user running the…
frlan
  • 495
  • 1
  • 4
  • 26
5
votes
1 answer

Foreign Key constraint on fixed value field

Note: I am a developer... I have an Asset table that has many codes that are foreign keys into a second table OutlineFiles. The OutlineFiles table has Type and Code as the primary key. The foreign key constraint need to look like this... ALTER TABLE…
David Gray Wright
  • 325
  • 2
  • 4
  • 10
5
votes
2 answers

Access 2010 linked table - solve the "decimal field's precision" error

I have an Access 2003 database (running on Win 7 64-bit, Office is also 64-bit) that has many linked tables pointing to an Oracle 11g instance through 64-bit Oracle ODBC driver. Most of the tables work fine, but some of them keep throwing at me this…
Marko
  • 61
  • 1
  • 4
5
votes
2 answers

Password character issues for } and ' in SQL connection string

I am using ODBC Driver 17 to connect to MSSQL server. To avoid SQL injection possibilities, have enclosed password in {}. Now, am facing issue if I give a password like }qwerty1234. i.e. a password that starts with } will give invalid connection…
Amal Jesudas
  • 69
  • 1
  • 7
5
votes
4 answers

MS Access / MySQL: unlock locked Records

I have a Microsoft Access database that is connected to a MySQL server via ODBC and is accessed by multiple users. Over time many records are locked and editing is not possible anymore. Is there a way to bulk unlock all records? The Error…
pila
  • 191
  • 1
  • 7
5
votes
1 answer

SQL Server ODBC Mirror/Failover Partner

Background/Context We are in the process of moving our SQL Server 2000 databases to a mirrored SQL Server 2008 R2 server with a witness and automatic failover. We have both .Net and Access applications running off of these databases, and are…
Mike S.
  • 53
  • 1
  • 3
5
votes
1 answer

SQL Server Linked server query problem (group by)

I have been using an old SQL Server 2000 installation for a long time that is linked to several Oracle servers, and it all works very well. I am trying to migrate to SQL Server 2012 via SQL Server 2008. I am encountering some problems with the…
marts
  • 51
  • 2
5
votes
2 answers

ODBC Connections locking tables in SQL Server

We have an ERP system that is a little less than modern, the backend is currently sitting on a SQL Server 2008 R2 installation. We have through mandate of management (isn't that always the case) the completely impractical practice of allowing many…
Sabre
  • 189
  • 1
  • 7
1
2 3
…
17 18