Hi Guffa, Thanks for the help. I resolved the issue.There was some issue with the connection string ;after resolving it my connection is working fine.The take away for me from here is if there is any issue with the connection string this error will happen. Thanks Again for your replies..... Keep up the spirit....

Hi Guffa; Thanks for trying to help. For my first question i found the soln from server explorer. "http://kb.seekdotnet.com/ViewArticle/119data.aspx" For the second question this is my error message "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)" Thanks for the help

Hi, 1) Can anybody tell me how can generate the connection string to my SQL Database from the solution explorer in VisualStudio2008. 2) Also can anybody tell me how i can resolve his error in my SQL;I tried the settings from Surface Area Config: but it didn't help :( 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)" Many Thanks,

modified on Sunday, October 19, 2008 12:32 PM

Hi, I have a small C# code snippet which i want to Unit test in VSTS 2008 .The problem is i am unable to find teh Unit Testing option in VSTS 2008. I have searched and didnt get a answer for that. In VS2008 and 2005 we can access Unit Test from Test Menu,but i cant seem to find teh similar in VSTS 2008.Can anybody provide any links. Thanks in advance.

modified on Monday, October 6, 2008 10:42 AM

Hi All, I am learning to use the Unit Testing features in Visual studio team system 2008 for C# projects.The book(Pro Visual studio 2005-Apress) i am reading says to open the "Service Class " to generate the Unit Test.But i cannot seems to know how to do it. I serached and in am unable to get an answer.Any person out there who havve used Unit testing or made use of any testing tools inbuilt in Visual Studio ;Please provide a hint or any links for the same. Thanks in advance.

Hi, Can anybody tell what are the testing tools present in Visual Studio 2008 Architect version. Any links to the above said information and testing tools will be most welcome. Thanking You

Hi all, I am modifying an application that will send email via smtp.My problem is its not sending emails to gmail,aol etc.Getting an eror"Mailbox unavailable. The server response was: 5.7.1 Unable to relay for [email]" I searched and found its issue with authetication. My questions are: 1)Is it possible to sent mail to gmail,hotmail,aol etc from a application like this. 2)Whats the username and pasword for authntication .I found this code when i searched but confused about how to implement.Any help is welcome. The link is " My code looks like this: public void sendSmtp() { if (!ValidateEmailSender()) return; clsEmailSender emailSender = new clsEmailSender(); MailAddress sendFrom = new MailAddress("devjn@itsoft.com"); MailAddress sendTo = new MailAddress(txtEmailTo.Text); MailMessage myMessage = new MailMessage(sendFrom, sendTo); if(txtEmailCc.Text!="") { MailAddress sendCc = new MailAddress(txtEmailCc.Text); myMessage.CC.Add(sendCc); } if (txtEmailBcc.Text != "") { MailAddress sendBcc = new MailAddress(txtEmailBcc.Text); myMessage.Bcc.Add(sendBcc); } myMessage.Subject = txtEmailSubject.Text; myMessage.Body = txtEmailBody.Text; SmtpClient emailClient = new SmtpClient("mail.tri.com", 28); emailClient.Send(myMessage); }

Hi Adarsh, Open SQL Server Create a database like "Test" Open that database You will find programability--open it you will find stored prtocedure. Rite click ....select new stored procedure A query window will come paste ur SP and run It will get added to your SP For further questions mai me at jijuanair@gmail.com Hope this helps

Hi all, Am running a open row set query in my "sql server management studio express". Am getting an error "Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".". I think the open row set stored procedure. will work only in 32 bit. So, I want to know whether 1)How cam i know my "SQL server ' is 32bit or 64bit? 2)My OS is Windows xp in my computer?Could that be the reason? 3)How can i know whther Windows Xp is 32 bit or 64bit? Any infprmation will be helpful Thanking You

Hi, am trying to upsize certain tables in MS Database to SQL.I tried the upsizing wizard,but for certain tables its giving me errors like "unable to drop table". Is their any stored procedures which will help us to upsize the ables to SQL?

