#1  
Old 15th July 2010, 09:28 PM
PtitRun
 
Posts: n/a
Default Databases alias list


Hi !

I'm trying to get (in the code) the list of aliases that exist in my
NxServer.

I found different code example on the forum, but none of them worked:
(the select * from #shema).
my problem is that i can't create a connexion without a database name.
i've got the last build of the ADO provider

thx for your answers !

Renaud

(sorry for my english)


--
PtitRun
  #2  
Old 16th July 2010, 07:27 AM
Hannes Danzl[NDD]
 
Posts: n/a
Default Re: Databases alias list

PtitRun wrote:

>
> Hi !
>
> I'm trying to get (in the code) the list of aliases that exist in my
> NxServer.
>
> I found different code example on the forum, but none of them worked:
> (the select * from #shema).
> my problem is that i can't create a connexion without a database name.
> i've got the last build of the ADO provider


You need to at least know ONE alias and connect to it. Then you can run the
"select * from #schemas" (not schema!) to find all others.

--

Hannes Danzl / NexusDB

Issue Tracker - http://www.nexusdb.com/mantis/view_all_bug_page.php
Newsgroup Web Gateway - http://www.nexusdb.com/forums/
Newsgroup Search - http://www.nexusdb.com/forums/search.php
  #3  
Old 20th July 2010, 09:29 PM
PtitRun
 
Posts: n/a
Default Re: Databases alias list


Ouch, that's not possible in my case...

Hope that will change in a future release


--
PtitRun
  #4  
Old 20th July 2010, 09:38 PM
Hannes Danzl[NDD]
 
Posts: n/a
Default Re: Databases alias list

PtitRun wrote:

>
> Ouch, that's not possible in my case...
>
> Hope that will change in a future release


It will change yes

--

Hannes Danzl / NexusDB

Issue Tracker - http://www.nexusdb.com/mantis/view_all_bug_page.php
Newsgroup Web Gateway - http://www.nexusdb.com/forums/
Newsgroup Search - http://www.nexusdb.com/forums/search.php
  #5  
Old 28th May 2019, 02:29 PM
it it is offline
 
Join Date: Feb 2016
Posts: 2
Default

Hi Hannes,

Did this actually change? Do we need to have to know a DB to connect to find the list of aliases or create a new one?
  #6  
Old 29th May 2019, 03:32 PM
Eivind Eivind is offline
Administrator
 
Join Date: Mar 2008
Posts: 183
Default

Quote:
Originally Posted by it View Post
Did this actually change? Do we need to have to know a DB to connect to find the list of aliases or create a new one?
If you connect to your server with Enterprise Manager and the ADO transport is activated, you should find a #NXADO_System alias that can be used for #meta queries.


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ADO.NET connection to database that has no alias ben909 nexusdb.public.support.adoprovider 0 15th April 2009 07:18 PM


All times are GMT +11. The time now is 03:55 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.