Page 1 of 1
Table extensions & ODBC
Posted: Thu Sep 18, 2003 7:58 pm
by John_Hand_(Guest)
We have upgraded from Arpeggio to R&R10v10 build 1.003.__Opening existing reports is fine but trying to create a new report the Master Table dialogue box appends incorrect table extensions to the names of our Brieve tables.____eg "Member" table becomes "^Member.dta^"____Our table extensions are ^.dat^ and hence we cannot create new reports. We use the Merant 3.6 Btrieve ODBC driver.____How can I get around this problem? Is there somewhere in the RSWSQL.ini file we can change"__We have a Merant section which includes:__[Merant]__DataSourceDBMS= BTRIEVE__DataSourceDriver= IVBTR15.DLL__....______Cheers,____John.________
=> RE: Table extensions & ODBC
Posted: Fri Sep 19, 2003 7:36 am
by kfleming
Do you get an error if you try to select one of these tables?______Kathleen__R&R Support
==> RE: Table extensions & ODBC
Posted: Fri Sep 19, 2003 7:27 pm
by john
Yes there is an error message. ____"DB access [Merant][ODBC Btrieve Driver] Table not found in dictionary Member.dta"
===> RE: Table extensions & ODBC
Posted: Fri Sep 19, 2003 7:30 pm
by john
I just noticed that not all the error message I typed in is shown in the reply. After DB access it should say "(Merant)(ODBC Btrieve Driver)" in square brackets - There must be a problem with squeare brackets in these messages.____Thanks.
====> RE: Table extensions & ODBC
Posted: Mon Oct 27, 2003 5:11 pm
by John_Hand_(Guest)
I fixed it by putting SetFileExt= 0.