Table Lookup type : Access tables outside of livelink DB

[hanreb]

I have Attribute Extension module.
In the table look up type I want to access the data from a table , which is not in the livelink DB.

How do I achieve that ?
In the Table lookup area, I am able to access only tables within livelink DB.

Thanks,
Sunu

 

[ggriffit]

can you not use a Linked table so that the table appears within the Livelink database even though the data is stored in its own database.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[appnair]

You have one or two options here.
There used to be a product called Livereport Extensions.That will allow you to query other databases using the livelink GUI

Or else see this sql

select * from master.dbo.country


Why it works when I call it from my livelink is because the dbuser that owns livelink has select permissions into the master database table called country .Simply put when livelink executes the connection to the table since it has permissions to do a slect no userid/password is exchanged.

In this example my livelink database and the master database both are in the same box,but I have used this method also at another client as well(I beleive we had to tweak the tnsname.ora file o make that work) try this as an alternative approach and see if it works.


Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

 

[appnair]

I think it si sthe domain user that runs livelink service who needs select permissions into your other datbase.DB users are local to the db I beleieve

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937