ADO Cannot Find Provider - help with connecting to Remote SQL Server!
I am trying to test out a VERY simple app in embedded vb that would connect
remotely to a SQL server over TCP/IP. We plan to write some apps for a palm-sized
CE machine with a wireless connection to our lan.
Now, I create the ADO objects just fine, but I get the following message:
An error was encountered: ADO Could Not Find the Specified Provider.
here is the code snippet:
Dim objConnection As ADOCE.Connection 'Declare a variable for the connection
Dim objRecordset As ADOCE.Recordset 'Declare a variable for the recordset
Set objConnection = CreateObject("ADOCE.Connection.3.1")
Set objRecordset = CreateObject("ADOCE.Recordset.3.1")
Dim strCon As String
strCon = "Provider=SQLOLEDB;User ID=sa;Initial Catalog=MYDATABASE;User
Obviously I use a real IP address for the Data Source property. Is there perhaps
something that I must install to tell the emulator that it should emulate a