Reserved Error (-7748); there is no message for this error

  • Thread starter Thread starter James D Smooth
  • Start date Start date
J

James D Smooth

I have seen many posts with this error when trying to either Link or
Import data into Access 2000 from Sybase Tables. I have a new twist on
this error and wondering if anyone has found a solution that works.

When I grab a group of Sybase Tables to Link / Import the error appears
only on certain tables, not all. The tables that do Link / Import
without the error seem to work without issue. One other thing that I've
noticed is that if you use an older database or a database that was
created by someone else it works fine? The ODBC Settings are identical,
and I actually have 2 old ODBC Sybase Connections that work without
issue, and 1 that I just tried to create that causes this error? It
almost seems like a Microsoft Patch changed something, but I can't be
sure.
 
I have found a solution to the issue.

Add a New String Value to the following Registry Keys
\\HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\(YOUR_DSN_NAME)
\\HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\(YOUR_DSN_NAME)

New String Name = WorkArounds2
Value = 40960 (I have also tested another suggestion which worked 8192)
 
Back
Top