Are you actually using the ODBC DSN connections?
I created the DSN's and when I click test they says it OK
However if I use an application to connect to these DSN's it says generic:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (SQL-IM002)
I reused the script for local connections to work on a remote via the ODBC but it says the same as other applications when they try to hook up to the DSN
use DBI;
my ($dbh, $cur, $sqlstr);
my $connString = "dsn=cmf;uid=lmsdatafeed";
$dbh = DBI->connect('DBI:ODBC:DSN', $connString, 'didata', {PrintError => 1});
if ($dbh) {
my $sqlstr = "SELECT Device_Id, Device_Display_Name, Management_IPAddress FROM Network_Devices";
my $cur = $dbh->prepare($sqlstr);
$cur->execute if ($cur);
while (my $rs = $cur->fetchrow_arrayref) {
my ($devId, $dispName, $ip,) = @$rs;
print "Device_Id: $devId\n";
print "Device_Display_Name: $dispName\n";
print "Management_IPAddress: $ip\n";
print "--------------------------------------------\n";
}
$cur->finish;
$dbh->disconnect();
}
Does anyone see what I miss here?
Cheers,
Michel
