Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Transfer data to SQL server

Author  Topic 

minhdai
Starting Member

1 Post

Posted - 2005-10-11 : 22:21:02
Dear Expert,

I'm trying to use DTS to transfer data file of AS400(V5R1) to SQL server via IBM Client Access Driver (32 bit) but I have a errror as below :

Error Source: Microsoft OLE DB Provider for OBDC Drivers

Error Description: Unspecified error

[IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]-

Context: Error calling GetRowset to get DBSCHEMA_TABLES schema info. Your provider does not support all schema rowsets required by DTS


I don't know why and I don't find the reason to resolve this problem. Please give me the advice or another solution


Best regards and thanks in advance
Minh Dai

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-10-12 : 01:34:43
That error message is specific to the ODBC driver and is not a SQL Server error, so I'm not sure that you'll be able to find assistance for it here. You might try calling the vendor of the ODBC driver or checking if they have a new version of it.

Tara
Go to Top of Page
   

- Advertisement -