Forum Discussion
MS Access DB dataset refresh using enterprise gateway error
After working with Microsoft support we arrived at following solutions:
1. If you want to use ODBC to access Access DB file on server other than the one on which the gate is you have to give the account that is used to authenticate gateway access Admin level privileges. This is linked to the fact, that it needs to modify registry HKEY_LOCAL_MACHINE\SOFTWARE\ODBC and when using a local account without admin rights it is unable to do so.
2. Use access trough FOLDER (i.e. create gate to the folder in which the DB is kept) and after navigating to the file expand Data column. In my case this was not working initially, becouse we did not have all necessary drivers installed.
In Desktop , you can connect to MS Access DB with ODBC , and it is successful . In Service , you can also use ODBC to configure your data source in Manage gateways as the link mentioned .
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Dear Ailsa,
Unfortunately when I try ODBC method it works only on Desktop version. When trying to create Gateway connection I'm getting following error (sorry for long text):
Details: GatewayXXXXXXXXXXXX: ODBC: ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x2fbf0 Thread 0x2f610 DBC 0xce241458 Jet'. ERROR [01S00] [Microsoft][ODBC Microsoft Access Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Microsoft Access Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Microsoft Access Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Microsoft Access Driver]Invalid connection string attribute Trusted_Connection ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x2fbf0 Thread 0x2f610 DBC 0xce241458 Jet'. ERROR [01S00] [Microsoft][ODBC Microsoft Access Driver]Invalid connection string attribute Trusted_Connection ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Your network access was interrupted. To continue, close the database, and then open it again. ERROR [01S00] [Microsoft][ODBC Microsoft Access Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Microsoft Access Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Microsoft Access Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Microsoft Access Driver]Invalid connection string attribute Trusted_Connection ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x2fbf0 Thread 0x2f610 DBC 0xce241458 Jet'. ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x2fbf0 Thread 0x2f610 DBC 0xce241458 Jet'. ERROR [01S00] [Microsoft][ODBC Microsoft Access Driver]Invalid connection string attribute Trusted_Connection ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Your network access was interrupted. To continue, close the database, and then open it again. Please have this information handy if you choose to create a support ticket. ActivityId: 132169cc-3e06-459f-94ee-7ef0478444a2 RequestId: e4f1082f-16b7-456f-9349-4a8ffa63c3a0 Cluster URI: https://api.powerbi.com Status code: 400 Time: Thu Sep 15 2022 12:15:47 GMT+0200 (Central European Summer Time)