PowerBuilder connect to Access(get an error SQLSTATE = 01S01 )

microsoft.public.sqlserver.programming

13 Aug 2005 5:06 AM

guo-feng lui via SQLMonster.com

I am trying to connect Microsoft Access Database from PowerBuilder(ODBC),
when execute a select clause, get an error SQLSTATE = 01S01(Row errors), but
trying open the database from Microsoft Access 2000 tools , the row is very
good. I am puzzled this error. Someone help me to this problem, please

13 Aug 2005 9:31 AM

John Bell

Hi

This is a SQL Server newsgroup a better place to post this would be a
powerbuilder or Access newsgroup. Searching google for 01S01 returned quite a
few hits
http://tinyurl.com/79ru9

this one looked promising

http://tinyurl.com/cr6u7

and indicates that is pssibly masking the real error which in this case the
truncation of a string.

John

Show quote

"guo-feng lui via SQLMonster.com" wrote:

> I am trying to connect Microsoft Access Database from PowerBuilder(ODBC),
> when execute a select clause, get an error SQLSTATE = 01S01(Row errors), but
> trying open the database from Microsoft Access 2000 tools , the row is very
> good. I am puzzled this error. Someone help me to this problem, please
>