New to compact framework tutorials? Learn to write your first compact framework application here.
Zac Efron - Hairspray star and Mythbusters' Kari Byron at Celebrity Treat. Check out income and career information in Singapore.

Thursday, December 15, 2005

- Accessing SQL Server Express from the emulator (or PDA)

This post talks about data access from the emulator (or actual device) to your PC. If you're just getting started on the .NET Compact Framework 2.0, you can read this to install the tools and this to write your first app.

In this tutorial, you learn how to let the emulator access a SQL Server Express database in your PC.

SQL Server 2005 Express edition is free and is installed together with most editions of Visual Studio 2005. As the successor of the very useful MSDE, SQL Server Express offers the equivalent, if not better, feature set of other free database servers (MySQL in particular). Compared to MSDE, SQL Server Express does not have the workload throttle restriction, thus giving better scalability, and allows a higher maximum database size of 4GB (an increase of 2GB). However, the new kid on the block always uses only a single CPU (even if the machine has multiple), and supports only replication subscriptions (it can't be a publisher). Still, it is extremely useful for basic development and exploration, in my opinion. It even comes with a management console (currently in Community Technology Preview, downloadable from a link on this page), something that its predecessor lacks.



Now, let's dive in! This step-by-step tutorial requires a sample database such as Northwind.mdf (which can be extracted from a download here). Although Northwind was created for SQL Server 2000, it can also be used in SQL Server 2005.

  1. You should have downloaded and extracted the Northwind sample database (download from here). Place both Northwind.mdf and Northwind.ldf files in a folder of your choice.
  2. Download and install the Management Studio Express from a link on this page. Start the Management Studio and login using Windows Authentication. Right-click on the first node in the treeview and click "Properties". In the dialog window, click "Security" on the left and select "SQL Server and Windows Authentication". This will allow connections to be made using SQL Server authentication.
  3. Next, still in Management Studio, expand the Security node in treeview, then expand Logins. In the main panel, right-click on "sa" and click "Properties". Change the password. Still within Properties dialog, click "Status" in the leftside panel, and enable the "sa" account. Click OK.
  4. Right-click on Databases, and attach the Northwind database.
  5. Next, we need to enable TCP/IP connections. Click Start-> All Programs-> SQL Server 2005-> Configuration Tools-> SQL Server Configuration Manager.
  6. Under "Protocols for SQLEXPRESS", ensure that "TCP/IP" is enabled. Double-click on TCP/IP, set Enabled to Yes, and under the "IP Addresses" tab, clear all the "TCP Dynamic Ports" entries (set them blank), and set TCP Port (under IP All) to 1433. We are fixing the port, which means SQL Browser service can be stopped (in fact, this is a security best practice). You may need to use another port number if you have other versions/instances of SQL Server running.
  7. Restart the SQL Express service to activate the new configurations.
  8. Start Visual Studio and create a new smart device project.
  9. Add a ComboBox called cboCountries to the form. Add the reference System.Data.SqlClient to your project. In code view, add the line "using System.Data.SqlClient;" near the top.
  10. In the Form_Load event handler, add the following code (replacing "192.1.2.3" with your IP address, and "yourPassword" with the password for your sa account:

  11. string sConnection = "Data Source=192.1.2.3,1433;Initial Catalog=Northwind;User ID=sa;Password=yourPassword;";
    string sSQL = "SELECT DISTINCT Country FROM Customers ORDER BY Country";
    SqlCommand comm = new SqlCommand(sSQL, new SqlConnection(sConnection));
    SqlDataReader dr = null;
    try
    {
      comm.Connection.Open();
      dr = comm.ExecuteReader();
      while (dr.Read())
        cboCountries.Items.Add(dr[0]);
    }
    catch (Exception e)
    {
      MessageBox.Show(e.Message);
      return;
    }
    dr.Close();
    comm.Connection.Close();

  12. Start the emulator and cradle it (see this post on cradling the emulator). Make sure that it can access the network.
  13. Run your program. You should see the combo box populated with a list of countries extracted from the Northwind sample database.
What next? Learn how to create a SQL Server Mobile database here.

Categories: [Data Access_] [Networking_] Tags: [] [] []

103 Comments:

Blogger danchong said...

hi Q, thanks for your interest in the tutorials. I've also tried using the host name in the data source, but without success. A possible workaround is to write code to translate the name to IP and then specifying the IP in the connection string.

-daniel

6/07/2006  
Anonymous Anonymous said...

Hi, thanks to your tutorial, I finally could connect to SQl Express i was starting to think that it wasnt possible :-)

I have a question meybe you can help me:
Can I conect to SQL 2000 in the same way as it was done here, I mean...Connect form my device emulator to SQl 2000 on my local machine, ive tried many convinations for my connection string and none of them work, SQL 2000 has TCP/IP enabled and as a default port it has 1433
Well i hope you can point me to a good example just like yours but with SQL 2000
Thanks in advance

Alexei Rodriguez

10/27/2006  
Blogger danchong said...

Hi Alexei, SQL 2000 should work in exactly the same way.

Assuming you do not have another program listening on port 1433 (i.e. remember to stop SQL Express), I think there's another small issue with SQL 2000, which could actually be a bug (if I remember correctly). To work around, you have to set the port to some other number (e.g. 1234) and try to connect. If it works, all's well! Then you can try changing the port back to 1433. Please let me know if this works.

10/27/2006  
Anonymous Anonymous said...

IT WORKED!!! I cant believe it :-)
I just did what you said, I changed the port number to 1234 and worked, then i changed to port number to 1433 and now it works too
Thats weird problem that SQL2000 has, too bad i never found that info on the internet, but hopefully if someone is having this problem can find this solution.
This was the final connection string:
Dim conn As New SqlConnection("Data Source=10.1.0.254,1433;Initial Catalog=NorthwindX;User ID=Alexei;Password=a;")
Dim da As New SqlDataAdapter("SELECT CategoryName FROM Categories", conn)

Thanks a lot danchong

Alexei Rodriguez

10/28/2006  
Blogger Steven said...

Please help me !

I'm using VB.NET 2003 writing application for WindowsCE 4.2. I have a problem about connect to SQL Server 2000. I have reference System.Data.SqlClient to connect to SQL Server 2000 but it not work. Can you help me about this problem ?. The connection string i used:

