RE: [Arsperl-users] Database connection to populate ARS form

[Mark V. <mva...@ev...>]

Thomas,
Thanks for the info.  I managed to get it working after much
consternation dealing with the dbi-users mailing list.

Thanks again,
Mark

Mark Vaughan

Programmer III

=20

Direct: +1 303 802 2426

Cell: +1 303 601 4434

Fax: +1 303 802 1420

mar...@ev...

Evolving Systems, Inc.=20

9777 Pyramid Court, Suite 100, Englewood, CO USA 80112

www.evolving.com


-----Original Message-----
From: ars...@ar...
[mailto:ars...@ar...] On Behalf Of Thomas Worth
Sent: Friday, April 29, 2005 8:00 AM
To: ars...@ar...
Subject: Re: [Arsperl-users] Database connection to populate ARS form

Mark,

I have done this in the past.  You need to have client
software on the Solaris box to connect to SQL Server.=20
I used a package called FreeTDS to do this.  Then, I
used the DBD::Sybase module to use DBI to access SQL.=20
Since SQL Server was forked from Sybase, the Sybase
module works.

HTH,

Tom Worth
--- Mark Vaughan <mva...@ev...> wrote:
> This is not a specific ARSperl question.
>=20
> =20
>=20
> I am trying to copy data from an MS SQL Server
> database into an ARS
> form.  The perl script is running on a Solaris 5.8
> box with perl 5.6.1
> but the source DB is on a Win2k server.  I have
> installed the DBI module
> from CPAN and read the docs, but I still can't get a
> connection.
>=20
> =20
>=20
> My environment:
>=20
> Solaris 5.8
>=20
> Perl 5.6.1
>=20
> ARSperl: 1.83
>=20
> AR API: 6.0
>=20
> =20
>=20
> MS database is running on a Win 2000 Server.
>=20
> =20
>=20
> Any and all help would be greatly appreciated.
>=20
> =20
>=20
> Thanks,
>=20
> Mark
>=20
> =20
>=20
> Mark Vaughan
>=20
> Programmer III
>=20
> =20
>=20
> Direct: +1 303 802 2426
>=20
> Cell: +1 303 601 4434
>=20
> Fax: +1 303 802 1420
>=20
> mar...@ev...
> <mailto:mar...@ev...>=20
>=20
> Evolving Systems, Inc.=20
>=20
> 9777 Mt. Pyramid Court, Suite 100, Englewood, CO USA
> 80112
>=20
> www.evolving.com
>=20
> =20
>=20
> This e-mail and any attachments may be confidential
> and/or legally privileged. If you have received this
> e-mail and you are not a named addressee, please
> inform Evolving Systems TIS at ti...@ev... and
> then delete the e-mail from your system. If you are
> not a named addressee you must not use, disclose,
> distribute, copy, print or rely on this e-mail. To
> ensure regulatory compliance and for the protection
> of our clients and business, Evolving Systems may
> monitor and read e-mails sent to and from its
> servers. Although Evolving Systems routinely screens
> for viruses, addressees should scan this e-mail and
> any attachments for viruses. Evolving Systems makes
> no representation or warranty as to the absence of
> viruses in this e-mail or any attachments.=20
>=20
> Registered Office: 9777 Mt. Pyramid Ct Suite 100,
> Englewood, CO 80112
>=20



-------------------------------------------------------
SF.Net email is sponsored by: Tell us your software development plans!
Take this survey and enter to win a one-year sub to SourceForge.net
Plus IDC's 2005 look-ahead and a copy of this survey
Click here to start!  http://www.idcswdc.com/cgi-bin/survey?id=3D105hix
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users
This e-mail and any attachments may be confidential and/or legally privil=
eged. If you have received this e-mail and you are not a named addressee,=
 please inform Evolving Systems TIS at ti...@ev... and then delete t=
he e-mail from your system. If you are not a named addressee you must not=
 use, disclose, distribute, copy, print or rely on this e-mail. To ensure=
 regulatory compliance and for the protection of our clients and business=
, Evolving Systems may monitor and read e-mails sent to and from its serv=
ers. Although Evolving Systems routinely screens for viruses, addressees =
should scan this e-mail and any attachments for viruses. Evolving Systems=
 makes no representation or warranty as to the absence of viruses in this=
 e-mail or any attachments.=20

Registered Office: 9777 Mt. Pyramid Ct Suite 100, Englewood, CO 80112