I'm accessing Pervasive SQL through ODBC connection.
My objective is to import the data from Pervasive SQL to MS SQL.
I have tried different options to achieve my objective:
1.) Import data feature of MS SQL
2.) Local Packages feature of MS SQL
3.) Visual Basic
No. 1 & 2 options has an error in importing because 0 value in datefields of MS SQL is not accepted.
In Visual Basic, it can't even read (no importing done yet) the data with 0 value.
The error is:
"Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."
The table design for the date field is nullable.
If i can only modify the PSQL table, i would just put null on these 0 value.
I only have control in our MS SQL tables.
I noticed that in PErvasive SQL, 0 is not really accepted for the date fields. How come there are 0 values in the table? (I know i need to ask the owner of these table but they are not very cooperative )