Hi, i am sure this is a fairly simple question, but I simply do not know the keywords / terminology that I need. I currently have an application, that is using ADODB connections to an ACCESS Database. I am now going to connect to a SQL database and want to use OLEDB.
Therefore the code I was previously using would look something like -----
Dim conDB As New ADODB.Connection
Dim cmdDB As New ADODB.Command
Dim rsDB As New ADODB.Recordset
conDB.ConnectionString = Access =Microsoft.Jet.OLEDB.4.0;Data Source = \Datastore\DB1.mdb
cmdDB.ActiveConnection = conDB
cmdDB.CommandText = "SELECT * FROM Appointment_Templates Order By Name"
rsDB = cmdDB.Execute
- could somebody please show me how to convert this into OLEDB, along with the new connectionstring and any references that I need to add.