The firewall on both sides are off. I discovered the reason but the do not know what to do exactly. The thing is that the remote server which is VPN server can not use netbios to reply to local server it can not resolve the Computer name. after the connection is made it is for about two seconds can reslove the name but after that it stop. I you know beside firewall what can cause such problem do not hesitate to tell me. Extra information : the remote server is win2003 local server is Winxp Pro both have sql 2005 standard edition No firewall software is installed and windows firewall is off. Thanks

Hi all, I got a problem with running distributed transactions between two servers that is connected via VPN connection (using RRAS). after the VPN connection is connected I can connect to the remote server with Microsoft SQL server management Studio and I can run query againts server. The problem occures when one of my store procedures start a distributed transaction and wants to insert at the remote server. (with just one insert command I can insert rows in the remote server but I can not wrap in a transaction) I got this error : "OLE DB provider "SQLNCLI" for linked server "172.26.0.11\CENTER" returned message "No transaction is active.". Msg 7391, Level 16, State 2, Procedure p_InsertPointOnline, Line 54 The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "172.26.0.11\CENTER" was unable to begin a distributed transaction." I tried the following things : 1. turn off firewall in both sides. 2. Checking MS DTC security to allow outbound an inbound transactions on both sides 3. SET XACT_ABORT ON 4. SET REMOTE_PROC_TRANSACTIONS ON the strange thing is when I switched the firewall off and reconnect the VPN I got some transactions through. But the day after that the system did not work, after a lot of time I again turn the firewall back on with some added port as exceptions. Again it works until I disconnect the VPN and reconnect. I again turn the firewall off and reconnect the VPN it works again, you see the loooop :((!!! if any one could help me with this issue I would be gratefull. Hope you never stuck in such situations.

Hi In SqlDataAdapter da = new SqlDataAdapter(this.richTextBox1.Text.ToString(), con); The first parameter in the Select Command and DA. Use this command to fill the dataset. As you are written you drop a procedure and does not select anything ! To run such command against Sql Server use SQlCommand class.Like this : SqlCommand cmd = new SqlCommand("",); cmd.ExecuteNonQuery();

Hi, I have a win Application in which I use toolbar bottons.when I roll over the buttons my computer CPU usage shows up to 70 % percent CPU usage. More info. I use .NET Framework 1.1 Any help would be apprecited

Thanks But you know when I am using asp.net there was a problem that only I can use imgeurl in my asp:Image control and I can not address the Image which reside on memory. I kind I have a solution by using a proxy page but that is kind of hard. And I thing there might be a better solution like that which we use in Windows Applications Like in example : Bitmap bmp1 = new Bitmap(bmp, new Size(500,300)); pictureBox.Image = bmp1; if any other usefull urls or suggestions please tell me

Hi I have problem to how could I show an image file which has been saved in db in my pages. I mean I have an image file that has been saved in db and I want to load it in my page. I search articles and I found nothing ! I appreciate your help Regrads

Hi I have declared a Socket.I have some problem on recieving data.I can not find my answers about Socket flags And how could I use them. Actually I wanted to use "SocketFlags.MaxIOVectorLength" unfortunatly it did not worked. tmpSocket.Receive(DataBuffer,0,BufferSize,SocketFlags.MaxIOVectorLength); Please give me help or resource on this Subject ? Thanks in advance.

Thanks Colin. I think that is the bottom line ! That 'll do my work ! :laugh:

hi First of all thanks . But you know I actually wanna to do the following thing : on button click of a page I wanna to do some server works to find out where should the response redirect and with what parameters.and then I don't wanna redirect my response to that page I wanna to Open a new page. I know about the window.open() return true; thing but that does not apply in this situation.and also know about the grid asp:HyeperLinkColumn but that dose not either. I think that may not be possible.(this much easy:sigh:)

Hi I wanna to open a new page from the server side in the client. I only know about the Response.Redirect that redirect the response to the another page and does not open a new page. Something like window.open of javascript that opens a new window but that is in the client side.

Hi I do not know if I'm get it right but from what you say : there is property of the form which when you set it to true also the form keypressed and key up key down raises . frmMain.KeyPreview = true ; then you can use form 's event to handle what you want.

Hi Do you run your programm with Ctrl+F5 ? if not that could be your problem ! Because that compile your code into dll file in bin Directory which then used by your application . The error seem that the links which you click miss onclick event ! check OnClick Event of the links that assign correctly to the controls . And you sure you are using "http://Localhost/MyApplication/" in your browser which if not your server side application can not be run ! I hope that help

Oooh Man ! Hi That was a real help . Thanks a lot I am totally in the wrong path . and never can get what I want . I am about to change the Character to it 's UTF8 code then save that in my Sql DataBase. I hope I can return a favour .

Hi I'm developing a site which contain Armenian Unicode Characters I have problem to save data into Ms Sql . I kind of sure I do not choose the right collation for my Database but I do not know which collation should I choose . I choose Cyrlic_General_CL_AS for my DataBase . Some one say that the charset should Mach to work correctly I set the Character set of my page to charset="windows-1251" Help me if I choose the wrong Collation and what is the right one ? or should I change something in my page characterSet ? Thanks

Hi As Mike Said below a full description if need join ! I do not exactly know what are you after if these two tables have relation you probably need kind of join ! but I can give another hint if you don't know it before ! when you use SqlDataAdapter (or Command) it only turns SqlData to some format that visul Studio can show . then you fill the DataSet SqlDataAdapter.Fill(DataSet,"TableName"); it brings the sql Data to a format Like Sql But Viewable with visual Sudio Tools ! so you can add two SqlTable to one Table in DataSet then can show that table with a grid . But Mike's message is very good for joinning Two tables.it works at the SqlServer Level .

thanks for telling me ! but I don't know if you Read my message !!!! "I post this message in the Part Sql/ADO but no one answer !!! " C# Forum have seen a lot more by developers !

Hi Try : Select * from Diagnosis,Diagnosis this brings the two table in one result set and you can show the result set in one grid

Hi, I want to save Armenian UniCode Characters in my tables of SqlServer any body knows which collation should I choose for my DataBase ?!! or Some Place I can find the right collation I searched the microsoft collation list but I find nothing. I post this message in the Part Sql/ADO but no one answer !!! Thanks in advance .

Hi Where you Put int num3 = Convert.ToInt32(num2); Num2 turns to 0.because it has 0 as integer part.you better convert Num1 to Decimal !! or just Multiply Nme1 and Num2

Hi, I want to save Armenian UniCode Characters in my tables any body knows which collation should I choose for my DataBase ?!! Thanks in advance .