Set con = New ADODB.Connection con.CursorLocation = adUseClient con.ConnectionString = "DSN=VBSQLHRM;user id=sa;password=;" con.Open rs.CursorLocation = adUseClient rs.Open "select * from emp", con, adOpenDynamic, adLockOptimistic, adCmdText rs.AddNew Text1.SetFocusIf I am using Connectiog provider SQL OLEDB like this...than getting error
Set con = New ADODB.Connection con.CursorLocation = adUseClient con.Provider = "SQLOLEDB" con.ConnectionString = "user id=sa;password=;data source=hrbo;initial catalog=Hrpay" con.Open rs.CursorLocation = adUseClient rs.Open "select * from emp where empid=0", con, adOpenDynamic, adLockOptimistic, adCmdText rs.AddNew TxtEmpID.SetFocuswhen using this OLEDB than getting following error..
I dont want to go through ODBC since in this case I have to configure all client machine and also I have to take care whenever machine format/chage. Thatswhy I want to go through OLEDB provider.YOur Detail Guide will be highly appreciated.