Database not found error. There is no open data connection.

wannakatana — Thu, 27 Sep 2018 18:12:31 GMT

I've been running this script successfully many times but now I get this error. I'm connecting to an Access database on my desktop. It's not open, I repaired and compacted it just in case. I moved it into a subfolder. Nothing has resolved the issue. Why would it all of a sudden give me this error after working many times? I didn't change the Access database in any way.

the first commented one worked then gave the error so I made another one below and it still gives the same error.

//OLEDB CONNECT32 TO [Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Users\ZY0004\Desktop\OutageWork\Outage Work off.mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False];

//LOAD ID,
// `MDR Date 0`,
// many more fields

//FROM `Outage Dates`;
//

2nd try:

OutageDates:OLEDB CONNECT32 TO [Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Users\ZY0004\Desktop\OutageWork\Outage Work off.mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False];
SQL SELECT *
FROM `Outage Dates`;

Re: Database not found error. There is no open data connection.

wannakatana — Thu, 27 Sep 2018 21:37:48 GMT

apparently it was some type of corruption as moving the code to a new project resolved the issue.

topic Re: Database not found error. There is no open data connection. in QlikView

Database not found error. There is no open data connection.

Re: Database not found error. There is no open data connection.