Hi,

I'm designing reports in VB using data report designer.

For connection in data environment designer, I'm specifying the path via "Data Link properties window" (By specifying provider and database location). However, this becomes a fixed path. I mean, after generating exe file, I would like to place database and exe file alone in separate folder. However, data environment designer connection still tries to get data from old location...and if database is deleted, it gives error while generating report.

For rest of my VB program, I'm reading a path.ini file in Module section--which facilitates me keeping database anywhere.

Can someone kindly suggest a solution which makes data report also take connection path from path.ini file??

Note: I tried to give dataenvironment.connection.provider = "Microsoft.Jet.OLEDB.4.0", but I'm getting error saying that a provider is already supplied. When it is echoed thru msgbox, it is showing as MSDatashape as provider name.

Any help in this regard will be greatly appreciated. Thank you in advance.

Kiran