plainblack.com
Username Password
search
Bookmark and Share

    

Setting up Database Link

User Codeman
Date 2/15/2010 3:16 pm
Views 1313
Rating 1    Rate [
|
]
Previous · Next
User Message
Codeman

I am having a problem setting up a Database Link to a Microsoft SQL server.  I have installed the FreeTDS ODBC driver and the unixODBC manager, and I can connect to the database using the following Perl script:

use DBI;

my $dbh = DBI->connect('DBI:ODBC:MSSQLServer','sa','sapassword') or die $DBI::errstr;

$dbh->do("use MyDB");

my $rows = $dbh->selectrow_array("SELECT COUNT(*) FROM tblMytable");

print "Mytable has $rows records\n" if ( defined $rows);

 

This script returns the correct row count from my MS SQL server.  However, I cannot get a DSN defined in WebGUI that will connect.  Any advice, instruction, etc. would be greatly appreciated.  I am running the WRE with WebGUI 7.7.31 on Debian 5.03.

 



Back to Top
Rate [
|
]
 
 
    



© 2012 Plain Black Corporation | All Rights Reserved