FAQ and Troubleshooting

call idba_setc (handle, "query", "stream") does not make any difference

Because of a quirk of the MySQL ODBC driver, you may need to add a special configuration option to the MySQL driver.

These are the instructions that you, or the person who set up ODBC in your computer, can follow:

You need to add 1048576 to the value of the Options field of the configuration of the ODBC DSN.

This can be done by adding the line Option = 1048576 to the file odbc.ini, or editing the Options field using the graphical ODBC configuration tool.

How do I access the extra station data?

There are two ways:

1. If you know in advances what variables you want to read, you can find them among the results of idba_elencamele:

   c     Query station data
         call idba_quantesono(handle, count)
      
   c     Get the informations about a station
         do i=1,count
           call idba_elencamele(handle)
           call idba_enqc(handle, "name", cname)
           call idba_enqi(handle, "B02001", type)
   c       ....
         enddo
   

2. If you want to see all the extra station data available, you can make an explicit query for the extra station data using idba_voglioquesto and idba_dammelo

         call idba_seti("ana_id", id)
         call idba_voglioquesto(handle, count)
         do i=1,count
           call idba_dammelo(handle, param)
   c       get the value of this variable
           call idba_enqc(handle, param, cvalue)
           print*,param,": ",cvalue
         enddo