Mike Lacey created a good FAQ in this forum to address updating an Access Database using the DBI. Take a look and see if that helps you. (It might be a good idea to take a look at the other Database FAQs in this forum as well.)
Just interested -- but why do you need to use a DSN-less connection? (didn't know you could do that) Mike
________________________________________________________________________________
"Experience is the comb that Nature gives us, after we are bald."
Is that a haiku?
I never could get the hang
of writing those things.
I use ADO a fair bit in vbscript and vb programs. It is very convenient to write a program and be able to run it on any windows machine and not worry about having to first set up the ODBC connection. The best URL I've found for ADO connection strings is
I am assuming that since Perl can use ADO, then this aspect may also be implemented. This may be a big assumption on my part. As you may guess, I am a beginner with Perl but it looks like a neat language to get results and I may have to interact more with Unix systems.
print ("\tADO DSN-Less to pubs database on local MS Access database. \n"
print "\n";
# Create ADO auto object
$conn = CreateObject OLE "ADODB.Connection" ||
die "Error on ADO CreateObject: $!" ;
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.