Connection strings used with OLEDB should use a User ID and a Password.

The Samples that are shipped with Adagio OLEDB do not include these fields and when none are supplied OLEDB uses the defaults of SYS and SYS. As a result the Samples will fail with a "Table does not exist" error if the "User ID=SYS" and "Password=SYS" are not valid.

Here is a sample Connection String that includes the User ID and Password:

UserInitials = "SYS"
UserPassword = "SYS"
DataFolder = "C:\Softrak\OLWin\Samdata"
DataExtension = "SAM"

"Provider=ADSDB.Provider;" &_
"User ID =" & UserInitials &_
";Password=" & UserPassword &_
";Data Source =" & DataFolder & "\DATA." & DataExtension

You will need to use your own values for the UserInitials, UserPassword, DataFolder and DataExtension