Dim gConn As New System.Data.SqlClient.SqlConnection
Dim sCnStr as String ="Data source=10.0.0.71\Sql2k;Initial Catalog=Northwind;User ID=sa;Password=steven;"
Try
gConn.ConnectionString = sCnStr
gConn.Open()
If gConn.State = ConnectionState.Open Then
MsgBox("Connect Succeed")
Else
MsgBox("Connect Failed")
End If
Catch ExSql as SqlClient.SqlException
MsgBox("ExSql Error = " + eSQL.Message)
Catch Ex as Exception
MsgBox("Ex Error = " + Ex.Message)
End try

If i run it on WindowsCE Emulator, it work well. But i run it on Device it not work, the error occur: "ExSql Error = The SQL Server does not exist or access denied."

Thanks for your help!

Steven.

11/17/2006  
Blogger danchong said...

hi Steven,

I suspect that it could be due to your personal firewall. Try turning it off.

Also, you may want to ping 10.0.0.71 from your PDA. And if 10.0.0.71 runs a web server, you can try using the pocket IE to access a web page in 10.0.0.71, just to test the connectivity.

Hope this helps.

11/18/2006  
Anonymous Anonymous said...

Hello Danchong,

I turned off windows firewall, it work well. You are expert, thanks for your help.
I have a problem about serial port, I added reference System.IO but I not found class SerialPorts in this package. I don't know using which component ?, Can you help me about this problem? Thank you very much.

Steven.

11/18/2006  
Blogger danchong said...

hi Steven,

Are you looking for this:
System.IO.Ports.SerialPort

It should be found under the System.IO.Ports package.

11/23/2006  
Anonymous Anonymous said...

hello it is good .. but it give me an sql exception..... it has deployed on emulater then show that message .......
help me ...

ganesh

11/30/2006  
Anonymous Anonymous said...

I'm having a similar but related problem. I thought someone on here might nave an idea. I can't get the emulators to connect to anything in VS2005. I have CF2.0 SP1,VS2005,SQL EXPress 2005...All my code is good I'm pretty sure. I've sone these type of app before but when I try to access a DB I just get a SQL Exception. Also my active sync doesn't see the emulator when I cradle it. Could this be an indicator? I've reinstalled Mobile 5.0 SDK to no avail. Also not sure if it's relevant but I can connect to the Mobile 5.0 phone emulator but not the "normal" one.

12/14/2006  
Anonymous Anonymous said...

hello, thank you for this tutorial .. but i need help ..

when i deployed the application
a "sql exception" appeared
i don't know why..

i execute all the step in this tutorial ..

thanks in advance .

hiba

12/19/2006  
Anonymous Anonymous said...

hi really cool article.now i am learning this technology please send me some basic tutorials and referene URLs.please..........

thanks in advance...

by,
vijayarock

1/19/2007  
Anonymous Anonymous said...

Hi,
I am trying to connect my .NETCF2.0 (Pocket PC) application to a SQLExpress 2005 database. This is the connection string that I am using:
"Data Source=192.168.1.25,1433;Initial Catalog=exilog;User ID=nybc;Password=nybc;Persist Security Info=False;Integrated Security=false"

But this gives me an error saying "SQL Server does not exist or access denied."

I have enabled remote connections on SQL Express, fixed the port to 1433, enabled SQL Server authentication. I am running out of ideas. Any help will be appreciated.

Cheers,
Sampath

3/19/2007  
Blogger danchong said...

Hi Sampath,

Try to ping 192.168.1.25 from your PDA. And try to disable the firewall in your PC.

-daniel

3/20/2007  
Anonymous Anonymous said...

Hi Daniel,

Yes it was a connectivity issue. Seems I was using an older version of ActiveSync and it was not supported by VS 2005. So what happened was, my emulator had no Network Access. I upgraded my ActiveSync and enabled network access and everything works fine now.

Thanks,
Sampath

PS: How do you ping an IP from the Pocket PC?

3/20/2007  
Anonymous Anonymous said...

Hello, Sampath!

I have some weird problems connecting to SQL Server 2005 and I hope you can help me:
I have written a c# app on an acer n300. My app is connected to a SQL SERVER 2005 database. This app works fine. So I decided to install the app on a second pda (a fujitsu loox). Both pdas have wireless lan and windows ce 5.0. But my app does not run on the new fujitsu loox. I have installed Compact Framework 2 SP2, but as soon as I try to connect to the database a get the error SQL Server does not exist or access denied. I am absolute sure that my connect string is OK, as it works on the acer pda. The configuration of SQL Server should also be ok, as I can connect from the acer devices.
Network connection is also OK, as I
can connect with remote Terminal Services to the machine hosting the database without any problems.
Can you give me a hint whats wrong? Are there any cab files that I must install on the pda before SQL Server 2005 Client is working? I only installed .net Compact Framework.
Any help is appreciated
Greetings from Europe
Wolfgang Muellauer

5/30/2007  
Anonymous Anonymous said...

hello,I have a problem,i was doing everything what is in this article but in console is
A first chance exception of type 'System.MissingMethodException' occurred in System.Data.SqlClient.dll
A first chance exception of type 'System.MissingMethodException' occurred in System.Data.SqlClient.dll
A first chance exception of type 'System.MissingMethodException' occurred in System.Data.SqlClient.dll

and emulator gives me an error saying can't find PInvoke.DLL

9/20/2007  
Anonymous Anonymous said...

Please can you help me with this?

9/20/2007  
Anonymous Anonymous said...

I resolve this problem,i've copied library "dbnetlib.dll" from C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Client\v2.0\wce500\armv4i\
to emulator where a running my program and really works it.

9/20/2007  
Anonymous Anonymous said...

when i connect to device Windows CE, when it hit the line 'comm.Connection.Open',
the error message Can't find PInvoke DLL 'dbnetlib.dll' is shown. What's the probelm ?

10/12/2007  
Anonymous Anonymous said...

why in my pocketPC project it dont have System.Data.SqlClient namespace.

11/01/2007  
Anonymous Anonymous said...

