onedunpark
IS-IT--Management
Hi,
CR for VB.net 2003 Professional edition
Rbase 6.5 ++ database
Oterro 2.6 ODBC database driver
Running VB.net 2003, I have no problems accessing my legacy databases in multi-user mode using the following DSN(less) connection string:
"Driver=Oterro Database Driver (*.rb1);DBQ=H:\PATRECS.RB1"
Trying to create a CR report based on the same database, it seems I have to select from a User or System DSN entry. I created one in Control Panel. In CR design mode I choose the ODBC(RDO) option and on selecting the new datasource am prompted to enter username/password fields. I have no choice but to skip this step because we have none applied in our databases at all, not even a master/owner userid/password.
The designer then moves on to displaying all of the tables/columns in the database and I can happily setup a basic report. Clearly then, the CR designer can access my database (which is open by many others in multi-user mode)
At run-time, however, when trying to display the form containing the CR report I receive the message "failed to open rowset".
I have happily created CR reports from other existing SQL databases, so am reasonably happy that the steps involved in creating/displaying CR reports from my code is correct.
I would guess that this is somehow security related, but am at a loss as to what I need to do to have CR allow me access to my database at runtime when my VB app (and for that matter VBA code in Word/Excel) happily accesses the database all day long, without the need for me to provide any form of userid/password info.
Any and all suggestions gratefully accepted.
I'll be more than happy to provide any other information as required.
Thanks for any and all replies.
Steven
CR for VB.net 2003 Professional edition
Rbase 6.5 ++ database
Oterro 2.6 ODBC database driver
Running VB.net 2003, I have no problems accessing my legacy databases in multi-user mode using the following DSN(less) connection string:
"Driver=Oterro Database Driver (*.rb1);DBQ=H:\PATRECS.RB1"
Trying to create a CR report based on the same database, it seems I have to select from a User or System DSN entry. I created one in Control Panel. In CR design mode I choose the ODBC(RDO) option and on selecting the new datasource am prompted to enter username/password fields. I have no choice but to skip this step because we have none applied in our databases at all, not even a master/owner userid/password.
The designer then moves on to displaying all of the tables/columns in the database and I can happily setup a basic report. Clearly then, the CR designer can access my database (which is open by many others in multi-user mode)
At run-time, however, when trying to display the form containing the CR report I receive the message "failed to open rowset".
I have happily created CR reports from other existing SQL databases, so am reasonably happy that the steps involved in creating/displaying CR reports from my code is correct.
I would guess that this is somehow security related, but am at a loss as to what I need to do to have CR allow me access to my database at runtime when my VB app (and for that matter VBA code in Word/Excel) happily accesses the database all day long, without the need for me to provide any form of userid/password info.
Any and all suggestions gratefully accepted.
I'll be more than happy to provide any other information as required.
Thanks for any and all replies.
Steven