|
Hi all
i have created a windows application using c#... its working fine in the developed system(ie server)...and i have created an exe of that and put it in another system...which is connected to the server...am getting an sql error(remote connection error)
and the system which i put the exe doesnt have sql/VS
what can be the reason?
|
|
|
|
|
Really that is not a Complete Error and you know it, post us a complete error.
When you Deploy the Application to a Client machine, the machine does not need to have VS or SQL installed. How did you create your exe and when does this error occurs ?
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswam@its.co.za
|
|
|
|
|
This is the error am getting while running the exe
--------------------------------------------------
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Webcam_Test.Form1.btnok_Click(Object sender, EventArgs e) in C:\Documents and Settings\Sreenivas\Desktop\cafeCup-04-02-09\C__Webcam_161075762003\Webcam_Test\Form1.cs:line 358
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
Webcam_Test
Assembly Version: 1.0.3324.23182
Win32 Version: 1.0.3324.23182
CodeBase: file:///C:/Program%20Files/DotNet/Setup06-02/Webcam_Test.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Management
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
WebCam_Capture
Assembly Version: 1.0.3322.24568
Win32 Version: 1.0.3322.24568
CodeBase: file:///C:/Program%20Files/DotNet/Setup06-02/WebCam_Capture.DLL
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
------------------------------------------------
|
|
|
|
|
There are Different reasons why you see this
Do you have a .NET Framework install in the Target Machine ? If so What is the Version and what Version of VS are you using ?
Are you installing this From a Network share ? Because if so there might be CAS(Ssecurity Problems) Problems ?
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswam@its.co.za
|
|
|
|
|
ya i have installed .NetFrameWork 3.5..
and am installing this directly to the system...
|
|
|
|
|
So that means you are using VS2008 ?
And Did you create setup Project or you just build the project and take the exe that gets created in the bin directory ? 
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswam@its.co.za
|
|
|
|
|
ya..what i did is..i have created a setup for that and that i put it in the other machine and run the set up to install... den i copied the exe in the bin and put in the sytem and tried running and got this error..
may be my approach is wrong
am new to c# and learning...
can u just tel me how to how to create the setup and wht and all i should do to the client machine to get it work?...
|
|
|
|
|
Thats was your mistake
Step 1
After you are happy with your application
Step2
Right Click on your Project and Add New Project,Go down to "others Project types" and look for a "SetupProject",
look at the path and make sure that its in the same directory as your Project and give it a name, just give it the same name as your Project but add something like MyProject_Setup.
Step 3:
At the Bottom of your Solution explorer you will see your setup Project and Right click on your setup project and select --> Project Output, You will see that automatically the name of the Project to be outputed will be displayed, just click ok.
Step 4:
In Visual Studio there is a Green Button that you use to run your program with , and next to it , the is an Option that is written "Debug", change it to Release"
Step 5:
Right Click your Application and rebuilt
Step 6:
Right Click your setup project and rebuilt
Step 7:
Go to your Application Folder(NOT in VS) and you will see that there is a Folder that has been created for you and it will have
a name like MyProject_Setup. Open it and Open the "Release" Folder and thats what you must take to the Clients computer and run a setup and your application will work.
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswam@its.co.za
|
|
|
|
|
ok..Thanks for ur kind reply...let me try with ur steps...
|
|
|
|
|
am not getting that release option.... is there any way to set that?
|
|
|
|
|
ok now i have taken the setup from the release folder and ran in client machine....it got installed and only the dll of the application is created...am not getting any application file to run the application?...do i need to copy the other files from the bin/debug folder?...
|
|
|
|
|
I want to create sub table in sql server . can any suggest me the process.
|
|
|
|
|
What is a sub table ? Did you know we have a SQL forum ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hi
i have used ManagementObjectSearcher class for listing the drives...
there is no error but it does not display the output....
please can anyone check the code and tell me whether this approach is right...If not please tell me what is wrong with this...and what modifications should i do to get required drives in the server?
private void button1_Click(object sender, EventArgs e)
{
try
{
ManagementObjectSearcher mosDisks = new ManagementObjectSearcher("SELECT name FROM Win32_DiskDrive");
// Loop through each object (disk) retrieved by WMI
foreach (ManagementObject moDisk in mosDisks.Get())
{
// Add the HDD to the list (use the Model field as the item's caption)
listBox1.Items.Add(moDisk["Model"].ToString());
}
}
catch (ManagementException me)
{
MessageBox.Show(me.ToString());
}
}
|
|
|
|
|
Well, the biggest problem is that you didn't check to see if the call to mosDisks.Get() actually returned anything. You just went straight to enumerating the collection that is MIGHT have returned. In this case, your WMI query didn't work, or didn't find anything to return.
|
|
|
|
|
|
Hard to tell without seeing the code. If you are not creating new form object each time, it should retain all the controls and it's values.
Please post the relevant code.
|
|
|
|
|
It shouldn't reload the controls each time unless you are constructing an instance of it each time (i.e. AForm Form2 = new AForm()) or you are calling some other method which forces it to reinitialise (e.g. are you handling some event in Form2 which initialises the controls)
Easy to see - breakpoint at ShowDialog and trace in to see what happens. If you're not sure if it's the same instance of the form each time, set the title to be the current time in the constructor.
___________________________________________
.\\axxx
(That's an 'M')
|
|
|
|
|
I will set a break point and do a trace. I only create Form2 once. Form 2 only gets initialized once as well. However I can tell you that every time Form2.ShowDialog(this) is called it gets into my Form2_Load but when I call it using Form2.Show(this) it only gets into Form2_Load once.
Below is a sample of code that is creating and Showing Form2.
<pre>
public partial class Order : UserControl
{
public OrderEntry.UserControls.OrderOptions orderOptions = new OrderEntry.UserControls.OrderOptions();
public Order()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
}
private void setupButton_Click(object sender, EventArgs e)
{
if (this.orderOptions.ShowDialog(this) == DialogResult.OK)
{
}
else
{
}
}
}
</pre>
Below is a sample of Form2.
<pre>
public partial class OrderOptions : Form
{
public OrderOptions()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
//Need to makes sure that all controls are enabled and disabled correctly.
if (this.printImmediately.checkBox1.Checked)
{
this.invoiceMsg.Enabled = true;
this.receiptMessage.Enabled = true;
}
else
{
this.invoiceMsg.Enabled = false;
this.receiptMessage.Enabled = false;
}
if (this.barcodeScanning.checkBox1.Checked)
{
this.stopInQuantity.Enabled = true;
}
else { this.stopInQuantity.Enabled = false; }
}
private void OrderSetup_FormClosing(object sender, FormClosingEventArgs e)
{
this.Hide();
e.Cancel = true;
}
}
</pre>
|
|
|
|
|
|
Well, I would think this is how it is meant to behave.
When you Show() a form, you may show and hide it, with the 'controlling' program deciding upon its visibility, but it is only Loaded the first time it is shown.
With a dialog form, you have to close it before continuing - so as it is closed, showing it again 'Loads' it.
I'm guessing you are hiding the dialog to save time in having to recreate it each time?
If you want to keep the values, set them up in the Form2 constructor - then they won't be set again - or add your own 'init' method which you can call when you want to initialise the form.
The bottom line is that the Load event is triggered when the ShowDialog method is used, so don't put code there when you don't want it executed every time.
___________________________________________
.\\axxx
(That's an 'M')
|
|
|
|
|
Setting up the values in Form2's constructor fixed my problem. Thank you very much.
|
|
|
|
|
Not a problem - glad to be of help
___________________________________________
.\\axxx
(That's an 'M')
|
|
|
|
|
Hi,
I need to parse some text that's currently is in PDF-format so I'm thinking that converting it to text or html would be a good place to start.
There are a lot of PDF-component out there for C#, has anyone of you tried anyone and can tell me which once are doing a good job.
Thanks.
|
|
|
|
|
I have used PDFBox. But its in java. So you need to use iKvm.net to use PDFBox.dll in .Net. It has a class called PDFTextStripper which has a method called getText. But this will only work on Text PDF. It won't work on Image PDF.
But if it not that much taks you can use iTextsharp.
One more thing So far I have learned that iTextsharp is great for creating pdf and PDFBox is great for parsing/reading pdf.
Be careful, there is no Undo Button(Ctrl+Z) in life.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
