|
Hi Henry,
Thanks for your feedback.
Sorry about the lack of information. It's a SQL Anywhere 10 database that I'm trying to connect to and I'm writing in C# within the .NET framework.
Please let me know if there is any other information I can give you that would be helpful.
Thanks again,
MWRivera
|
|
|
|
|
Did you try the connectionstrings.com link I gave?
I have found for version 11[^], don't know if it will help for V 10 though as I'm not familiar with SQL Anywhere.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Henry,
Thanks I was able to connect after visiting the site you referred.
I had to play around with a combination of connects but got there in the end
The connection string is:
ENG=serverName;DBN=databaseName;Uid=username;Pwd=password;Links=tcpip(Host=server);
Do you know if the connection is using anything in particular to connect ADO.net or anything like that? Or is this a straight connection to the server (if that's at all possible).
Thanks again
|
|
|
|
|
MWRivera wrote: Do you know if the connection is using anything in particular to connect ADO.net or anything like that? Or is this a straight connection to the server (if that's at all possible).
That depends as much on the code that you have that uses the connection string. However it looks very much like ADO.Net.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Hello i have to create an application that read an existing drawing file .DWG and then aorder a robot to cut the shape drawin in a tissue
any help , which tools i should use , i am thinking about microsoft robotics and c#?
|
|
|
|
|
That's an ambitious task - this is for school ? Have you worked with Autocad in C# before ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Hi
I have a void method which has an interface passing parameters in and parameters going out. This method is in one Visual Studio Project. However, when I open up my other Visual Studio Project which has a service reference to the other Visual Studio Project, and call the method, I can only see my in parameters and not out parameters. If I change the method to a function I can see both, but I don't want a function!
Can someone please explain why this is the case? Am I missing something?
Please help!
|
|
|
|
|
Hi,
in C# all callable code units are called methods, whether they return something or not (as opposed to Fortran or Basic subroutines and functions). And the behavior of parameters is independent of the return type.
So I suggest to check your facts again; if need be, show us the one that works well and the one that fails.
Luc Pattyn
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
Local announcement (Antwerp region): Lange Wapper? Neen!
|
|
|
|
|
Since you are speaking about a Service Reference, I assume you are using WCF.
Apparently, WCF supports out parameters in operations (I didn't think it did), but can have some tricky behaviors with them (look this discussion, for instance).
I strongly suggest you to refactor it by changing the out parameter to return value, since your method don't already has one. Really, that will be effectively the same.
|
|
|
|
|
Yes, I am using WCF on a pipe between two applications, and yes I did notice the change in position of the input and output parameters but this isn't the problem.
If a have a method public bool mymethod (string abc, out string def) and call this method on in my other project, I can see output parameter and when I run the project a is returned. So, no great issues there, but if I change the method to public void (string abc, out string def) and go back to my project I only ever see the input parameter.
Any ideas?
|
|
|
|
|
AndyASPVB wrote: Any ideas?
Yes, refactor your code to not use out parameters. It is not a recommended design for WCF implementation and if you use a code analyzer it will flag this as a design issue that should be reviewed.
only two letters away from being an asset
|
|
|
|
|
Edit: It seems i have missread your post, if this doesn't help i am sorry
You didn't explain properly. There can be either solution, depends on your need
you can use ref keyword
Int32 getDouble = 6;
DoubleIt(ref getDouble);
public void DoubleIt(ref Int32 nevVal)
{
nevVal = nevVal * 2;
}
You can use Property
public class A
{
public A(){}
private Int32 _subInt;
public Int32 unit
{
get
{
return _subInt * 2;
}
set
{
subInt = value;
}
}
}
A a = new A();
a.unit = 4;
MessageBox.Show(a.unit.ToString());
|
|
|
|
|
can anybody help
i do have both window and web application that have to work on the same database file. they work fine in design time together I mean before deploying. Now i have deployed them independently and work fine except they can't share the database file.
the main problem is the windows application is installed in C:\program files...
while the web application is installed in the file path C:\inetpub\wwwroot\..
|
|
|
|
|
Djtech01 wrote: the main problem is the windows application is installed in C:\program files...
while the web application is installed in the file path C:\inetpub\wwwroot\..
of course they are. Why is that a problem ? Is it an access file ? Did you write your windows app to require the DB to be in the same folder as the exe ? If they share the same DB, that must mean that the windows app is designed to run on the server ? You need to give more details if you want help.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
First of all, thank you
secondly, sorry for the reason that I became silent, It is because I wasn't connected to the internet for the last 20 hrs.
the database file is SQL
Christian Graus wrote: Did you write your windows app to require the DB to be in the same folder as the exe ?
yes that is the problem. the windows app will search the database in the same location as the exe.
Christian Graus wrote: If they share the same DB, that must mean that the windows app is designed to run on the server ?
yea the windows app is designed to run on the server
hope to hear from you soon
thank you
|
|
|
|
|
I guess you don't want help then ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
I have made server with this code and in new form. When I push button that loads this form it stops.
private void server_Load(object sender, EventArgs e)
{
Int32 port = 1111;
IPAddress localAddr = IPAddress.Parse("127.0.0.1");
TcpListener tcpListener = new TcpListener(localAddr, port);
tcpListener.Start();
Console.WriteLine("Strežnik pognan...");
try
{
Socket socketForClient = tcpListener.AcceptSocket();
while (true)
{
if (socketForClient.Connected)
{
MessageBox.Show("Odjemalec povezan " + socketForClient.RemoteEndPoint.ToString(), "Napaka", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
NetworkStream networkStream = new NetworkStream(socketForClient);
StreamWriter streamWriter = new StreamWriter(networkStream);
StreamReader streamReader = new StreamReader(networkStream);
string line = streamReader.ReadLine();
textBox1.Text = "Sprejeto: " + line;
line = line.ToUpper();
streamWriter.WriteLine(line);
Console.WriteLine("Poslano: " + line);
streamWriter.Flush();
Console.WriteLine();
}
socketForClient.Close();
}
}
catch (Exception x)
{
Console.WriteLine(x.ToString());
}
When i connect client(also new form) to it..client form opens(client connected) but server form still isn't responding. Now i would like to type something in client and this message would be also writen lets say in textbox in server. If i delete while(true) it works but only first time. What should i do that it would work multiple times.
Please help
|
|
|
|
|
Hi,
IMO there are a few problems:
1.
Socket socketForClient = tcpListener.AcceptSocket(); is a blocking call, which means it returns only when the connection is established. So the thread will have to wait; as the code seems to be inside a Form's Load handler, that Form will not show nor function as long as you don't have a connection.
2.
the whole if (socketForClient.Connected)... statement sits inside a while loop which has no way to terminate, so your code will never finish the Load handler, your Form will never become alive.
The solution to both problems is to use a separate thread; that way your Form can start, and react to your operations, while the other thread deals with the networking. Handlers running on the GUI thread (such as a Load handler) should never take more than some 30 milliseconds, which basically means all networking should always be performed by some other thread.
Luc Pattyn
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
Local announcement (Antwerp region): Lange Wapper? Neen!
|
|
|
|
|
Ok i changed it somehow now..it works now.. now next step for me is to transfer data for drawing. Lets say i draw circle in client..how to send data(x,y,width,heigth,colour) of it to server, so circle would be also drawn there?
Thanks,
Bye
|
|
|
|
|
So you need to define a "language" that you will use to communicate between both apps; it must cover all the functionality you plan to support. First decision is text versus binary; text is the preferred way for portability and ease of debugging; binary would be somewhat more compact and faster. Go for text!
example (just one from an infinite number of possibilities; each #x is a number):
color,#r,#g,#b;
circle,#x,#y,#w,#h;
end;
Luc Pattyn
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
Local announcement (Antwerp region): Lange Wapper? Neen!
|
|
|
|
|
For the first time i send string to server it works..second time it gives me this error:
<br />
A first chance exception of type 'System.InvalidOperationException' occurred in System.dll<br />
An unhandled exception of type 'System.InvalidOperationException' occurred in System.dll<br />
<br />
Additional information: The operation is not allowed on non-connected sockets.<br />
<br />
The thread 'vshost.RunParkingWindow' (0xf94) has exited with code 0 (0x0).<br />
The program '[6184] server_client.vshost.exe: Managed' has exited with code -532459699 (0xe0434f4d).<br />
I am getting something for sockets..but on server_load sockets starts and they don't stop. Do i have to make new socket for every new string i send? I am beginner here so plz don't judge me if i ask simple questions.
Thanks for any help
modified on Thursday, October 8, 2009 11:47 AM
|
|
|
|
|
why would you open and close the connection and the streams all the time? can't you just set them up once and keep them open?
That would imply you turn some of those variables into class members of course.
Luc Pattyn
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
Local announcement (Antwerp region): Lange Wapper? Neen!
|
|
|
|
|
Here is my code for sending:
private void poslji()
{
novo = textbox();
NetworkStream networkStream = odjemalec.GetStream();
StreamReader streamReader = new StreamReader(networkStream);
StreamWriter streamWriter = new StreamWriter(networkStream);
streamWriter.WriteLine(novo);
Console.WriteLine("Pošiljam sporočilo...");
streamWriter.Flush();
string s = streamReader.ReadLine();
textBox1.Text = s;
Console.WriteLine("Prejemam sporočilo...");
Console.WriteLine(s);
streamReader.Close();
streamWriter.Close();
networkStream.Close();
}
And here is code for server in server_load form:
try
{
IPAddress ipAd = IPAddress.Parse("127.0.0.1");
TcpListener myList = new TcpListener(ipAd, int.Parse("1111"));
myList.Start();
Socket socketForClient = myList.AcceptSocket();
Console.WriteLine("Odjemalec povezan " + socketForClient.RemoteEndPoint.ToString());
NetworkStream networkStream = new NetworkStream(socketForClient);
StreamWriter streamWriter = new StreamWriter(networkStream);
StreamReader streamReader = new StreamReader(networkStream);
string line = streamReader.ReadLine();
Console.WriteLine("Sprejeto: " + line);
line = line.ToUpper();
textBox1.Text = line;
streamWriter.WriteLine(line);
Console.WriteLine("Poslano: " + line);
streamWriter.Flush();
Console.WriteLine();
it sends first time..next time error that i pasted in post before.
|
|
|
|
|
Hello everyone, It has been long time I am trying to solve or deal with two ro more version of Excel file. It works for one not for others. Really don't know how to Accommodate all the different excel version in one project.
My Application works only with 2007 version.(The application in c#)
Jashim
|
|
|
|
|
You're using the office primary interop assemblies version 12, you must also use the PIA's for version 11 which is office 2003.
|
|
|
|