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

[Thomas W. <tm...@ya...>]

Mark,

I have done this in the past.  You need to have client
software on the Solaris box to connect to SQL Server. 
I used a package called FreeTDS to do this.  Then, I
used the DBD::Sybase module to use DBI to access SQL. 
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.
> 
>  
> 
> 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.
> 
>  
> 
> My environment:
> 
> Solaris 5.8
> 
> Perl 5.6.1
> 
> ARSperl: 1.83
> 
> AR API: 6.0
> 
>  
> 
> MS database is running on a Win 2000 Server.
> 
>  
> 
> Any and all help would be greatly appreciated.
> 
>  
> 
> Thanks,
> 
> Mark
> 
>  
> 
> Mark Vaughan
> 
> Programmer III
> 
>  
> 
> Direct: +1 303 802 2426
> 
> Cell: +1 303 601 4434
> 
> Fax: +1 303 802 1420
> 
> mar...@ev...
> <mailto:mar...@ev...> 
> 
> Evolving Systems, Inc. 
> 
> 9777 Mt. Pyramid Court, Suite 100, Englewood, CO USA
> 80112
> 
> www.evolving.com
> 
>  
> 
> 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. 
> 
> Registered Office: 9777 Mt. Pyramid Ct Suite 100,
> Englewood, CO 80112
>