FactoryTalk SE: Failed to Open ODBC Database Error

[Maulik Dudani 0]

Can any one give a solution to this. I have created Database to one folder. now i am configuring in data logging setup with ODBC File Selection But when i am giving path to ODBC Data Source and click on Create Tables then it shows Error: Failed to open ODBC Database. Please help me Out.

[kaiser_will 65]

Solving your problem, ODBC Database Connection Error, is much more involved than a simple fix.  

This system was working before you made a change?

You are trying to add a table to the existing database in what manner?

[Maulik Dudani 0]

Sir I am Trying this first time.

I have Created a database file in Microsoft Access Using Administrative Tools, ODBC Setup. Then I am trying to give the path of this database file to factorytalk database setup in ODBC File Selection. Anther Problem is that there is no Browse Button in "ODBC Data Source File:", so i am giving a file path Manually by Copying the path from file location. But then when i am clicking on create Table Button it shows Error: "Failed to Open ODBC Datafile".

Edited 23 May 2017 by Maulik Dudani

[kaiser_will 65]

Have you thoroughly read the FTViewSE User Guide?  This process is very particular that the steps be executed in the proper manner.  This 6-page work instruction may be of use for your task. 

FTView Studio - Event Data Collection.doc

[Maulik Dudani 0]

Sir,

What If i want to use Microsoft Access Instead of SQL Server Management?

[Maulik Dudani 0]

Sir,

What If i want to use Microsoft Access Instead of SQL Server Management?

[Maulik Dudani 0]

Sir,

What If i want to use Microsoft Access Instead of SQL Server Management?