| Previous · Next | |
| User | Message |
|
Codeman
|
Date: 2/15/2010 3:16 pm · Subject: Setting up Database Link · Rating: 1
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 [ | ]
|