08-02-06, 04:25 #1Registered User
- Join Date
- Aug 2006
Unanswered: Linux Perl to MSSQL Server using Freetds & Sybase
i have been having trouble trying to understand what exactly is going on if anyone had the same experience as me please do let me know.
I am trying to make my perl script on my Centos box talk to a MSSQL server.
I have installed the freetds package and the sybase driver .Which a DBI trace give me the following
Data Source is DBIBM:f_dir=.
Data Source is DBIBM:f_dir=freetds-0.64
Data Source is DBIBM:f_dir=DBD-ODBC-1.13
Data Source is DBIBM:f_dir=DBD-Sybase-1.07
Data Source is dbi:ExampleP:dir=.
Data Source is DBI:File:f_dir=.
Data Source is DBI:File:f_dir=freetds-0.64
Data Source is DBI:File:f_dir=DBD-ODBC-1.13
Data Source is DBI:File:f_dir=DBD-Sybase-1.07
install_driver(Proxy) failed: Can't locate RPC/PlClient.pm in @INC (@INC contains: /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 .) at /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBD/Proxy.pm line 28.
BEGIN failed--compilation aborted at /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBD/Proxy.pm line 28.
Compilation failed in require at (eval 9) line 3.
Perhaps a module that DBD::Proxy requires hasn't been fully installed
at DBDDriverTester.pl line 19
My Relevant drivers are here.
But when i run my simple connection script
DBI connect('CustomerDB:ADEV01,'wiki',...) failed: (no error string) at mssqltestfinal.pl line 18
couldn't connect to mssql db at mssqltestfinal.pl line 18.
Can anyone shed any light I have installed the PlRPC-0.2018.tar but its another problem but i don't think this is related to the problem i am having as all my other drivers are installed.
Many thanks in advance