Hi all,
After installing fme2005 my joiner doesn't work anymore:
We are trying to connect to SQL Server using ODBC 3.x
After we choose the table there's a message box stating "Error: " (with no further information) and the process fails.
using SQL Profiler, we found that you force the @table_owner= LoginName while executing the sp_columns system stored procedure.
Since the table is own by the dbo and that we do not consider the FME user should have dbo rights, there are no columns retrieved as stated in the MS BOL parameter specification. We think it could be the source of the problem.
Microsoft BOL: "[EMAIL PROTECTED] =] owner
In Microsoft® SQL Server, if the current user owns a table or view with the specified name, that table's columns are returned. If owner is not specified and the current user does not own a table or view with the specified object, sp_columns looks for a table or view with the specified object owned by the database owner. If one exists, that table's columns are returned."
http://msdn.microsoft.com/library/default.asp?url="">
If you set the parameter to null, everythings works fine.
So my question is does anybody know How do we force the @table_owner parameter to be null (any registry/config to do so)?
Thx alot
Yahoo! Mail - Votre e-mail personnel et gratuit qui vous suit partout !
Créez votre Yahoo! Mail sur http://mail.yahoo.fr
Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our Professional Services team. Visit www.safe.com/services for details.
YAHOO! GROUPS LINKS
- Visit your group "fme" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
