Greetings,
Newbie here - so appreciate any assistance on such a minor issue.
Looking for an example of a remote connectionstring example. Instead of
Function CreateConnection() As OleDbConnection
Dim myConnection As OleDbConnection = New OleDbConnection
myConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Context.Server.MapPath("../uploads/Northwind.mdb") + ";"
myConnection.Open()
Return myConnection
End Function
Looking for an example along the lines of:
<connectionStrings>
<add name="DaveConnectionString" connectionString="Data Source=207.158.71.122;Initial Catalog=DaveStudies01;Persist Security Info=True;User ID=Dave;Password=password" providerName="System.Data.SqlClient"/>
</connectionStrings>
Didn't see one posted in the forums.
Thanks in advance,
Dave