Get sql server/database name through code

wilk_u · 2011-12-22

Hi, is there any way to get nav sql server name through c/al code to use it in connection string?

mohana_cse06 · 2011-12-22

Use Server table

wilk_u · 2011-12-22

Server? How is it named? Can't find it

mohana_cse06 · 2011-12-22

Its table 2000000047..

Use form wizard to see..

satbir · 2011-12-22

You can also use CONTEXTURL function.

wilk_u · 2011-12-22

May sound weird but i don't have such table. Just Company and windows login around table no. You specified.

Appreciate Your help satbir but looks like ms made it obsolete and nav returns error when using it

mohana_cse06 · 2011-12-23

please check this
http://www.dynamics.is/?p=541

deV.ch · 2011-12-23

Of course you have table 2000000047

it's a virtual table like printers, so you can't see it in object designer but its there, session table is another one like that!
Just assign the number to a variable of type record and you will see that it exists!

wilk_u · 2012-01-13

Thank You for Your answer, got it

julkifli33 · 2012-02-08

hi all
i create codeunit to get server name
when i test it using message, it can show my server name
but when using webservice, there is an error message

Metadata for object of type Table with id 2000000047 is in a failed state. This is caused by a previous exception:
Table 2000000047 is not available and cannot be opened.

anybody know how to solve?
thanks

postsaurav · 2012-02-08

hi,

Table 2000000047 is a hidden table named as "Server" in Navision Database.

For the error -

Metadata for object of type Table with id 2000000047 is in a failed state. This is caused by a previous exception:
Table 2000000047 is not available and cannot be opened.

Please check by creating a form with table id 2000000047, if it didnt work then i think you are using an old version database( < 6SP1).

Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.in/

julkifli33 · 2012-02-08

i already solved it
using this code

IF ISSERVICETIER THEN BEGIN

  IF ISCLEAR(DomDoc) THEN
    CREATE(DomDoc);

  DomDoc.load(APPLICATIONPATH + 'CustomSettings.config');
  DomNode :=
    DomDoc.selectSingleNode(
      '//appSettings/add[@key=''DatabaseServer'']');
  MyServerName := DomNode.attributes.item(1).text;
end;

rsaritzky · 2012-03-07

For us XML newbies, what are the Automation variable subtypes for DomDoc and DomNode?

mohana_cse06 · 2012-03-08

rsaritzky wrote:

For us XML newbies, what are the Automation variable subtypes for DomDoc and DomNode?

Name DataType Subtype Length
DomDoc Automation ‘Microsoft XML, v6.0′.DOMDocument
DomNode Automation ‘Microsoft XML, v6.0′.IXMLDOMNode

rsaritzky · 2012-03-08

mohana_cse06 wrote:

rsaritzky wrote:

For us XML newbies, what are the Automation variable subtypes for DomDoc and DomNode?

Name DataType Subtype Length
DomDoc Automation ‘Microsoft XML, v6.0′.DOMDocument
DomNode Automation ‘Microsoft XML, v6.0′.IXMLDOMNode

Thanks, Mohana!

Ron

wilk_u · 2012-03-09

Thanks all for Your help

Get sql server/database name through code

Comments

Categories