That worked. Thanks loads.
-- In vantage@yahoogroups.com, "Dave Olender" <dolender@...> wrote:
-- In vantage@yahoogroups.com, "Dave Olender" <dolender@...> wrote:
>found
> Mr. Charles: I ran into the same error using my Vista 64bit and
> the following on the Progress site. Add the registry key10.1x
> Workarounds2=40696 to fix this.
>
> ID: P116845
> Title: "Reserved error -7748 when attempting to link a OpenEdge
> Database table in Microsoft Access"driver]
>
> Created: 06/20/2006 Last Modified: 09/24/2007
> Status: Unverified
>
> Facts:
>
> OpenEdge 10.1A
> OpenEdge 10.1B
> Progress OpenEdge 10.1A driver
> Progress OpenEdge 10.1B driver
> Windows
>
>
>
> Symptoms:
>
> Error attempting to link a OpenEdge Database table in MS Access
> Reserved error (-7748): there is no message for this error
> Error in ODBC trace file
> DIAG [01004] [DataDirect][ODBC Progress OpenEdge Wire Protocol
> String data, right truncated. Error in column 10. (0)10.1A
> Problem occurs when using the 5.1 DataDirect driver shipped with
> Problem occurs when using the 5.1 DataDirect driver shipped with10.1B
> Problem does not occur with the 4.2 DataDirect driver shipped with10.0B
>any
>
>
>
> Cause:
> Known issue with the DataDirect driver
>
>
> Fixes:
>
> WARNING - You should always make a backup of the Registry before
> changes.ODBC ->
>
> To resolve this error, set WorkArounds2=8192 for the affected data
> source. This can be done by using the Registry Editor (RegEdit).
>
> 1. Run RegEdit
>
> 2. Locate the ODBC DSN in the Registry:
>
> For a USER Data Source, go to HKEY_CURRENT_USER -> Software ->
> ODBC.INI -> YourDataSourceNameODBC -
> For a SYSTEM Data Source, go to HKEY_LOCAL_MACHINE -> Software ->
> > ODBC.INI -> YourDataSourceNameadded
>
> 3. Click on the folder for your data source; from the menu choose:
> Edit -> New -> String Value
>
> 4. Set the name of the new string value to be WorkArounds2
>
> 5. Double click on WorkArounds2 in the right hand panel; this will
> bring up a dialog box with a data value field
>
> 6. Change the data value to 8192 (The string value that must be
> to Windows XP SP2 and Progress 10.1A02 is WorkArounds2=40960)to
>
> 7. Click OK
>
> 8. Close RegEdit
>
> PCs running Windows 95 and 98 need to be rebooted for this setting
> take effectcalls
>
> WorkArounds2=8192. Workaround for Microsoft Access 2000 when it
> SQLStatisticsW and SQLGetData for column number 10. Microsoft Accessinsufficient
> only asks for the data as a two-byte SQL_C_WCHAR, which is
> buffer to store the UCS2 character and the null terminator. Thus,the
> the driver returns a warning, "01004 Data truncated", and returns a
> null character to Microsoft Access. Microsoft Access then passes
> error -7748. Setting this workaround causes Microsoft Access to not
> pass the error -7748.
>
>
> Good Luck,
>
> Dave Olender dolender@...
> Ph: 651-246-3281
>
>
> --- In vantage@yahoogroups.com, "charles06072006" <shadow031449@>
> wrote:
> >
> > I have been trying to add a link table to an access database with
> > new Progress OpenEdge 10.1B ODBC driver for 8.03.403d. Every timeI
> > make the attempt I get this error message:fine.
> >
> > Reserved error (-7748); there is no message for this error.
> >
> > I have existing link tables in the access database and they work
> > I just can't set up a new link. If I delete a current linkedtable I
> > am also not able to relink it. I have tried this in Windows Vista2003.
> > (32bit) with Office 2007 and in Windows XP (32bit) with Office
> > Same message both places.
> >
> > Anyone have any ideas?
> >
>