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
