|
Hi
Can someone tell me what the appropriate connection string would to connect to an SQL2008 db using an IP address?
I am able to log in from the host machine using "Datasource=SQL2008Server etc.", but substituting this with
"Datasource = x.x.x.x,1433" or
"Datasource = x.x.x.x\SQL2008ServerName,1433" or
"Datasource = x.x.x.x,1433\SQL2008ServerName" (or any number of permutations I can think of) doesn't work.
What am I doing wrong?
Thanks
Karl
|
|
|
|
|
Have you tried by providing the network library ? Check if it works or not if network library is provided as follows...
"Datasource = x.x.x.x,1433;Network Library=DBMSSOCN"
"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)
|
|
|
|
|
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?
|
|
|
|
|
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 
"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)
|
|
|
|
|
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
|
|
|
|
|
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?
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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]
|
|
|
|
|
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
|
|
|
|
|
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 
|
|
|
|
|
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.
|
|
|
|
|
Try replying to the posting and not to yourself!
Your doofusness has out doofused King Doofus of Doofusstan!
Well Done!
Panic, Chaos, Destruction.
My work here is done.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
|
yes, i got it, but i only can get body = HTML format.
i need RTF format
Thanks
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
Triggers are EVIL - find a better solution, as Navaneeth suggested
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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#
|
|
|
|
|
Are you asking how client and server communication can be done? If yes, you can use WCF/Web services or normal TCP communication.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
