Search found 10 matches

by Mike_Pelone
Tue Dec 02, 2003 12:58 am
Forum: R&R ReportWorks Users
Topic: ODBC Connection with SQL Version
Replies: 1
Views: 1396

ODBC Connection with SQL Version

I am trying to use ODBC to connect to a very large ASCII flat file.____When I work my way through the ODBC Text Setup dialog window, and then select _define format_ _ I can see that the program successfully _guesses_ the record layout, field lengths and types. So far _ so good. However, when I click...
by Mike_Pelone
Thu Jun 05, 2003 3:50 pm
Forum: R&R ReportWorks Users
Topic: RE: Data Direct ODBC driver
Replies: 3
Views: 2378

==> RE: Data Direct ODBC driver

Great! That worked...__Thanks for the prompt reply.____I take it that the DataDirect driver for Access files is also restricted to the Access97 file formats...____MIke Pelone__Buffalo - NY
by Mike_Pelone
Thu Jun 05, 2003 10:21 am
Forum: R&R ReportWorks Users
Topic: RE: Data Direct ODBC driver
Replies: 3
Views: 2378

RE: Data Direct ODBC driver

I upgraded to 10+ expecting the new ODBC drivers from DataDirect to be more stable and to take advantage of other Version 10 fixes. However, I have not been able to connect to a simple Excel file with 3 rows and 3 columns since I have installed the Step-Up upgrade. ____The error message is:____[Data...
by Mike_Pelone
Wed May 28, 2003 11:11 am
Forum: R&R ReportWorks Users
Topic: Ver 10+ Install Error Message
Replies: 2
Views: 1887

==> RE: Ver 10+ Install Error Message

____O.K. - I will reinstall only those drivers I need which will surely be less than all drivers available later today...____Thanks for the timely response...____Mike P.__Buffalo - NY____
by Mike_Pelone
Tue May 27, 2003 10:18 pm
Forum: R&R ReportWorks Users
Topic: Ver 10+ Install Error Message
Replies: 2
Views: 1887

Ver 10+ Install Error Message

____I recently upgraded to 10+ Step Up but during the upgrade installation, I received the following error message on my Windows XP machine. "...String variable is not large enough for string. Check string declarations. Error 401..."____On my second PC that has Windows 95 _ there was NO er...
by Mike_Pelone
Fri Mar 21, 2003 9:32 pm
Forum: R&R ReportWorks Users
Topic: RE: ODBC Data Connections
Replies: 2
Views: 1927

==> RE: ODBC Data Connections

__Actually, the original problem was not how to establish stand-alone data source connections to different data files in different folder locations. My problem relates to making substitutions of other data files (with a common record layout) using the SQL version of R&R.____Although I have been ...
by Mike_Pelone
Thu Mar 20, 2003 11:46 pm
Forum: R&R ReportWorks Users
Topic: RE: ODBC Data Connections
Replies: 2
Views: 1927

RE: ODBC Data Connections

Hello Again...____After building my initial SQL report using an ODBC link to my Excel data file, I tried to substitute another Excel file as the master table that has a common record layout. I previously created a series of ODBC data sources to these common data files to make these data file substit...
by Mike_Pelone
Tue Mar 18, 2003 11:52 pm
Forum: R&R ReportWorks Users
Topic: SQL Wizard Problem
Replies: 1
Views: 1503

SQL Wizard Problem

__This problem statement is a little long but..here goes...____I have a large number of Excel and Dbase files that currently share a common record layout (field names and widths, etc). I initially created my first report using a master table based on the Xbase file format. I can easily replace the o...
by Mike_Pelone
Wed Feb 26, 2003 5:30 pm
Forum: R&R ReportWorks Users
Topic: Control File Problem...
Replies: 1
Views: 1521

Control File Problem...

Howdy !!____I am trying to setup a batch file that contains a simple text file with the control parameters for running a single report. Based on the files in the Sample folder created by the installation process, and the hints in the help file, I created a small batch file that has one line in it:__...
by Mike_Pelone
Mon Dec 30, 2002 4:19 pm
Forum: R&R ReportWorks Users
Topic: ODBC error messages
Replies: 8
Views: 4916

ODBC error messages

Howdy!____I am using R&R Ver 10 (build 11).__My problem is trying to connect directly to an Access 97 file.__Error message displayed is "Database access [ODBC Microsoft access driver] syntax error in FROM clause..."____I used the help menu but that seems to lead me into the ODBC Data S...