odbc caches - cannot browse

classic Classic list List threaded Threaded
8 messages Options
wt wt
Reply | Threaded
Open this post in threaded view
|

odbc caches - cannot browse

is there a reason why the odbc driver can't show all the caches and browse
their schemas' like regular odbc drivers?

this is a regular odbc driver allowing the user to navigate tables.
odbc.png
<http://apache-ignite-users.70518.x6.nabble.com/file/t1892/odbc.png>  



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
ilya.kasnacheev ilya.kasnacheev
Reply | Threaded
Open this post in threaded view
|

Re: odbc caches - cannot browse

Hello!

ODBC driver should allow you to show all *tables* in their schemas and browse them. Note that you need to have tables and not just plain caches.

If it doesn't, please guide me what is the software you are using. Is it Microsoft Excel? What is the version?

Regards,
--
Ilya Kasnacheev


пт, 5 окт. 2018 г. в 12:18, wt <[hidden email]>:
is there a reason why the odbc driver can't show all the caches and browse
their schemas' like regular odbc drivers?

this is a regular odbc driver allowing the user to navigate tables.
odbc.png
<http://apache-ignite-users.70518.x6.nabble.com/file/t1892/odbc.png



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
wt wt
Reply | Threaded
Open this post in threaded view
|

Re: odbc caches - cannot browse

i would love some guidance on this. i have the 2.6 odbc setup and i can query
it in excel 2016 but only if i manually type in the query. Excel won't show
any of the tables like you would typically expect

odbc connection is not configured to use a specific cache and no security is
configured


here is an image that shows it has connected but when i try click the
dropdown next to the connection it shows nothing.  odbc.png
<http://apache-ignite-users.70518.x6.nabble.com/file/t1892/odbc.png>  



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Igor Sapego-1 Igor Sapego-1
Reply | Threaded
Open this post in threaded view
|

Re: odbc caches - cannot browse

Can you please collect and share logs with us?

You can find instructions on how to enable ODBC
log for example here: [1]

[1] - https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=BGOD_logging_logwin

Best Regards,
Igor


On Wed, Oct 10, 2018 at 5:46 PM wt <[hidden email]> wrote:
i would love some guidance on this. i have the 2.6 odbc setup and i can query
it in excel 2016 but only if i manually type in the query. Excel won't show
any of the tables like you would typically expect

odbc connection is not configured to use a specific cache and no security is
configured


here is an image that shows it has connected but when i try click the
dropdown next to the connection it shows nothing.  odbc.png
<http://apache-ignite-users.70518.x6.nabble.com/file/t1892/odbc.png



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
wt wt
Reply | Threaded
Open this post in threaded view
|

Re: odbc caches - cannot browse

here is the log file generated when opening a new odbc connection to ignite
in excel.

odbc3.log
<http://apache-ignite-users.70518.x6.nabble.com/file/t1892/odbc3.log>  



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Igor Sapego-1 Igor Sapego-1
Reply | Threaded
Open this post in threaded view
|

Re: odbc caches - cannot browse

It looks like an error. I filed a ticket [1]. I'll try to fit to to 2.7

On Mon, Oct 15, 2018 at 10:46 AM wt <[hidden email]> wrote:
here is the log file generated when opening a new odbc connection to ignite
in excel.

odbc3.log
<http://apache-ignite-users.70518.x6.nabble.com/file/t1892/odbc3.log



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
wt wt
Reply | Threaded
Open this post in threaded view
|

Re: odbc caches - cannot browse

Igor Sapego-1 Igor Sapego-1
Reply | Threaded
Open this post in threaded view
|

Re: odbc caches - cannot browse

The issue is fixed and is in master already.

You can wait for Ignite 2.7 release or check that the issue is
resolved with nightly release [1]


Best Regards,
Igor


On Tue, Oct 16, 2018 at 10:42 AM wt <[hidden email]> wrote:
Thank you Igor



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/