Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Nithyanand Gnanamoorthy (NithyanandG)
Ford Motor Private Ltd

Ford Motor Private Ltd
IN
NithyanandG Member since 2018 1 post
Ford Motor Private Ltd
Posted: Jan 9, 2019
Last activity: Jan 23, 2019
Posted: 9 Jan 2019 3:09 EST
Last activity: 23 Jan 2019 21:33 EST
Closed

Connecting ODBC through MS Access

I have a SQL Query already designed in MS Access which extracts data from ODBC Connection through authentication. While i execute the query using OLEDB Execute Query the automation is starting but not getting executed. Authentication pop up window also is not coming up which is coming while is test the query in properties pane. Need support to execute the query and download the datatable onto an excel file.

To see attachments, please log in.
Data Integration

  • Abhisek Sau
Posted: 6 years ago
Updated: 6 years ago
Posted: 23 Jan 2019 21:33 EST
Updated: 23 Jan 2019 21:32 EST
Nithyanand Gnanamoorthy (NithyanandG)
Ford Motor Private Ltd

Ford Motor Private Ltd
IN

I had found the same query in another post and the suggestion was to program the code to provide credentials as it is not possible to interogate the popup created during query execution.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice