Skip to main content
G
GC_107257093-Newcomer
3-Newcomer
May 9, 2024
Solved

ODBC Driver does automatically create tags

  • May 9, 2024
  • 2 replies
  • 2001 views

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

Best answer by ntripathi

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.

2 replies

N
ntripathi15-MoonstoneAnswer
15-Moonstone
May 9, 2024

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.

    G
    GC_107257093-NewcomerAuthor
    3-Newcomer
    May 10, 2024

    Thank you that worked perfect. Thanks again. 

    M
    MS_99379867-Bedrock
    7-Bedrock
    June 15, 2024

    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).

    G
    GC_107257093-NewcomerAuthor
    3-Newcomer
    June 15, 2024


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



    I did all sql authentication for this project. 



    Terms & ConditionsCookie settingsAccessibility statement