Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OLEDB Driver Provider Problem - Inconsistent Connection
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00650884
Message ID:
00651034
Views:
23
OK, taking this a step further, this is what happens.

Applied VFP7-SP1 to my installation.

Install the OLEDB driver and whatnot as part of an InstallShield-Express-VFPEdition application (I included the .msm files as part of "what needs to be installed").

Install the setup.exe on a Win2K computer that has already had MDAC 2.6-SP1 and MDAC 2.7 installed. Using the local Administrator account.

Create a simple .vbs and run it, logged on as local Administrator. This runs fine.
cCacheDir = "e:\db\cache.dbc"
	On Error Resume Next
	Set oConn = CreateObject("ADODB.Connection")
	cConn = "Provider=VFPOLEDB.1;Data Source=" & cCacheDir
	oConn.Open cConn
	If Err.Number <> 0 Then
		WScript.Echo Err.Number
		WScript.Echo Err.Description
		WScript.Echo Err.HelpContext
		WScript.Echo Err.Source
	End If
	WScript.Echo "Complete"
Create a local user account, member of local Administrators. Create a COM+ server package that runs under this account. Create a COM Scriptlet .wsc that when a given method is called, it does this to launch the .vbs script out-of-process:
	cExec =  "cmd /c cscript.exe -nologo e:\wintemp\cachetouch.vbs"
	Set oProc = GetObject("winmgmts:!Win32_Process")
	oCMD = oProc.Create( cExec,,,iPID )
The COM scriptlet is instantiated by an .ASP page (running in High-Isolated mode on IIS5)

If I am logged on to the local machine with the same user credentials as the COM package, the script gets executed, I see the CMD instance and the scripit runs fine.

I get the error:
	ERROR #3706 - Provider cannot be found. It may not be properly installed.
1. If no user is locally logged on.
2. If the local Administrator is locally logged on.

What gives?
Previous
Reply
Map
View

Click here to load this message in the networking platform