Information générale
Forum:
Microsoft SQL Server
Catégorie:
Business Intelligence
Titre:
SQL server 2008 64bit vs Visual Fox Pro odbc
Versions des environnements
SQL Server:
SQL Server 2008
Hi all,
i have a big problem and i guess there are already a lot of comments on the issue. I have installed a sql server 2008 on a windows server 64bit os. Now i'm making a DTS to transport data from a vfp database to the sqlserver. When i configure the connection in the connection manager and do the connection test everything seems to be ok. When i create my data transfer from the vfp database to te sqldatabase useing this connection i got an error like :
[Connection manager "SourceConnectionOLEDB"] Error: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR. The requested OLE DB provider VFPOLEDB.1 is not registered -- perhaps no 64-bit provider is available. Error code: 0x00000000.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
i guess the problem is due to the 32bit to 64bit odbc connections. Is that right and is there a solution for this problem ?
thnx
Suivant
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