2 Replies Latest reply: Nov 2, 2012 8:25 AM by Andr� Groen RSS

    Error OLE DB Connect

    Andr� Groen

      Hi

       

      For a client I am trying to connect to an .sdf file (SQL server compact). It's working except for fields with numeric values. Integer, text and date fields are working fine. The following script is an brief example based on northwind.sdf (see attached file). The OLE DB msi is also attached (needs to be installed before Reloading the script).

       

      OLEDB CONNECT32 TO [Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=Northwind.sdf]

      ;

       

      LOAD *;

      SQL SELECT

                Freight

      FROM Orders;

      // Freight is a numeric field, other fields are working fine

       

      After Reload the next error message appears:

      ErrorMessage.PNG

      Probably it has something to do with numeric settings? Changing the country settings of my PC or switching te comma and point within the set ThousandSep and DecimalSep didn't help so far.

       

      Anyone? Thanks in advance.

       

      Andre