Cannot connect to SQL Server

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Ado
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - MDAC 2.8 on Win 2003, How do you repair or re-install MDAC 2.8 on Windows 2003 Server? Tag: Cannot connect to SQL Server Tag: 88656
  - 2
    - Is there a .NET version of ADOX. ADOX is the extension ADO. And I wonder if there is any extension for ADO.NET? I need a object model in C#, with which I could easily access the schema of a database. Tag: Cannot connect to SQL Server Tag: 88650
  - 3
    - Checking for NULL data Does null check have to explicitly be performed on every nullable value from a DataReader return. ie. for: DataReader dr = sqlCommand.ExecuteReader() while( dr.Read() { int intTestValue = dr.GetInt32( dr.GetOrdinal("TestValue")); } This will cause an exception if value is null, so do I have to do a special check for null on every return?? Or is there a more efficient way of doing this? Thanks Tag: Cannot connect to SQL Server Tag: 88644
  - 4
    - Help: OleDbException: Operation must use an updateable query I do an UPDATE query in my ASP.NET page. On my development machine it works PERFECTLY. When I upload the site (inlcuding my Access MDB) to my production website and try to do the same update qry I get this error. Any ideas? System.Data.OleDb.OleDbException: Operation must use an updateable query. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at MyPage.EditHtml.cmdSave_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\EarlyAlert2\EditHtml.aspx.vb:line 151 Tag: Cannot connect to SQL Server Tag: 88640
  - 5
    - Do I Have to Open a Connection 3 Times? I'm just starting to learn asp.net. What I have is a registration form for a message board system. Basically, the user enters in their info and it's validated. So I have a custom validator check to make sure the username is unique, I have another custom validator that makes sure the email address is unique and then I save the info to the database. That means I open the connection to the sqlserver 3 times. Seems inefficient to me. Is there a better way? Sub Button1_Click(sender As Object, e As EventArgs) if me.isvalid then Dim connectionString As String = "server='netsdk'; trusted_connection=true; database='db'" Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString) Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand dbCommand.Connection = dbConnection Dim uname as string Dim password as string Dim em as string Dim ip as string Dim rightnow as date ip = Request.UserHostAddress() rightnow = now uname = username.text password = password1.text em = email.text dbCommand.CommandType = System.Data.CommandType.StoredProcedure dbCommand.CommandText = "sp_register" Dim dbParam_username As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_username.ParameterName = "@username" dbParam_username.Value = uname dbParam_username.DbType = System.Data.DbType.StringFixedLength dbCommand.Parameters.Add(dbParam_username) Dim dbParam_password As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_password.ParameterName = "@password" dbParam_password.Value = password dbParam_password.DbType = System.Data.DbType.StringFixedLength dbCommand.Parameters.Add(dbParam_password) Dim dbParam_email As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_email.ParameterName = "@email" dbParam_email.Value = em dbParam_email.DbType = System.Data.DbType.String dbCommand.Parameters.Add(dbParam_email) Dim dbParam_ip As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_ip.ParameterName = "@ip" dbParam_ip.Value = ip dbParam_ip.DbType = System.Data.DbType.StringFixedLength dbCommand.Parameters.Add(dbParam_ip) Dim dbParam_last_ip As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_last_ip.ParameterName = "@last_ip" dbParam_last_ip.Value = ip dbParam_last_ip.DbType = System.Data.DbType.StringFixedLength dbCommand.Parameters.Add(dbParam_last_ip) Dim dbParam_created As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_created.ParameterName = "@created" dbParam_created.Value = rightnow dbParam_created.DbType = System.Data.DbType.DateTime dbCommand.Parameters.Add(dbParam_created) Dim dbParam_last As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_last.ParameterName = "@last" dbParam_last.Value = rightnow dbParam_last.DbType = System.Data.DbType.DateTime dbCommand.Parameters.Add(dbParam_last) Dim rowsAffected As Integer = 0 dbConnection.Open Try rowsAffected = dbCommand.ExecuteNonQuery Finally dbConnection.Close End Try 'Server.Transfer("index.aspx") end if End Sub Sub CustomValidator_Username( s As Object, e As ServerValidateEventArgs ) Dim connectionString As String = "server='netsdk'; trusted_connection=true; database='db'" Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString) Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand dbCommand.Connection = dbConnection dbCommand.CommandType = System.Data.CommandType.StoredProcedure dbCommand.CommandText = "sp_username" Dim dbParam_username As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_username.ParameterName = "@username" dbParam_username.Value = trim(e.value) dbParam_username.DbType = System.Data.DbType.StringFixedLength dbCommand.Parameters.Add(dbParam_username) dbConnection.Open Dim cnt as integer cnt = dbCommand.ExecuteScalar If cnt = 0 Then e.IsValid = True Else e.IsValid = False End If End Sub Sub CustomValidator_Email( s As Object, e As ServerValidateEventArgs ) Dim connectionString As String = "server='netsdk'; trusted_connection=true; database='db'" Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString) Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand dbCommand.Connection = dbConnection dbCommand.CommandType = System.Data.CommandType.StoredProcedure dbCommand.CommandText = "sp_email" Dim dbParam_email As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter dbParam_email.ParameterName = "@email" dbParam_email.Value = trim(email.text) dbParam_email.DbType = System.Data.DbType.String dbCommand.Parameters.Add(dbParam_email) dbConnection.Open Dim cnt as integer cnt = dbCommand.ExecuteScalar If cnt = 0 Then e.IsValid = True Else e.IsValid = False End If End Sub -- . http://sf-f.org, weblog and search engine for fans and writers of speculative fiction. . Tag: Cannot connect to SQL Server Tag: 88638
  - 6
    - No Smart Device Choice How come My VB.Net environment does not contain the Smart Device Application Template to open the Smart Device Application Wizard. Any Ideas? Thanks Paul Tag: Cannot connect to SQL Server Tag: 88637
  - 7
    - Updating field with single/double quotes I have a memo field in my Access database that is called HtmlText. I have a text box in my ASP.NET application that I fill with HTML. The HTML has both single and double quotes throughout the HTML. I tried to run an UPDATE query to update the db but it fails. I think it's because of the quotes. How can I get the UPDATE command to update fields that contain both single and double quotes? Ideas? Examples? Thanks. Tag: Cannot connect to SQL Server Tag: 88627
  - 8
    - ADO Update Problem Greetings all, I am using an Access Database to store question information for a questionare application. I am using VB.net as the front end, and ADO.net to retrieve the information from the database. My data is bring displayed in a DataGrid bound to a dataset. All of my calls to the database are to parameter queries. The problem that I am having is with the update command. When I call the update method for my data adapter, and pass a dataset containing only the changed records, only one record shows the change. I know that parameter queries work because data is being returned and update, just not in the quantities that I want. From what I have read, the update method in ADO.NET should be able to process a batch change, but the only specific information I have been able to find concerns SQL Server and not MS Access. The only information I have been able to find regarding the update method and MS Access were for single records. Does ADO.net send each update request separately, waiting for conformations between requests, or does it send all of the changes at once? I know, if you write the queries properly, SQL server can process the data in a lump sum, but I do not believe Access has that ability. I have been working on this for several days. Any help you can provide would be greatly appreciated Thanks in advance, Edison Tag: Cannot connect to SQL Server Tag: 88626
  - 9
    - Books reviewed I've been on a mission this past year to move from VB6 to .Net. I'm fortunate(!?) not to have the big catalog of some long-time VB developers, although I have some CE apps that have to be entirely rewritten in CF. A lot of what I develop has to be written for the PPc, so I knew I would be looking for information in .Net, ADO.Net, CF -- and SQL Server. So in the spirit that others might benefit from my journey, here are my observations. Having been a tech writer many years ago (and a page designer before that), I give these reviews with the caveat that I know how difficult it is to write technical literature and also how difficult it is to pull together all the aspects of a book. Thus I'm not going to give much about any specific errors or bugs, but a general feel for the book and how it helped me. I will also give the caveat that I've never read ANY book that didn't give up some useful bits of information -- no matter how bad that book might be otherwise. Final caveat is that I'm not there yet -- I'm still learning much as I develop and I'll still have many questions here. But I don't see my opinions changing on the books I'm reviewing here. The following list is in no particular author order: Introducing Microsoft.Net 2nd Ed (note: the 3rd Ed is out now), David S. Platt As its title implies, its a great book to get you started in the .Net way of thinking. There are some examples, but that is not really the focus of the book. Touches briefly on all areas of .Net. I wish I had read this book first. VB.Net, Matthew McDonald Strange, I've never seen any reviews of this book, and I got it for $10 at the half-price bookstore, but its chock-full of information and examples. The book is aimed at developers moving from VB to .Net, so it was right up my alley. If you can find it, buy it. Visual Basic.Net, Matt Tagliaferri Another out-of-the-mainstream book (spell that c-h-e-a-p) with some good stuff in it. If you are interested in GDI, this might get you kickstarted. Also gave me some intro to the datareader and datasets. Visual Basic.Net Database Programming, Evangelos Petroutsos, Asli Bilgin I've seen this book slammed in a few reviews, but I feel that's totally undeserved. This is a very good book for those just starting with ADO.Net. Its deep enough, it gives you a lot of great examples, and is fairly well illustrated. I do have some minor heartburn as follows. Some of the examples that required the Command Builder to be used did not show those in the code example. Literally, those examples would not run (I'm thinking this was one of the places that William Ryan straightened me out). Next, a few of the illustrations were actually screen shots of the code that were too small to read (altho in fairness, you have a CD to pull the code up in front of you -- I'm not much on using the CDs unless I do not understand the written word). Finally, the layout of the book is kinda goofy as regards the DataReader (you have to look in a couple of different areas where the material should have been pulled together). I have about a dozen pages tabbed for future reference, so that may give you some idea that despite my misgivings about a few errors, I still find the book very useful. Microsoft ADO.Net, David Sceppa In the lingo of the 20-something crowd, this book is "the bomb". I'd read reviews of how good this book is, and its reputation is well-deserved. I have not finished the book yet, but after several chapters (and some peeks ahead into the "Questions that should be asked more frequently"), I can see already that I'll feel more secure in my knowledge of ADO.Net once I'm finished. I'm thinking that this is probably the only book I've ever paid full-price for. If you were to be stuck with the task of creating a robust application with just any 3 books, this would be 1 of the 3. More about this anon. .Net Compact Framework, Craig Morris, et. al. One of the first books I bought and should've been one of the last. Examples all in C#, and since I had no .Net experience at the time, I didn't spend much time with it. Fairly lightweight tome, but I'm hanging on to it and intend to get back to it Microsoft .Net Compact Framework Kick Start, Erik Rubin, Ronnie Yates This book helped me out tremendously, not only with the CF, but on how to work with the datagrid and datatables. I do not claim to being there completely, but using some pieces of this book in conjunction with answers from the afore-mentioned William Ryan in the forums, I can at least visualize most of the concepts I need to pull things together. Microsoft .Net Compact Framework, Andy Wigley, Stephen Wheelwright I have not finished this book. Examples all in C#, and highly technical (these guys might be wound a little too tight, and might want to check out www.moosehead.com). I'm counting on this to fill in the holes in my technical knowledge once I have the nuts and bolts down. C# Text Manipulation Handbook, Francois Liger, et. al. I found this book also at the half-price book store and oh I love it as a reference! This little gem has helped me tremendously with casts, parsing, math manipulations, numbers to strings, strings to date, you name it. Even if you write only in VB.Net, the examples are easy to read/convert. This book will save you hours and hours of frustration with casting issues. Buy it. Professional SQL Server 2000 Database Design, Louis Davidson How did books about SQL Server land on the .Net list? Frankly, you will miss more than half the journey if you try to learn.Net in a vacuum without some knowledge of SQL Server. This book is so language-agnostic, it is an excellent resource. Written in a very user-friendly conversational tone, I have been enjoying it tremendously -- while learning much along the way. Troubleshooting SQL, Forrest Houlette I found this book totally by accident. It deals exclusively with troubleshooting SQL statements. Heck, while I realized the depth of SQL, I never envisioned that someone could write such a "troubleshooting" book that was language-independent. Using this book in conjunction with "The Practical SQL Handbook", "SQL Queries for Mere Mortals" and "Database Design for Mere Mortals" will make you much more confident in your SQL abilities. SQL Server Black Book, Patrick Dalton, Paul Whitehead I really appreciate the "black book" series of books. They helped me tremendously with VB and got me started with understanding C++. But for some reasons, this particular black book has not been as helpful. Its just as big, has just as many examples in it, but for some reason, I feel disconnected and the descriptive material feels lightweight. This book will remain a reference for me, but I'm somewhat scratching my head about some topics in the book. ADO.Net Step-by-Step, Rebecca Riordin Of all the tech books I've bought over the last 4 years, this is the only one I've ever returned and I did that last night. Because I consider books I buy to be such a repository of reference material, I struggled with even returning it, but something about the book just did not fit my way of thinking (which cannot be considered a knock on the author at all!). I've read some reviews about the book that it has errors and buggy code, but I did not get past the 2nd chapter nor even crack the CD, so I'll not lay that out as an issue either. I think that maybe part of the problem was that I had some knowledge already and clunking around with a "step-by-step" manual was like having someone eager to drive a racecar but their instructor wants to show them how to use the shifter. This book probably has a target audience that I didn't fit in. Visual Basic.Net, Richard Bowman One of my bargain purchases that was a dog. If the author's name is not on the cover of the book, that should be some sort of warning right there. Actually, there is some good material in the book, but its so covered up with screens on every page, you have to spend a lot of time digging for what you need. An excellent example of how NOT to design pages for tech books. Save your money. If you were only allowed 3 books to learn how to write both desktop and Compact Framework database apps, my choices would be: Microsoft ADO.Net, David Sceppa Professional SQL Server 2000 Database Design, Louis Davidson Microsoft .Net Compact Framework Kick Start, Erik Rubin, Ronnie Yates Tag: Cannot connect to SQL Server Tag: 88621
  - 10
    - Forcing/Flushing dataset updates to mdb database Hello, When calling the .Update() method on a dataset to make the changes on the undercover database (access .mdb), the changes are not reflected immediatly. If i close the connection, it makes the changes more quickly effective. Do you have an idea how to force the update (writing the cache on the disk) without closing the connection ? Regards, Cybertof. Tag: Cannot connect to SQL Server Tag: 88616
  - 11
    - Late and early binding "Patrice" <nobody@nowhere.com> wrote in message news:<ezhVHjLREHA.1388@TK2MSFTNGP09.phx.gbl>... > It's always different. Probably not very well explained but basically : > - Early binding is to know the type of an object at compile time. The > compiler have all the needed element at compile time to build the call into > the excutable code (resolution of calls at compile time) > - With late binding, the type of an object is known only at runtime. It will > need extra instructions to find out where is the method to be called (if it > exists) before calling it (resolution of calls at runtime) > > > > "al" <grawsha2000@yahoo.com> a écrit dans le message de > news:66edfd3c.0405272344.af8f49e@posting.google.com... > > Hi, > > > > Does it make difference to do early or late binding in ADO.net? > > > > > > MTIA, > > Grawsha What about the allocated resources to the early bound object (declared and instantiated at the same time with NEW keyword). This object might not be called untill some time, dose that (untill it is called)waiste needed resources? Tag: Cannot connect to SQL Server Tag: 88609
  - 12
    - How to work with MSSQL uniqueidentifier type I have a MSSQL table that has a uniqueidentifier that defaults to (newid()) I'm getting the following Error when I try to insert a new record into the dataset Column 'ID' does not allow null I've hacked at the properties for a while but no luck...any clues TIA Ro Tag: Cannot connect to SQL Server Tag: 88601
  - 13
    - avoiding temp table creation Hi All, I'm migrating a legacy, reporting-type application (ODBC) to use ADO.NET in order to facilaite ASP.NET delivery. The problem I have is that some of the reports this old app runs relies heavily on creating temporary tables to hold intermediate results of complex select expressions. The temporary tables are then joined in order to get the final data set, and the temp tables are deleted when done. Needless to say, performance wasn't really stellar. Now that I'm re-wrinting the app, is there any advice people could give me to leverage ADO.NET technology to improve performance? Can I somehow get rid of the temp table creation and bring these intermediate query results into DataAdapters/DataSets AND be able to join them? Another constraint is that I have to support a variety of db's (SQLServer, Oracle, Jet), so I can't rely on the features of any specific provider. Thanks for any advice. Corey. Tag: Cannot connect to SQL Server Tag: 88598
  - 14
    - Where can I find a BerkeleyDB XML for .Net || Has anybody found anything about .Net and BerkeleyDB Hi, I am looking for any information regarding BerkeleyDB XML for .NET or if anybody have information regarding an alternativ (free) to BerkeleyDB XML for storing XML and using XQuery. (Yes I have looked at http://www.sleepycat.com) I have found the samples in the download (http://www.merrells.com/john/dbxml/archives/cat_faq.html#000197) ==> I am currently having a look at SWIG.... Any more links or any other information would be much appreciated. Regards, .RikardN Tag: Cannot connect to SQL Server Tag: 88597
  - 15
    - Modal / Parent forms VB.net Hi all, Wonder if anyone can shed any light on this scenario. I have an MDI form, Form1, that opens a child window Form2.. - simple enough. However, from Form2, I would like to open a form Form3 (is a 'search and select' type form) and have it modal to form2 AND be an MDI child... i.e. the user cannot get back to Form2 without doing whatever they have to do in Form3, but at the same time can go and do something else in Form1 - e.g. open another form.!!.. I'm sure this has been explained in the past - if anyone can help it would be appreciated. Thanks, Graham Tag: Cannot connect to SQL Server Tag: 88596
  - 16
    - [ANN] June 1, "ADO.NET with Visual Basic .NET" chat Wondering about how best to access data from your applications? Then bring your questions and ask them to experts from the Visual Studio and SQL teams. Come learn about the best approaches for working with data in your applications. Date: June 1, 2004 Time: 1:00 - 2:00 P.M. Pacific time 4:00 - 5:00 P.M. Eastern time 20:00 - 21:00 GMT (For a list of local time zones relative to GMT, please see http://msdn.microsoft.com/chats/timezones.asp.) Outlook Reminder: http://msdn.microsoft.com/chats/outlook_reminders/vb_june1.ics Location: http://msdn.microsoft.com/chats (then click the name of the chat to enter the chat room) For more information about Visual Basic .NET, see http://msdn.microsoft.com/vbasic/ To see a list of upcoming chats or set a reminder for this chat, see http://msdn.microsoft.com/chats. For archives of previous chats, see http://msdn.microsoft.com/chats/recent.asp. Thanks! Jason Cooke VB.NET Team ======== This posting is provided "AS IS" with no warranties, and confers no rights. You assume all risk for your use. (c) 2004 Microsoft Corporation. All rights reserved. Tag: Cannot connect to SQL Server Tag: 88590
  - 17
    - Output Parameter Issue I want to use a datareader to execute a stored procedure and records from a table. I want to trap any possible errors in the stored procedure and return the error message via an output parameter. But, the output parameter is empty (nothing!) any time after I execute a query For example, say I have the stored procedur CREATE PROCEDURE sp_Some_Pro @OutMsg varchar(200) = '' OUTPU A SET @OutMsg = 'test RETUR I do the following in my code after the ExecuteReader statement sOutMsg = CType(arParms(0).Value, String and sOutMsg is "test". But when the stored procedure has a select statement in it lik CREATE PROCEDURE sp_Some_Pro @OutMsg varchar(200) = '' OUTPU A SELECT * FROM AnyTabl SET @OutMsg = 'test RETUR I get sOutMsg equal to nothing I also got the same result when I tried to use just straight ADO instead of ADO.NET Has anyone seen this before Tag: Cannot connect to SQL Server Tag: 88584
  - 18
    - BindingManagerBase Not Working I have a Windows form with textboxes, labels, comboboxes, and a listbox. I bind the database fields to those objects and would like the user to be able to click through them (forward, back, first, last). The navigation buttons are not working. I commented out the combobox code b/c I read somewhere that could be causing the problem. That didn't work. What am I doing wrong. Thanks. Private Sub btnGetRecords_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGetRecords.Click If cboDept.SelectedIndex = 0 Then MessageBox.Show("You must select an area.", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error) cboDept.Focus() Else Try sb.Append("SELECT e.eqnum, nvl(purpose, ' ') AS purpose,") sb.Append(" NVL(theory_of_operation,' ') AS theory_of_operation,") sb.Append(" NVL(similar_devices, ' ') AS similar_devices,") sb.Append(" NVL(level_nbr, 1) As level_nbr, l.description AS unit_op,") sb.Append(" nvl(me.description, ' ') AS description, e.tagged") sb.Append(" FROM dbo.th_equipment e, dbo.equipment@MAXLDA_P me, ") sb.Append("dbo.locations@MAXLDA_P l ") sb.Append("WHERE me.location LIKE '%") sb.Append(CType(cboDept.SelectedItem, ItemData).Key) sb.Append("%' AND ") sb.Append("SubStr(me.location,1,5) = l.location AND ") sb.Append(" me.eqnum=e.eqnum") sb.Append(" ORDER BY e.eqnum") da.SelectCommand.CommandText = sb.ToString() da.Fill(ds, "equipment") sb.Remove(0, sb.Length) sb.Append("SELECT eqnum, issue_id FROM dbo.th_equipment_issue") Dim cmdEqIssues As New OleDb.OleDbCommand(sb.ToString, conn) Dim daEqIssues As New OleDb.OleDbDataAdapter(cmdEqIssues) daEqIssues.Fill(ds, "equipment_issues") sb.Remove(0, sb.Length) sb.Append("SELECT issue_id, description FROM dbo.th_issue ") sb.Append("ORDER BY description") Dim cmdIssues As New OleDb.OleDbCommand(sb.ToString(), conn) Dim daIssues As New OleDb.OleDbDataAdapter(cmdIssues) daIssues.Fill(ds, "issues") Dim equip_issue_rel As New DataRelation("eq_issue_rel", ds.Tables(0).Columns("eqnum"), ds.Tables(1).Columns("eqnum")) ds.Relations.Add(equip_issue_rel) Dim issue_rel As New DataRelation("is_rel", ds.Tables(2).Columns("issue_id"), ds.Tables(1).Columns("issue_id")) ds.Relations.Add(issue_rel) lbSelectedIssues.DataSource = ds.Tables("issues") lbSelectedIssues.DisplayMember = ds.Tables("issues").Columns(1).ColumnName lbSelectedIssues.ValueMember = ds.Tables("issues").Columns(0).ColumnName lbSelectedIssues.DataBindings.Add("SelectedValue", ds.Tables("equipment_issues"), "issue_id") txtPurpose.DataBindings.Add("Text", ds.Tables("equipment"), "purpose") lblEQNUM.DataBindings.Add("Text", ds.Tables("equipment"), "eqnum") lblUnitOp.DataBindings.Add("Text", ds.Tables("equipment"), "unit_op") lblDescription.DataBindings.Add("Text", ds.Tables("equipment"), "description") txtTheoryOfOperation.DataBindings.Add("Text", ds.Tables("equipment"), "theory_of_operation") txtSimilarDevices.DataBindings.Add("Text", ds.Tables("equipment"), "similar_devices") ' cboLevel.DataSource = ds.Tables("equipment") ' cboLevel.DisplayMember = "level_nbr" ' cboLevel.ValueMember = "level_nbr" 'cboLevel.DataBindings.Add("SelectedValue", ds.Tables("equipment"), "level_nbr") ' cboTagged.DataSource = ds.Tables("equipment") ' cboTagged.DisplayMember = "tagged" ' cboTagged.ValueMember = "tagged" 'cboTagged.DataBindings.Add("SelectedValue", ds.Tables("equipment"), "tagged") eqBindingManagerBase = Me.BindingContext(ds, "equipment") Catch ex As Exception MessageBox.Show("Encountered error when getting records.", "System Error", MessageBoxButtons.OK, MessageBoxIcon.Error) End Try End If End Sub Private Sub btnLast_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLast.Click eqBindingManagerBase.Position = eqBindingManagerBase.Count - 1 End Sub Private Sub btnFirst_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnFirst.Click eqBindingManagerBase.Position = 0 End Sub Private Sub btnBack_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnBack.Click eqBindingManagerBase.Position -= 1 End Sub Private Sub btnForward_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnForward.Click eqBindingManagerBase.Position += 1 End Sub Tag: Cannot connect to SQL Server Tag: 88576
  - 19
    - COM wrapper around a .NET assembly Hi all, Wonder if anyone can point me in the right direction. Due to time-constraints, it looks lie I may have to abandon using VB.NET development in favour of my more familiar VB6 environment. The issue I have is, that I have to use a .NET assembly (DLL) to access data from a database. I understand it is possible to create a wrapper using COM which would then make it available to VB6. Although this isnt ideal, it might help me, in this partiular case, get to where I need to go a lot quicker. I'm not familiar with COM, but it may still be less of a learning curve than .NET.... Any help would be happily received. Thanks, Graham Tag: Cannot connect to SQL Server Tag: 88573
  - 20
    - Expression columns and DevisionByZero Hi all, I'm adding a DataColumn to my DataTable with a given expression: "column1/column2". But sometimes it occurs that in some rows, value of column2 is 0. Then while adding my expression column, program throws DivisionByZeroException. I would like to handle this exception in a way, that if division by 0 occurs, Iwould like to set expression columns to 0. How should I do it? Any advice would by very appreciated. Tag: Cannot connect to SQL Server Tag: 88558
  - 21
    - cannot connect sql server with sqlDataAdapter when i have tried connect local or remote server i have give below error message. An unhandled exceptin of type 'System.Data.SqlClient.SqlException' occured in system.data.dll Additional information: System Error i use below command Public Class Form1 Inherits System.Windows.Forms.Form #Region " Windows Form Designer generated code " Public Sub New() MyBase.New() 'This call is required by the Windows Form Designer. InitializeComponent() 'Add any initialization after the InitializeComponent() call End Sub 'Form overrides dispose to clean up the component list. Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean) If disposing Then If Not (components Is Nothing) Then components.Dispose() End If End If MyBase.Dispose(disposing) End Sub 'Required by the Windows Form Designer Private components As System.ComponentModel.IContainer 'NOTE: The following procedure is required by the Windows Form Designer 'It can be modified using the Windows Form Designer. 'Do not modify it using the code editor. Friend WithEvents SqlDataAdapter1 As System.Data.SqlClient.SqlDataAdapter Friend WithEvents SqlSelectCommand1 As System.Data.SqlClient.SqlCommand Friend WithEvents SqlInsertCommand1 As System.Data.SqlClient.SqlCommand Friend WithEvents SqlConnection1 As System.Data.SqlClient.SqlConnection Friend WithEvents DataSet11 As WindowsApplication2.DataSet1 <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent() Me.SqlDataAdapter1 = New System.Data.SqlClient.SqlDataAdapter Me.SqlSelectCommand1 = New System.Data.SqlClient.SqlCommand Me.SqlInsertCommand1 = New System.Data.SqlClient.SqlCommand Me.SqlConnection1 = New System.Data.SqlClient.SqlConnection Me.DataSet11 = New WindowsApplication2.DataSet1 CType(Me.DataSet11, System.ComponentModel.ISupportInitialize).BeginInit() ' 'SqlDataAdapter1 ' Me.SqlDataAdapter1.InsertCommand = Me.SqlInsertCommand1 Me.SqlDataAdapter1.SelectCommand = Me.SqlSelectCommand1 Me.SqlDataAdapter1.TableMappings.AddRange(New System.Data.Common.DataTableMapping() {New System.Data.Common.DataTableMapping("Table", "tblreg", New System.Data.Common.DataColumnMapping() {New System.Data.Common.DataColumnMapping("ID", "ID"), New System.Data.Common.DataColumnMapping("FirstName", "FirstName"), New System.Data.Common.DataColumnMapping("LastName", "LastName"), New System.Data.Common.DataColumnMapping("Address1", "Address1"), New System.Data.Common.DataColumnMapping("Address2", "Address2"), New System.Data.Common.DataColumnMapping("Il", "Il"), New System.Data.Common.DataColumnMapping("City", "City"), New System.Data.Common.DataColumnMapping("State", "State"), New System.Data.Common.DataColumnMapping("Zip", "Zip"), New System.Data.Common.DataColumnMapping("Phone", "Phone"), New System.Data.Common.DataColumnMapping("Fax", "Fax"), New System.Data.Common.DataColumnMapping("Email", "Email"), New System.Data.Common.DataColumnMapping("CardType", "CardType"), New System.Data.Common.DataColumnMapping("CardNum", "CardNum"), New System.Data.Common.DataColumnMapping("Exp1", "Exp1"), New System.Data.Common.DataColumnMapping("Exp2", "Exp2"), New System.Data.Common.DataColumnMapping("Cvv", "Cvv"), New System.Data.Common.DataColumnMapping("UserOrder", "UserOrder"), New System.Data.Common.DataColumnMapping("Product_Id", "Product_Id"), New System.Data.Common.DataColumnMapping("Product_Adet", "Product_Adet"), New System.Data.Common.DataColumnMapping("Product_Fiyat", "Product_Fiyat"), New System.Data.Common.DataColumnMapping("Product_Toplam", "Product_Toplam"), New System.Data.Common.DataColumnMapping("Product_KDV", "Product_KDV"), New System.Data.Common.DataColumnMapping("Product_Tutar", "Product_Tutar"), New System.Data.Common.DataColumnMapping("Product_Name", "Product_Name"), New System.Data.Common.DataColumnMapping("Tarih", "Tarih"), New System.Data.Common.DataColumnMapping("TransId", "TransId"), New System.Data.Common.DataColumnMapping("OrderId", "OrderId"), New System.Data.Common.DataColumnMapping("GroupId", "GroupId"), New System.Data.Common.DataColumnMapping("OrderType", "OrderType"), New System.Data.Common.DataColumnMapping("onay", "onay"), New System.Data.Common.DataColumnMapping("Grup", "Grup")})}) ' 'SqlSelectCommand1 ' Me.SqlSelectCommand1.CommandText = "SELECT ID, FirstName, LastName, Address1, Address2, Il, City, State, Zip, Phone, " & _ "Fax, Email, CardType, CardNum, Exp1, Exp2, Cvv, UserOrder, Product_Id, Product_A" & _ "det, Product_Fiyat, Product_Toplam, Product_KDV, Product_Tutar, Product_Name, Ta" & _ "rih, TransId, OrderId, GroupId, OrderType, onay, Grup FROM tblreg" Me.SqlSelectCommand1.Connection = Me.SqlConnection1 ' 'SqlInsertCommand1 ' Me.SqlInsertCommand1.CommandText = "INSERT INTO tblreg(FirstName, LastName, Address1, Address2, Il, City, State, Zip," & _ " Phone, Fax, Email, CardType, CardNum, Exp1, Exp2, Cvv, UserOrder, Product_Id, P" & _ "roduct_Adet, Product_Fiyat, Product_Toplam, Product_KDV, Product_Tutar, Product_" & _ "Name, Tarih, TransId, OrderId, GroupId, OrderType, onay, Grup) VALUES (@FirstNam" & _ "e, @LastName, @Address1, @Address2, @Il, @City, @State, @Zip, @Phone, @Fax, @Ema" & _ "il, @CardType, @CardNum, @Exp1, @Exp2, @Cvv, @UserOrder, @Product_Id, @Product_A" & _ "det, @Product_Fiyat, @Product_Toplam, @Product_KDV, @Product_Tutar, @Product_Nam" & _ "e, @Tarih, @TransId, @OrderId, @GroupId, @OrderType, @onay, @Grup); SELECT ID, F" & _ "irstName, LastName, Address1, Address2, Il, City, State, Zip, Phone, Fax, Email," & _ " CardType, CardNum, Exp1, Exp2, Cvv, UserOrder, Product_Id, Product_Adet, Produc" & _ "t_Fiyat, Product_Toplam, Product_KDV, Product_Tutar, Product_Name, Tarih, TransI" & _ "d, OrderId, GroupId, OrderType, onay, Grup FROM tblreg" Me.SqlInsertCommand1.Connection = Me.SqlConnection1 Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@FirstName", System.Data.SqlDbType.NVarChar, 50, "FirstName")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@LastName", System.Data.SqlDbType.NVarChar, 50, "LastName")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Address1", System.Data.SqlDbType.NVarChar, 50, "Address1")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Address2", System.Data.SqlDbType.NVarChar, 50, "Address2")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Il", System.Data.SqlDbType.NVarChar, 50, "Il")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@City", System.Data.SqlDbType.NVarChar, 50, "City")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@State", System.Data.SqlDbType.NVarChar, 50, "State")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Zip", System.Data.SqlDbType.NVarChar, 50, "Zip")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Phone", System.Data.SqlDbType.NVarChar, 50, "Phone")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Fax", System.Data.SqlDbType.NVarChar, 50, "Fax")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Email", System.Data.SqlDbType.NVarChar, 50, "Email")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CardType", System.Data.SqlDbType.NVarChar, 50, "CardType")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@CardNum", System.Data.SqlDbType.NVarChar, 50, "CardNum")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Exp1", System.Data.SqlDbType.NVarChar, 50, "Exp1")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Exp2", System.Data.SqlDbType.NVarChar, 50, "Exp2")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Cvv", System.Data.SqlDbType.NVarChar, 50, "Cvv")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@UserOrder", System.Data.SqlDbType.NVarChar, 50, "UserOrder")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Product_Id", System.Data.SqlDbType.NVarChar, 50, "Product_Id")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Product_Adet", System.Data.SqlDbType.NVarChar, 50, "Product_Adet")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Product_Fiyat", System.Data.SqlDbType.NVarChar, 50, "Product_Fiyat")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Product_Toplam", System.Data.SqlDbType.NVarChar, 50, "Product_Toplam")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Product_KDV", System.Data.SqlDbType.NVarChar, 50, "Product_KDV")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Product_Tutar", System.Data.SqlDbType.NVarChar, 50, "Product_Tutar")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Product_Name", System.Data.SqlDbType.NVarChar, 50, "Product_Name")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Tarih", System.Data.SqlDbType.NVarChar, 50, "Tarih")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@TransId", System.Data.SqlDbType.NVarChar, 50, "TransId")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@OrderId", System.Data.SqlDbType.NVarChar, 50, "OrderId")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@GroupId", System.Data.SqlDbType.NVarChar, 50, "GroupId")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@OrderType", System.Data.SqlDbType.NVarChar, 50, "OrderType")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@onay", System.Data.SqlDbType.NVarChar, 50, "onay")) Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Grup", System.Data.SqlDbType.NVarChar, 50, "Grup")) ' 'SqlConnection1 ' Me.SqlConnection1.ConnectionString = "workstation id=SEK01;packet size=4096;user id=sa;data source=""SNX"";persis" & _ "t security info=False;initial catalog=shoppingregs" ' 'DataSet11 ' Me.DataSet11.DataSetName = "DataSet1" Me.DataSet11.Locale = New System.Globalization.CultureInfo("tr-TR") ' 'Form1 ' Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13) Me.ClientSize = New System.Drawing.Size(292, 273) Me.Name = "Form1" Me.Text = "Form1" CType(Me.DataSet11, System.ComponentModel.ISupportInitialize).EndInit() End Sub #End Region Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load SqlDataAdapter1.Fill(DataSet11) End Sub End Class please help me! Tag: Cannot connect to SQL Server Tag: 88553
  - 22
    - retrieving pictures Okay, so I got it down on how to store a bit stream (jpeg file) in Access using Visual Basic .NET. Now when I want to pull that information back to the form and display the picture I am guessing that it is not as easy as just binding a picture box to the Picture field in my table as it is not letting me bind to that field. What is required to read this file back to the form and display the information. Thanks for the help. Brad Tag: Cannot connect to SQL Server Tag: 88550
  - 23
    - Retrieving relational data Hello! I need to retrieve the data from two related Access 2000 tables and store them in two datatables within a dataset. There is a datarelation between these datatables. I select information to fill the parent datatable based on a pretty complex filter criteria. Is there a way to select the records from the second Access table that are related to the rows of the already-filled parent datatable? Are the only two options here either to create separate queries for each of the parent rows and filter children based on the parent ID-field or use a single query including both the parent and the child tables and repeating filtering of the parent? Thank you, Grigory. Tag: Cannot connect to SQL Server Tag: 88545
  - 24
    - how do I create a page that listen to the following url http://us.f513.mail.yahoo.com/ym/login?.rand=cpewweffef2kgrt? hi guys. how do I create a page that listen to the following url http://us.f513.mail.yahoo.com/ym/login?.rand=cpewweffef2kgrt? what are the classes that I should look into it? please advise all thoughts welcome. regards, Nigil Chua Tag: Cannot connect to SQL Server Tag: 88541
  - 25
    - Retrieving relational data Hello! I need to retrieve the data from two related Access 2000 tables and store them in two datatables within a dataset. There is a datarelation between these datatables. I select information to fill the parent datatable based on a pretty complex filter criteria. Is there a way to select the records from the second Access table that are related to the rows of the already-filled parent datatable? Are the only two options here either to create separate queries for each of the parent rows and filter children based on the parent ID-field or use a single query including both the parent and the child tables and repeating filtering of the parent? Thank you, Grigory. Tag: Cannot connect to SQL Server Tag: 88539
- Next
  - 1
    - Problem for insert Unicode data to nVarchar table field Dear all I encounter a problem for upgrade an existing ASP.net project to support binary characters store to SQL 2000 database (like Traditional Chinese) which originally support for english characters only. I find out that to achieve that I have 2 ways to do 1. to change the collation setting of the database table to support binary characters which may need to drop and re-create all table 2. to change the table field from varchar to Nvarchar and modify sql parameter type in the project I find out that both method are quit time-consuming and quit trouble-some, do anyone know that there is a better way to do so? If no, then which method is better for implement a multi-language ASP.net project? Thank you for your kindly reply Best Regards Ivan Tong Tag: Cannot connect to SQL Server Tag: 88531
  - 2
    - How To utilize an XML based dataset in a DataGrid Good Morning to all, I have some XML files. Each one represent a single table of a database, and some of them are related. I want to use a simple example to explain my needs: Supposed that I have a xml file named "people" with fields "id_people" and "name" and an xml named "phone_number" with fields "id_phone", "id_people" and "number". (phone_number.id_people is a foreign key verus people.id_people, representing "this phone number is for this person" - sorry for my english- ) I am able to load all the xml files in a dataset, and so creating 2 tables. Suppose that now I want to display in a datagrid a listing of each phone number with this format: | number | people |. I need to assign as datamember of this grid a join query made against "number" and "people". Obviously I need to create a join, but how is it possible having a dataset with just two table? Regards Dev Tag: Cannot connect to SQL Server Tag: 88523
  - 3
    - Late and early binding Hi, Does it make difference to do early or late binding in ADO.net? MTIA, Grawsha Tag: Cannot connect to SQL Server Tag: 88518
  - 4
    - Binding I have creating VB .NET form with ADO .NET which have 2 textbo and have set DataBindings to the text properties of the TextBoxes i bind the the box with txtsysno.DataBindings.Add(new binding("Text", dataset1, "trxsystem.sysno") txtbranch.DataBindings.Add(new binding("Text", dataset1, "trxsystem.branch") when the form run, i place a method when a button clic txtsysno.text = "Z001 when i trace it, the txtsysno.text = "Z001" and i set the branch value throught the dataset wit dataset1.tables(0).Rows(0)("Branch") = e.SelectedRow(1) after i run the above code, the txtsysno was set to "", i don't know what makes this happen an BUT according to tests I've run, it says that the DataBindings exist, but the IsBinding is set to False, and is ReadOnly (the bindings exist, they just aren't active AND I can't/don't know how to make them active) Any body can help me??? thanks before Tag: Cannot connect to SQL Server Tag: 88512
  - 5
    - SQL server 2000 , how to save Danish data HI all I am working on Denmark Project, where I need to save Danish data to SQL server 2000 Database. When I am trying to save Danish Data, it is having some special Characters, it is getting converted to english characters. eg:character 'Ã¸' is getting saved as 'o How can we avoid this Thanks in advance. Eary help appreciated Thanks EJ Tag: Cannot connect to SQL Server Tag: 88508
  - 6
    - Monitor Transaction log Is there a way to monitor transaction log in SQL server and Oracle server using .NET? I'd like to write in VB.NET to mimic the SQL server replication (transactional publication) to use against SQL and Oracle to monitor some of the tables. Please advice. Thanks Tag: Cannot connect to SQL Server Tag: 88505
  - 7
    - returning values FROM window form Hi all, Quickie - I hope. I already know how to use a forms New() Sub to receive parameters from a calling class - but I don;t know how to return values... Anyone know the recommended method for doing this? Thanks, Graham Tag: Cannot connect to SQL Server Tag: 88496
  - 8
    - this stored procedure in sql query analyzer works correctly. but! i have a stored procedure : CREATE PROCEDURE [AddBuyer] ( @ID [int], @Name [varchar](50), @Address [varchar](50), @Phone [int] ) AS ... this procedure in sql query analyzer works correctly. but: i had created a app and test these lines of code: SqlConnection sqlCon = new SqlConnection(Connection.String); SqlCommand insertCommand = SqlHelper.CreateCommand(sqlCon,"AddBuyer", "@ID","@Name","@Address","@Phone"); SqlCommand updateCommand = SqlHelper.CreateCommand(sqlCon,"ChangeBuyerInfo", "@ID","@Name","@Address","@Phone"); SqlCommand deleteCommand = SqlHelper.CreateCommand(sqlCon,"DeleteBuyer", "@ID"); SqlHelper.UpdateDataset(insertCommand,deleteCommand,updateCommand,dsBus,tabl eName); sqlCon.Close(); this code raises an error and error message is: procedure 'AddBuyer' expects parameter '@ID', which was not supplied. Tag: Cannot connect to SQL Server Tag: 88495
  - 9
    - Retrieving timestamp output parameter from SqlCommand I've got a SqlCommand that executes a SQL Server 2000 stored procedure which, among other things, returns a timestamp output parameter. For the life of me, I can't figure out how to assign the value of this timestamp value to a byte array. I figure it's gotta be simple so what am I missing here? -- Cheers, David Clegg dclegg_at_ebetonline_dot_com Vote 1 http://cc.borland.com/codecentral/ccweb.exe/listing?id=21489 :-) Now supports Google Groups searching with Dyna-extend(tm) technology! Quality Central. The best way to bug Borland about bugs. http://qc.borland.com "Oh, well, of course, everything looks bad if you remember it." - Homer Simpson Tag: Cannot connect to SQL Server Tag: 88486
  - 10
    - Intermittent IndexOutOfRangeException - SqlDataReader Hi All I've been searching on the internet more than a week for a solution to this problem. All that I got was some desperate guys like me without an answer. My ASP.Net system works fine 99% of the time. However, eventually the system starts to fail with an IndexOutOfRangeException in any query that I run using the datareader object. The only way to stop this behavior is restarting the IIS Service. I know itÂ´s not a scalabillity problem... just few users are operating the system on that moment. It could be a pooling problem? I'll aprecciate any clue Alisso [IndexOutOfRangeException: field_name System.Data.Common.FieldNameLookup.GetOrdinal(String fieldName) +5 System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) +7 System.Data.SqlClient.SqlDataReader.get_Item(String name) +1 Tag: Cannot connect to SQL Server Tag: 88484
  - 11
    - Problem when creating database with SQL batch via ExecuteNonQuery() Hi All, I'm trying to create my database using a batch of SQL commands via ExecuteNonQuery(). The SQL batch should create the database and then all the tables to go into it. The start of the script is as follows: IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'TEST') DROP DATABASE [TEST] print 'Creating database TEST.' CREATE DATABASE [TEST] ON PRIMARY ( Name=TEST_Data, filename = 'C:\dbtest\scripts\\TEST.mdf', size=3, maxsize=5, filegrowth=10% ) LOG ON ( name=TEST_log, filename='C:\dbtest\scripts\TEST.ldf', size=3, maxsize=20, filegrowth=1 ) exec sp_dboption N'TEST', N'auto create statistics', N'true' exec sp_dboption N'TEST', N'auto update statistics', N'true' use [TEST] set nocount on print 'Creating branch table.' CREATE TABLE [dbo].[branch] ( [code] [char] (10) COLLATE Latin1_General_CI_AS NOT NULL , [name] [varchar] (12) COLLATE Latin1_General_CI_AS NULL , [addr1] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [addr2] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [addr3] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [addr4] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [addr5] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [postcode] [varchar] (15) COLLATE Latin1_General_CI_AS NULL , [telnum] [varchar] (15) COLLATE Latin1_General_CI_AS NULL , [usemodemno] [char] (10) COLLATE Latin1_General_CI_AS NULL , [modemnum] [varchar] (15) COLLATE Latin1_General_CI_AS NULL , [commreq] [char] (10) COLLATE Latin1_General_CI_AS NULL , [active] [char] (10) COLLATE Latin1_General_CI_AS NULL ) ON [PRIMARY] .... and so it goes on. (I'm picking up the 'print' statements via InfoMessage and a SqlInfoMessageEventHandler) The problem I get is that it's not creating the database or rather it seems not to be waiting for the database to be created. I've tried adding a WAITFOR DELAY but the execution just seems to ignore the statement and continues. I really don't want to split out the CREATE DATABASE into a separate script. I've tried placing the CREATE DATABASE into an EXEC ('..') but it still has the problem when it comes to the USE [TEST] ... I keep getting 'Cannot locate entry in sysdatabases for 'TEST' ...' I'm using a trusted connection to MSDE. Any help would be appreciated. Thanks in advance. Scott Tag: Cannot connect to SQL Server Tag: 88480
  - 12
    - 150+ columns SQL table??? Hi All; The DataAdapter Wizard does not like more than 99 columns so I have 2 DataAdapters with 2 DataSets. The first fills the first half of the row and the second fills the second half. Is this the best way of filling a DataSet with 150+ columns from a SQL MSDE Database? Thanks. Tag: Cannot connect to SQL Server Tag: 88479
  - 13
    - Two parent tables related to the same Child table Hello all, I have a problem that I'm not sure can be solved with a typical relationship in a DataSet. I have 3 tables in a dataset. 2 parents and a child. I have set up relationships between the parent tables and the child tables. The way I have set up the relationships is like this. ParentTables have an identity column, lets say ParentTable1ID or ParentTable2ID, and a 'SourcetypeID' column. The 'SourceTypeID' column is an integer (either 1 or 2). I.E. In Parenttable1 all rows have 1 in the column SourceTypeID and in Parenttable2 all rows have 2 in the column SourceTypeID. In the child table there is a column of ParentUniqueID and SourceTypeID. ParentUniqueID column maps to the parentID based on the SourceTypeID column. This way I can have rows in the childtable are associated with a row in either Parenttable1 or ParentTable2 based on the SourceTypeID column. So I have set up a relationship with both the ParentUniqueID and SourceTypeID columns (a multicolumn relationship). To put it another way if there is a row in the child table with ParentUniqueID set to 3 and SourceTypeID set to 1, the relationship dictates, the child row is associated to ParentTable1 with the ParentTableID of 3. Here is the problem. Becuase rows in the child table can have a parent in either parent table, I can not enable the constraint when creating the two relationships. This is because every row in a child table will be related to a single row in EITHER ParentTable1 or ParentTable2. Having said that, from what I understand, if you don't have a FK constraint on the child table you can not get cascading changes between the parent and child tables. So when I am updating the parents identity column it is not updating the childs 'ParentUniqueID' column to reflect the change. Is it possible to cacade changes in a dataset with relationships set up in this manner? If not, what is a good technique for updating children rows data when a parent tables row updates? Thanks for all responses in advance! Tom Tag: Cannot connect to SQL Server Tag: 88478
  - 14
    - Need DataGrid Help I want to "hot track" the cursor as it moves over the datagrid (highlight each row as the cursor moves), and I want to be able to select a row for editing when clicking on it. Is this possible? Tag: Cannot connect to SQL Server Tag: 88477
  - 15
    - IDbTransaction spanning several methods I am building a multi-tier app (similar to the design of MS PetShop). My original intention was to use MS DTC and declarative/automatic transactions, but having run into a million problems and having read some performance stats, I am at least investigating an alternative path: The BLL (Business Logic Layer) that is the transaction boundary, but would contain no transaction code other than [AutoComplete] attributes, etc, now has some knowledge of transactions. Each DAL (Data Access Layer) method has a ref IDbTransaction parameter, which they test for null and initialize if they are. This results in DAL code similar to: public void MyMethod(...., ref IDbTransaction trans) { OracleConnection conn = null; if ( trans == null ) { conn = new OracleConnection(CONN_STRING); trans = conn.BeginTransaction(); } else { conn = (OracleConnection)trans.Connection; } : OracleCommand cmd = ... cmd.Connection = conn; cmd.Transaction = (OracleTransaction)trans; : } and BLL code similar to: IDbTransaction trans = null; try { DALFactory.Create().MyMethod(..., trans); DALFactory.Create().MyOtherMethod(..., trans); } catch ( Exception e ) { IDbConnection conn = trans.Connection; trans.Rollback(); conn.Close(); throw e; } IDbConnection conn = trans.Connection; trans.Commit(); conn.Close(); Not very elegant.... I can swallow the transaction stuff in the BLL code, but I would really prefer it if I could end each DAL method with a conn.Close() as I would if I was using EnterpriseServices. Is there a more elegant solution? What happens if I call conn.Close() with a running transaction? I suppose I could try it, but I am still interested in input and suggestions on what to do. Cheers, Ola Tag: Cannot connect to SQL Server Tag: 88473
  - 16
    - Icon in Column Header On a WinForm application is there a way to add an icon into the column header of a datagrid? I am wanting to display a 'key' icon for the key columns of tables. Tag: Cannot connect to SQL Server Tag: 88472
  - 17
    - XML & Datset problem I am having big problem manipulating XML in a dataset. I am reading in a schema based on the following XML document. The minute I try to e.g. create a new row I get 'Object reference not set to an instance of an object' error <?xml version="1.0" encoding="utf-8"?> <DocumentElement xmlns="http://tempuri.org/dseditted2.xsd"> <TableInfo> <FieldName>column value</FieldName> <ControlType>column value</ControlType> <IsNull>column value</IsNull> <MaxLength>column value</MaxLength> </TableInfo> </DocumentElement> editteddataset = New DataSet() editteddataset.ReadXmlSchema("C:\Inetpub\wwwroot\xmlxconfig\dseditted2.xsd") Dim dsItem As DataRow Dim dsTable As DataTable dsTable = editteddataset.Tables("TABLEINFO") dsItem = editteddataset.Tables("TABLEINFO").NewRow Dim getcontroltype As DropDownList getcontroltype = CType(e.Item.FindControl("controltype"), DropDownList) THIS IS THE LINE OF CODE WHICH GENERATES THE ERROR dsItem("CONTROLTYPE") = getcontroltype.DataTextField What am I not understanding about XML, As I am fine when it is pulled from a database. Tag: Cannot connect to SQL Server Tag: 88467
  - 18
    - Oracle client not found ...- vb.net SQL*Plus works fine from te command line. Running code inside the vb.net app gives the long message at the bottom. Here is the code in question: ado_ora_con = CreateObject("ADODB.Connection") ado_ora_con.Provider = "MSDAORA" ado_ora_con.ConnectionString = "Data Source=umdw.umsystem.edu;User ID=email_directory;Password=************" ado_ora_con.Open() If ado_ora_con.State <> 1 Then MsgBox("Authentication to Oracle Failed") Exit Function End If Thanks, HankC error message=============================================================== Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Runtime.InteropServices.COMException: Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [COMException (0x80004005): Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.] Microsoft.VisualBasic.CompilerServices.LateBinding.InternalLateCall(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack, Boolean IgnoreReturn) +789 Microsoft.VisualBasic.CompilerServices.LateBinding.LateCall(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack) +23 vanity.oracle.is_student(String site, String id) in c:\inetpub\wwwroot\inetpub\wwwroot\projects\vanity\oracle.vb:154 vanity.WebForm1.Button1_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\inetpub\wwwroot\projects\vanity\vanity.aspx.vb:135 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain() +1277 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573 Tag: Cannot connect to SQL Server Tag: 88461
  - 19
    - How make non-web app work on Local area network I have a non-web (winforms) VS dot net application that I have written using SQL Server 2000 as the back-end. This was done on a local area network with a dedicated file server. SQL Server 2000 resides on the file server and a full blown version of VS.net is on a client machine of the server. My solution resides on the local C drive. At this point in time I suppose I am doing what you would call a client/server type application in a two tier architecture. Is this Correct? So far so good. My applicaiton runs and works fine. However, I would like the application to be accessable to other machines on the network. The other machines all run Windows XP and have the dot net framework. My question has to do with the best way to do this. I suppose from the original machine I could create an .msi file, copy it to each of the other machines on the network and run it but this seems tidious. Another thought that comes to me is that instead of creating the solution on the local drive of the design machine, maybe I should create it on a shared drive of the server. Perhaps then I could compile to release mode and the other client machines could simply access the .exe that release mode creates. Is this possible and the way you do things in dot net or do I have it wrong? My guess is that at this point I would effectively have a 3-tier solution its just that the middle tier and the data tier would be considered as residing on the same machine - i.e., the file server. Any clarification would be appreciated. Tag: Cannot connect to SQL Server Tag: 88458
  - 20
    - ASP.NET w/ SQL Server Sessions & Cluster Failover Is there an elegant way to clear out the ADO connection pool used by the SQL Server State Service following a cluster failover? We are using a SQL Cluster to store both the ASP Session State database and our application database. When the SQL Server cluster is failed-over, any "pointers" to the live connections stored in the connection pool are made invalid. When the application tries to reference these "damaged" connections, it throws an exception, and the pooling mechanism drops the bad connections from the pool. In our application, we are using a looping try/catch block to clear out the bad connections from the pool following a failover, and the users typically are not affected by the failover as a result of any exceptions in our application code. However, we don't have access to the source code for managing the ASPState connections. It appears as though there is no mechanism for the ASPState database to clear out the bad connections from the pool following a failover, and thus the exceptions are affecting users. Is SQL Server Session State Management even supposed to work with a SQL Cluster? Mike Olund OpenRoad Communications Tag: Cannot connect to SQL Server Tag: 88456
  - 21
    - datgrid helps those who help themselves ok - I'm not looking for a specific answer to a specific problem all I need is a push in the right direction where can I find full descriptions/usage for ALL the DATAGRID operators (ie GetVal, GetText, ...... (Visual C++ 6. thanks Tag: Cannot connect to SQL Server Tag: 88451
  - 22
    - DataGrid not customizing columns! Hi, I have the following code, that "should" display only one column on the datagrid from the datatable created here, but that is the theory anyway!,any comment on this would be appreicated...Thanks in advance DataTable dtCompany = new DataTable("Company") // Declare DataColumn and DataRow variables DataColumn dcolCompanyCode DataColumn dcolCompany DataColumn dcolCompanyID DataRow drowCompany // Create new DataColumn, set DataType, ColumnName and add to DataTable. dcolCompanyID = new DataColumn() dcolCompanyID.DataType = System.Type.GetType("System.Int32") dcolCompanyID.ColumnName = "CompanyID" dtCompany.Columns.Add(dcolCompanyID) // Create new DataColumn, set DataType, ColumnName and add to DataTable. dcolCompanyCode = new DataColumn() dcolCompanyCode.DataType = System.Type.GetType("System.String") dcolCompanyCode.ColumnName = "CompanyCode" dtCompany.Columns.Add(dcolCompanyCode) // Create second column dcolCompany = new DataColumn() dcolCompany.DataType = Type.GetType("System.String") dcolCompany.ColumnName = "CompanyName" dtCompany.Columns.Add(dcolCompany) // Create new DataRow objects and add to DataTable. for(int i = 0; i < dsetCompanyDetails.Tables["Table"].Rows.Count; i++ drowCompany = dtCompany.NewRow() drowCompany["CompanyCode"] = dsetCompanyDetails.Tables["Table"].Rows[i]["CompanyCode"] drowCompany["CompanyName"] = dsetCompanyDetails.Tables["Table"].Rows[i]["CompanyName"] dtCompany.Rows.Add(drowCompany) this.dgrdCompanyDetails.DataSource = dtCompany //this.dgrdCompanyDetails.DataSource=dsetCompanyDetails DataGridTableStyle ts1 = new DataGridTableStyle() ts1.MappingName = dtCompany.GetType().Name //ts1.MappingName = "dtCompany" DataGridTextBoxColumn dcolCustomerCode = new DataGridTextBoxColumn();// DataGridBoolColumn() dcolCustomerCode.HeaderText = "Company Code" dcolCustomerCode.MappingName = "CompanyCode" dcolCustomerCode.Width = 150 ts1.GridColumnStyles.Add(dcolCustomerCode) this.dgrdCompanyDetails..TableStyles.Add(ts1) Tag: Cannot connect to SQL Server Tag: 88444
  - 23
    - System.DllNotFoundException at OracleClient.UnsafeNativeMethods.OraMTSJoinTxn (also posted in microsoft.public.dotnet.framework.interop) I am running Windows XP Professional, Visual Studio .NET 2003, Oracle 9.2.0.1 and am trying to get automatic transactions with System.EnterpriseServices/MSDTC to work. I have set up the registry to point to, as far as I am aware, the right DLLs under HKLM\softare\microsoft\msdtc\mtxoci. I have also created the key XADLL and added a <orahome>\heteroxa9.dll. The business layer component (C# using System.Data.OracleClient) that is marked as transactional is called by an asp.net web application. The transactional class is registered with regsvcs and is visible in Component Services. The first time a method on the calling thread within the transactional component touches the database, the below exception is generated. Giving "Everyone" full access to the <orahome>\bin directory didn't help, so I do not think it is a security related problem. I have also tried to set the asp application to be in-process/out of process just to make sure that there is no problem with working directories etc (the dll in question resides and is registered in the bin directory of the web app) Any ideas? System.Exception: ? ---> System.DllNotFoundException: ? at System.Data.OracleClient.UnsafeNativeMethods.OraMTSJoinTxn(HandleRef pCtxt, ITransaction pTrans) at System.Data.OracleClient.TracedNativeMethods.OraMTSJoinTxn(HandleRef pCtxt, ITransaction pTrans) at System.Data.OracleClient.OciEnlistContext.Join(ITransaction transaction) at System.Data.OracleClient.OracleInternalConnection.Enlist(String userName, String password, String serverName, ITransaction transaction, Guid transactionGuid) at System.Data.OracleClient.OracleInternalConnection.ActivateForDistributedTran saction() at System.Data.OracleClient.OracleInternalConnection.Activate() at System.Data.OracleClient.DBObjectPool.GetObject(Object owningObject, Boolean& isInTransaction) at System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(Str ing encryptedConnectionString, OracleConnectionString options, OracleConnection owningObject, Boolean& isInTransaction) at System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionStrin g parsedConnectionString, Object transact) at System.Data.OracleClient.OracleConnection.Open() -- rest of stracktrace snipped Tag: Cannot connect to SQL Server Tag: 88442
  - 24
    - Oracle Parameter goes missing I have stored proc that takes 5 parameters and works fine when called from within one class, in another class i ge "ORA-06550: line 1, column 7 PLS-00306: wrong number or types of arguments in call to 'GETPEOPLE ORA-06550: line 1, column 7 PL/SQL: Statement ignored when looking with QuickWatch at the Command object its Parameters collection has all the parameters set up correctly BU StatementText for the Command object is: StatementText "begin PDCProcedures.GetPeople(p_LinkPersonID=>:p_LinkPersonID, p_PersonID=>:p_PersonID, p_Result=>:p_Result, p_ErrorMessage=>:p_ErrorMessage); end;" Strin ie it only has 4 parameters rather than 5, the middle one is missing Microsoft Oracle DataProvider, VB.NET 2002, Win2K, Oracle Server V8.174, Oracle Client 9.2.0.1. any ideas gu Tag: Cannot connect to SQL Server Tag: 88441
  - 25
    - HELP:Need add/update code example This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C443CB.F7F90250 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Just making the transition from VB6 to .net. I've been thru the ado.net = course but still am reaching. I have a project that MUST be done quickly = and MUST be in vb.net. It's a simple routine that downloads some = fixed-length data files then updates a database. Specifically, I'm = having trouble with the code that checks for an existing record (based = on an account ID). If the record doesn't exist, then it needs to add a = new record and populate the rest of the columns. If the record does = exist then just populate the rest of the columns. Please help me to stop beating me head upon the wall with a few code = samples, please? Thanks in advance. (an email copy to rick1ryan@yahoo.com would be great also) ------=_NextPart_000_0008_01C443CB.F7F90250 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Just making the transition from VB6 to = .net. I've=20 been thru the ado.net course but still am reaching. I have a project = that MUST=20 be done quickly and MUST be in vb.net. It's a simple routine that = downloads some=20 fixed-length data files then updates a database. Specifically, I'm = having=20 trouble with the code that checks for an existing record (based on an = account=20 ID). If the record doesn't exist, then it needs to add a new record and = populate=20 the rest of the columns. If the record does exist then just populate the = rest of=20 the columns.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Please help me to stop beating me head = upon the=20 wall with a few code samples, please?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks in advance.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>(an email copy to <A=20 href=3D"mailto:rick1ryan@yahoo.com">rick1ryan@yahoo.com</A> would be = great=20 also)</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV> </DIV></BODY></HTML> ------=_NextPart_000_0008_01C443CB.F7F90250-- Tag: Cannot connect to SQL Server Tag: 88431

I am not connecting to my sql server running local.programming in
VB.net Database programming with statement
Dim OConn As New SqlConnection("Data
Source=localhost\\KIRZAD-APPLE;Initial Catalog=Northwind;
UID=sa;PWD=")

My server name is KIRZAD-APPLE

OConn.Open() 'Throwing exception,probably not getting the server.

Please help me.Bye.

Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com

Top

Re: Cannot connect to SQL Server by William

William
Sun May 30 12:29:14 CDT 2004

It'd help if you told us what the exception was, but I can guess what it
is. Take off the localhost\\KIRZAD-APPLE and replace it with KIRZAD-APPLE
or the instance name. Just using the Instance name should be enough.

Another thing. Do yourself a favor and either put a password on the SA
account, or better yet, get rid of the SA account and make one of your own
with the privileges you need. Give it a strong password and change the
password on a regular basis, plus anytime an employee leaves or is fired
that may have known what it was. Hackers will target SA and if you don't
have a password on it, you are giving them the keys to the kingdom. This is
such a well known exploit you are really putting yourself at unnecessary
risk for no benefit. While putting a password on it, particularly a strong
one will help minimize this risk, getting rid of SA all together. I know
you need help connecting and not a lecture on security practices, but I
think my first comment will fix the first problem and whether or not you
take my advice about SA, I figured I'd at least mention it in case you
weren't aware of the vulnerability.

Let me know if that doesn't fix the problem.

Bill

--
W.G. Ryan MVP Windows - Embedded

http://forums.devbuzz.com
http://www.knowdotnet.com/dataaccess.html
http://www.msmvps.com/williamryan/
"zenedenzidane" <kashifabbas1@yahoo-dot-com.no-spam.invalid> wrote in
message news:40ba17e6_2@Usenet.com...
> I am not connecting to my sql server running local.programming in
> VB.net Database programming with statement
> Dim OConn As New SqlConnection("Data
> Source=localhost\\KIRZAD-APPLE;Initial Catalog=Northwind;
> UID=sa;PWD=")
>
> My server name is KIRZAD-APPLE
>
> OConn.Open() 'Throwing exception,probably not getting the server.
>
> Please help me.Bye.
>
>
> Posted Via Usenet.com Premium Usenet Newsgroup Services
> ----------------------------------------------------------
> ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
> ----------------------------------------------------------
> http://www.usenet.com

Top

re:Cannot connect to SQL Server by kashifabbas1

kashifabbas1
Tue Jun 01 02:21:25 CDT 2004

Thanks for tell me about hacking,I have tried the connection with
string
Dim OConn As New SqlConnection("Data Source=KIRZAD-APPLE;Initial
Catalog=Northwind; UID=sa;PWD=")

But still
OConn.Open() 'An unhandled exception of type
'System.Data.SqlClient.SqlException' occurred in system.data.dll

probably not matching the User id & PWD.Can any one tell me how to
change the SQL databse password,and also what is the syntex of actual
string in Sqlconnection. Bye.

Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com

Top