Get sql server/database name through code

wilk_u

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

mohana_cse06

Use Server table

wilk_u

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

mohana_cse06

Its table 2000000047..

Use form wizard to see..

satbir

You can also use CONTEXTURL function.

wilk_u

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

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

deV.ch

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

Thank You for Your answer, got it

julkifli33

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

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

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

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

mohana_cse06

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

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

Thanks all for Your help