|
Hi all,
I have an application that attemps to connect to a database.
I have one machine running XP that connects to a server machine with SQL server 2005 installed.
In this instance i can connect every time, any time with no issues.
My second machine is running Vista Business SP1, and connects to a server with SQL Server 2008 installed.
I had spent alot of time trying to get the application to connect to the database as I initially had an 'error: 26 - Error Locating Server/Instance Specified' message. so i did the research on that and all suggestions seemed to already be applied in my case. Anyway after a number of hours after server restart it works.
The next day, application failed again. I did a server restart and did not work for while, but then it started to connect again, then stopped again. Basically with no change to the application its working sometimes but not others.
If i use command prompt and 'osql' commands i am always able to detect the server\instance i want, and i can also retrieve data from it. so i cant see how it is a server setup issue. but if it is a programming issues why would it work sometimes and not others.
Does anyone know of any extra coding required when working the SQL server 2008, over 2005
my relevant code is as simple as follows.
connection string is:
Server=<server>\<instance>;Database=<database>;User Id=<username>;Password=<password>;
using System.Data.SqlClient;
SqlConnection connection = new SqlConnection(@connectionString);
connection.Open();
Any help or suggestion will be great
Thanks
|
|
|
|
|
Hi,
your connection string looks kind of strange to me. Are you sure that this is correct. I'm missing the servername\instancename...
Regards
Sebastian
|
|
|
|
|
Sorry, it didnt display how i typed it.
the blank values do have data in:
Server=server\instance;Database=database;User Id=username;Password=password;
the Bold values are masked
as i have said i did manage to connect a couple of times, with the same connection string, so i cant see that being an issue
thanks
|
|
|
|
|
Hi,
try this ..
connectionString="Data Source=<database server="" ip="">;Initial Catalog=<databasename>;Persist Security Info=True;User ID=<user id="">;Pwd=password"
Charith Jayasundara
|
|
|
|
|
Hi Charith,
Thanks for your input.
As I said in my post. My application connects sometimes and not others. At the minute it is working, so I can verify that your connection string suggestion is valid. but so is the connection string I was originally using so I can not say that my solution is solved.
|
|
|
|
|
This could be a connection pool issue. Have you tried disabling connection pool; Specify Pooling=false to your connection string and test if it has any effect.
Also is the message 'error: 26 - Error Locating Server/Instance Specified' still the one you receive or are you getting any other messages.
|
|
|
|
|
Thanks for your reply Mika,
Curently my application is connecting and setting the Pooling=False has no noticable affect. From what I just read about Pooling thou, it seems best to leave this at the default 'True' value as it can improve performance with database applications the use the same connection strings over and over again.
(http://msdn.microsoft.com/en-us/library/8xx3tyca.aspx[^])
Whenever I cannot connect the 'error: 26' message is the only one I have ever recieved in regards to this issue.
At the moment the application has been able to connect with no errors since last night, so fingers crossed that it stays that way :P
If the problem has been solved in my case then I can only conclude that there was an issue with some server setting. If I manage to find a definative answer to my problem I will post my findings here.
|
|
|
|
|
musefan wrote: Curently my application is connecting and setting the Pooling=False has no noticable affect
Ok, so it seems that the pooling isn't affecting
musefan wrote: what I just read about Pooling thou, it seems best to leave this at the default 'True'
Absolutely. The idea was just that you should test if the pool acts correctly. In some situations you can end up with connections in the pool but they won't work thus leading to an error.
musefan wrote: At the moment the application has been able to connect with no errors since last night, so fingers crossed that it stays that way
Let's hope so.
|
|
|
|
|
Nope it gave in eventually.
Now I am using the server IP address and instance name and worked as soon as I changed it. If this lasts then there must be some issue with resolving the DSN at some times and not other.
Any ideas on this?
|
|
|
|
|
Hi all,
I have a problem. I'm using VS2005 and I'm writing a web service. It's been working fine so far. Now, when I try to debug the code whenever I step over/in a line of code it goes to some random line elsewhere in the code.
Sometimes, when I stop the program and then run again it automatically stop on a breakpoint without even Invoking the web service!!
I tried Cleaning the solution, removed all .pdb files but nothing helped. Does anybody have a solution for this because it's driving me crazy!
In life truth does not matter. What really matters is what others believe to be the truth. (The Up and Comer - Book)
|
|
|
|
|
Is it multi-threaded application?
Charith Jayasundara
|
|
|
|
|
no ... it's just a webservice.
In life truth does not matter. What really matters is what others believe to be the truth. (The Up and Comer - Book)
|
|
|
|
|
There's no chance that there are multiple calls occurring to the webservice during your debugging?
|
|
|
|
|
This usually happens when the source file and the pdb files are out of sync. This means the compiled version does not correspond to the current version of the source files.
Erase all binaries, unGAC if necessary.
|
|
|
|
|
Hi,
I am running something on a loop till a certain condition meets. I have two options,
1. Create a timer and execute the loop.
2. This is already running in a child thread so I can just add a while (condition) loop with Thread.Sleep()
I prefer to use the second one. But I am not sure which one is the best..
Any Idea?
Thanks!
Charith Jayasundara
|
|
|
|
|
Charith Jayasundara wrote: I am running something on a loop till a certain condition meets
Charith Jayasundara wrote: his is already running in a child thread so I can just add a while (condition) loop with Thread.Sleep()
Thread.Sleep blocks the current thread for specified time. If your thread slept, how can you check whether the condition met or not? Your question is not clear.
|
|
|
|
|
A timer is always best, sleep loops are very ugly and poor form IMO.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hello
I add a record to a table with a web service
I use a winform for calling this web service
now, my question:
when new record added, i want the datagrid points to new record
if there is a link about my question, plese put it herer
thanks
|
|
|
|
|
You can catch some event of the DataGrid and set the selectedRow ?
Charith Jayasundara
|
|
|
|
|
Hello
I do it with "for" and not with event(s)
and this way is not a good solution
for(int i....){
}
|
|
|
|
|
I have a project server 2007. using its event handler i want to run "notepad" against some perticular event (trigerred by project professional). The project server is running an eventing service under the user "Network service" that processes the event handlers registered to the project server. Event handler is written as a class library and the generated dll is registered in the project server's event handler. Following is the code which is failed to run a notepad application, resulting an error message mentioned in the subject:
public override void onpublish(PSContextInfo ps, ProjectPostPublishEventArgs e)
{
SecureString ssPwd = new SecureString();
foreach ( char c in "password" )
ssPwd.Append(c);
Process myProcess = new Process();
myProcess.StartInfo.FileName = "Notepad.exe";
myProcess.StartInfo.CreateNoWindow = false;
myProcess.StartInfo.RedirectStandardError = true;
myProcess.StartInfo.LoadUserProfile = true;
myProcess.StartInfo.Domain = "myDomain";
myProcess.StartInfo.User = "domainAdmin"; // domain administrator
myProcess.StartInfo.Password = ssPwd;
myProcess.StartInfo.WindowStyle = ProcessWindowStyle.Normal;
myProcess.StartInfo.UseShellExecute = false;
myProcess.Start();
}
Any help ???
Madni
|
|
|
|
|
|
Don't ask the same question twice, its a waste of time.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
i have multiple monitors connected to my system.and i want to show different forms for each monitor how it is possible.
Thanks in Advance
nothing
|
|
|
|
|
I doubt if it is possible as the user can drag app windows from monitor to monitor. I could be wrong though.
Bob
Ashfield Consultants Ltd
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
