Sql ce 3.5 OleDB Driver

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jonas Pedersen - 10 Dec 2007 10:03 GMT

My main application is written in a language called Gupta team developer.
I need to be able to communicate with a sql ce 3.5 database.

However there is some strage things with the OleDB driver.

It is no problem establishing the connection to the database, but when ever
I try to bind variables in Sql Statements I get a Sql
Exception
-2147217891
Requested conversion is not supported. [,,,,,].

Here is my connection string:
Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=tm_mobile.sdf;

The exact same code works fantastic with the MSDE 2000 and sqloledb.dll

Any help are apreciated.

Jonas

Reply to this Message

João Paulo Figueira - 11 Dec 2007 21:46 GMT

SQL CE 3.5 uses a subset of the SQL Server data types. What data types are
you trying to bind to?

João Paulo Figueira
DAD MVP

> My main application is written in a language called Gupta team developer.
> I need to be able to communicate with a sql ce 3.5 database.
[quoted text clipped - 16 lines]
>
> Jonas

Reply to this Message

Jonas Pedersen - 13 Dec 2007 09:15 GMT

Any datatype will cause this problem.
Tried with one integer only and one String to varchar.

Jonas

> SQL CE 3.5 uses a subset of the SQL Server data types. What data types are
> you trying to bind to?
[quoted text clipped - 22 lines]
>>
>> Jonas

Reply to this Message