Sorry to bother everyone, it was a 32 vs 64 bit issue. If I run >%windir%\SysWOW64\cscript.exe connect.vbs from the command line it runs fine and gets my recordset with IBM.UniOLEDB.1 as the Provider.
I know how to switch between wscript and cscript but if anyone knows how to default to the SysWOW64 version, could you share? I'm just glad I can finally get back to it since at least I can run and schedule it now! Thanks, Andrew -----Original Message----- From: Andrew E. Tegenkamp [mailto:[email protected]] Sent: Thursday, April 22, 2010 1:15 PM To: '[email protected]' Subject: UniOLEDB Connection Issues I'm trying to connect to UniOLEDB and having no luck. I've created a simple connect.vbs file on the UniVerse server but I am getting the "Provider cannot be found. It may not be properly installed." My code is here and I have tried both IBM.UniOLEDB.1 and Ardent.UniOLEDB for Provider. Dim dbConn Dim userID, pass, conStr userID = "andrew" pass = "password" msgBox("Trying") conStr = "Provider=IBM.UniOLEDB.1;Data Source=localuv;Location=HS.SALES" SET dbConn = CreateObject("ADODB.Connection") dbConn.Open conStr, userID, pass msgBox("Connected") dbConn.Close SET dbConn = Nothing msgBox("DONE") I have checked the UCI Config Editor and localuv is setup as UNIVERSE; TCP/IP; uvserver; localhost. I also can created ODBC just fine with those settings (localuv; HS.SALES; andrew; password) so I know it can connect but just won't go. Here is the full error prompt: Windows Script Host Script: C:\connect.vbs Line: 8 Char: 1 Error: Provider cannot be found. It may not be properly installed. Code: 800A0E7A Source: ADODB.Connection The command line cscript output just says the same: C:\connect.vbs(8, 1) ADODB.Connection: Provider cannot be found. It may not be properly installed. Thanks for any tips/ideas, Andrew _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
