When creating an OLE DB Connection String, What is a simple way to test it against the PI Server. Is there any way to generate the String based on the test.
Try the following:
You should now see this:
OleDbConnection cnn;cnn.ConnectionString = strConnectionString;cnn.Open();
Hope this helps!
Thanks a lot this post helped me to crack OLEDB connection string.
I've found VS2008 to be a great tool for making such connection strings, i like the way it presents the information and have found them to be interchangeable (can copy the connection string to Excel, PI OLEDB, <tool of your choice here>) and has a great and nice ability for testing it out and making queries.
Query wise I would still recommend the tool provided with PI OLEDB as it writes queries with the proper sintax (as opossed to VS2008 which tends to oversimplify the query).
Retrieving data ...