convert Access code to add records to Oracle db
First of all, I am NOT very experienced in databases (and certainly not in SQL).
But I do have some code that updates an Access database on my own PC - and it works okay.
Now I need to convert it to do the same thing on an Oracle database (which unfortunately is not available to me for testing at this time).
Here is the code that I use now (VB6) :
Dim oCn As ADODB.Connection
Dim oRs As ADODB.Recordset
Set oCn = New ADODB.Connection
Set oRs = New ADODB.Recordset
oCn.Open "Provider=Microsoft.Jet.OLEDB.3.51;" & "Data Source=c:\ct\database\ct_db.mdb"
oRs.Open "msg_data", oCn, adOpenKeyset, adLockOptimistic, adCmdTable
.Fields("msg_sent") = sentDateMsg
.Fields("msg_received") = rcvDateMsg
.Fields("msg_txt") = textMsg
Set oRs = Nothing
Set oCn = Nothing
So, now my question is : Do I need to make huge changes to this in order to make it work on an Oracle database?
I realize that I will need to change the connection string, but do I also need to add some SQL to this? (if that is a dumb question, I apologize. I freely admit that I am still only learning this stuff).
I would appreciate any input regarding this.
Click Here to Expand Forum to Full Width