|
I receive this error
"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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
Here is my connection string
Data Source=SQLEXPRESS; Initial Catalog=dbEasyManager; User id=sa; Password=;
i even had data source = localhost
Came across enabling pipes in sql config manager, but i have no idea where that is in the manager cant find it
that may not even be the problem, because i had connected to the db before with someone elses code just dont know where it is.
can someone help me please
|
|
|
|
|
kourvoisier wrote: Data Source=SQLEXPRESS
This tells it to look for the SQL Server on a machine called SQLEXPRESS. I suspect that this is the instance name and you just haven't told it which machine on your network to find that instance of SQL Server.
Try:
Data Source=MachineName\InstanceName
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
|
|
|
|
|
Colin Angus Mackay wrote: Data Source=MachineName\InstanceName
I still get the same error.
here is connection string i used among others
"Data Source=./SQLEXPRESS; Initial Catalog=dbEasyManager; User id=sa;Password=;"
after adding a connection thru database explorer, by browsing thru the files and selecting the actual database, it stated i made a successful connection. It then generated a connection string.....(below)
Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Program Files\MicrosoftSQLServer\MSSQL.\MSSQL\Data\dbEasyManager.mdf";Integrated Security=True;ConnectTimeout=30;UserInstance=True
I was going to test this connection string in my code but couldnt figure out how to make the whole thing a string with the extra ""'s in it throws the syntax off.
Bottom line is i still cant connect to my database
I am using SQL server 2005 express and
visual 2005 c# express on a windows xp machine
the name of my database is dbEasyManager.mdf
someone help me, is there any other info you need to get me connected, its got to be something little i just cant figure it out.
HELP
|
|
|
|
|
server=(local)/SQLExpress;database=Pubs;Integrated Security=true
Error i get because of the slash "/" --> Unrecognized escape sequence
why is this?....
on tutorials they have it setup this way but when i compile i get this error...
someone help me.
|
|
|
|
|
After a couple of days of trying to figure this thing out i did!
something very simple, i knew it would be
in my connection string the "unrecognized escape sequence" error i was getting was because
c# does not like the "/" character one bit, so before your string you must use the @ symbol
to make c# happy.
and WHALA!!! works like a charm
|
|
|
|
|
Hello,
I am beginner in c#.net, i need your help.Now i am in a problem i want to delete a folder with data in my c# application.Can you help me please.
Thanks in advance.
alex.
Help me
|
|
|
|
|
|
how i can control electric items through c# application?
need some help from u people.
Sheharyar_JH
|
|
|
|
|
By sending data over WiFi, or serial bus, or parallell port or USB, or internet, having your 'electric item' connected to the correct media over which you are sending your commands. Adjust the item so that it can interpret any command you send to it. Make sure your item is powered. And that should pretty much do it.
(more specific questions might result in more specific answers btw)
|
|
|
|
|
|
Because the question was SOOOO vague, with an utter lack of any detail, that it was the only answer possible! 
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
The technology you are refering to is called X10. It is aimed at controlling household appliances thru you computer.
MS recently posted an article on doing exactly this on their 'codeforfun' website. Sorry, no link, but you should find the answers you are looking for. 
xacc.ide-0.1.1 released! :) Download and screenshots
|
|
|
|
|
Hi all, idont know where am i going wrong please help me.My idea is that, i am retrieving the deptnames from database into the dropdown list and afterthe selection of the deptname the respective details are to be displayed on the datagrid. The code is working till the dropdownlist.
code to get deptnames to the dropdownlist:
private void Page_Load(object sender, System.EventArgs e)
{
try
{
connectdb();
Cmd.CommandText = "Select distinct (Dept) from emp";
da.SelectCommand = Cmd;
da.Fill(ds,"Emp");
DropDownList1.Items.Clear();
foreach (DataRow dr in ds.Tables["emp"].Rows)
{
DropDownList1.Items.Add(dr["Dept"].ToString());
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
Con.Close();
}
code to dispaly the details onto datagrid:
private void DropDownList1_SelectedIndexChanged(object sender, System.EventArgs e)
{
try
{
connectdb();
Cmd.CommandText = "Select * from emp Where Dept Like '" + DropDownList1.SelectedItem.Value.ToString() + "' order by Empno";
da.SelectCommand = Cmd;
da.Fill(ds,"Emp");
DataGrid1.DataSource = ds;
DataGrid1.DataMember = "Emp";
DataGrid1.DataBind();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
Con.Close();
}
Note: The same code is working if i enter the deptname in a textbox and click the button to display details on to the datagid. But the code is not working if i select the option in the dropdownlist.Is the event Dropdownlist_SelectedIndexChanged relevent or any other events are there to select the dropdownlist.
pleasehelp me
thanks in advance
yamini
|
|
|
|
|
Hi,
By default AutoPostBack property for dropdown list is set to false, set the AutoPostBack property to true
Thanks
Warm Regards
Prakash-B
|
|
|
|
|
Can anyone give me the exact difference between Virtual and Override? I am a bit confused... 
Bikash Rai
|
|
|
|
|
Virtual indicates that any inherriting class may override the function and replace it with its own content. The keyword override indicates that I intend to replace a function out of a base class with my own.
So you can only use override when a member in the base class is declared as: virtual, abstract or override. (as stated in the override article on the MSDN)
The related articles from MSDN are:
virtual
override
|
|
|
|
|
Gerben Jongerius wrote: So you can only use override when a member in the base class is declared as: virtual, abstract or override.
Lets say that I have a base class A. A has one virtual function whose name is func. Now I create another class B which inherits from A. I override the function func using the override modifier. Lets say I create another class C which inherits from B. Now, if I have to override the function func of B in C then do I use override?
Thanks for helping.
---
With best regards,
A Manchester United Fan
The Genius of a true fool is that he can mess up a foolproof plan!
|
|
|
|
|
yep, you use override once again.
override states that it is overriding the function from the base class, and the overridden function still remains virtual, meaning that classes that derive from the class that overrode the func can still override it and do their own stuff...
Greetings,
Davy
|
|
|
|
|
Thanks a mil..
---
With best regards,
A Manchester United Fan
The Genius of a true fool is that he can mess up a foolproof plan!
|
|
|
|
|
How can send file to server with webservice
|
|
|
|
|
What server? Windows, Samba, Linux, FTP, TFTP, Web, ..., ??? How does the webservice figure into this problem?
If you expect any help with this, you have to supply more detail in your question.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Windows server.
Send the file from computer A to computer B,this computer in different place.
|
|
|
|
|
A web service really isn't the best choice for this. And you're still very short on the details. A web service must be called from a client. It's not just running in the background all the time like a Windows service.
You have some problems with this.
First, where is the file comming from? (Remember those DETAILS you're not telling us about?) Is it comming from an upload from the client to a folder on the web service server? Is it being uploaded using a method of the web service?
Second, is the server that is going to receive this file from the web service part of a Windows domain? Are both the target server and the web service server in the same domain? Or are they seperate, usch as different domains or workgroups?
What type of target server are you sending this file to? Windows 2003 is fine, but what server type are you sending this file to? An FTP Server?, A Windows Share?, ..., ???
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I wrote a video jukebox program in C# last year. I initially used the AudioVideoPlayback namespace, but it's really buggy, so I used the WMP control instead. However, we used DX to read ID3 tags in the manager program. Now, a year later, the client has changed the contact person, and every machine he tries to install on gives him this error :
The type initializer for "Microsoft.DirectX.DirentInput.Manager" threw an exception.
in the constructor for the class that uses DX. The machines are all XP SP2, which means that DX is installed, although I'm not sure if managed DX gets installed by SP2, the installer won't run as it's there already.
The real worry is, it works fine on my dev machine, and works fine on his machine at home. I've tried with a couple of dll versions ( I have several installed ).
My constructor looks like this :
public JukeboxDXJoystickController()
{
foreach(DeviceInstance di in Manager.GetDevices(DeviceClass.GameControl, EnumDevicesFlags.AttachedOnly))
{
device = new Device(di.InstanceGuid);
}
if (device == null)
{
MessageBox.Show("Unable to find attached joystick");
return;
}
device.SetDataFormat(DeviceDataFormat.Joystick);
device.SetCooperativeLevel(null, CooperativeLevelFlags.Background | CooperativeLevelFlags.NonExclusive);
device.Properties.AxisModeAbsolute = true;
deviceUpdated = new AutoResetEvent(false);
appShutDown = new ManualResetEvent(false);
device.SetEventNotification(deviceUpdated);
Thread threadLoop = new Thread(new ThreadStart(this.ThreadLoop));
threadLoop.Start();
device.Acquire();
}
I previously used joyGetPos, etc, but they proved to be unreliable in C#. We can still use them and the program runs fine. Any suggestions are most appreciated.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Hi Chris!
I'm pretty sure that Managed DirectX is not installed out of the box, so I'd try installing it first.
Regards,
mav
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
