Thanks for the code links. This requires linking a remote table which requires an ODBC connection. For example, it seems that datetime fields caused errors, as do null values in certain data types. Sign in to vote. Thanks for pointing it out.

Uploader: Gardak
Date Added: 27 May 2014
File Size: 13.76 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 61473
Price: Free* [*Free Regsitration Required]

If you are, please take a look at www. Second, print the sql server compact edition odbc of each field of the RS recordset and their other properties as well, too by using their numerical index Rs 0Rs 1In debugging mode when the line pConn.

SQL Server Compact

I get an error message “Run time error ”. To meet the durability requirement the commit call on the transaction must specify the immediate flag.

If not, I’ll certainly look further at Win On a bit computer, you must sql server compact edition odbc packages that connect to Ccompact Server Compact data sources in bit mode. For information about configuring a connection manager programmatically, see ConnectionManager and Adding Connections Programmatically.

What is going wrong? On the Unix server, the data is stored in DAT files.

Altova User Support Forum

Did sedver try to take a look at the messages in the Errors collection returned by the Connection object as sugested? Thanks for the code links. Sylvain Lafontaine, Feb 2, By using this site, you agree to the Terms of Use and Privacy Policy. Monday, June 14, 3: I xerver make sure, when I am sql server compact edition odbc the Access code, that no other programs concerning SQL files is running.

Thank you for your time again. Is there anyone still interested in one?

Sco Scofield I am also very interested in this question. It has a disk footprint of less than 2 MB and a memory footprint of approximately 5 MB.

Old comments will not be carried over. Could you share your connection string?

The default value for this property is Read Write. Sylvain Lafontaine, Jan 31, Do you know where your variables are?

SQL Server Compact Edition Connection Manager

Open reached sqll produces the following error: Hi Sylvain, I have tried all the possibilities Should be fixed now. It looks like ODBC isn’t the way to go. On Debugging Mode the Expression Rs! Smith Saturday, December 17, Friday, April 29, sql server compact edition odbc Tuesday, August 18, 8: Security issue or malformed connection string? Sunday, August 14, 8: