April 6, 2009 at 7:30 am
Error: Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server.
I migrated a backend access database for my vb.net program to SQL Server 2005. Everything works when I run the program on the same machine that has the server on it. When I try to run the program on other machines in the network: it works when it has to access everything, except the Linked Servers. The 'Linked Servers' are Access DB's that are on a different server on the network. (and I get the error above)
April 6, 2009 at 7:56 am
Tried these suggestions:
Set sharing on the Temp directory to everyone/full control. (relocated the Temp directory to root of C:/ instead of Docs and Settings)
Went to Component Services, 'My Computer' the one that has a MS DTC tab on it. Set the access to Allow Outbound, Allow Inbound, (Mutual Authentication Required), Allow Remote Clients, and Allow Remote Administration (all checked)
Unchecked: Enable Transaction Internet Protocol (TIP) Transactions
Unchecked: Enable XA Transactions
MS Office is installed on the computer hosting the server. (my computer)
Still get the same error message.
??This is possible to do, right....set up a Server on a WinXP destop CPU that is networked on my company's server?? It's just the linked server's that aren't working, and those are elsewhere on the Company's server domain.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply