Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

error datetime convertion in ms sql server ?

2 posts in Powerscript Last posting was on 2000-10-16 16:38:24Z
Rw Posted on 2000-10-03 09:20:26Z
Newsgroups: sybase.public.powerbuilder.powerscript
Date: Tue, 03 Oct 2000 16:20:26 +0700
From: Rw <goldbase@centrin.net.id>
Organization: Goldbase Technology
X-Mailer: Mozilla 3.04Gold (Win95; I)
MIME-Version: 1.0
Subject: error datetime convertion in ms sql server ?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 28
NNTP-Posting-Host: 202.146.238.219
Message-ID: <368_39D9A4DA.D55@centrin.net.id>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.powerscript:6974
Article PK: 780554

We custom a datawindow, and when execute it, an error came out :

SQLSTATE=22008
[Microsoft][ODBC SQL Server Driver][SQL Server] Syntax error
converting datetime from character string.


The sql statement is :

SELECT nobuk, tgl, nobuk2, cab, tot1
FROM "icpakai"
WHERE tipe = :tipe_ws and nobuk LIKE rtrim(:nobuk_ws) + '%'

tgl is the datetime field.

the odbc profile is :

// Profile as3000mf7
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm =
"ConnectString='DSN=as3000mf7;UID=sa;PWD=',PacketSize=4096,DisableBind=1"


If we omitted the DisableBind in the dbparm, it works fine. But is there
any way to keep the 'DisableBind' work ?

We will appreciate for any help. Thanks.
--

Best regards,


Ridwan
Goldbase Technology

Visit our Homepage :
http://www.pembukuan.com
http://members.xoom.com/goldbase
http://www.ibi.co.id/goldbase
http://members.tripod.com/goldbase
http://www.geocities.com/Wallstreet/Floor/5251/index.html

ICQ : 72084395


Bruce Armstrong [TeamSybase] Posted on 2000-10-16 16:38:24Z
Newsgroups: sybase.public.powerbuilder.powerscript
From: "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
Organization: TeamSybase [12.13.238.141]
X-Newsreader: AspNNTP 1.50 (Advent 2000, Inc.)
Subject: Re: error datetime convertion in ms sql server ?
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Date: Mon, 16 Oct 2000 12:38:24 -0400
Lines: 45
NNTP-Posting-Host: 207.156.232.111
Message-ID: <368_tbVpA#4NAHA.267@forums.sybase.com>
References: <368_39D9A4DA.D55@centrin.net.id>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.powerscript:6893
Article PK: 754695

What version of PB?

On Tue, 03 Oct 2000 16:20:26 +0700,
in powersoft.public.powerbuilder.powerscript

Rw <goldbase@centrin.net.id> wrote:
>We custom a datawindow, and when execute it, an error came out :
>
> SQLSTATE=22008
> [Microsoft][ODBC SQL Server Driver][SQL Server] Syntax error
> converting datetime from character string.
>
>
>The sql statement is :
>
> SELECT nobuk, tgl, nobuk2, cab, tot1
> FROM "icpakai"
> WHERE tipe = :tipe_ws and nobuk LIKE rtrim(:nobuk_ws) + '%'
>
>tgl is the datetime field.
>
>the odbc profile is :
>
> // Profile as3000mf7
> SQLCA.DBMS = "ODBC"
> SQLCA.AutoCommit = False
> SQLCA.DBParm =
>"ConnectString='DSN=as3000mf7;UID=sa;PWD=',PacketSize=4096,DisableBind=1"
>
>
>If we omitted the DisableBind in the dbparm, it works fine. But is there
>any way to keep the 'DisableBind' work ?
>
>We will appreciate for any help. Thanks.
>--
>
>Best regards,
>
>
>Ridwan
>Goldbase Technology
>
>Visit our Homepage :
> http://www.pembukuan.com
> http://members.xoom.com/goldbase
> http://www.ibi.co.id/goldbase
> http://members.tripod.com/goldbase
> http://www.geocities.com/Wallstreet/Floor/5251/index.html
>
>ICQ : 72084395
>
>

Bruce Armstrong [TeamSybase]
mailto:Bruce.Armstrong@teamsybase.com

Preach the gospel at all times. If necessary, use words. [Francis of Assisi]
http://www.kidbrothers.org | http://www.fccwc.org
http://www.harvest.org/knowgod/index.htm | http://www.needhim.org
http://www.jesusfilm.org/view/realvideo/rv/languages/english.ram

-----------== Posted via the PFCGuide Web Newsreader ==----------
http://www.pfcguide.com/_newsgroups/group_list.asp