Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Zeke Hoskin
March 30, 2005, 11:59 pm
rate this thread
I need to write a Perl program to append records to a SQL Server db. I
can connect to it using a connection string lifted from an Access
my $dbh = DBI->connect("DBI:ADO:Provider=Microsoft.Access.OLEDB.10.0;
Persist Security Info=False;Data Source=##NAMEOFSERVER##;
Integrated Security=SSPI;Initial Catalog=##NAMEOFDB##;Data
or die "connection failed: $DBI::errstr\n";
This (surprisingly) works if I just query the database, but if I send
it a correct INSERT statement, it carries it out and then crashes with
no DBI errmsg and a screen that says "Microsoft has to shut down the
Perl database interface". (An incorrect insert just dies properly with
If I edit the Provider= phrase, it very nicely refuses to connect and
dies with a long and informative message. Obviously there is a correct
Provider phrase, but I can't find it. Suggestions?
- » FAQ 6.6 How can I make "\w" match national character sets?
- — Previous thread in » PERL Discussions