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