[Info-ingres] IngresII ODBC Administrator - 64 bit

[Martin Bowes]

Hi Andy,

Sadly that wasn’t the case. The user who reported this to me noticed that of three databases they should have access to only two showed in their display. The permissions on all three were the same. Further, they didn’t see iidbdb.

So something else is at play.

Marty
From: Andy <prgcoder at gmail.com>
Sent: 01 April 2020 13:59
To: info-ingres at lists.planetingres.org
Subject: Re: [Info-ingres] IngresII ODBC Administrator - 64 bit

Could it be that the database access on some of the databases are marked as Private (in accessdb)?
You may require a Role username and password to get access...
eg:
[cid:image002.png at 01D6086A.5DFC4DE0]

Not sure if this has been suggested or not...


On 1/04/2020 6:12 pm, Martin Bowes wrote:

Hi Steve,



Sadly no progress as I couldn't make a reliable test case to send to Actian. As a rule, I only raise issues where I have a test case with some chance of demonstrating a problem.


Have you seen the same thing? If you have, let me know and I'll raise the issue with Actian and we'll just have to proceed without the test case and hope for the best. If a number of people have a similar issue then that at least is something worth reporting.



Marty



-----Original Message-----
From: Steve <s.anderson.au at gmail.com><mailto:s.anderson.au at gmail.com>
Sent: 01 April 2020 03:05
To: info-ingres at lists.planetingres.org<mailto:info-ingres at lists.planetingres.org>
Subject: Re: [Info-ingres] IngresII ODBC Administrator - 64 bit



On Thursday, 5 March 2020 21:08:04 UTC+11, Martin Bowes  wrote:

> Hi All,

>

>

>

> Using Ingres ODBC Administrator set up a data source. I use a tested vnode, set Type to Ingres and then clicked on the dropdown menu box for Database…why isn’t it displaying all the databases?

>

>

>

> I have an  installation with 82 databases. The dropdown menu did not include three of them, one of which was iidbdb.

>

>

>

> Thinking this was related to the number of database, I set up another data source to an installation with 103 databases..no problem there on the number of databases with iidbdb being included. So the number doesn’t appear to be the issue.

>

>

>

> I traced the call from the Administrator into the server to get the database details and it’s just a simple ‘SELECT name FROM iidatabase’ . There are no qualifications imposed at that end.

>

>

>

> The servers are at

> II 11.0.0 (a64.lnx/100) with various patch levels.

>

>

>

> Anyone got any ideas?

>

>

>

> Martin Bowes

>

>

>

>



Hi Martin



Did you make any progress with this?



Steve

_______________________________________________

Info-ingres mailing list

Info-ingres at lists.planetingres.org<mailto:Info-ingres at lists.planetingres.org>

https://lists.planetingres.org/mailman/listinfo/info-ingres



_______________________________________________

Info-ingres mailing list

Info-ingres at lists.planetingres.org<mailto:Info-ingres at lists.planetingres.org>

https://lists.planetingres.org/mailman/listinfo/info-ingres

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20200401/7baafcbc/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 52018 bytes
Desc: image002.png
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20200401/7baafcbc/attachment.png>