Please Help me!!!!!!!!
I have problem about peograming smart device with vb.net
i want to connect smart device to sql server what should i do???
'*****************************
Dim SQLStr As String = "select * from Test WHERE ID = 1"
Dim con As System.Data.SqlServerCe.SqlCeConnection = New System.Data.SqlServerCe.SqlCeConnection("Data Source =D:\my_DB\DBTest.sdf; Password =1;") 'Persist Security Info=True;
Dim cmd As SqlServerCe.SqlCeCommand = New SqlServerCe.SqlCeCommand(SQLStr, con)
Try
con.Open()
Dim reader As SqlServerCe.SqlCeDataReader = cmd.ExecuteReader
If reader.Read Then
Form1.TXTLname.Text = CStr(reader.Item("Lname"))
Else : MsgBox("Can not open server becose path not fond!!!!!!" & vbCrLf & " plese checking!", vbCritical, "Warning")
End If
Catch
MsgBox("Can not open server becose path not fond!!!!!!" & vbCrLf & " plese checking!", vbCritical, "Warning")
End Try
con.Close()
'*****************************

12/10/2007  
Blogger ramana said...

hi, i m building a pocket pc application using windows mobile 6.0 and vs 2005. i have gone through all the steps of port no, and all. but i m getting an error saying "sql server does not exist or access denied". pls help me out as early as possible.

2/13/2008  
Blogger Unknown said...

Hi experts

Thanks for your tutorial on accessing SQL Server Express from the emulator.

I had gone through it but
emulator gives me an error saying can't find PInvoke.DLL

plz help me.....

3/20/2008  
Anonymous Anonymous said...

Hi all,
I've a terminal with windows ce connected by usb cable with the pc, but when I try to connect sql server I've the the error that indicates that the connection is close or is down: "sqlexception ...". I've tried all tips of this forum but not function, at this point I've this question: it's possibile connect the windows ce with sql server remote with winform application ?

3/27/2008  
Blogger Maharajan said...

Hi
The tutorial which provided is more usefull. But I need to connect MS Sql server 2005 which is in separate machine. What else to do?
pls let me clear my doubt.

4/16/2008  
Anonymous Anonymous said...

I was having a lot of problems connecting SQLExpress from a pocket and now it works. Thank you very very much for the help. This post was a life (and job) saviour :)

6/05/2008  
Anonymous Anonymous said...

After two days lost searching why my connection does´t work, I finnaly see your post and all works perfect now!!!

Thank you very much :)

8/08/2008  
Anonymous Anonymous said...

Hello, I tried to link from device(emulator)to PC for SQL2005,but got Exception.
Using C#(vs2008), WM6,Motorala MC75(Symbol),vista
Reading your comments, and checked all items below

1)SQL2005 accept TCPremote con,use fixed 1433port. delete SQL SQLexpress in engine, instead using default。tried out can be linked from other PC, SQLCMD -e -s 127.0.0.1,1433 checked ok.
2)ConnectString add 1433,or change PD name to IP, with different framework2.0,3.0,3.5,

3)Disable Windows firewall,add Sqlserver exception, release port1433,

4)Tried a small program not mobile, but windows form,can linkup

5)Tried 2 PC, same setting vs2008, tried vs2005,tried ce, WM5

6)Without running, can preview data,

7)Want to use Linq,but no system.data.linq in mobile

8)vista update,vs2008 sp1, framwwork3.5 sp1.

9)Installed SQL compact

Feel can not link out from emulator, not sure where het error.
Stay here for one week, may you help.

The details error code and screenshots
http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_23647957.html

Thanks alot.

Turbot

8/16/2008  
Blogger eternalbard said...

Hi! Do you know if the framework compacts all data transmited throught network or is this a flat result data from server to windows mobile?

Thanks

8/21/2008  
Anonymous Anonymous said...

Hi,
Great tutorial. Thanks first.
I can connect with device, it works well.
But it always sql server not exist or access denied when deploy to windows emulator, what's wrong?

Please help.
Thank You,
Ibrahim N

11/21/2008  
Anonymous Anonymous said...

emh,
I just miss to cradle the emulator, it works now.

Thank you for your great works tutorial.

11/22/2008  
Anonymous Anonymous said...

搬家 搬家 搬家公司 徵信社 徵信 彩妝造型 新娘秘書 票貼 室內設計 室內設計 徵信 徵信社 外遇 徵信 徵信社 外遇 搬家 搬家 花蓮民宿 花蓮民宿 免費a片 a片 免費av 色情影片 情色 情色網 色情網站 色情 成人網 成人圖片 成人影片 18成人 av av女優 情慾 走光 做愛 sex H漫 免費a片 a片 免費av 色情影片 情色 情色網 色情網站 色情 成人網 成人圖片 成人影片 18成人 av av女優 情慾 走光 做愛 sex H漫 a片 アダルト アダルト アダルトサイト アダルトサイト 離婚 抓姦 外遇蒐證 外遇抓姦 外遇 侵權 仿冒 應收帳款 工商徵信 Shade sail nike shoes 水泵 电动隔膜泵 自吸泵 离心泵 磁力泵 螺杆泵 化工泵 水泵 电动隔膜泵 自吸泵 离心泵 磁力泵 螺杆泵 化工泵 水泵 电动隔膜泵 自吸泵 离心泵 磁力泵 螺杆泵 化工泵 隔膜泵 气动隔膜泵 隔膜泵 气动隔膜泵 隔膜泵 气动隔膜泵 a片 成人網站 成人影片 寵物用品 情趣用品 情趣用品 MBA 在职研究生 在职博士 補習班 花店 花店 補正下着 中古車買賣 貸款 婚紗 婚紗攝影 補習班 留學 情色 情色 百家乐 轮盘 21点 德州扑克 百家乐系统 真人娱乐场 百家乐 足球 德州扑克 电子游戏 英格兰超级联赛 德国甲组联赛 意大利甲组联赛 西班牙甲组联赛 法国甲组联赛欧冠杯 英超 足球比分 足球彩票 体育彩票 即时比分 堆高機 婚禮佈置 宜蘭民宿推薦 寵物用品 情趣用品 情趣用品 坐月子 植牙 牙齒矯正 租屋 催眠 房屋出租 租房子 xo醬 牛軋糖 牛嘎糖 代償 房屋貸款 信用貸款 失眠 減肥 眼鏡 金門高梁酒 變頻洗衣機 票貼 借款 關鍵字廣告 租車 派報 漆彈 減重 高雄花店 學英文 糖尿病 花店 呼吸照護 勞工體檢 安養中心 飾品批發 窈窕 雞腳凍 自行車褲 自行車帽 自行車衣

