Questions tagged [ingres]

Ingres is a relational database management system from Actian that supports spatial data management capabilities, among others.

Filter by
Sorted by
Tagged with
0
votes
0answers
16 views

Ingres ODBC driver not working

I recently installed an Ingres database as part of an application install. When I try to view its ODBC though it returns the following screen. A majority of the text has been replaced with ERget: ...
0
votes
0answers
43 views

How to uniquely identify a row in a table where there are no unique columns in Ingres DB?

I am trying to find a way to uniquely identify a row in a table where there aren't any unique columns. I have seen that it is advised not to use tid as a unique row identifier so I was wondering what ...
1
vote
0answers
303 views

Linked server select Openquery causing datetime column to be an hour behind?

I have a SQL 2014 server which has a linked server to an Actian Ingres database. When I run a simple linked server select openquery on any table with date/times, the results it pulls back is an hour ...
0
votes
2answers
123 views

Missing rows in Visual DBA, exist when queried specifically

I have an interesting issue on which Google has failed me. Background I am working with medical records managed with Ingres SQL. The other day I wrote a simple query in Excel to pull all patient ...
0
votes
1answer
43 views

call a file contains a list of table

I'm using Ingres Database and I've this procedure that create a text file with a list of tables. How i can call the file into the where condition? select request_num,table_name,temp_table from tables ...