Re: Error in the code - C# Discussion Boards

Re: SQL connection string using IP address

aastudent14-May-09 19:46

14-May-09 19:46

Yep I did set the network library, doesn't work.

connectionstrings.com give this example:

Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

I'm wondering, is it absolutely essential to provide a User ID and Password?

Re: SQL connection string using IP address

Spunky Coder14-May-09 23:14

Spunky Coder

14-May-09 23:14

aastudent wrote:
Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

Ideally it should work with the connection string you have specified. Try your luck by giving the provider name Smile | :)

"Provider=sqloledb;Network Library=DBMSSOCN;"
        "Data Source=190.190.200.100,1433;"
        "Initial Catalog=MyDatabaseName;User ID=MyUsername;"
        "Password=MyPassword;"

"Don't worry if it doesn't work right. If everything did, you'd be out of a job." (Mosher's Law of Software Engineering)

Re: SQL connection string using IP address

Mycroft Holmes14-May-09 21:46

Mycroft Holmes

14-May-09 21:46

I use the following string

Data Source=Server;Initial Catalog=Database;User ID=xUser;Password=PWD;Pooling=True;Min Pool Size=1;Max Pool Size=10

no library using the SQLClient, works perfectly

Never underestimate the power of human stupidity
RAH

Re: SQL connection string using IP address

aastudent14-May-09 22:14

aastudent

14-May-09 22:14

Could you specify what your "Datasource=server" looks like? My problem is going from "DataSource=SQL2008ServerName" to using IP and port. Do I need something like "DataSource=x.x.x.x\SQL2008ServerName"? If so where do I specify the port?

Re: SQL connection string using IP address

Mycroft Holmes14-May-09 22:34

Mycroft Holmes

14-May-09 22:34

Sorry - I use a server instance name but I'm pretty sure you can use a bracketed IP address [###.###.###.###]

Never underestimate the power of human stupidity
RAH

caspol

devvvy14-May-09 19:14

devvvy

14-May-09 19:14

hello

ran command "caspol -listgroups", not sure what "StrongName" below means. what are those two entries, especially one with strong name=all-zeros?

<br />
Security is ON<br />
Execution checking is ON<br />
Policy change prompt is ON<br />
<br />
Level = Machine<br />
<br />
Code Groups:<br />
<br />
1.  All code: Nothing<br />
   1.1.  Zone - MyComputer: FullTrust<br />
      1.1.1.  StrongName - 00240000048000009400000006020000002400005253413100040<br />
0000100010007D1FA57C4AED9F0A32E84AA0FAEFD0DE9E8FD6AEC8F87FB03766C834C99921EB23BE<br />
79AD9D5DCC1DD9AD236132102900B723CF980957FC4E177108FC607774F29E8320E92EA05ECE4E82<br />
1C0A5EFE8F1645C4C0C93C1AB99285D622CAA652C1DFAD63D745D6F2DE5F17E5EAF0FC4963D261C8<br />
A12436518206DC093344D5AD293: FullTrust<br />
      1.1.2.  StrongName - 00000000000000000400000000000000: FullTrust<br />
   1.2.  Zone - Intranet: LocalIntranet<br />
      1.2.1.  All code: Same site Web<br />
      1.2.2.  All code: Same directory FileIO - 'Read, PathDiscovery'<br />
   1.3.  Zone - Internet: Internet<br />
      1.3.1.  All code: Same site Web<br />
   1.4.  Zone - Untrusted: Nothing<br />
   1.5.  Zone - Trusted: Internet<br />
      1.5.1.  All code: Same site Web<br />
Success<br />

dev

Error in the code

Payam Rastogi14-May-09 17:47

Payam Rastogi

14-May-09 17:47

Hi,
I'm using C#.net 3.0.I used this code but it is still showing an error highlighting fThread.Interrupt() ---Object reference not set to an instance of an object.Now what changes should I do in order to make this code work

[code]
private void frameExtract()//function to extract frames
{
string outPath = txtExtBitmap.Text;
System.IO.Directory.CreateDirectory(outPath);

if (fg != null)
{
foreach (FrameGrabber.Frame f in fg)
{
using (f)
{
picBoxFrame.Image = (Bitmap)f.Image.Clone();
f.Image.Save(System.IO.Path.Combine(outPath, "frame" + f.FrameIndex + ".bmp"), System.Drawing.Imaging.ImageFormat.Bmp);
Application.DoEvents();
}

if (fg == null)
{
return;
}
}
}
}

public void ThreadProc()
{
try
{
MethodInvoker mi = new MethodInvoker(this.frameExtract);
this.BeginInvoke(mi);
}
catch (ThreadInterruptedException e)
{
Console.WriteLine("Interruption",e);
}
catch (Exception we)
{
Console.WriteLine("Exceptiom",we);
}
}

private void button43_Click(object sender, EventArgs e)//Extract button
{
fThread = new Thread(new ThreadStart(ThreadProc));
fThread.IsBackground = true;
fThread.Start();
}

private void button44_Click(object sender, EventArgs e)//Stop Button
{
fThread.Interrupt();
fThread = null;
}
[\code]

Re: Error in the code

Wes Aday14-May-09 18:00

Wes Aday

14-May-09 18:00

The error is telling you that fThread was not created. Make sure that it has been created and is not null when you click button 44.

Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Individuality is fine, as long as we do it together - F. Burns

Help humanity, join the CodeProject grid computing team here

Re: Error in the code

N a v a n e e t h14-May-09 18:17

N a v a n e e t h

14-May-09 18:17

Payam Rastogi wrote:
fThread.Interrupt();
fThread = null;

What do you mean by this code? Interrupting a thread and setting it as NULL doesn't make any sense. Also do a NULL checking before you use the thread object.

Payam Rastogi wrote:
button44_Click

Great name for a button Poke tongue | ;-P

Navaneeth

How to use google | Ask smart questions

Re: Error in the code

Payam Rastogi14-May-09 18:36

Payam Rastogi

14-May-09 18:36

hi,
thanks for your reply.I'm not able to figure out this problem since I have already created the fThread in button43 click event and also instantiated it.

Re: Error in the code

Nagy Vilmos14-May-09 22:17

Nagy Vilmos

14-May-09 22:17

Try replying to the posting and not to yourself!

Your doofusness has out doofused King Doofus of Doofusstan!

Well Done!
Laugh | :laugh:

Panic, Chaos, Destruction.
My work here is done.

Re: Error in the code

Nagy Vilmos14-May-09 22:16

Nagy Vilmos

14-May-09 22:16

Hey look! you've invented your own special tags! Wow & Double Wow!

You didn't use
  the <pre> tag
  that others use?
All the <pre> tag does
  is make sure that
    the cvode is idented
  and formated 
  so that
    it can be read!

doofus x4

Panic, Chaos, Destruction.
My work here is done.

Read EML files using C#

nv_thien14-May-09 17:18

nv_thien

14-May-09 17:18

I want to get information such as: From, To, CC, Subject, Body(Text plain data and RTF data). from file .eml

anybody can help me?

Thanks and best regards
Thien Nguyen

Re: Read EML files using C#

N a v a n e e t h14-May-09 17:39

N a v a n e e t h

14-May-09 17:39

Have you tried searching this site? I got Easily retrieve email information from .EML files[^]

Navaneeth

How to use google | Ask smart questions

Re: Read EML files using C#

nv_thien14-May-09 23:38

nv_thien

14-May-09 23:38

yes, i got it, but i only can get body = HTML format.
i need RTF format

Thanks

rdbms trigger calling C#

mark_me14-May-09 17:15

mark_me

14-May-09 17:15

Hi,
I have a firebird database and because of an update to a single table i need to make some calculations ( alot of calculations, I cant do them in a stored procedure(in firebird) because some of required information is in sql server, so the functionality would be added using C#). I think triggers might help, but is there any way in which a firebird trigger would call C# code. What if i make a windows service in C# and somehow make firebird trigger run the service. If anybody has any idea, please provide help.
thanx for helping.

Re: rdbms trigger calling C#

N a v a n e e t h14-May-09 17:35

N a v a n e e t h

14-May-09 17:35

mark_me wrote:
I have a firebird database and because of an update to a single table i need to make some calculations

Who is updating this table? C# code? If yes, do all the calculation in the C# code only after updating the table. A trigger can't call a C# code.

Navaneeth

How to use google | Ask smart questions

Re: rdbms trigger calling C#

mark_me15-May-09 5:30

mark_me

15-May-09 5:30

Hi, thanx for your reply.
The table is being updated by another application. My C# application has access to the database only, hence i talked about using a trigger (at database end). Without a trigger, how would i know whether code is updated or not.

Re: rdbms trigger calling C#

Mycroft Holmes14-May-09 21:49

Mycroft Holmes

14-May-09 21:49

Triggers are EVIL - find a better solution, as Navaneeth suggested

Never underestimate the power of human stupidity
RAH

Re: rdbms trigger calling C#

mark_me15-May-09 5:33

mark_me

15-May-09 5:33

Hi,
Thanx.
I think i have no other option.
An application (not mine) makes a change to the database, after this update my application should make changes accordingly. how do i know when an update to table has been made and carry out tasks that i desire.

Re: rdbms trigger calling C#

Mycroft Holmes15-May-09 13:39

Mycroft Holmes

15-May-09 13:39

Understood - a trigger is the solution to the problem. However all you need the trigger to do is send some info to your application. You want the trigger to be as stupid as possible to simplify the process (and keep support easier). I would devise a way for the trigger to communicate with your app. Set a flag in a table you own and can monitor, call a web service that can do your processing, send an email (I don't beleive I am said that).

SQL can't interact directly with your client but it can communicate so check out the different methods. I like the flagged table but if time is critical I would use a web service, which SQL can call, to do the notification.

Never underestimate the power of human stupidity
RAH

C# User Account Question HELP!

Serpendiem14-May-09 17:06

Serpendiem

14-May-09 17:06

Hello,

So what I want to do basically is this:

The user opens the client Console Application, and connects to the server Application on the server. It prompts a user for a username/ password. Once they hit enter, it sends the request to the server and it checks to see if those details exist or not. If it is succesful it will prompt the user that their login info is correct, and it opens Form1. If it is incorrect, it will bring back an error message and log the IP on the server..

What kind of system should I do for this, are there any tools like this out there? Please help me.

[X] 100% HTML
[ ] 100% PHP
[ ] 100% C#

Re: C# User Account Question HELP!

N a v a n e e t h14-May-09 17:12

N a v a n e e t h

14-May-09 17:12

Are you asking how client and server communication can be done? If yes, you can use WCF/Web services or normal TCP communication.

Navaneeth

How to use google | Ask smart questions

Re: C# User Account Question HELP!

Serpendiem14-May-09 17:18

Serpendiem

14-May-09 17:18

I don't want to do this through web application. How can I do this through TCP communication? Lead me in the right direction.

[X] 100% HTML
[ ] 100% PHP
[ ] 100% C#

Re: C# User Account Question HELP!

N a v a n e e t h14-May-09 17:21

N a v a n e e t h

14-May-09 17:21

Start from the TCPListener[^] class. But I suggest you to take a look at web services or WCF which makes the communication simple.

Navaneeth

How to use google | Ask smart questions

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.