減肥 眼鏡 睡眠障礙 憂鬱症 躁鬱症 減重 瘦身 中醫減肥 台北中醫減肥 台中中醫減肥 高雄中醫減肥 產後減肥 下半身減肥 下半身瘦身 高雄眼鏡 屏東眼鏡 名牌眼鏡 太陽眼鏡 隱形眼鏡 鐵氟龍 PTFE 中壢花店 林口花店 南崁花店 金莎花束 歌倫比亞 飲料加盟 太陽餅 月餅 口袋秤 度量衡 吊秤 吊磅 電子秤 磅秤 口袋秤 度量衡 吊秤 吊磅 電子秤 磅秤 招牌製作 招牌設計 廣告招牌 大圖輸出 電腦割字 招牌看板 廢鐵 廢銅 廢不銹鋼 廢電線 廢鋁 廢棄物 廢電纜電線 廢塑膠 制服 成衣 戒指 耳環 項鍊 對戒 手鍊 銀飾 飾品 對鍊 護理之家 台中花店 考試 塑膠箱 塑膠容器 工具箱 物流箱 拖板車 自動倉儲 倉儲設備 自行車衣 自行車背包 自行車手套 車衣 債務更生 債務清理 法協 蜂蜜 蜂王乳花粉 農產品 草本膠囊 促進新陳代謝 排便順暢的方法 體內環保 塑膠射出 塑膠製品 塑膠箱籃 物流塑膠箱 休閒傢俱 庭園圍籬

2/05/2009  
Anonymous Anonymous said...

(法新社倫敦四日電) 英國情色大亨芮孟的公司昨天情色視訊說,芮孟日前去世,享壽八十二歲;這位身價上億的房地產開發商成人網站,曾經在倫敦推出第一場脫衣舞表成人演。
成人電影
av女優
芮孟色情的財產估計達六億色情五千萬英鎊(台幣將近四百a片億),成人光碟由於他名下事業大多分成人影片布在倫av女優敦夜生活a片下載區蘇活區,因此擁情色電影有「蘇活之王」av的稱號。

a片
他的公司「保羅芮孟集團」旗下發行多種情色雜誌情色,包a片下載括「a片Razzl成人網站e部落格」、「av男性世界」以部落格部落格「Mayf色情影片air」。


芮孟本名傑福瑞.安東尼.奎恩,父親為搬運av承包商。成人芮孟十五av歲離情色電影開學校,矢言要在表演事業留名,起先表演讀心術,後來成為巡成人電影avdvd歌舞雜耍表演的製作人。情色成人影片


許多評論家認為,他把情色表演帶進主流社會,一九五九AV片年主持破天荒的脫衣舞色情表演,後來更靠著在蘇活區與sex倫敦西av女優區開發房地產賺得大筆財富。a片


有人形成人網站成人影片芮孟是英日本av國的海夫色情a片納,地位等同美國的「花花公子」創辦人海夫納。

2/17/2009  
Anonymous Anonymous said...

辣妹脫衣視訊辣妹脫衣視訊辣妹脫衣視訊辣妹脫衣視訊色情聊天室色情聊天室色情聊天室色情聊天室色情聊天室色情聊天室色情聊天室色情聊天室色情聊天室色情聊天室性愛影音視訊聊天大廳性愛影音視訊聊天大廳性愛影音視訊聊天大廳性愛影音視訊聊天大廳性愛影音視訊聊天大廳性愛影音視訊聊天大廳性愛影音視訊聊天大廳性愛影音視訊聊天大廳性愛影音視訊聊天大廳性愛影音視訊聊天大廳免費日本視訊 av女優聊天室免費日本視訊 av女優聊天室免費日本視訊 av女優聊天室免費日本視訊 av女優聊天室免費日本視訊 av女優聊天室免費日本視訊 av女優聊天室免費日本視訊 av女優聊天室免費日本視訊 av女優聊天室免費日本視訊 av女優聊天室免費日本視訊 av女優聊天室激情成人聊天室激情成人聊天室激情成人聊天室激情成人聊天室激情成人聊天室激情成人聊天室激情成人聊天室激情成人聊天室激情成人聊天室激情成人聊天室免費女優電影免費女優電影aa片免費看微風論壇080哈啦聊天室6k聊天室成人聊天室上班族捷克論壇大眾論壇plus論壇080視訊聊天室520視訊聊天室尋夢園上班族聊天室成人聊天室上班族 a片a片影片免費情色影片免費a片觀看小弟第貼影片區免費av影片免費h影片試看 H漫 - 卡通美女短片小魔女貼影片免費影片觀賞無碼a片網美女pc交友相簿美女交友-哈啦聊天室中文a片線上試看免費電影下載區免費試看a短片免費卡通aa片觀看女優影片無碼直播免費性感a片試看日本AV女優影音娛樂網日本av女優無碼dvd辣妹視訊 - 免費聊天室美女交友視訊聊天室080免費視訊聊天室尋夢園聊天室080苗栗人聊天室a片下載日本免費視訊美女免費視訊聊天

2/17/2009  
Anonymous Anonymous said...

dear,
i have tried and already installed, but when i choose sql server and windows authentication mode, why cannot, the command is:
"alter failed for server '....'. (Microsoft.SqlServer.express.smo)

2/18/2009  
Anonymous Anonymous said...

☆♀ av女優影片 ☆♀ ☆♀ av女優影片 ☆♀ ☆♀ av女優影片 ☆♀ ☆♀ av女優影片 ☆♀ ☆♀ av女優影片 ☆♀ ☆♀ av女優影片 ☆♀ ☆♀ av女優影片 ☆♀ 三級電影三級電影三級電影三級電影三級電影三級電影三級電影三級電影三級電影三級電影情色短片情色短片情色短片情色短片情色短片情色短片情色短片情色短片情色短片情色短片av情色網 av情色網 av情色網 av情色網 av情色網 av情色網 av情色網 av情色網 av情色網 av情色網 ☆♀ 成人影視☆♀☆♀ 成人影視☆♀☆♀ 成人影視☆♀☆♀ 成人影視☆♀☆♀ 成人影視☆♀☆♀ 成人影視☆♀☆♀ 成人影視☆♀☆♀ 成人影視☆♀☆♀ 成人影視☆♀☆♀ 成人影視☆♀色咪咪影片網色咪咪影片網色咪咪影片網色咪咪影片網色咪咪影片網色咪咪影片網色咪咪影片網色咪咪影片網色咪咪影片網色咪咪影片網sex5220免費影片sex5220免費影片sex5220免費影片sex5220免費影片sex5220免費影片sex5220免費影片sex5220免費影片sex5220免費影片sex5220免費影片sex5220免費影片尋夢園上班族聊天室尋夢園上班族聊天室尋夢園上班族聊天室尋夢園上班族聊天室尋夢園上班族聊天室尋夢園上班族聊天室尋夢園上班族聊天室尋夢園上班族聊天室尋夢園上班族聊天室尋夢園上班族聊天室ut聊天聯盟ut聊天聯盟ut聊天聯盟ut聊天聯盟ut聊天聯盟ut聊天聯盟ut聊天聯盟ut聊天聯盟ut聊天聯盟ut聊天聯盟電愛聊天室電愛聊天室電愛聊天室電愛聊天室電愛聊天室電愛聊天室電愛聊天室電愛聊天室電愛聊天室電愛聊天室琉璃仙境聊天室琉璃仙境聊天室琉璃仙境聊天室琉璃仙境聊天室琉璃仙境聊天室琉璃仙境聊天室

