ODBC Driver does automatically create tags

[GC_10725709]

Hi,

Setting up an ODBC client for the first time here. When I use fixed table Kepware throws an error after the setup saying "Kepware is unable automictically generate tags" . When I go to manually create the tags I'm not sure what to put in the Address section of the Data Properties, as there are no hints available/populated. 

Thanks

[ntripathi · Accepted solution]

Greetings @GC_10725709 

Thank you for reaching out! It seems you’re encountering an issue with Kepware when trying to automatically generate tags for a fixed table using the ODBC client. Here are some steps you can take to address this issue:

• Changing KEPServer from running as a System service to an Interactive Process will pass Windows credentials to the DSN to allow the database to return tags.
  1. Right-click on the KEPServer Administration Icon in the system tray
  2. Select Settings
  3. Select Runtime Process
  4. Change to Interactive
  5. Auto Generate tags through Device Properties
  6. Change process back to System Service

Please take a look at the following article as it may help resolve your issue:

https://www.ptc.com/en/support/article/CS334154

If you are prompted to log in to view the complete article, you can use your MyKepware login credentials.

[GC_10725709]

Thank you that worked perfect. Thanks again. 

[MS_9937986]

Faced the same issue with AD / Windows Authentication when setting up the DSN. when switching to SQL authentication + sa user/pass the issue is resolved.

Must an SQL permissions issue (despite windows authenticated user was an sa / db owner in SQL).

[GC_10725709]

<meta http-equiv="Content-Type" content="text/html; charset=us-ascii" />

I did all sql authentication for this project.