In computing, ODBC (Open Database Connectivity) is a standard C programming language interface for accessing database management systems (DBMS).
2
votes
5answers
324 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 ...
3
votes
1answer
601 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 ...
1
vote
0answers
257 views
SELECT value from database over ODBC wont reach the software
SQL Server 2008 R2 latest updates.
SQL server ODBC driver version 6.01.7601.17514
PS!!! native drivers are incompatible with the software so i cannot use them.
I cannot edit or change the server ...