lo folks,
I encountered big probs converting a VBS Connection method to Perl. It is a Access97 (*.mdb) DB which is generated at runtime on an ASP-Server using VBS.
In the Global.asa the DB connection is established using this connectionstring:
"Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;User ID=Admin;Data Source=d:\ShopONLINE\shoponweb\74\AccessDB\shop.mdb;Mode=Share Deny None;Extended Properties="";COUNTRY=0;CP=1252;LANGID=0x0409"";Locale Identifier=1033;Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB
atabase Password="""";Jet OLEDB:Global Partial Bulk Ops=2;User Id=Admin;"
The interesting part is the Provider="..", this look to me like an ADO-Driver. I downloaded the Win32::ADO module, but the author doesnt mention DSNless DBs.
Anyone knows how to connect to such a DB using perl?
thx a bunch,
apu (apu@gmx.li)
I encountered big probs converting a VBS Connection method to Perl. It is a Access97 (*.mdb) DB which is generated at runtime on an ASP-Server using VBS.
In the Global.asa the DB connection is established using this connectionstring:
"Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;User ID=Admin;Data Source=d:\ShopONLINE\shoponweb\74\AccessDB\shop.mdb;Mode=Share Deny None;Extended Properties="";COUNTRY=0;CP=1252;LANGID=0x0409"";Locale Identifier=1033;Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB
atabase Password="""";Jet OLEDB:Global Partial Bulk Ops=2;User Id=Admin;"The interesting part is the Provider="..", this look to me like an ADO-Driver. I downloaded the Win32::ADO module, but the author doesnt mention DSNless DBs.
Anyone knows how to connect to such a DB using perl?
thx a bunch,
apu (apu@gmx.li)