Çë½ÌRDAÓësqlserverÊý¾Ýͬ²½ÎÊÌ⣨¼±£©
ÎҵĻ·¾³ÊÇ£ºsqlserver2000+sqlce3.5+sqlcesa3.5+vs2008
ÔÚ½øÐвâÊÔʱÎÒ²ÉÓÃÁËÒÔÏ·½·¨£º
C# code:
SqlCeRemoteDataAccess access = new SqlCeRemoteDataAccess(@"http://localhost/sqlce3.5/sqlcesa35.dll", @"Data source=MyTest.sdf");
string ConnectStr = "Provider=sqloledb;Data Source=127.0.0.1;Initial Catalog=MyTest;User Id=sa;Password=sa;";
access.InternetLogin = "";
access.InternetPassword = "";
access.Pull("person", "select * from person", ConnectStr, RdaTrackOption.TrackingOnWithIndexes,"errortable");
È»ºó³öÏÖÒÔÏÂÒì³££¬ÏêϸÐÅÏ¢ÈçÏ£º
C# code:
source:Microsoft SQL Server Compact
message:
data:System.Collections.ListDictionaryInternal
errors:System.Data.SqlServerCe.SqlCeErrorCollection
HResult:-2147024891
Source:Microsoft SQL Server Compact
StackTrace: at System.Data.SqlServerCe.NativeMethods.CheckHRESULT(IntPtr pISSCEErrors, Int32 hr)
at System.Data.SqlServerCe.SqlCeRemoteDataAccess.Pull(String localTableName, String sqlSelectString, String oleDBConnectionString, RdaTrackOption trackOption, String errorTable)
at SqlCE__PC.Form1.button5_Click(Object sender, EventArgs e) in C:\Documents and Settin
Ïà¹ØÎÊ´ð£º
ÔÚSqlServerÖÐÈçºÎ²é¿´ÀúÊ·ÉÏÖ´ÐеĴ洢¹ý³ÌµÄÐÅÏ¢ÄØ£¬È磺´«Èë²ÎÊý£¬Ö´ÐÐʱ¼äµÈµÈ¡£Èç¹û²»Äܲ鿴ÀúÊ·¼Ç¼£¬ÊÇ·ñ¿ÉÒÔ×Ô¼ºÐ´´¥·¢Æ÷Ö®ÀàµÄ£¬È˹¤¿ØÖÆÄØ£¬ÔÚOracleÀïÃæÓж¯Ì¬ÊÓͼ¿ÉÒÔËæÊ±²é¿´ÀúÊ·Ö´ÐеÄsqlÓï¾ä£¬SqlSer ......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......
ËùÓбíµÄÎı¾×ֶζ¼±»²åÈë´úÂë
Ôõô»ØÊ¡£
´úÂëÒѾдÁ˹ýÂË×Ö·û´®
Èç¹ûÊÇ´úÂëµÄÎÊÌâ²»Ó¦¸Ãÿ±í¸ö¶¼±»²åÈëÁË
Èç¹û²»ÊÇ£¬sqlserverºÃ¶à¸ö¿â£¬Ö»ÓÐÕâ¸ö¿â±»²åÁË
»¹ÓÐʲô¸üºÃµÄ¼ÓÃÜ·½Ê½
Ôõôà ......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
ÎÒÓõÄÊÇ£ö£ó£²£°£°£¸×Ô´øµÄsqlExpress2005°æ±¾,windowsÉí·ÝÁ¬½Ó£¬¿ÉÒÔ²âÊÔÁ¬½Óͨ¹ý£¬µ«ÊÇÒªÊÇÑ¡Ôñ£ó£ñ£ì£ó£å£ò£ö£å£òÉí·ÝµÄ»°£¬¾Í»á±¨¡¡¡¡ÎÞ·¨Éú³ÉsqlserverµÄÓû§ÊµÀýÎÊÌ⣬½ö¼¯³ÉµÄÁ¬½Ó²Å¿ÉÒÔÉú³ÉÓû§ÊµÀý
Ó¦¸ ......