Questions tagged [odbc]
In computing, ODBC (Open Database Connectivity) is a standard C programming language interface for accessing database management systems (DBMS).
15
questions
3
votes
5
answers
3k
views
SQL Query with ODBC, Joins and Group Bys
I am having issues with the statement below. The main purpose of the query is to pull a list of customers into an Access db from ODBC (our customers are stored in DB2 on IBM i). The query is ...
- 31
0
votes
2
answers
79
views
MySQL Allows ODBC With Any Username
I have a MySQL Community database on a remote server and I am trying to get Microsoft Access to read data from it. This data is sensitive. The problem is, MySQL doesn't care about the username that I ...
- 111
26
votes
3
answers
59k
views
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'
- 64.2k
6
votes
1
answer
23k
views
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 ...
- 64.2k
5
votes
1
answer
3k
views
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 ...
3
votes
1
answer
2k
views
Trace ODBC commands: What is the registry path for TraceSQLMode and where is SQLOUT.TXT?
In the Optimizing Microsoft Office Access documentation, it mentions that we can:
...edit a Microsoft Windows registry setting that allows you to see
the commands that the Office Access database ...
- 1,497
3
votes
2
answers
6k
views
#Deleted as values when using MS Access to query a db2 database through ODBC
When trying to query certain db2 tables I get #Deleted for all values in the table. But for other tables it works fine.
The row count of this query is equal to the row count when using the data studio ...
- 236
3
votes
4
answers
44k
views
Microsoft ODBC Driver 11 for SQL Server: Named Pipes Provider: Could not open a connection to SQL Server
I am aware this question has been asked before. I have been following the extensive troubleshooting steps at MSQL Tips as well as every answer I can find on Google. I am really stumped.
The error is ...
2
votes
0
answers
1k
views
Include HostName in ODBC System DSN Connection
Not sure if this is a question for here or if it should go on Stack Overflow. If SO is a better fit, please migrate it.
Our finance team uses Dynamics GP. Occasionally we need to track the query that ...
- 3,272
1
vote
0
answers
701
views
SSIS: Error from ODBC provider when inserting into Always Encrypted table using CMK in Azure Key Store
I'm trying to use SSIS (Visual Studio 2017) to insert data into an Azure SQL table with a column that's encrypted via Always Encrypted, and a column master key stored in Azure Key Vault, but I keep ...
1
vote
2
answers
5k
views
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Data source name not found and no default driver specified
I recently upgraded from SQL Server 2017 Express to SQL Server 2019 Express and installed Microsoft SQL Server ODBC Driver 18. However, a sqlcmd script to back up all databases, using Ola Hallengren's ...
- 11
1
vote
1
answer
676
views
After a database upgrade from MariaDB 10.1 to 10.6 new ODBC connections are returning wrong values [closed]
I had a total meltdown after installing "Feature update to Windows 10, version 21H2". A month into this I am now suspect that somehow this update reconfigured the way user System is handled. ...
- 133
1
vote
1
answer
9k
views
Oracle Database Client 11g R2 Installation Types, which components?
I need to know which component is under each installation type!
Instant Client
Administrator
Runtime
Custom (No need as it shows all the components)
ALSO?
does it includes ODP.NET? is it the ...
- 357
0
votes
1
answer
3k
views
Extracting data from SQL Server linked server
I am using MS SQL Server 2012, and I am trying to extract data from a Linked Server database.
In SQL Server management studio, I can see the linked server. I can browse the database on the server. I ...
- 1
-1
votes
1
answer
709
views
'INTERVAL' is not a recognized ODBC date/time extension option
According to this docs on Interval Literals, this should be a valid INTERVAL,
SELECT {INTERVAL '326' YEAR(4)};
But when I try that on dbfiddle, I get,
Msg 155 Level 15 State 1 Line 1
'INTERVAL' is ...
- 64.2k