2/18/2009  
Anonymous Anonymous said...

(法新社a倫敦二B十WE四日電) 「情色二零零七成人影片」情趣情色產品大產自二十色情三日起在倫敦的肯辛頓奧林匹亞AV女優展覽館舉行,倫敦人擺脫對性的保守A片態度踴躍參觀,成人影片許多穿成人網站皮衣與塑膠緊身衣的好色之徒擠進這項世界規模最大的成人生活展,估計三天展期可吸引八萬多好奇民眾參觀。

情色電影活動計畫負責人米里根承諾:「要搞浪漫、誘惑人、玩虐待,你渴望的我們都有。」

他說:「時髦的設計與華麗女裝,從吊飾到束腹到真人大小的雕塑,是我們由a片今年展出的數千件產品精選出的一情色部分,參展產品還包括時尚服飾、貼身女用內在美、鞋子、珠寶、玩具、影片、藝術成人電影、圖書及遊戲,更不要說性愛輔具及馬術裝備。成人電影

色情參觀民眾遊覽兩百五十多個攤位,成人網站有性情色電影感服裝、玩具及情色食品,迎合各種品味。

大舞台上AV表演的是美國野蠻搖滾歌手瑪莉蓮曼a片下載森的前妻─av全世界頭牌脫衣舞孃黛塔范提思,這是她今年在英國唯一一場表演。

以一九四零年代色情影片a片格演出的黛塔范提思表演性感的天堂鳥、旋轉木馬及羽扇A片下載等舞蹈。

參展攤位有的推廣情趣用av女優品,有的公開展示人體藝術和人體雕塑,也有情色藝術家工會成員提供建議。

2/28/2009  
Anonymous Anonymous said...

Is this still open for discussion? I really need help for this, please...
My Visual Studio 2005 does not have System.Data.SqlClient, i have tried adding reference, but there is only System.Data. It is available for windows application but not for smart device application? What can i do?? Please help me...
Thank you very much in advance

8/02/2009  
Anonymous Anonymous said...

hi.Thanks for your advise and tutorial..It is very clear and understandable...
But I am working on Visual Studio 2008 Prof. Ed. and Sql Server 2008.
So I am trying the deploy my application with Pocket Pc SDK 5 emulator..But not working.
The error is something like "dbnetlib.dll cannot found".
But if I run the program from exe,
It runs..(myAppFolder\bin\debug\myapp.exe)

How can I solve this problem?
It is my GRADUATION PROJECT and ver very important..
Thanks your attention and helps

11/03/2009  
Blogger ArGeMaNiA said...

Hi, I need to perform a oracle-CF connection, but I can't find any article about this subject..Can you help me about this?

1/14/2010  
Blogger Tunisien said...

Hi,

I am really fed up.I experimeted many times the code but doesn't work.It gaves me an sqlexception.In fact,my combobox should contain the result of my select statement,but when running,the system shows an sqlexception and nothing is added to my combobox.
The problem is sure in the connexion string I used :string sConnection = "Data Source=169.254.2.1,1433;Initial Catalog=GMAO;User ID=sa;Password=sa;";
I cradled my emulator.When trying to install windows mobile device center,it failed showing this error: Error 1335. The cabinet file 'product.cab'required for this installation is corrupt and cannot be used..." .
Should i connect a real device to be able to install this tool???

When should I uncradle my emulator???

I wanna ask what is the IP that sould I write in data source field:is it the IP of the emulator?or of the PC?or of the sql server??

Thanks for u clarification

Tunisien

5/07/2010  
Anonymous Anonymous said...

The SQL server is running on a differnet computer which has windows server 2003 I tried pinging the emulator but when i was following the steps I get this error when i go to (on the emulator)file >configure>network tab> and check enable NE2000 and press ok with any thing selected from the list box it gives me this error

No VPC network adaptors enemurated or no host network adapter with provided MAC address found

and when I try to conect to the sql server with the smart device programm i get an sql exeption i have tried to give exeption for sqlsrvr on the fire wall and installe VPC on both PC's and still i cant get through can some one give me the correct steps to get pass this issue

8/09/2010  
Anonymous Your Escort Agency said...

Your Escort Agency offers exclusive and most beautiful London escort girls of various nationalities.

6/26/2011  
Anonymous London escort agency said...

Your Mademoiselle escorts agency is select the most charming, friendly and the finest London escorts for our Escort gallery and provide the best escort services in London.

6/26/2011  
Anonymous Anonymous said...

This saves my day. Thank you very much.

7/21/2011  
Anonymous London escorts said...

If you are looking for European escorts Bestescort4U is the best place in London

8/05/2011  
Anonymous Escorts London said...

London escort agency which provides genuine female escort models in Central London area

8/05/2011  
Anonymous Elite escorts said...

Beautiful escorts can be found at Elite Club International. Elite Club International is an elite escort agency operating mostly in Dubai and London.

8/08/2011  
Anonymous Porn Star Escorts said...

Bunny Planet is an Exclusive Online Gentlemen's Club filled with Adult Stars, Adult Entertainers, Centerfolds and Erotic Models who want to meet you in person now!

8/08/2011  
Blogger javi said...

I have tried this project as per your advice.But i cant run it both in emulator and device.
it shows error at #0.
please help me to connect

