Displaying available database servers

[Former Member]

Hi,

I am using xMII 12.0, I want to display avilable database servers and after selecting a perticular database server,available tables should be displayed in my irpt page.Can any one help in this issue..

Thanks & Regards,

Eswar

[Former Member · Accepted solution]

Eswar,

One way of achieveing this is using the following URLs:

List of SQL servers:

http://<server>:<port>/XMII/Illuminator?Service=SystemInfo&Mode=ServerList&Method=SQL

Tables:

http://<server>:<port>/XMII/Illuminator?Server=<Server Name>&Mode=TableList

Columns:

http://<server>:<port>/XMII/Illuminator?Server=<Server Name>&Mode=ColumnList&Group=<Table Name>

Now that you know how to extract these values I would suggest try to find out (search the forums, help , wiki etc..) how you can display these values in your irpt pages.

All the Best

Udayan

[Former Member · Accepted solution]

Hi Udayan

while getting available tables for a particular server its giving only few tables not all tha tables..may be they are default table..becose every time i am giving different severs names but its giving same table name list.

Thanks and Regards,

Eswar