[Solved]test connection using connect database

Hi Guys,

I want to connect database using connect database activity but i got an error cannot open the microsoft jet engine workgroup information file


Don’t know why about this error, because some time ago im running this activity and doesnt encounter any problem. Now im running this and got this error.
Can you please tell me about this error? Im currently in lost about this error

Regards

Delf

1 Like

Hi @delf

Is the Package for Database is Updated?

Thanks
Ashwin S

@delf,The database file which you have selected is from the Database?If yes then did you provide the username and password to log in

Thanks,
Sreekanth.k

Hi @AshwinS2

Yes, i’ve checked and im using the latest updated (no update after im checked the packages)
Thanks

Hi @sreekanth
Yes the database file is xxx.mdb that i’ve selected. No need username & password for me to open it so usually im just leave it blank for password and username is default admin as far as i know.

Thanks

Regards

Delf

Hi all,

For this problem i already found the answer
use this
"Driver={Microsoft Access Driver (*.mdb)};DBQ=“Path_file”
“System.Data.Odbc”
instead of using "Provider=Microsoft.JET.OLEDB.4.0
and make sure to download and install microsoft access database engine 2010 match with your office version (32 bit or 64 bit)

Thanks

Best Regards

Delf

1 Like