IP21 and 12.0

[Former Member]

We have an issue similar to the one that Harold had in this [thread|;

Our ODBC/System DSN connects to IP21 with the 32bit ODBC. As well the Data Servers connection status says "Running" within xMII. But when we create a Tag query within the workbench, it says (with the admin role) "Can not create a connection to the Database." Under the developer role it says "You do not have permission to access the <IP21 Server Name>."

Right now I don't have access to the error logs so I can't tell you what the error message is.

I know in 11.5 we had to go into the Services and change the "Log on as" for the xMII service to get access to our IP21 server. Do we need to do this in 12 as well? If so, what do we need to change?

Could the 32bit ODBC be the cause of the issue?

[salvatore_castro · Accepted solution]

Brian,

Hope all is well in TX....

From the Menu:

Security Services -> Data Access

This will allow you to assign role based access to various data server connections.

Hope this helps.

Sam

[Former Member · Accepted solution]

Ok, we gave access to the Developer role and now both roles are getting the same error message - "Can not create a connection to the Database." My assumption is security on the IP21 side -- it is denying access to the server's local account that xmii is using and sending the query with.

Any thoughts?

=

[Former Member · Accepted solution]

You've go to get access to the logs.

[Former Member · Accepted solution]

We discovered that the only solution to our issue is the OLEDB UDS driver.

[Former Member · Accepted solution]

Which version of the OLEDB UDS? The existing one or the elusive version 4.0?

[Former Member · Accepted solution]

The mysterious and elusive 4.0