Connecting to database with OLEDB driver

[hayjude]

Using the RDC with VB6 I have a report which needs to be 'pointed' to its database prior to use. ie. I can not be sure of the path to the database. At present I am connecting to an MS Access database but will need to connect to a SQL Server one in the near future.

I have tried the following code.

For intLoop = 1 To Form3.Report2.Database.Tables.Count
   Form3.Report2.Database.Tables _
   (intLoop).SetTableLocation "G:\Work\Prosper\Working _ 
    Folder\Prosdemo.mdb", "", ""
Next

The above code has not wrapped well in my browser but all in the loop is on one line.

The error message I get is 'No rowset was returned for this table, query, or procedure.' followed by 'Error detected by database DLL'.

The report driver is pdsoledb.dll.

If I use the pdbdao.dll driver this error does not occur.
It seems to me that the oledb report is somehow using the wrong driver.

Any ideas greatly appreciated.

 

[nelsonl]

I usually get around this by passing a ADO recordset to a report. I then code to obtain a path from something like an .ini file for my application where I can can set up path of the database which can be used in a OLEDB connection string within VB when creating the ADO recordset.

HTH

Nelson