VB.Net falls over INTERVAL DAY(2) field type

Question

I have an application written in VB.NET that collects information from an SQL/MX database via an ODBC driver. All works fine except for one specific table that contains two INTERVAL DAY(2) fields. When I run the query for this table I get an 'Unknown SQL type - 103' error. If change my query to exclude these fields then it works fine.

Dim SQLQueryDataAdapter As New OdbcDataAdapter(MySQLQuery, MyNonStopConnection)
Dim SQLQueryOutputTable As New DataTable("SQLOutput")
SQLQueryDataAdapter.Fill(SQLQueryOutputTable)

My ODBC connection string:

MyNonStopConnection = New OdbcConnection(
        "Driver=" & MyDriver & ";DSN=" & MyDSN & ";SERVER=TCP:" _
        & MyTCP & ";UID=" & MyUserName & ";PWD=" & MyPassword)

MyNonStopConnection.Open()

What am I doing wrong?

AjV Jsy · Answer 1 · 2013-02-25T14:32:15.580

0

Not all data types get through ODBC correctly (depending upon flavour of SQL and driver). You may need to CAST the fields in question as a more standard type.
What driver are you using?

edited Feb 25 '13 at 14:32

answered Feb 25 '13 at 14:05

AjV Jsy

5,799
4
34
30

I doubt that is something to do with the ODBC. Initially I used Excel(VBA) and the same ODBC driver to collect the information. Then it went without any problems. – Rico Strydom Feb 25 '13 at 14:34
I am using SQL/MX 3.1 driver – Rico Strydom Feb 25 '13 at 15:51

score 0 · Answer 2 · answered Feb 25 '13 at 14:16

0

What is the MAXIMUM number of days you expect to log as the INTERVAL?

To me it looks like either your precision or data type length is incorrect for your SQL Interval Field? so one would be tempted to ask how you defined the field type? in your table record.

Ref: http://msdn.microsoft.com/en-us/library/windows/desktop/ms716230(v=vs.85).aspx

answered Feb 25 '13 at 14:16

Zeddy

2,079
1
15
23

If I INVOKE the table then this is defined: ,TOES_RESV_DGN_AANT INTERVAL DAY(2) NO DEFAULT – Rico Strydom Feb 25 '13 at 14:35

VB.Net falls over INTERVAL DAY(2) field type

2 Answers2