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

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"  wrote in message
news:[email protected]...
> 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
>
>
>

A: PB 8.0.1 Build 9056
     ODBC 2000.80.194.00

"Simon Caldwell [TeamSybase]"  skrev i
meddelandet news:[email protected]...
> 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"  wrote in message
> news:[email protected]...
> > 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
> >
> >
> >
>
>

..... and Sql 7.0

"Bengt �str�m"  skrev i meddelandet
news:[email protected]...
> A: PB 8.0.1 Build 9056
>      ODBC 2000.80.194.00
>
> "Simon Caldwell [TeamSybase]"  skrev i
> meddelandet news:[email protected]...
> > 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"  wrote in message
> > news:[email protected]...
> > > 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
> > >
> > >
> > >
> >
> >
>
>