Hi,
We have a problem and I already searched everything I could on it but with no success.
The soultion may be simple but somehow I can't make it work.
We made a windows service that connects to tps files using Softvelocity ODBC driver and send data to our SQL server database.
It was working well until software provider made some changes in tps files. The change is in the name of the columns.
The names of the columns now have a kind of prefix separated with colon )
Before: column name was DOKUMENT
Now: column name is SSKOKUMENT
Now we got error saying:
System.Data.Odbc.OdbcException (0x80131937): ERROR [S0000] [SoftVelocity Inc.][TopSpeed ODBC Driver]Column not found: Dokument
So instead using just DOKUMENT we tried using:
SSK: DOKUMENT
"SSK: DOKUMENT"
[SSKOKUMENT]
!SSKOKUMENT
SSK.DOKUMENT
None of these works!!!
Any help would be appreciated.
Thanks,
Marko
We have a problem and I already searched everything I could on it but with no success.
The soultion may be simple but somehow I can't make it work.
We made a windows service that connects to tps files using Softvelocity ODBC driver and send data to our SQL server database.
It was working well until software provider made some changes in tps files. The change is in the name of the columns.
The names of the columns now have a kind of prefix separated with colon )
Before: column name was DOKUMENT
Now: column name is SSKOKUMENT
Now we got error saying:
System.Data.Odbc.OdbcException (0x80131937): ERROR [S0000] [SoftVelocity Inc.][TopSpeed ODBC Driver]Column not found: Dokument
So instead using just DOKUMENT we tried using:
SSK: DOKUMENT
"SSK: DOKUMENT"
[SSKOKUMENT]
!SSKOKUMENT
SSK.DOKUMENT
None of these works!!!
Any help would be appreciated.
Thanks,
Marko