rweiman

Issues with Connecting via ODBC in WinSPC

Discussion created by rweiman on Jul 29, 2014
Latest reply on Aug 8, 2014 by asorokina
I've setup a User DSN with a SQL Data Access Server that is running on the PI server, and configured for PI Data Archive with Trusted Connection checked and Integrated Security=SSPI as the only option on Windows 7 x64 via the 32 bit ODBC administration tool.  If I use DSN= in the PI ODBC Tester, I'm able to retrieve tag values without a problem. When I select that same DSN in WinSPC, I get [PIODBC] [PI SQL DAS gSOAP Channel] HTTP Error Details: HTTP/1.1 403 Forbidden (-1) error messages.  I'm trying to figure out if it is how they're invoking the ODBC call, or if I've configured something incorrectly, but I need to figure out what step to take next in troubleshooting and resolving this. Any ideas as to why two client programs are getting different results from the same machine?  Neither is being run as administrator.

Outcomes