MS SqlServer connected via ODBC

Hello out there,
Anyone experienced whit that connection?
If so, I'm interested to get an advice from you.
The problem is that I can't get my dw-retrieval's with args work from appl.
They work fine without args as well as RPC-calls with and without args.
DW-retrieval's from DB-painter work also fine with and without args.
In appl. I tried to change vars to constants with no success.
Here's the message:[Microsoft][ODBC Sql Server Driver]Invalid character
value for cast specifikation.
There's a company decision to change from DB-Library to ODBC due to obsolete
function
for DB-Library in future SqlServer-versions.

Any suggestions or even wise counter-question's asked, would be highly
appreciated.

Regards Bengt �str�m



0
Bengt
10/29/2002 10:05:45 AM
sybase.powerbuilder.datawindow 28057 articles. 5 followers. Follow

3 Replies
544 Views

Similar Articles

[PageSpeed] 51

Which versions of PB and MSSQL?

--
All views expressed in this message are my own and not necessarily those of
my employer


"Bengt �str�m" <nospam@nowhere.se> wrote in message
news:$mKApTzfCHA.249@forums.sybase.com...
> Hello out there,
> Anyone experienced whit that connection?
> If so, I'm interested to get an advice from you.
> The problem is that I can't get my dw-retrieval's with args work from
appl.
> They work fine without args as well as RPC-calls with and without args.
> DW-retrieval's from DB-painter work also fine with and without args.
> In appl. I tried to change vars to constants with no success.
> Here's the message:[Microsoft][ODBC Sql Server Driver]Invalid character
> value for cast specifikation.
> There's a company decision to change from DB-Library to ODBC due to
obsolete
> function
> for DB-Library in future SqlServer-versions.
>
> Any suggestions or even wise counter-question's asked, would be highly
> appreciated.
>
> Regards Bengt �str�m
>
>
>


0
Simon
10/29/2002 10:45:52 AM
A: PB 8.0.1 Build 9056
     ODBC 2000.80.194.00

"Simon Caldwell [TeamSybase]" <simonDOTcaldwellATbigfootDOTcom> skrev i
meddelandet news:jCopQqzfCHA.249@forums.sybase.com...
> Which versions of PB and MSSQL?
>
> --
> All views expressed in this message are my own and not necessarily those
of
> my employer
>
>
> "Bengt �str�m" <nospam@nowhere.se> wrote in message
> news:$mKApTzfCHA.249@forums.sybase.com...
> > Hello out there,
> > Anyone experienced whit that connection?
> > If so, I'm interested to get an advice from you.
> > The problem is that I can't get my dw-retrieval's with args work from
> appl.
> > They work fine without args as well as RPC-calls with and without args.
> > DW-retrieval's from DB-painter work also fine with and without args.
> > In appl. I tried to change vars to constants with no success.
> > Here's the message:[Microsoft][ODBC Sql Server Driver]Invalid character
> > value for cast specifikation.
> > There's a company decision to change from DB-Library to ODBC due to
> obsolete
> > function
> > for DB-Library in future SqlServer-versions.
> >
> > Any suggestions or even wise counter-question's asked, would be highly
> > appreciated.
> >
> > Regards Bengt �str�m
> >
> >
> >
>
>


0
Bengt
10/29/2002 11:53:20 AM
..... and Sql 7.0

"Bengt �str�m" <nospam@nowhere.se> skrev i meddelandet
news:q$sDvP0fCHA.249@forums.sybase.com...
> A: PB 8.0.1 Build 9056
>      ODBC 2000.80.194.00
>
> "Simon Caldwell [TeamSybase]" <simonDOTcaldwellATbigfootDOTcom> skrev i
> meddelandet news:jCopQqzfCHA.249@forums.sybase.com...
> > Which versions of PB and MSSQL?
> >
> > --
> > All views expressed in this message are my own and not necessarily those
> of
> > my employer
> >
> >
> > "Bengt �str�m" <nospam@nowhere.se> wrote in message
> > news:$mKApTzfCHA.249@forums.sybase.com...
> > > Hello out there,
> > > Anyone experienced whit that connection?
> > > If so, I'm interested to get an advice from you.
> > > The problem is that I can't get my dw-retrieval's with args work from
> > appl.
> > > They work fine without args as well as RPC-calls with and without
args.
> > > DW-retrieval's from DB-painter work also fine with and without args.
> > > In appl. I tried to change vars to constants with no success.
> > > Here's the message:[Microsoft][ODBC Sql Server Driver]Invalid
character
> > > value for cast specifikation.
> > > There's a company decision to change from DB-Library to ODBC due to
> > obsolete
> > > function
> > > for DB-Library in future SqlServer-versions.
> > >
> > > Any suggestions or even wise counter-question's asked, would be highly
> > > appreciated.
> > >
> > > Regards Bengt �str�m
> > >
> > >
> > >
> >
> >
>
>


0
Bengt
10/29/2002 1:15:17 PM
Reply: