I want access and insert data into Citadel dataabse from Visual basic 6.0.
I was able to make connection to the database using ODBC and ADO and dispaly
data from Traces table. I used default OLEDB provider MSDASQL. But I am not
able to write data into the database. While prinitng the field datatypes
it was displaying Datatype as DATETIMEPRECISION for all the Fields. What
could be the problem. Can you please advice me how to write data into Citadel
database using VB 6.0 and ADO.
The code I used is as follows and the printed values while debugging
Set cnn_Lt = New ADODB.Connection
cnn_Lt.ConnectionString = "Data Source=San1"
cnn_Lt.Open
Set rec_test = New ADODB.Recordset
rec_test.Open "Traces", cnn_Lt, adOpe
nDynamic, adLockOptimistic, adCmdTable
Count - 0
Field name - "LocalTime"
Value - 2/7/01 4:06:17 PM
Datatype - DATETIMEPRECISION
Count - 1
Field name - "UTCTime"
Value - 2/7/01 10:36:17 AM
Datatype - DATETIMEPRECISION
Count - 2
Field name - "Interval"
Value - 1
Datatype - DATETIMEPRECISION
Count - 3
Field name - "Resolution"
Value - 00:00:01
Datatype - DATETIMEPRECISION
Count - 4
Field name - "\\kalki_node_2\San\ModbusSlave1@ashdsdg"
Value - Null
Datatype - DATETIMEPRECISION
Count - 5
Field name - "\\kalki_node_2\San\ModbusSlave1@dddd"
Value - False
Datatype - DATETIMEPRECISION
Count - 6
Field name - "\\kalki_node_2\San\ModbusSlave1@dddw"
Value - Null
Datatype - DATETIMEPRECISION
Santhosh Xavier
