JDBC - Query to another database

Hi all,

I have a JDBC driver for MSSQL 2005 which is working properly. I now
want to add a direct query in de stylesheet to another database to
check something. This works fine when using the query in one database,
when using another (besides the database Identity Manager connects to)
the following error message comes forward:

Table/view 'zzz.dbo.location' is undefined or the driver lacks the
necessary privileges to see it.</description>
<jdbc:document xml:space="preserve"
xmlns:jdbc="urn:dirxml:jdbc"><nds>
	<input xmlns:jdbc="urn:dirxml:jdbc">
		<jdbc:statement event-id="0">
			<jdbc:sql>SELECT name FROM zzz.dbo.location WHERE
name='Joe'</jdbc:sql>
		</jdbc:statement>
	</input>
</nds></jdbc:document>

The user has all permissions on the second database as well. If I use
the query directly in the same database Identity Manager connects to,
it works (which means privileges are not the issue). If I paste the
query in the admin tool for SQL, it also works. Is there a solution for
this, or am I missing something?


-- 
anitone
------------------------------------------------------------------------
anitone's Profile: http://forums.novell.com/member.php?userid=6798
View this thread: http://forums.novell.com/showthread.php?t=327156

anitone,

It appears that in the past few days you have not received a response to your 
posting.  That concerns us, and has triggered this automated reply.

Has your problem been resolved? If not, you might try one of the following
options:
 
- Visit http://support.novell.com and search the knowledgebase and/or check all
the other self support options and support programs available.
- You could also try posting your message again. Make sure it is posted in the 
correct newsgroup. (http://support.novell.com/forums)

Be sure to read the forum FAQ about what to expect in the way of responses:  
http://support.novell.com/forums/faq_general.html

If this is a reply to a duplicate posting, please ignore and accept our
apologies 
and rest assured we will issue a stern reprimand to our posting bot.

Good luck!

Your Novell Product Support Forums Team
http://support.novell.com/forums/