If you get the error 3265 or the message about could not connect or wrong format, then there are a few points to check. Open the INTERFACE.INI file in Notepad.
1. First check the connection strings in the INI file. They look something like:
DBTYPE=2
1=Provider=OraOLEDB.Oracle.1;Data Source=ORADEV;User ID=@@@;Password=###;
2=Provider=SQLOLEDB;Data Source=LT035\OPSSQL;initial catalog=@@@;User Id=OPSDBA;Password=###;OLE DB Services =-2;
Make sure the Data Source for either connection is correct. Line '1=' is the Oracle connection and line '2=' is the MS SQL.
2. Next, check the source connection string. For RSVIEW32, Data Source points to a folder of dBase IV files. If you bring up windows explorer and navigate to that folder, you should see files with the extension .DBF.
USERCON1=Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\OPSSQL\OPSSQL_RSVIEW32\Auburn;Extended Properties=dBASE IV;User ID=Admin;Password=;
3. One other item to check in the INTERFACE.INI is the DATABASE line as shown below:
DATABASE=OPSAUBURN~1
This line looks fine and will work as long as OPSAUBURN exists. In older versions of RSVIEW32, however, the program had put and extra '~0' on the end - like this 'DATABASE=OPSAUBURN~1~0' - This was designed for an offset, but when set to 0, it causes the error 3265 when running the RSVIEW32 interface.