L
Lance Stern
Guest
I am making a program that connects to an PI database. When I try to open a connection using an ADO COM object, when it finally opens the connection I get the "Provider cannot be found. It may not be properly installed".
Could you help me figure out the steps to setting up a proper ADO connection? Does that error usually come with an ADO object being set wrong, or because the connection string is wrong? Do I need to manually configure a OLE DB connection like ODBC connections?
Earlier in the code:
Dim objCon As New ADODB.Connection
Dim objRS As New ADODB.Recordset
objCon = CreateObject("ADODB.Connection")
objRS = CreateObject("ADODB.Recordset")
<add key="ConString1" value="Provider=PIOLEDB.1;Data Source=_____;Integrated Security=SSPI;Persist Security Info=no;connect timeout=60" />
Kept the data source hidden for security reasons.
Continue reading...
Could you help me figure out the steps to setting up a proper ADO connection? Does that error usually come with an ADO object being set wrong, or because the connection string is wrong? Do I need to manually configure a OLE DB connection like ODBC connections?
Earlier in the code:
Dim objCon As New ADODB.Connection
Dim objRS As New ADODB.Recordset
objCon = CreateObject("ADODB.Connection")
objRS = CreateObject("ADODB.Recordset")
<add key="ConString1" value="Provider=PIOLEDB.1;Data Source=_____;Integrated Security=SSPI;Persist Security Info=no;connect timeout=60" />
Kept the data source hidden for security reasons.
Continue reading...