8/22/2011  
Anonymous Japanese London Escorts said...

We are a Central London agency with many of girls exclusive to London Japanese Paradise.

9/02/2011  
Anonymous Escort Models said...

Adoras Models is an escort agency in London where you can find the beautiful and exclusive London escorts. Adoras Models prides itself in running a honest and efficient London escort agency.

9/03/2011  
Anonymous London Asian Escorts said...

London Asian Escorts is an Asian and Oriental escort agency operating in Central London. The agency provides escort service for a true gentlemen.

9/09/2011  
Anonymous Escorts of London said...

Escort of London agency a well-established and respected agency. We have a great selection of girls in London for your pleasure.

10/11/2011  
Anonymous London Escorts said...

Only Pleasures is a well established and respected London escort agency. We are pride of ourselves on having the most exquisite selection of escort girls in London for your pleasure…

10/17/2011  
Anonymous By Viagra Online said...

Wow really very nice post here...

10/20/2011  
Anonymous Dapoxetine said...

Nice post...keep it up..

11/05/2011  
Anonymous Anonymous said...

It's working on emultor, but with device (devkit8000) i have this error:

An unexpected error has occurred in mojprogram.exe.
Select Quit and then restart this program, or select Details for more information.

File or assembly name 'System.Data.SqlClient, Version=3.0.3600.0, Culture=neutral,
PublicKey Token=3BE235DF1C8D2AD3', or one of its dependencies, was not found.

What to do?

2/09/2012  
Anonymous Anonymous said...

I cant attach northwind database...
an error occured when attaching the database.How?

5/05/2012  
Blogger robertd903 said...

Okay, judging from all of the "pats on the back"--I assume you have some knowledge in this area. Let me challenge you to find a solution to MY problem:

I am using VS2008 SP1 mobile device emulator (for testing), attempting to access an SQL SERVER 2005 express database. From my application, I am UNABLE to connect to my database. From within VS2008, I AM able to connect to my database--using the EXACT SAME connection string. I have tried the following:

