Using the Microsoft SQL Server 2000 with Axiant 3.4 through an ODBC interface
Keld Pedersen
kpe@scanconsult.dk
Wed, 10 Jul 2002 12:50:09 +0200
This is a multi-part message in MIME format.
------=_NextPart_000_0007_01C22810.52D9ABE0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello.
We are using Microsoft SQL Server 2000 SP1 and accessing it through an =
ODBC driver as the
database connection for Axiant v 3.4B.
In client server developing, we wish to put a great deal of intelligence =
on the server, programmed
as stored procedures.=20
Using e.g. Sybase gives the possibility of using RESULT SETs returned =
from a stored procedure in the database. Has anyone tried this with the =
MSSQL 2k server?
And if so, have you succeeded in this.
And if no succes, it would be fine to have workaround procedure for =
this.
We would appreciate comment, answers and solutions for this.
Mange hilsner / With kind regards
Keld Pedersen
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
E-mail: kpe@scanconsult.dk Direct Phone: =
+45 8738 7473
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
ScanConsult IT-Partners ApS Voice =
: +45 8738 7474
Jegstrupvej 96A =
Fax : +45 8738 7475
DK-8361 Hasselager Support : =
support@scanconsult.dk
Denmark Sales : =
sales@scanconsult.dk
http://www.scanconsult.dk =
=20
=3D ParaSuite : A Suite of Air Cargo Handling solutions =
=3D
=3D ParaSafe : A Suite of IT-Security solutions =
=3D
=3D Partners : Hewlett-Packard, Cognos, Microsoft and more =
=3D
------=_NextPart_000_0007_01C22810.52D9ABE0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2713.1100" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hello.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>We are using Microsoft SQL Server 2000 =
SP1 and=20
accessing it through an ODBC driver as the</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>database connection for Axiant v =
3.4B.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>In client server developing, we wish to =
put a great=20
deal of intelligence on the server, programmed</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>as stored procedures. </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Using e.g. Sybase gives the possibility =
of using=20
RESULT SETs returned from a stored procedure in the database. Has anyone =
tried=20
this with the MSSQL 2k server?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>And if so, have you succeeded in =
this.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>And if no succes, it would be fine to =
have=20
workaround procedure for this.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>We would appreciate comment, answers =
and solutions=20
for this.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Mange hilsner / With kind =
regards</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Keld Pedersen</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial=20
size=3D2>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR>E-mail: <A=20
href=3D"mailto:kpe@scanconsult.dk">kpe@scanconsult.dk</A> &nbs=
p;  =
; =
Direct=20
Phone: +45 8738=20
7473<BR>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR>ScanConsult=20
IT-Partners=20
ApS &nbs=
p;  =
; =
Voice =20
: +45 8738 7474<BR>Jegstrupvej=20
96A &nbs=
p; =20
=
=20
=
=20
Fax : +45 =
8738=20
7475<BR>DK-8361 =
Hasselager =20
=
=20
Support : =
<A=20
href=3D"mailto:support@scanconsult.dk">support@scanconsult.dk</A><BR>Denm=
ark &nbs=
p;  =
; =
&=
nbsp; Sales :&n=
bsp;=20
<A=20
href=3D"mailto:sales@scanconsult.dk">sales@scanconsult.dk</A><BR> &n=
bsp; =20
=
=20
=20
&=
nbsp; =20
<A=20
href=3D"http://www.scanconsult.dk">http://www.scanconsult.dk</A> &nb=
sp; &nbs=
p; =20
<BR></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>=3D ParaSuite : A Suite of Air =
Cargo Handling=20
solutions &nbs=
p;  =
; =
=3D<BR>=3D=20
ParaSafe : A Suite of IT-Security=20
solutions &nbs=
p;  =
; =
&=
nbsp; =3D<BR>=3D=20
Partners : Hewlett-Packard, Cognos, Microsoft and=20
more &nb=
sp; &nbs=
p; =3D</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML>
------=_NextPart_000_0007_01C22810.52D9ABE0--