[Info-ingres] IngresII ODBC Administrator - 64 bit

[Andy]

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:


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>
> Sent: 01 April 2020 03:05
> To: 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
> 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/568b40f7/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: chjmlncapfnohgbf.png
Type: image/png
Size: 10041 bytes
Desc: not available
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20200401/568b40f7/attachment.png>