Integration studio: problem importing from a linked server

Integration studio: problem importing from a linked server

  
I'm having this problem when trying to import entities from a linked server on sqlserver for Filemaker 9 server via ODBC drivers.

"error retrieving databases: ssServiceCenter.ExcptIntegrationStudio: The OLE DB Provider "Sql Server" for linked server "(null)" reported an error. One or more arguments were reported invalid by the provider."

the linked server connection seems properly configured since i do

EXEC sp_tables_ex 'FILEMAKER'

and i can see the list of tables.

Im using latest version of outsystems express edition, with sql 2005 express and SQL Server Management Studio Express to create the linked server.

i post screenshot of properties in attach.

thanks in advance
Hi João,


The Hub Server will execute exec sp_catalogs <dblinkname> to obtain the list of catalogs in the dblink and exec sp_tables_ex <dblinkname>, NULL, NULL, <catalogname>, "'TABLE'|'VIEW'" to obtain the list of tables. Can you execute these stored procedures?

If you are unable to use the wizard to import Entities, try to manually add an Entity, set its Physical Table Name to <dblinkname>.dbo.<catalogname>.<tablename> and then hit the Refresh Entity option in the Entity's context menu. This will attempt to contact the Hub Server, retrieve the metadata for the Entity and create/update its Attributes and properties.


Hope this helps,

Rodrigo Castelo
Hi,

I've been getting the error too using version 5.0.2.3 of Integration Manager:
Error retrieving databases: ssServiceCenter.ExcptIntegrationStudio: The OLE DB provider "SQL Server" for linked server "(null)" reported an error.
One or more arguments were reported invalid by the provider.

We are running version 9.00.4053.00 of Microsoft SQL Server Express Edition on Windows 2003 server ; Microsoft Windows NT 5.2 (3790)

I have downloaded an upgrade of the SQL Express server (SQLEXPR.EXE) from:
http://www.microsoft.com/downloads/details.aspx?FamilyID=3181842a-4090-4431-acdd-9a1c832e65a6&displaylang=en

For the 'normal' SQL Server 2005 use (SQLServer2005SP3-KB955706-x86-ENU.exe):
http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en:

According to: http://support.microsoft.com/kb/959031 this should fix the problem.

Unfortunately this didn't work for me :(