...using SQL SERVER CONFIGURATION MANAGER, ensured TCP/IP enabled; port set to 1433, SQL BROWSER and SQL SERVER INSTANCE started and running;
...using SSMSE, ensured REMOTE CONNECTIONS allowed;
...TURNED OFF FIREWALL (out of desperation!)
...installed MS VIRTUAL PC2007;
...configured device emulator--enabled NE2000 PCMCIA network adapter and bind to CONNECTED NETWORK CARD;
...selected HOST-ONLY networking (using host computer's database)

AND STILL NOT ABLE TO CONNECT TO SQL SERVER 2005 EXPRESS DATABASE!!!! WHY!?!?!?!?!?!?!?!?!?!?!

11/20/2012  
Blogger Joe said...

Quetark you can use the server name but you must to use the instance must to be like this:"Data Source=ServerName\InstanceName"

11/23/2012  
Anonymous Anonymous said...

I simply cannot convey in words how grateful I am for your advice. I have been really struggling with these connection issues on my first freelance project (I'm a .net developer++ but a SQL Server adminstrator--) and been feeling like a total failure after going through loads of posts and nothing worked (panicking now!) until I worked through your post step by step and finally that flaming Connection object FINALLY opened!!! Thank you SO much, you made my day :)

7/17/2014  
Blogger Unknown said...

Hi,
Great tutorial!
I have problem for connecting Sqlserver database.It give me this error:
{"PlatformNotSupportedException"}

1/04/2015  
Blogger Massage Center said...

We are the one of massage hub in thane.We provide female to male body massage thane, Body to Body massage in Thane, female to male body massage parlour thane, female to male body massage center in thane.
Female to Male Body Massage in Thane
Female to Male Body Massage in Thane
Female to Male Body Massage in Thane

12/06/2016  
Blogger Massage Center said...

Nice post. I like this...
We are the one of massage hub in thane.We provide female to male body massage thane, Body to Body massage in Thane, female to male body massage parlour thane, female to male body massage center in thane.
Best Female to Male Body Massage in Thane
Female to Male Body Massage in Thane
Body Massage in Thane by Female
Full Body Massage in Thane

12/07/2016  
Anonymous buy provigil online said...

articles are very helpful and i thank you for your amazing insights. Kindly share few more blogs on the topic.

2/16/2017  
Anonymous Buy Genric Viagra said...

Great!All necessary information provided.Must go through it.

2/23/2017  
Blogger expertshelp said...

I really love information that have to do with computer software, and this happens to be one of the major posts that have offered very nice and helpful information. Its my greatest wish that you will keep on posting this kind of information. Thank you and kindly continue to post.
Gold Ceiling Downlight

4/17/2017  
Blogger Archana The best Call Girl said...


Dear Friends! Follow me on the links bellow for captivation call girls near you make your dreams of B2B intercaurse with females true. Thanks

mumbai call girl
russian escorts in mumbai
Escorts in Chembur

mumbai call girls
mumbai escorts
Call girls in Thane

Mumbai call girls
Call girls in Mumbai
Thane Escorts

12/04/2018  
Blogger Archana The best Call Girl said...

Dear Friends! Follow me on the links bellow for captivation call girls near you make your dreams of B2B intercaurse with females true. Thanks

escorts mumbai
escort mumbai
Call girls in Chembur

mumbai escort
escorts in mumbai
Chembur call Girls

escort service in mumbai
escort services in mumbai
Chembur Escorts

12/04/2018  
Blogger Morika Rawat said...

I am Morioka offering independent Model service I got something to please each and every gentleman, if you appoint often with us call or email to Pune Model available 24 hours.

Pune Escorts
Pune independent Escort
Pune Escort service

1/28/2019  
Blogger Naziaa said...

Chandigarh Escorts are the daring ladies for fun because they offer all sorts of sensuality. The babes can go for a date, love the men, offer friendly services, sing and dance with you, sleep with you in the night and various other services. Look for dashing services from hot babes in Chandigarh who are exceptional in their facilities.
Escorts service in Chandigarh
Escort service in Chandigarh
Escorts in Chandigarh
Escort in Chandigarh
Chandigarh escorts
Chandigarh escorts service
Chandigarh independent escorts
Chandigarh female escorts
Chandigarh escort
Chandigarh escort service
Chandigarh independent escort
Chandigarh female escorts
Female escorts in Chandigarh
Female escort in Chandigarh
Chandigarh female escort
independent escorts in Chandigarh
independent escort in Chandigarh
Chandigarh vip escort
Chandigarh vip escorts
vip escorts in Chandigarh
vip escort in Chandigarh
Chandigarh call girls
Chandigarh call girl
Call girls in Chandigarh
Call girl in Chandigarh
Chandigarh russian escorts
Chandigarh russian escort
Russian escorts in Chandigarh
Russian escorts in Chandigarh
Chandigarh russian call girls
Chandigarh russian call girl
Mohali escorts service
Panchkula escorts service
Zirakpur escorts service

Chandigarh call girls
Chandigarh call girl
Call girls in Chandigarh
Call girl in Chandigarh
Escorts service in Chandigarh
Escort service in Chandigarh
Escorts in Chandigarh

2/03/2019  
Anonymous Vip Escorts In Mumbai said...

Welcome to Vip Escorts In Mumbai the escorts mumbai with the finest skills of love making. Call: 9004063011, Our Escorts Service In Mumbai can make anyone happy because we are available 24/7

3/01/2019  
Anonymous jalandharescorts said...

Are you looking for Jalandhar Escorts? Jalandhar Independent Escorts, find the best companion on the Yuvleen Kaur official hooker’s website who gives you girlfriend experience. You can hire our 100% genuine Escort service in Jalandhar. We have VIP Escorts, College girls and Jalandhar Escorts Agency ready to entertain you at a budget price. Other Links Like Jalandhar Escort, Jalandhar Call Girls, Escorts In Jalandher etc etc.

3/02/2019  
Blogger Pia Trivedi said...


Adjoining getting the Indian and Asian escorts in the city, blonde and brunette free self-decision Delhi Escorts can in like way be grabbed if they live in your suggestive dreams. The most focal intriguing point them they are especially kept up, brilliant and enough stately to continue running with you out in the open places so you can book a social affair with them at whatever point you need to visit with an ideal female in a party. This is the essential reason; single respectful accomplices love to be with prominent friend.

3/19/2019  
Blogger Natalia Kapoor said...

It is only your Female Independent Escort in Delhi visit, who are such confederate, who can influence your life to live whether you devour a couple of minutes with them. They are totally cool and don't put you at any dangers.

4/11/2019  
Blogger sabhnamkhan171 said...

Zirakpur independent escorts are accomplished and professionally prepared in a wide range of grown-up fun and stimulation. These girls are best in giving physical love and giving sexual joys on bed during the evening. You can have boundless grown-up service in the event that you procure independent escorts in Zirakpur. Escorts Payal Sharma are handpicked and picked on premise of, looks, magnificence, nature and capacity to fulfil customer's sexual wants.
Escorts service in Zirakpur
Escort service in Zirakpur
Escorts in Zirakpur
Escort in Zirakpur
Zirakpur Escorts
Zirakpur Escort
Zirakpur Escorts Service
Zirakpur Escort Service
Call Girls in Zirakpur
Call Girl in Zirakpur
Zirakpur Call Girls
Zirakpur Call Girl
Female Escorts in Zirakpur
Female Escort in Zirakpur
Zirakpur Female Escorts
Zirakpur Female Escort
Independent Escorts in Zirakpur
Independent Escort in Zirakpur
Zirakpur Independent Escorts
Zirakpur Independent Escort
Russian Escorts in Zirakpur
Russian Escort in Zirakpur
Zirakpur Russian Escorts
Zirakpur Russian Escort

4/26/2019  
Blogger Ridhi said...

Female escort in Bangalore
Russian escort in Bangalore
Bangalore escort agency
Sexy collage girl in Bangalore
24/7 Available call girl in Bangalore

5/20/2019  
Anonymous interior designers in delhi ncr said...

Famous Interior Designers in Delhi, Interior Decorators in Delhi ncr,, Residential Design in delhi ncr, Top 10 interior designers in Delhi

best interior designers in delhi
top interior designers in Gurgaon
interior designers in delhi ncr
home interior designers in delhi india
top 10 interior designers in delhi
famous interior designers in delhi
interior decorators in delhi ncr
Residential Design in delhi ncr
home interior design in Delhi
luxury interior designers in delhi
top interior design companies in Delhi
top interior design companies in delhi ncr
designer furniture stores in delhi ncr
residential interior designers in delhi
best interior designers in india

6/07/2019  
Anonymous Mba course in distance education said...

Aiimes provides Mba course in distance education, B.tech in distance education, Engineering course in distance education, Mechanical course in distance education.

best interior designers in delhi
top interior designers in Gurgaon
interior designers in delhi ncr
home interior designers in delhi india
top 10 interior designers in delhi
famous interior designers in delhi
interior decorators in delhi ncr
Residential Design in delhi ncr
home interior design in Delhi
luxury interior designers in delhi
top interior design companies in Delhi
top interior design companies in delhi ncr
designer furniture stores in delhi ncr
residential interior designers in delhi
best interior designers in india

7/03/2019  
Blogger malar said...

Thank you for excellent article.You made an article that is interesting.
Tavera car for rent in chennai|Indica car for rent in chennai|innova car for rent in chennai|mini bus for rent in chennai|tempo traveller for rent in chennai
Keep on the good work and write more article like this...
innova car rental in chennai|Tavera car rental in chennai
Great work !!!!Congratulations for this blog

7/05/2019  
Blogger leenaroy said...

Air Hostess Escorts in Delhi A legend among the most incredibly fascinating Leena Roy Escort in Delhi, who just prefers men that have a class and are sensible.

9/16/2019  
Blogger Nancy Oberoi said...

They turned out to be so challenging with excellent efforts and planning. They are Hyderabad Escorts, who have strange styles of beauty and bias. In their lovemaking attitudes they are such a large quantity of master that no other High Profile Escorts in Hyderabad is similar with them. They've got all the excellent characteristics and characteristics to get you excited. If your eyes continue to run over them, you will be agitated to avail yourself of their services. For sure, they are the great side effect of fairies.

10/23/2019  
Blogger Schloka - Free classifieds in india said...

Ambala Call Girls
Bhiwani Call Girls
Faridabad Call Girls
Fatehabad Call Girls
Gurgaon Call Girls

12/06/2019  
Blogger Escort Service Dehradun said...

There are many escorts in Dehradun where you can get the service but our main motto is to give the quality service according to demand.

1/23/2020  
Blogger Tanu Sharma said...

Our best Chandigarh escorts are waiting to meet you in the time alone of your hotel room, to be your buddy for the night out or anything else you might desire.

Haridwar escorts
Rishikesh escorts
Dehradun escorts
Mussoorie escorts
Panchkula escorts
Call girls in Chandigarh

1/23/2020  
Blogger Jannat Models said...

Sounds Good,

Amritsar Escorts 
Amritsar Escort
Amritsar Independent Escorts 
Amritsar Independent Escort
Amritsar Escorts Service 
Amritsar Escort Service 
Amritsar Escorts Services
Amritsar Escorts Agency 
Amritsar Escort Agency 
Amritsar Call Girls 
Amritsar Call Girls Service 
Amritsar Call Girl
Amritsar Call Girl Service


Chandigarh Escorts
Chandigarh Escort
Chandigarh Escort Service
Chandigarh Escorts Services
Escorts In Chandigarh
Escort In Chandigarh
Chandigarh Independent Escorts
Chandigarh Independent Escort
Chandigarh Escorts Agency
Chandigarh Escort Agency
Chandigarh Call Girls
Chandigarh Call Girl

Thanks for sharing this amazing stuff.

2/01/2020  
Anonymous sara jenifer said...

Your site is truly cool and this is an awesome moving article.
Allahabad BCom Time Table 2020
Agra BCom Time Table 2020

2/05/2020  
Blogger Neha Sharma said...

If you guys looking for best sex story site then Click here to Read my sex story

3/05/2020  
Blogger Divya Mehta said...

The society is pretty prejudiced when it comes to men paying women for pleasurable or entertainment services. Prostitution is such a service that has been prevalent in the society for centuries and over the time has become a common umbrella term for any pleasurable service that is offered by women to men in lieu of money.
Ludhiana Escorts Blog
Ludhiana Call Girls Blog
Patiala Escorts Blog
Mumbai Escorts Evernote Blog
Ludhiana Escorts Hatena Blog
Mumbai Escorts Hatena Blog

6/08/2020  
Blogger Divya Mehta said...

Among the others Ludhiana Escorts Services are in nice interest as a results of the wide assortment of feminine alternative it furnishes aboard the many suggestive and non-sexual agency
Ludhiana Call Girls Evernote Blog
Ludhiana Escorts EklaBlog
Mumbai Call Girls Blog
Ludhiana Escorts Blog
Ludhiana Call Girls Blog
Mumbai Escorts Blog
Ludhiana Escorts

6/08/2020  
Blogger leqis said...

Find your dream escorts at Manchester Escorts Directory from different location Leeds escorts, Liverpool escorts, Wigan escorts, Bolton escorts, Preston escorts, Warrington escorts and much more.

7/19/2020  
Blogger Salma Ji said...

https://ello.co/celebboxing
https://prince.org/profile/celebboxing
http://www.webestools.com/profile-202460.html
https://www.steinberg.net/forums/memberlist.php?mode=viewprofile&u=235357
http://click2connectclubs.com/index.php?do=/public/forum/posts/id_2980/
https://digitalmedialab.johncabot.edu/members/celebboxing/
https://aulasabiertas.congresos.unc.edu.ar/perfil/celebboxing/
https://www.wpdownloadmanager.com/support/users/celebboxing/
https://knkusa.com/forums/users/celebboxing1/
https://www.new-aspect.ru/forums/users/celebboxing/

7/28/2020  
Blogger Unknown said...

Girlfriend for a day An escort is a distinct partner whose business enterprise goes to have getting better effect for your tired body and mind. As Rajasthan Escort is quite pleasant in nature similarly to extra talkative too. Rajasthan escorts are completely discrete and one of a form of their issuer it truly is why you do not want to be worried about a few element within the slightest.

Rajasthan Escorts Call Girls ||
Ajmer Escorts Call Girls ||
Alwar Escorts Call Girls ||
Bhilwara Escorts Call Girls ||
Bikaner Escorts Call Girls ||
Jaipur Escorts Call Girls ||
Jaisalmer Escorts Call Girls ||

10/03/2020  
Blogger RUBI PUNE said...





Aundh Call Girl
Pune call girl
Baner call girls
Wakad call girls
Pimpri Chinchwad call girls
Hinjewadi call girls
Kalyani Nagar call girls
Koregaon Park call girls
Lonavala call girls
call girls shivaji nagar pune

4/27/2021  
Blogger priyatakur said...

Bangalore Escorts Service Elite Call Girl in skokkaa
Enjoy at Bangalore with a hot and sexy girls. Avail here luxury Bangalore escorts
and spend some quality time with her
Bangalore Escorts ||
Marathahalli escorts

5/16/2021  
Blogger Instant love spell Georgia USA said...

Love lost spells to get your ex back, make someone love you, attract a new lover, stop your lover from cheating & lost love spells to heal a broken relationship, mend a broken heart, make your lover listen and understand you. Consult Dr. Ahmed for lost love spells and online free review Lost love spells in UK | Lost Love Spells in Netherlands | Lost love spells in USA | Love Spells in UK | Love

7/17/2021  
Blogger دیجیتال مارکتینگ و راه اندازی کسب و کار آنلاین said...

فروشگاه لوازم آشپزخانه تهران
فروشگاه لوازم آشپزخانه شهرام فر
فروشگاه لوازم آشپزخانه عمده
فروشگاه لوازم آشپزخانه مدرن
فروشگاه اینترنتی لوازم آشپزخانه ارزان قیمت

9/10/2021  
Anonymous Best interior designer Bihar said...

Homeinteriors comes with the Best interior designers in Patna
and Bihar. We provide latest designs for every type of interiors. Your ideas can also make
us think differently. We work along with our cilent's openion. For more info. find us.

5/07/2022  
Anonymous best interior designer in patna said...

A creative mind of Designer Associates put a creative touch to your home or office. We can help you to make your space look great with your personal choice. We use our expert insights to create designs that will help you to leverage the space to its maximum
interior designer in patna



7/24/2022  
Blogger Redleaf interior said...

Interior decorators in Patna who can transform your living space into a space of your dreams with panache. Interior decorators in Patna that have mastered the art of interior designing
interior designer in patna

7/30/2022  
Anonymous Thane Escorts said...

Great Blog Post Keep Wrighting Great Posts, Thanks for Sharing

8/13/2023  

Post a Comment

<< Home