Hi all,
I have written some perl scripts which were converted to *.exe files with
perlApp.
The scripts (running as cgi-scripts) were written to connect to a MySQL
database and it worked fine. Now I have to connect to a MS-SQL database. The
only thing I have changed was the DSN from dbi:mysql:dbm to dbi:ADO:dbm
(where dbm is the name of the database). And now I read the following error
message.
######################
Software error
DBI connect ('dbm', 'username', ...) failed: Can't open connetion 'dbm'
Package : DBD::ADO::dr
Filename : /PerlApp/DBD/ADO.pm
Line : 158
Last error : -2147467259
OLE exception from "Microsoft OLE DB Provider for ODBC Drivers":
[Microsoft][ODBC Driver Manager] The datasourcename was not found and it was
no standarddriver given.
Win32::OLE(0.1701) error 0x80004005: "unknown error"
in METHOD/PROPERTYGET "Open" at login.pl line 92
#######################
What does it tell me?
What went wrong?
What do I have to do?
Is this a problem of configuring the MS-SQL Server or of my script?
Please give me detailed answers.
Any hints are welcome.
Thanks
Sven
_______________________________________________
Perl-Win32-Admin mailing list
Perl-Win32-Admin@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
