I am the current maintainer of DBD::ODBC

WOW, thank heavens for that :-)

Ok, I wonder if you can help me please (this may seem very simple but I am having kittens already)

I have this script

#! c:/perl/bin/perl.exe
#
# 
#
#
#
use strict;

use DBI;
use DBD::ODBC;
use DBD::ADO;

use Win32::OLE;
use Win32::ODBC;
#use Win32::SqlServer;


my $server = "ABCB00062\\Dev";
my $dbusername = "uk_ggg\\xyz12345";
my $dbpassword = '7seven7';
my $database = 'ukdevxxxx';

my $Error_Message = "\nThere Was A Problem Connecting To The Database\
+n";

my $dbh;    #Database Handler

#$dbh = DBI->connect("DBI:ODBC:driver={SQL Server};Server=$server;Data
+base=$database;UID=$dbusername;PWD=$dbpassword") ||  die "$Error_Mess
+age $DBI::errstr";

$dbh = DBI->connect("DBI:ODBC:dsnname;Server=$server;Database=$databas
+e;UID=$dbusername;PWD=$dbpassword")
[download]

But when I run it i get the following error

U:\Doccuments\Scripts\Start>db2.pl
DBI connect('dsnname;Server=ABCB00062\Dev;Database=ukdevxxxx;UID=uk_gg
+g\\xyz12345;
PWD=7seven7','',...) failed: [Microsoft][ODBC Driver Manager] Data sou
+rce
name not found and no default driver specified (SQL-IM002) at U:\Doccu
+ments\Scri
pts\Start\db2.pl line 32
[download]

I thought I had all the requirements in place! Would it be possible for you please to advise me on what I need to do? Thanks in advance