Guest_imported
New member
- Jan 1, 1970
- 0
I have made a project in MS VB 6.0 with the following components
MS ADO Data Control 6.0 (OLEDB)
MS Datagrid Control 6.0 (OLEDB)
The Adodc is linked in Design time with a connection string to "FILE NAME=C:\Program Files\Common Files\ODBC\Data Sources\thedatafile.dsn" whihc in turn points to an excel file "thedatafile.xls".
thedatafile.xls has a few tables which are accessed by 7-8 adodc controls which in turn are linked to data grids.
Both these files are kept in the "C:\Program Files\Common Files\ODBC\Data Sources\" Directory in my PC.
When running the program in my PC it works fine w/o any trouble.
When I use Package & Deployment Wizard and create a setup file I include "Excel Drivers", "MSEXCL35.DLL", "MSADODC.OCX", "MSDATGRD.OCX" and the .dsn, .xls files (which I push into the "\odbc\data sources" location of the PC where the program is being installed.
Once I run the setup from another PC. It installs the program (all the OCX and other files properly). When I run the Program it suns properly till a form with adodc is opened when the following error appears.
"Rowset not available" Error No. 7005.
I tried some fixes mentioned here in the threads but it didnt work. I dont want to include loads of files to keep the deployment pack small. Only essentials.
Can someone help me to work this one out.
Bye
Parag
MS ADO Data Control 6.0 (OLEDB)
MS Datagrid Control 6.0 (OLEDB)
The Adodc is linked in Design time with a connection string to "FILE NAME=C:\Program Files\Common Files\ODBC\Data Sources\thedatafile.dsn" whihc in turn points to an excel file "thedatafile.xls".
thedatafile.xls has a few tables which are accessed by 7-8 adodc controls which in turn are linked to data grids.
Both these files are kept in the "C:\Program Files\Common Files\ODBC\Data Sources\" Directory in my PC.
When running the program in my PC it works fine w/o any trouble.
When I use Package & Deployment Wizard and create a setup file I include "Excel Drivers", "MSEXCL35.DLL", "MSADODC.OCX", "MSDATGRD.OCX" and the .dsn, .xls files (which I push into the "\odbc\data sources" location of the PC where the program is being installed.
Once I run the setup from another PC. It installs the program (all the OCX and other files properly). When I run the Program it suns properly till a form with adodc is opened when the following error appears.
"Rowset not available" Error No. 7005.
I tried some fixes mentioned here in the threads but it didnt work. I dont want to include loads of files to keep the deployment pack small. Only essentials.
Can someone help me to work this one out.
Bye
Parag