Information générale
Forum:
Microsoft SQL Server
Titre:
AS400 DB2 Ole db Connection problem in IIS package
Versions des environnements
SQL Server:
SQL Server 2005
I am trying to create my first IS project and want to move data from a table on an AS400 db2 to sqlserver. I created the connection using the ole db provider for AS400 DB2. When I put the name of the database in the initial catalog field and do a test connection it says it conected just fine. When I double click on the source and get the ole db source editor window I go to the name of the table or view combo box it says "No tables or views could be loaded". Now if I go back to the connection manager and put the name of the schema rather than the database name and do a test connection I get an error that says it is an invalid catalog.
I can connect to this machine from excel using the ODBC provider.
Thank you in advance.
Quinn
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement