Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Çë½Ì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Ö´ÐйýµÄ´æ´¢¹ý³Ì״̬

ÔÚSqlServerÖÐÈçºÎ²é¿´ÀúÊ·ÉÏÖ´ÐеĴ洢¹ý³ÌµÄÐÅÏ¢ÄØ£¬È磺´«Èë²ÎÊý£¬Ö´ÐÐʱ¼äµÈµÈ¡£Èç¹û²»Äܲ鿴ÀúÊ·¼Ç¼£¬ÊÇ·ñ¿ÉÒÔ×Ô¼ºÐ´´¥·¢Æ÷Ö®ÀàµÄ£¬È˹¤¿ØÖÆÄØ£¬ÔÚOracleÀïÃæÓж¯Ì¬ÊÓͼ¿ÉÒÔËæÊ±²é¿´ÀúÊ·Ö´ÐеÄsqlÓï¾ä£¬SqlSer ......

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

½ô¼±ÇóÖúsqlserver Êý¾Ý¿â±»ÅúÁ¿²åÈë´úÂë

ËùÓбíµÄÎı¾×ֶζ¼±»²åÈë´úÂë
Ôõô»ØÊ¡£
´úÂëÒѾ­Ð´Á˹ýÂË×Ö·û´®
Èç¹ûÊÇ´úÂëµÄÎÊÌâ²»Ó¦¸Ãÿ±í¸ö¶¼±»²åÈëÁË

Èç¹û²»ÊÇ£¬sqlserverºÃ¶à¸ö¿â£¬Ö»ÓÐÕâ¸ö¿â±»²åÁË

»¹ÓÐʲô¸üºÃµÄ¼ÓÃÜ·½Ê½
Ôõôà ......

Sqlserver Óï¾äת³ÉMySqlÓï¾ä

Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......

ÎÞ·¨Éú³ÉsqlserverµÄÓû§ÊµÀýÎÊÌâ

ÎÒÓõÄÊÇ£ö£ó£²£°£°£¸×Ô´øµÄsqlExpress2005°æ±¾,windowsÉí·ÝÁ¬½Ó£¬¿ÉÒÔ²âÊÔÁ¬½Óͨ¹ý£¬µ«ÊÇÒªÊÇÑ¡Ôñ£ó£ñ£ì£ó£å£ò£ö£å£òÉí·ÝµÄ»°£¬¾Í»á±¨¡¡¡¡ÎÞ·¨Éú³ÉsqlserverµÄÓû§ÊµÀýÎÊÌ⣬½ö¼¯³ÉµÄÁ¬½Ó²Å¿ÉÒÔÉú³ÉÓû§ÊµÀý
Ó¦¸ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