Home > Archive > ASE Database forum > October 2005 > ODBC error in excel









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 ODBC error in excel
cd

2005-10-27, 8:21 am

I am running an ase 15 stored procedure in excel
Driver 15.0.0.50
Driver ODBC version 03.51

The procedure should return 18990 rows. I keep getting an
error "Dataoverflow. Increase specified column size or
buffer size"
and the proc returns 172 rows.

Any ideas on how to correct this?
Andrew Schonberger

2005-10-27, 8:21 am

try "set ansinull off"
This setting modifies the behavior of many stored procs. In Artisan or
ISQL, the default is off. In ODBC, the default is "on".

You can try adding this statement to the start of your stored proc, if
you have the possibility of recompiling it. Or, the ODBC datasource
usually has a filed where you can enter an initial command, which the
driver executes for you immediately after connecting.

cd wrote:

>I am running an ase 15 stored procedure in excel
>Driver 15.0.0.50
>Driver ODBC version 03.51
>
>The procedure should return 18990 rows. I keep getting an
>error "Dataoverflow. Increase specified column size or
>buffer size"
>and the proc returns 172 rows.
>
>Any ideas on how to correct this?
>
>

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com