EDN Admin
Well-known member
Hi guys, Im having trouble getting an old VB.Net(2.0) Windows Forms application that uses SQLXMLBulkLoad 3 to work, which runs fine on my client (Windows 7, 32 bit), and our old Server (Windows Server 2003, 32 bit), but not on our new server, (Windows Server 2008 R2, 64 bit). It crashes with the error:
"System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {8270CB2F-B0E6-4C37-8A40-D70778F47894} failed due to the following error: 80040154."
On the following Line:
"Dim objBulkUpload As New SQLXMLBULKLOADLib.SQLXMLBulkLoad3"
(Ive referenced Microsoft XML BulkLoad for SQL Server 3.0 by COM in my app, and copied the Interop.SQLXMLBULKLOADLib.dll into the same folder as my .exe, as works on the clients and old server)
Now Ive done a bit of research and that error basically says its unreferenced? I HAVE installed SQL XML 3.0 SP3 on the server, as that was all Ive ever needed to get this to run on our clients. Ive checked the registry on the server and it does list the .dll, heres part of the key:
"[HKEY_CLASSES_ROOTWow6432NodeCLSID{8270CB2F-B0E6-4c37-8A40-D70778F47894}]
@="SQLXMLBulkLoad Class"
[HKEY_CLASSES_ROOTWow6432NodeCLSID{8270CB2F-B0E6-4c37-8A40-D70778F47894}InprocServer32]
@="C:\Program Files (x86)\Common Files\System\Ole DB\xblkld3.dll"
"ThreadingModel"="Apartment""
The xblkld3.dll does exist at that location. Is this something to do with 32 and 64 bit incompatability? Ive found an old post on here that suggests so, but the help link is dead:http://social.msdn.microsoft.com/forums/en-US/netfxsetup/thread/9220bb88-38c2-4d4d-a0bb-f771162fdea8Theres also the possibility of some other dependency being missing, as this is quite a new server, and the old one has had alsorts installed on it over the years.
View the full article
"System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {8270CB2F-B0E6-4C37-8A40-D70778F47894} failed due to the following error: 80040154."
On the following Line:
"Dim objBulkUpload As New SQLXMLBULKLOADLib.SQLXMLBulkLoad3"
(Ive referenced Microsoft XML BulkLoad for SQL Server 3.0 by COM in my app, and copied the Interop.SQLXMLBULKLOADLib.dll into the same folder as my .exe, as works on the clients and old server)
Now Ive done a bit of research and that error basically says its unreferenced? I HAVE installed SQL XML 3.0 SP3 on the server, as that was all Ive ever needed to get this to run on our clients. Ive checked the registry on the server and it does list the .dll, heres part of the key:
"[HKEY_CLASSES_ROOTWow6432NodeCLSID{8270CB2F-B0E6-4c37-8A40-D70778F47894}]
@="SQLXMLBulkLoad Class"
[HKEY_CLASSES_ROOTWow6432NodeCLSID{8270CB2F-B0E6-4c37-8A40-D70778F47894}InprocServer32]
@="C:\Program Files (x86)\Common Files\System\Ole DB\xblkld3.dll"
"ThreadingModel"="Apartment""
The xblkld3.dll does exist at that location. Is this something to do with 32 and 64 bit incompatability? Ive found an old post on here that suggests so, but the help link is dead:http://social.msdn.microsoft.com/forums/en-US/netfxsetup/thread/9220bb88-38c2-4d4d-a0bb-f771162fdea8Theres also the possibility of some other dependency being missing, as this is quite a new server, and the old one has had alsorts installed on it over the years.
View the full article