If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > Perl and the DBI > Linux Perl to MSSQL Server using Freetds & Sybase

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-02-06, 04:25
deadpool deadpool is offline
Registered User
 
Join Date: Aug 2006
Posts: 1
Linux Perl to MSSQL Server using Freetds & Sybase

Hi everyone

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

Driver: DBM
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

Driver: ExampleP
Data Source is dbi:ExampleP:dir=.

Driver: File
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

Driver: Proxy
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On