connection string

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
    - Query is too complex Hi, I'm using the querybuilder when updating a (rather wide) record in a table (Access). However, I get a "Query is too complex" message. It seems that for "optimistic locking " purposes, the WHERE Clause is very complex Any suggestions how to get this working? Thanks in advance, Ben Tag: connection string Tag: 87265
  - 2
    - How do I use store procedures? How do I create and use "store procedures" with an SqlConnection object? I need to create a procedure that will add a record and return the new ID of said record. I know that I can accomplish this with "store procedures." If you can direct me to a simple sample, I would really appreciate it. - Rashad Rivera Tag: connection string Tag: 87264
  - 3
    - Connection time out Hi all i´m opening a table with a few thousands of records and it allways gets me a connection timeout. my connection string is ( using sqlclient.sqlconnection and a SqlDatadapter) "User ID=sa;Initial Catalog=BD;Data Source=Server;Password =xxxx;Connect Timeout=30000" can someone help .. JSB Tag: connection string Tag: 87263
  - 4
    - DataSet Updates fails when there are non-printable characters in a field Hi When I try to update my changes found in a dataset I often get Concurrency violation: the UpdateCommand affected 0 records. Because one of the fields (varchar) contains a single TAB chr(9) or a single CRLF pair of characters. How can I fail-safe my update code so that even these characters can get updated? I guess it is because of the tests that the command-builder object creates that doesn't like non-printable characters. Perhaps they should be escaped properly? but how can I do that? It is frustrating moving to ADO.NET from ADO finding that now updates fails because there's some odd content in the fields! Any ideas for simple solution? //Andy Tag: connection string Tag: 87262
  - 5
    - Named Pipes alias in web.config I'm trying to use a named pipes alias in a connection string in a web.config file. At the moment, my string looks like this: "Application Name=test1;Data Source=richtest;Network=DBNMPNTW;Initial Catalog=richdb1;Integrated Security=SSPI" /> I'm guessing that the problem is the "richtest" alias seems to just be read as a DNS name - ie. I think it assumes it's a machine called richtest and it tries to resolve that name to an IP address. The richtest alias is set up in the SQL Client Network Utility as a named pipes connection and works fine for other applications. The connection string works if I use the actual pipe name (\\richserver1\pipe\MSSQL$SQ2\sql\query), but I want to avoid doing that if I can, just in case it changes. If I can use the alias, it means I only have to change the alias if the database location changes, and I don't have to worry about other things stopping working because of hard-coded pipe names. Any help with this would really be appreciated. Rich Tag: connection string Tag: 87261
  - 6
    - Request for details on XML-MSDATA Schema I request that Microsoft's .Net team publish the schema indicated by: 'urn:schemas-microsoft-com:xml-msdata', or at least publish a document describing all of the attributes (and elements?) defined in the said schema. I'm developing an ASP.net application using datasets, on a very time restriced schedule, and so the details of the said schema would be extremely helpful in manually crafting the XSD file used by my application. Tag: connection string Tag: 87250
  - 7
    - commandBuilder Update SQL generation for > 1 table? In ADO, I could issue a query (using an MSS provider) which returned a result set from multiple tables, and update the data in a grid and post it. (I'm actually not quite sure how that works but it does). In ADO.NET I can't do this, I have to roll my own UPDATE, which isn't possible for ad-hoc queries. Does anyone know why this changed and if there is any technique to allow updates of ad-hoc queries in a data grid involving multiple tables? Thanks Tag: connection string Tag: 87247
  - 8
    - Application Global Datasets I am creating a dataset from xml on my main form using ReadXML. I have alot of other forms and want to use data from the tables in the main forms dataset. THIS IS NOT AN MDI APP. How can I set this up? reference the main form then the data set? put the dataset in its own class file? use the dataset xsd (which I don't know how to do yet)? something else I am not thinking of. Obviously the entire point is to get the disconnected dataset into memory and allow all my forms to hit the datables however they want. Also, since I am creating the dataset from XML I dont think I can use most of the normal wizards when doing this from server explorer. Many thanks, James M Tag: connection string Tag: 87240
  - 9
    - DataReader to ArrayList Hi, What would be the fastest way to transfer a one column DataReader into a ArrayList ? Thanks, Alan Tag: connection string Tag: 87223
  - 10
    - Prob with Param in UpdateCommand Greetings, I'm trying to update a detail table which does not have any unique fields (that is the exercise) and have a problem with parameters in the Where clause, message says my Where params not supplied. I have an int var and 2 string vars to retrieve the original values of the fields in the row to be updated. If I don't use a where clause, the params for the new values work OK except that all the rows get the same values. Thus, I have to use a Where clause but don't know to implement the Params in the Where clause. Here is what I have so far: sqlDA.UpdateCommand = New SqlCommand("Update tbl2 Set fld1 = @prm1, fld2 = @prm2 Where (ID = @ID And fld1 = @fld1 And fld2 = @fld2)", conn) ------------------------------------------------------- ---params with new values---------this works OK without Where clause---------- sqlParm = sqlDA.UpdateCommand.Parameters.Add(New SqlParameter("@prm1", SqlDbType.VarChar, 50, "fld1")) sqlParm = sqlDA.UpdateCommand.Parameters.Add(New SqlParameter("@prm2", sqlDbType.VarChar,50, "fld2")) ----------------------------------------------------- ----------------------------------------------------- ---params for Where Clause with original values from variables--------- ---message says these params not being supplied to Where clause''--------------- sqlParm = sqlDA.UpdateCommand.Parameters.Add(New SqlParameter("@ID", SqlDbType.BigInt, 8, conID.ToString)) sqlParm = sqlDA.UpdateCommand.Parameters.Add(New SqlParameter("@fld1", SqlDbType.VarChar, 50, strfld1)) sqlParm = sqlDA.UpdateCommand.Parameters.Add(New SqlParameter("@fld2", SqlDbType.VarChar, 50, strfld2)) ----------------------------------------------------- Is there a way for me to reference the original field values without using vars, conID, strfld1, strfld2? How do I supply these params to the Where clause? Do I need to do anything to conID.ToString - supposed to be an Integer. Thanks for help, Jerry Tag: connection string Tag: 87218
  - 11
    - Data from Dataset into new table in SQL Hello: I am having trouble creating a table and then taking the contents of a dataset and insert it into the new table. I am looking for methods and exsamples I have read many different approches. 1. I read my data into the dataset from a Text file. I do some modifactions to the data. 2. I ask the user what table name they want. And then create the table with the same fields that the text file has and the table name that they specify. 3. I would like to take the data that is in the dataset and dump it into the table that was just created. How would I do that? Again, I have read many differnt ways with no success. Please help. :) Tag: connection string Tag: 87211
  - 12
    - dataset share between 2 user controls I have 2 user controls that both share the same typed dataset (which uses the typical parent child relationship). The first control fills the dataset and then passes a reference to it to the second control. There is a time when the first control needs to update the data in the dataset and re-fills it. However, when that is done, the second control does not "see" that change as the pointers to the memory locations are now out of sync. Does anyone know how to get it so that if my first control updates the dataset, the pointers will remain the same, so that the second control can "see" the new data? I tried creating a temporary dataset, filling it, and then copying it to the original, but that didn't seem to work either. Any thoughts would be greatly appreciated. Tag: connection string Tag: 87205
  - 13
    - Typed DataSet names - length restriction Is there any restriction on the length of a DS name, Table name, Field Name, number of tables, etc. in a Typed Dataset? Tag: connection string Tag: 87203
  - 14
    - Concurrency in ADO.NET Hi all WeÂ´re developing an application will have a lot of concurrent users. I want to know whatÂ´s he best way to give a solution to this problem in .NET. Any idea will be appreciated Thanks a lot. Tag: connection string Tag: 87190
  - 15
    - sp_help_job (HELP) Can anyone get sp_help_job to execute via ado.net ?? The following code produces a "severe error occurred on the command object" SqlConnection connection = new SqlConnection(connectionString) connection.Open() SqlCommand cmd = new SqlCommand() cmd.Connection = connection cmd.CommandText = "exec msdb.dbo.sp_help_job @job_name='My SQL Job',@job_aspect='JOB'" cmd.CommandType = System.Data.CommandType.Text cmd.CommandTimeout = 90 SqlDataAdapter da = new SqlDataAdapter(cmd) DataSet ds = new DataSet() da.Fill(ds) connection.Close() I can execute the same command Text in SQL Query Analyzer without a problem (using the same connection id and pwd) Even if I don't pass any parms I get the error. I've tried to execute it as a proc and as text Any ideas ?? Tag: connection string Tag: 87186
  - 16
    - connect to Access DB via IP address Hi, Like SQL Server, is it possible to build the connection string using IP address for retrieving data from Access DB(.mdb) ? Because I'm implementing an application in which the program installed on retail shops which has boardband internet access, but the database is located on Data Center, they have different subnet mask. So far I can think of using VPN is the only solution to connect Access database in data center. Thx in advance! Keith Tag: connection string Tag: 87185
  - 17
    - Using only one connection for several forms with VS.NET Hi, I have several forms in my project now, each with it's separate connection to a DB. I would like to have only one connection in a form or class that can be used by all the other forms and still be able to use the VS wizards for DataAdapter creation etc. I would also like to use the same DataAdapters and DataSets accross multiple forms. How can I do this most efficiently? Any good articles on this? I have not found any good information about this on the web yet. Any tips, hints, links or help will be greatly appreciated. Thanks in advance! Cheers, Trygve Tag: connection string Tag: 87176
  - 18
    - XML EXPLICIT Hello, I have a stored proc that takes two input params and returns xml using the "FOR XML EXPLICIT". I am at a loss how I can read this proc in .Net . I don't want to bind it or use a data grid etc, as its all on the server side. Does anyone know how to read a proc that returns XML ? Regards Danny Tag: connection string Tag: 87171
  - 19
    - Comparing two typed datasets Hi, I have a typed dataset for Employee named tdsEmployee. tdsEmployee has two columns named FirstName, LastName I want to compare two instances of tdsEmployee and get the differences. For Ex: tdsEmp1 might have data like Row1: 'Mike', 'Meyers' Row2: 'John', 'Doe' tdsEmp2 might have data like Row1: 'Mike', 'Meyers' Row2: 'John', 'Abe' Then after comparision, I want the result : 'John', 'Doe' is there any way to do this ?? TIA. :) Tag: connection string Tag: 87170
  - 20
    - Connections as Static??? Hi I am writing a fairly simple desktop app which will not be subject to great loads. Therefore this question is more for academic purposes I have implemented a class that declares only static members and functions. I use this class to control my connections. There are just 2 methods; Open and Close. The connection object within the class is static and has public scope. It is created when the app is started. (This obviously enables connection pooling This makes the code very simple. When I want to use a connection I just call myConnectionClass.Conn. No need to dimension anythinig, dispose etc. I just make sure I close it when the routine has finished Is this OK? I am worried that by declaring just 1 connection as a static there will be threading issues. i.e. There may be a que of users waiting to use the single, shared connection object What do you experts think Andy Newland (MCAD) Tag: connection string Tag: 87169
  - 21
    - Parameter causing error It's been a long night ... Hopefully someone can point out my mistake here. I'm getting a System.Data.SqlClient.SqlException system error when trying to pass the parameter to the database. Even substituting a hard-coded value causes the error. If I drop the parameter, no errors -- but of course, no parameter either. Dim cmdPayments As New SqlCommand Dim drPayments As SqlDataReader cnSQLServer.Open() cmdPayments = cnSQLServer.CreateCommand cmdPayments.CommandType = CommandType.StoredProcedure cmdPayments.CommandText = "GetPaymentHistoryByCustomer" 'this line causing the error cmdPayments.Parameters.Add(New SqlParameter("@CustomerID", cmbCustomers.ValueMember)) drPayments = cmdPayments.ExecuteReader(CommandBehavior.CloseConnection) Tag: connection string Tag: 87168
  - 22
    - unicode sorting How can I sort datatable according to unicode? I set corret regional and culture settings but Basic .Net sorts according Ascii. It sorts letters with accents like without them. thank you in advance Tag: connection string Tag: 87167
  - 23
    - .NET studio, add connection problem Hi, I use Microsoft Visual Basic .NET studio, and I created a VB project. I would like to create a new connection on the Server Explorer view. I select Data Connection item, and select "add connection ... " popup menu item, the "Data Link Properties" dialog box is not displayed. does anyone here have any idea ?? Thanks. Tag: connection string Tag: 87164
  - 24
    - DataSet constraints Hi I have a typed DataSet that contains two tables. The second table has a foreign key that refers to the primary key of the first table. When i fill the first table there is no problem. But when i fill the second table i get the following error: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. Many thanks in advance Tag: connection string Tag: 87163
  - 25
    - ADO.NET and Localization Hi, I want work with local language in a VB.NET Application, like storing 'Arabic data' in the database as well as retrive it.Can any one help me out in this regard? Reny Tag: connection string Tag: 87161
- Next
  - 1
    - "Vertical Slice" of a DataSet I have a DataSet with three tables: (sorry, I'm at another PC and don't have access to my code to provide an XML snippet myDataSet.Tables[0].TableName = "AccountManagers" myDataSet.Tables[1].TableName = "NewsFeeds" myDataSet.Tables[2].TableName = "NewsFeedArticles" There are two DataRelations in this DataSet, they are defined as follows myDataSet.DataRelations.Add "AccountManagers_NewsFeeds", myDataSet.Tables["AccountManagers"].Columns["UserId"] myDataSet.Tables["NewsFeeds"].Columns["UserId"]) an myDataSet.DataRelations.Add "NewsFeeds_NewsFeedArticles", myDataSet.Tables["NewsFeeds"].Columns["SubscriptionId"] myDataSet.Tables["NewsFeedArticles"].Columns["SubscriptionId"]) The NewsFeedArticles table is filled with "articles" from an RSS feed. Here's what I need to do: (pseudo code for every entry in myDataSet.Tables["AccountManagers"].Row Generate some simple HTML as follows AccountManage NewsFee NewsFeedArticl NewsFeedArticl NewsFeedArticle .. NewsFee NewsFeedArticl NewsFeedArticl NewsFeedArticle .. It's easy to do the XSL transformation on a whole DataSet. My difficulty is coming from the fact that I have to do a tranformation on a vertical slice of the DataSet. So what I have to do is basically create a copy of the DataSet for each entry in .Tables["AccountManagers"]. I would fill the other tables using the two DataRelations. That seems inefficient. Is there an easier way to select a "vertical slice" of this DataSet? Hope I made sense, thank you. Tag: connection string Tag: 87159
  - 2
    - Free Extensions Library Simplify application development with this free .NET framework extensions, which includes: + Straight-forward data access with in-memory databases: No need to manage connections, adapters, commands etc. + Soft XML rules + Extended controls library: Data control, progress bars, image buttons, explorer + Multilingual support with a single line of code + Intuitive data binding + Samples and utilities included Fully documented. Requires .NET framework 1.1 or later. You will be allowed to use the libraries in any application - private or commercial, and distribute them as part of your application, royalty-free. E-mail me for you free copy: ori@s-e-a.com.au Your acceptance of the license agreement will be required. Thank you -- Ori Millo Solutions Consultant SEA Software Ever After http://www.s-e-a.com.au Tag: connection string Tag: 87157
  - 3
    - Accessing Foxpro DBF and index files Please give me example to connect to DBF files and its indexes using OLEDB.NET Thank you. Tag: connection string Tag: 87156
  - 4
    - Accessing Foxpro DBF and index files Please give me example to connect to DBF files and its indexes using OLEDB.NET Thank you. Tag: connection string Tag: 87155
  - 5
    - Preserving Lists in Product Description Fields I create lists in my products description field in SQL by pressing ctrl + j. I pull the information and find that I get one big long string in my dataset. Is there a way to preserve this lists? I'm dropping it into my html file and find that I can't break it up... Is there a way to do a string.indexof() for a ctrl + j? Maybe I can keep them working this way. Eg. Features: <ctrl + j> Ladder Back<ctrl+ j> Color option<ctrl + j> Tag: connection string Tag: 87147
  - 6
    - Cross -Site Scripting and SQL Data Reader I am using sqlDataReader for Showing data from the Data base But if the Data from sql is having tags like <script>alert()</script> then it shows an alert box while binding Is there any way of suppressing it this ..... ??? regard Vineet Batt Tag: connection string Tag: 87144
  - 7
    - integrated security and using NT credentials vs. ASP.NET My connection string is set to use integrated security. When I try to log into my data source via my asp.net application, I get the following error: "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection" My NT login name is setup in the data source as a user and it has been granted the necessary rights against the database objects. I thinking that the default user name for asp.net application is the asp.net machine account, and because the database does not have this user established, I'm getting this permission error. Does anyone know the best way to avoid this and have the credentials of the logged in user be used via the integrated security connection string? Tag: connection string Tag: 87137
  - 8
    - ADO.NET the dataset and XML I have an XmlDatadocument (named rawXmlDataDocument ) which has been populated by a dataset (named searchResultDTO). This yields the following xml: <SearchResultDTO xmlns=\"http://tempuri.org/SearchResult.xsd\"> <SearchResult> <ID>182</ID> <Summary>Power User Account, Please enter your content here ...</Summary> <Path>This is the path!!</Path> </SearchResult> <SearchResult> <ID>185</ID> <Summary>Power User Account, Please enter your content here ...</Summary> <Path>This is the path!!</Path> </SearchResult> </SearchResultDTO> I am trying to parse with XSL using the XslTransform object. My XSL is the following: <?xml version="1.0" encoding="UTF-8" ?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" > <xsl:template match="/"> <xsl:call-template name="DisplayResults"></xsl:call-template> </xsl:template> <xsl:template name="DisplayResults"> <xsl:for-each select="SearchResult"> <h1>HELLO!</h1> </xsl:for-each> </xsl:template> </xsl:stylesheet> This is done using the following code (Please note that the XslTransform was populated earlier) : rawXmlDataDocument = new XmlDataDocument(searchResultDTO); //return rawXmlDocument.OuterXml; transformedXmlDataDocument = new XmlDataDocument(); transformedXmlDataDocument.Load(XslTransform.Transform(rawXmlDataDocument,null)); Response.Write(transformedXmlDataDocument.OuterXml); I would expect this to produce the following HTML when the XMLDataDocument.OuterXml method was called (after the tasnformation): <h1>HELLO!</h1> <h1>HELLO!</h1> Instead no transformation occurs. I think my xslt is wrong. Can anybody halp me? Tag: connection string Tag: 87134
  - 9
    - HELP - Getting a Value Out of a DataTable This is a multi-part message in MIME format. ------=_NextPart_000_00BC_01C436AA.ACCF8D40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have code to populate 1 data table in a dataset. The data table looks = something like: ParameterName ReportName ParameterValue Param1 Report1 1 Param2 Report1 2 Param3 Report1 3 ReportStartDate Report1 05/10/2004 00:00 ReportEndDate Report1 05/10/2004 23:59 After querying the DB and populating the dataset/data table, I now need = to get the "ParameterValue" for the "ReportStartDate" and = "ReportEndDate" rows to save to local variables, something like: value in local variable rptSDate =3D 05/10/2004 00:00 value in local variable rprEDate =3D 05/10/2004 23:59 But, I'm not sure how to navigate through this data table to find the = "ReportStartDate" and "ReportEndDate" rows and then get their associated = "Parameter" values. Help? Any suggestions? Thanks. ------=_NextPart_000_00BC_01C436AA.ACCF8D40 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>I have code to populate 1 data table in = a=20 dataset.  The data table looks something like:</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3D"Courier New" = size=3D2>ParameterName     =20 ReportName    ParameterValue</FONT></DIV> <DIV><FONT face=3D"Courier New" = size=3D2>Param1     =20        = Report1      =20 1</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2>Param2   =20         =20 Report1       2</FONT></DIV> <DIV><FONT face=3D"Courier New"=20 size=3D2>Param3         &nbs= p;  =20 Report1       3</FONT></DIV> <DIV><FONT face=3D"Courier New" = size=3D2>ReportStartDate   =20 Report1       05/10/2004 = 00:00</FONT></DIV> <DIV><FONT face=3D"Courier New" = size=3D2>ReportEndDate     =20 Report1       05/10/2004 = 23:59</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>After querying the DB and populating = the=20 dataset/data table, I now need to get the "ParameterValue" for the=20 "ReportStartDate" and "ReportEndDate" rows to save to local variables, = something=20 like:</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>value in local variable rptSDate =3D = 05/10/2004=20 00:00</FONT></DIV> <DIV><FONT face=3DArial size=3D2>value in local variable rprEDate = =3D 05/10/2004=20 23:59</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>But, I'm not sure how to navigate = through this data=20 table to find the "ReportStartDate" and "ReportEndDate" rows and then = get their=20 associated "Parameter" values.  Help?  Any = suggestions?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_00BC_01C436AA.ACCF8D40-- Tag: connection string Tag: 87132
  - 10
    - Number of registers returned After executing the ExecuteReader command fom IDbCommand, what is the best way to get the number of registers returned by the query? Thanks in advance, Lourenço. Tag: connection string Tag: 87131
  - 11
    - Configuration.AppSettims returns Nothing Hi - can anyone please help this is driving me up the wall!! I have a config file <?xml version="1.0" encoding="utf-8"?><configuration><appSettings><add key="connectString" value="server=DEV1-SMCT\NIIR;database=DBName;uid=username;password=password" /></appSettings></configuration (In final release I won't have passwords in this!! And when I load my first form I try and retrieve the value usin str_Connection = ConfigurationSettings.AppSettings("connectString" And every time this returns Nothin I also tried the line str_Connection = ConfigurationSettings.AppSettings.Item("connectString").ToString but just gives an error because the object is nothing I hope someone can point the obvious that I must be missing! Thank Siobha PS Apologies - I am posting this again as I originally posted as a response to someone elses old post - just in case it doesn't get spotted Tag: connection string Tag: 87130
  - 12
    - Pls help: updatingAccess db with ASP.NET > Hi, I'm have problems updating records in an access db. I'm using the code > generated by WeB Matrix wizard for 'update'. The insert code and delete > code > work fine. > No eorror messages, it just won't update the rexord. > Where do I start looking? > I'm running the latest version of the DotNete framework onn a Win2k server > with IIS 5.0. Update function code: Function UpdateEventInfo(ByVal eventName As String, ByVal description As String) As Integer Dim connectionString As String = ConfigurationSettings.AppSettings("constring_db") Dim dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbConnection(connectionString) Dim queryString As String = "UPDATE [Events] SET [Description]=@Description WHERE ([Events].[EventName] = @Eve"& _ "ntName)" Dim dbCommand As System.Data.IDbCommand = New System.Data.OleDb.OleDbCommand dbCommand.CommandText = queryString dbCommand.Connection = dbConnection Dim dbParam_eventName As System.Data.IDataParameter = New System.Data.OleDb.OleDbParameter dbParam_eventName.ParameterName = "@EventName" dbParam_eventName.Value = eventName dbParam_eventName.DbType = System.Data.DbType.String dbCommand.Parameters.Add(dbParam_eventName) Dim dbParam_description As System.Data.IDataParameter = New System.Data.OleDb.OleDbParameter dbParam_description.ParameterName = "@Description" dbParam_description.Value = description dbParam_description.DbType = System.Data.DbType.String dbCommand.Parameters.Add(dbParam_description) Dim rowsAffected As Integer = 0 dbConnection.Open 'Try rowsAffected = dbCommand.ExecuteNonQuery 'Finally dbConnection.Close 'End Try Return rowsAffected End Function ------------------------------------------------- Commit Button code: Sub butUpdate_Click(sender As Object, e As EventArgs) If IsValid Then Dim intEventID, intRowsUpdated, intRowsDeleted As Integer Dim strEventName As String Dim strStartTime, strEndTime, strEventTime As String Dim dtStartDate, dtEndDate As DateTime Dim strLocation, strDescription, strReservations, strFireworks As String Dim strCost AS String Dim strURL, strPubEmail, strSponsor, strContactName, strContactPhone, strPhoneExt, strNotes As String intEventID = Session("id") strEventName = txtEventName.Text strLocation = txtLocation.text strDescription = txtDescription.Text strURL = txtURL.Text strPubEmail = txtEmail.Text strSponsor = txtSponsor.Text strContactName = txtContactName.Text strNotes = txtNotes.Text strCost = txtCost.Text strStartTime = dropStart.SelectedItem.Value & " " & radioStart.SelectedItem.Value strEndTime = dropEnd.SelectedItem.Value & " " & radioEnd.SelectedItem.Value strEventTime = strStartTime & " - " & strEndTime strReservations = radioReservations.SelectedItem.Value strFireworks = radioFireworks.SelectedItem.Value strContactPhone = txtContactPhone.Text strPhoneExt = txtPhoneExt.Text Try dtStartDate = Convert.ToDateTime(txtStartDate.Text) dtEndDate = Convert.ToDateTime(txtEndDate.Text) Catch Response.Redirect("error.aspx?Error=1") End Try 'intRowsUpdated = UpdateEventInfo(intEventID,strEventName,dtStartDate,dtEndDate,strEventTime,s trLocation,strDescription,strCost,strReservations,strFireworks,strURL,strPub Email,strSponsor,strContactName,strContactPhone,strPhoneExt,strNotes) intRowsUpdated = UpdateEventInfo(strEventName,strDescription) If intRowsUpdated = 1 Then Response.Redirect("complete.aspx?Action=2") Else Response.Redirect("error.aspx?Error=3&ID=" & intEventID & "") End If End If End Sub __________________________________________ The aforementioned code send me to the error page call if intRowsUpdated is 0, meaning the data is not updating. And if I open the DB in Access, I can see that it's not gettting there either. TIA, Mark Tag: connection string Tag: 87129
  - 13
    - Optimistic Concurrency causing Data Adapter Configuration Wizard Error Hi, Here's a mystery: I have a simple database with a primary key and 25 columns. When I create a data adapter using the wizard, I get the message: "There were errors configuring the data adapter." for the UPDATE and DELETE statements only. By experiment, I've found that these errors are generated only when the "Use Optimistic Concurrency" radio button on the Adavanced options of the wizard is selected. When I did the same thing for the database when it had only 3 columns, there are were no problems. Any ideas? The primary key is an INT type and the other fields are "text" type. Tag: connection string Tag: 87128
  - 14
    - Invalid attempt to GetBytes on column '' , Please HELP Hi , I have a Stored Procedure that return an xml (by using the xml auto or explicit) into some XmlReader and i m getting the following error . Invalid attempt to GetBytes on column ''. The GetBytes function can only be used on columns of type Text, NText, or Image. Please note that the SP running ok under the query analyzer and when i m using the XmlReader with other SP which return an XML every thing ok . -- Best Regards , Tiraman :-) Tag: connection string Tag: 87114
  - 15
    - Text to Dataset I am trying to read in the contents of a Text file to a dataset. Every time I run the line = "Objconn.open()" it gives me the following exception "System.data.oledb.oledbexception: 'c:\D.txt' is not a vaild path yada yada yada" I have changed the location of the file to many differnt locations as well and replace the file with a different one, No luck. I was wondering if someone out there could help. Here is my Code. Dim sconnectionstring As String Dim da As OleDb.OleDbDataAdapter sconnectionstring = "Provider=microsoft.jet.oledb.4.0;Data " &_ "source=c:\D.txt;extended properties=""Text;HDR=Yes;FMT=Delimited """ Dim objconn As New System.Data.OleDb.OleDbConnection(sconnectionstring) Try objconn.Open() Catch ex As Exception MsgBox(ex.ToString) End Try Dim sSQL As String sSQL = "Select * from D.txt" da = New OleDb.OleDbDataAdapter(sSQL, objconn) Dim ds As New DataSet("table1") da.Fill(ds, "table1") Dim dt As DataTable dt = ds.Tables("table1") Tag: connection string Tag: 87108
  - 16
    - Dynamic SQL and Datatable I have a question about populating a datatable from a stored proc. I have a dynamic Sql statement that I'm building that I execute using the exec command to populate a temporary table. I then do a select from that table. Here is a simple example of what I'm talking about SET @SQL ='SELECT * INTO dbo.TempTable FROM Table; EXEC (@SQL) SELECT * FROM dbo.TempTable GO In QA everything seems to work fine but my datatable never has any rows in it (no exception is thrown). I'm thinking it must be because it stops after the EXEC command. I've noticed a similar phenomenon when using PRINT for debugging purposes and forgetting to comment it out. Is this behaviour by design? Any advice is appreciated, Jason Tag: connection string Tag: 87107
  - 17
    - ODBC access with ASP .NET I have an application where I'm using ODBC connection to query a database via C#. I'm sure my connection string and dsn information are correct because the application works fine when 1) I run it from Visual Studio 2) I create a C# console application and give the .exe full trust using the .NET configuration wizard. If I create an ASP .NET web application using C# and the exact same connection code I get the following error: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 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: Microsoft.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 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: [OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified] Microsoft.Data.Odbc.OdbcConnection.Open() +646 Overdue_Items.WebForm1.btnRunOverdueItemsReport_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\overdue_items\webform1.aspx.cs:101 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 I'm assuming that it's a security issue since the console application works fine but I can't figure out where I have to make the appropriate security changes for the ASP .NET page to run. I'm running on Windows Server 2003 with IIS 6.0. Any advice? Thanks, Michael Tag: connection string Tag: 87095
  - 18
    - Connection recovery problem with OracleConnection Hi, I'm using ADO.Net in C# with Oracle9i Release 9.2.0.4.0 when loosing the connection with the Oracle database server the connections doesn't recover and always returning the following exception even when the connection has been restore: "ORA-03114: not connected to ORACLE". I'm closing the connection properly in that it will return to the connection pool. Here is an example code: using(OracleConnection conn = new OracleConnection(connectionString)) { conn.Open(); using(OracleCommand cmd = new OracleCommand(sql, conn)) { object obj = cmd.ExecuteScalar(); } } This should close the connection properly. In the MSDN it is mention that if the connection pooler detect that the connection with the server has been severed it will remove the connection from the connection pool. It appears that this is not happening an I always get bad connections from the pool, even after the connection with the database server has been restore. How can I solve this? What is the proper way to recover from connection lost with database server? Thanks, Michael. Tag: connection string Tag: 87070
  - 19
    - Think this is simple but im lost:( Hey Group, Im Sure this is simple but I carn`t seem to find any info anywhere:( I have 2 x Forms: Form 1 has a DataConnecter and several DataAdapters on it, all bound together in my DataSet. On My Table(Faxs) I have a relationship to another Table(MeterReadings), on my Form I have a button called "Meter Reading". How do I get it so that when I select a row from my Database in my datagrid on my Form1, and click Meter Reading, it loads up Form2 with a Datagrid that only shows me the meter Readings for the Fax Row I selected on Form 1? If you get what I mean Any Links Are help would be greatly appriciated. Many Thanks MCN Tag: connection string Tag: 87066
  - 20
    - Datatable.Compute and Sorting Can I use this to sort a datatable or can you suggest another way to sort it without using a dataview? I have a situation where I need to do this without a dataview due to other facets it will affect within my application. When I try opends1.Tables(0).Compute("ORDER by " & sortterm & "","") it says I am missing the operand after "by". Tag: connection string Tag: 87061
  - 21
    - XML order I have an XSD schema. I also get an XML file that was prodiced using that schema. Now, the order of tags in the XML doc does not match the order in the XSD. Whaen i do bulk insert usinf SQLXML3.0 does that order matter? Tag: connection string Tag: 87060
  - 22
    - DataTable RowChanging problem with Row.Count I have DataTable which I fill with DataAdapter. Problem is that if I fill the DataTable with data in DB and after that I insert new row it doesn't count Rows correctly. private void InvoiceDetail_RowChanging(object sender, DataRowChangeEventArgs e) { if (e.Action == DataRowAction.Add) { DataTable dt = (DataTable)sender; int count = dt.Rows.Count; dt.Columns["PacketNro"].DefaultValue = count; } } If there is already 3 rows in DataTable in the new row "PacketNro" should be 4 but it's 0 and rows after that it counts correctly. The problem only occurs in the first row only. Thanks, Oka Morikawa Tag: connection string Tag: 87045
  - 23
    - Fetching from foxpro tables and updating sql tables Hi I am using vb.net Is it possible to fetch data from foxpro tables (vfp8) and update tables in sql server 2000? The table structures of the foxpro tables are different from those in sql server. Depending on the data fetched, I would like to update relavant table columns in sql server. How can this be done Regards Sara Tag: connection string Tag: 87043
  - 24
    - (newbie) Get the return value from a stored proc (return @aValue) Hi, i'm a newbie to ADO.NET and would like to know how to get the return value of a stored procedure called using ExecuteNonQuery ? Thks Tag: connection string Tag: 87041
  - 25
    - Creating IDbDataAdapter from IDbConnection/IDbCommand Hello, I know that I can use IDbConnection.CreateCommand () to write common code for .NET data providers but what about IDbDataAdapter, is there any method that let's me create IDbDataAdpater from IDbCommand or IDbConnection, I mean all I have is IDbConnection as in parameter and have no idea what kind of ? Or maybe I have to use If (connection is OleDbConection)... ??? Thank You Best regards Rafal Grzybowski Tag: connection string Tag: 87039

I apologize for such an elementary question. My connection string requires a data source. Is that the server name? The DB name is the Initial catalogue, so that isn't the data source. Thanks for the help
SMK

Top

Re: connection string by CT

CT
Wed May 12 06:52:45 CDT 2004

It's the server name if you're using a back-end database such as SQL Server,
but with an Access database it's actually the path and name of the mdb file.
Check out http://www.connectionstrings.com

--
Carsten Thomsen
Enterprise Development with VS .NET, UML, and MSF
http://www.apress.com/book/bookDisplay.html?bID=105
"smk2" <anonymous@discussions.microsoft.com> wrote in message
news:738ECCF4-F401-48DF-9EF2-66D50DA39908@microsoft.com...
> I apologize for such an elementary question. My connection string requires
a data source. Is that the server name? The DB name is the Initial
catalogue, so that isn't the data source. Thanks for the help.
> SMK

Top

Re: connection string by anonymous

anonymous
Wed May 12 07:06:10 CDT 2004

Thanks. Backend is SQL server. Web site was helpful, too
SMK

Top