|
Home > Archive > Sybase ODBC > August 2005 > Reserved Error (-7748)...
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Reserved Error (-7748)...
|
|
| penny.robinson@eds.com 2005-08-23, 9:23 am |
| Hi,
XP User with Access 2000 and Access 2003: when trying to
link to a Sybase db from either Access versions, I get the
above noted error for one of the 2 dbs on the same server.
Can anyone provide insight or a solution?
Cheers,
Penny
| |
|
| Could you post more detail such as what ODBC driver you are using? And also
if this is Sybase ASE or ASA
<penny.robinson@eds.com> wrote in message
news:430b1805.5c0.1681692777@sybase.com...
> Hi,
>
> XP User with Access 2000 and Access 2003: when trying to
> link to a Sybase db from either Access versions, I get the
> above noted error for one of the 2 dbs on the same server.
> Can anyone provide insight or a solution?
>
> Cheers,
> Penny
| |
|
| Thanks for the prompt reply.
I am using the Sybase ASE ODBC driver syodase.dll (version
4.10.00.00). Please note: I am able to link to my Sybase
server
using this driver. I have two dsn's setup that are for two
different
dbs on this server (the only differences in the
configuration
between the two dsn's are the db name and the dsn name).
Cheers,
P
> Could you post more detail such as what ODBC driver you
> are using? And also if this is Sybase ASE or ASA
> <penny.robinson@eds.com> wrote in message
> news:430b1805.5c0.1681692777@sybase.com...
>
>
| |
| Murali 2005-08-25, 3:28 am |
| P,
This looks like a known problem documented in the ODBC
driver readme as below:
WorkArounds2=8192. Workaround for Microsoft Access 2000 when
it calls SQLStatisticsW and SQLGetData for column number 10.
Microsoft Access only asks for the data as a two-byte
SQL_C_WCHAR, which is insufficient buffer to store the UCS2
character and the null terminator. Thus, 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.
See whether this applies in your case.
HTH
[color=darkred]
> Thanks for the prompt reply.
> I am using the Sybase ASE ODBC driver syodase.dll (version
> 4.10.00.00). Please note: I am able to link to my Sybase
> server
> using this driver. I have two dsn's setup that are for
> two different
> dbs on this server (the only differences in the
> configuration
> between the two dsn's are the db name and the dsn name).
> Cheers,
> P
>
|
|
|
|
|