Hi all, Am trying to upsize certain tables from MSAccess database to SQL database.I have a preexisting database with tables which are vacant in SQL.While i try to upsize the database tables from MSAccess 2003 to SQL server am getting an error.I tried to upsize three tables out of which one was upsized fine with all data imported with out errors(was not having foreign key relations).But the other two are shooting errors and not upsizing . The error looks like " "Server Error 3726:"Couldnot drop object 'tablname' because it is referenced by a Foreign key constraint." I tried to remove all the foreign key connections in SQL tables and still getting the same error. Since am doing this for the first time,am unsure what exactly is the way to go? Any help will be welcome. Many Thanks,

Hi, I am trying to open a MS Access database from C# code. I want the MSAccess database to open up on a button click. Am able to create a connection to the database but am unable to open the database. i want the database to be open on a button click event so that i can open a table. Atached below is my code.Any help is welcome :). using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using ADOX; using System.Data.OleDb; using System.Runtime.InteropServices; namespace DatabaseCreation { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { string strAccessConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + txtdatabaseName.Text; OleDbConnection myAccessConn = null; try { myAccessConn = new OleDbConnection(strAccessConn); myAccessConn.Open(); MessageBox.Show("Database connection is successfully Opened"); } catch (Exception ex) { MessageBox.Show("Error: Failed to create a database connection. \n{0}", ex.Message); } if (myAccessConn.State == ConnectionState.Open) { myAccessConn.Close(); MessageBox.Show("Database is successfully Closed"); } } } }

modified on Wednesday, April 23, 2008 5:40 AM

2. Stop the SQL Server Service, copy the mdf and ldf to a different location and do your reinstall. Once you have the new instance up, you can try attaching the mdf, although I seriously doubt if it'll succeed. It's a gamble you've to take. I did this and am going to reinstall my SQL server 2005.I hope while attaching it will work.Any way at this point i think we have to take that risk since we dont have any other options. I will try this and will post the effects.Please be in this loop. Many Thanks

H, I have a stored procedure in SQL server 2005 in a database.Right now i am unable to access my SQL Server and it needs reinstallation.But i need the stored procedures i have written previously in this.I know the name of teh database that contains the SP.I can see it in my programmeFiles as mdf and ldf. Once the reinstallation of my new sql server 2005 is done,i want my new sql server to have this SP.I tried to open my mdf and ldf but its not opening.I tried to copy to some location but it says "another program is using this file"-This is not true. So my question is how can i do this.I desperatly need ny SQL server after reinstallation to have these SP's since writting them again will be tedious. Many Thanks

Hi All, I am trying to import a txt file into MSAccess database and later into SQL server database using C# Code.This is the whole purpose. I have two questions. 1)I have a txt file that has double quotes as field separator.This text contains more than 44lakh lines with morethan 10 columns.I want to import this into an MSAccess database using C# code.I will be having a blank database already created for this purpose.We just have to import the data into this blank database using C# Code.Is it possible,if so how? 2)This is basically a continuation of the previous issue. The file that we imported into MSAccess has to be now imported into SQL server 2005 database using C# code.I tried using BCP(Bulk copy programming),but unfortunatly its not working.So that option is closed now.How can we do this using C# code?Is it possible? Many Thanks

Thank you Mark,I will check this.

Hello Friends, I need to import a MSAccess Database to SQL server 2005 using C# code. My question will be is it possible to do so?--I googled and am yet to find a satisfactory answer.So i thought i will post the question. Also is it possible to import a txt file to MSAccess? If yes can you guys give me any links please. Thanking You all

Hi all, Is it possible to import a .dat file to MS Access and from there to SQL Server using C# code. Is it possible to get any links on the same.I serached google amd didnot find any. Thanking You

You have to download the Ajax Tool kit .You can do it from ASP.net site

Hi, I have done some validations for text boxes using Ajax and they are not working when i try in Mozilla Firefox.It works fine in IE. Am unable to find the reason. ErrorMessage="Name Required" Display ="none"> Any help is welcome