I'm having a problem using the OraOLEDB to INSERT records into a table using the following syntax. I want to utilize the "PwdChgDlg" of the driver.
conn.ConnectionString = "Provider=OraOLEDB.Oracle;PwdChgDlg=1;Data Source=" & ORACLE_Database
sql = "INSERT INTO " & tablename & " VALUES(" & Parseda & Parsedb & ")"
I get an error at .BeginTrans...? I believe I need to use .command and ExecuteNonQuery() but can't find any syntax except for VB.net.
Can anyone help?