Accessing Remote MSAccess Database with ADO.Net

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
    - ComboBox Values! I would like my ComboBox to display the 'CustomerName' value but it should store the 'CustomerID' value whenever it is assigned to the DataTable.LoadDataRow. Also, I need to trap the 'CustomerID'value in the ComboBox_SelectedIndexChanged Event whenever that event is fired. Thanks! Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74984
  - 2
    - Controls Binding Inquiry? Hi, If controls (textboxs,combos,etc...) are dataset-bound and dataset is used interchangeably (rowfilter on and off), do I have to clear bindings when user get different no. of records, or binding context will adjust itself to this?? That is, do I have to call this sub each time row filter is changed (on and off) Sub clearbinding() Dim ctl As Control Dim txt As Control ds.Tables("employees").clear For Each ctl In frmemp.Controls If TypeOf ctl Is GroupBox Then For Each txt In ctl.Controls If TypeOf txt Is TextBox Then txt.Text = "" txt.DataBindings.Clear() End If Next End If Next ds_changexposition() End Sub MTIA, Grawsha Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74974
  - 3
    - intermittent Oracle numeric errors Hello, We had run into intermittent "ORA-01858: a non-numeric character was found where a numeric was expected" and "ORA- 06502 PL/SQL: numeric or value error string" error on few of our store prodcedures. We are using .Net Framework 1.1 with MS Oracle Provider and Oracle 9i (9.2.0.1.0). The same data and same store procedure always works on developer's desktop. Hand executing those store procedures with the same data works fine. So we know it's not the data problem or incorrect store procedure problem. But the exact same thing would work fine on an integration server, and then suddenly throws the oracle exception intermittently. And it might work a couple of hours latter or after the SP was recompiled. Dumping the OracleParameters in the OracleParameter array before calling the SP reveals nothing wrong with the input parameters. The Oracle exception does not indicate which parameter is the offender. Since it's itermittent and we have a large parameter list, one-by-one elimination would be difficult. We do not specify the OracleType for our OracleParameters because OracleProvider documentation says: 1. "The DbType, OracleType, and Size properties of a parameter can be inferred by setting Value. Therefore, you are not required to specify them." 2. "Setting the Precision or Scale properties has no effect." So my questions are: 1. How can we pinpoint the offending parameter? DB tracing? 2. Is the omission to sepcify OracleType a problem? 3. If this is a bug in the OracleClient, any fix? 4. Will Oracle ODP solve this problem? Thanks, GT Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74973
  - 4
    - Is this Valid? I have written the following method.. public IDataReader CreateDataReader(IDbCommand cmd) { if (ProviderType == 0) { OleCommand oCmd = (OleCommand) cmd; OleDbDataReader dr = oCmd.ExecuteReader; return (IDataReader) dr; } } Would it be valid to write it like this? public IDataReader CreateDataReader(IDbCommand cmd) { if (ProviderType == 0) { IDbDataReader dr = cmd.ExecuteReader; return dr; } } The IDbCommand being passed is ultimated either a OleDBCommand or a SqlCommand - so is it valid to use the IDbCommand prior to changing it to the appropriate class? If that is valid, Since the type of object which is returned by the cmd.ExecuteReader is either an OleDbDataReader or a SqlDataReader, must I first get that and then "reclass" it to the IDataReader. Thanks IN Advance for your assistance!!!!!!!!!! Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74968
  - 5
    - How do I do this...? Hi, I have a database that needs a whole bunch of records added. The data comes from an XML file. I have grabbed the nodes in question, looped through them and I now want to populate SQL. Obviously I can pass each nodes data to a stored proc which will add to the table but this means lots of network traffic and I am sure it is not as efficient as dumping the data into SQL in one go. So, my question is, how do I create a client side recordset, populate the data into it, and then update the server, using ADO.Net via VB.Net. This would be more efficient, right? This is probably pretty basic but if someone could show me a sample that dumps several records into a table (just make one up - I'll be able to follow) it would really help clarify a few things. Thanks to all in advance... Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74959
  - 6
    - Anyone tried async ADO.NET in Whidbey ? Hi, I've read in a number of articles on MSDN and elsewhere that the Whidbey version of .NET+framework will support true async calls for ADO.NET. Has anyone tried this in Whidbey? I'm looking for something like a DataAdapter.BeginFill()/EndFill() but can't seem to find anything in the documentation. Have any articles been written on this topic? I can't seem to find any. [I know this product is pre-beta, but hey, it never hurts to plan ahead for this stuff!] Sincerely, Xavier Mendez Lecture Snoddddgrass Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74952
  - 7
    - DataReader Troubles I think I must be going crazy?! I am using a DataReader (OleDb in this case) to select some records from a table. When I let the code execute it runs fine (via an ASP.Net page). When I step through it using the debugger - the DataReader acts very strange... My table has 5 records and while debugging it will iterate 2 out of the 5 records before the call to Read() returns false. This has been driving me nuts for a few hours now - hoping I am just really beat and doing something obvious. Any insights, etc would be greatly appreciated. Below is a simplified block of code that reproduces the issue on my machine. OleDbConnection oConn = new OleDbConnection( System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"] ) ; oConn.Open(); OleDbCommand oCmd = new OleDbCommand("SELECT * FROM tblClients Order By ClientID", oConn); OleDbDataReader oReader = oCmd.ExecuteReader(); string a = ""; //--this block executes correctly unless I decide to step through it //--the results read "1,2,3,45," when I just let it go //--when I step through it I get "2,5," while( oReader.Read() ) { a = oReader.GetValue(0).ToString(); Response.Write( a + "," ); } oReader.Close(); oConn.Close(); Thanks, G. Herrell Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74945
  - 8
    - DataSet Xml persistency does not support the value '0x20' as Char value In all my previous experience a space, ' ', was considered to be a character, but I'm having trouble filling a dataset if a 'char' column contains a space. Example cmd.CommandText = "create table spacetab(c1 char)"; cmd.ExecuteNonQuery(); cmd.CommandText = "insert into spacetab values (' ')"; cmd.ExecuteNonQuery(); [vendor]DataAdapter da = new [vendor]DataAdapter("select * from spacetab", conn); DataSet dataSet = new DataSet( "dataset" ); da.Fill( dataSet ); The error (with snippet of stack trace) that is returned is System.ArgumentException: The DataSet Xml persistency does not support the value '0x20' as Char value, please use Byte storage instead. at System.Data.Common.CharStorage.Set(Int32 record, Object value) at System.Data.DataColumn.set_Item(Int32 record, Object value)Couldn't store < > in c1 Column. Expected type is Char. In other tests, this vendor's datareader is returning the column as a Char; GetValue() returns a char and GetChar() works as well. This seems to make sense since it is a char column and a .Net Framework definition of char is any 2-byte value between 0 and 65535. So, why would the Fill reject a Char with the value ' ' == 0x20? Any information much appreciated. -Chris Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74944
  - 9
    - dynamic grammar question I need to modify a grammar according to some per-user settings. The grammar is fairly complicated so I don't want to construct it entirely in code. So I constructed it in the grammar editor and placed a tag where I want to insert my <one-of> branch. At runtime, I then use StreamReader to load the grxml file, and do a replace on <item>replaceme</item> with my dynamically constructed <one-of> branch. this doesn't seem to be working. I keep getting a -1 error (generic error). Any idea on how to better handle this? Thanks Reggie Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74943
  - 10
    - Set active row thru code I have a dataset bound to a grid and some other controls. Databinding is responsible for all updates. I add a row using code and want that to be the active row displayed in the controls. How do I set the active row for databinding? Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74941
  - 11
    - SuspendBinding/ResumeBinding Hello, I have a form where the controls are linked to a Access database via Dataset Adapter and DataSet. I can navigate in the dataset. Now I'd like to use the same form to insert data. For that, my idea is : - SuspendBinding - Clear TextBox - User fill in the Textbox - Insert in DataRow and after in Database - ResumeBinding But I have a problem, when I do this (see below) I receive this error message (exception raised): System.Windows.Forms DataBinding could not find a row in the list that is suitable for all bindings. An idea ? Thanks, Christian, The code, in the event button (ADD) click : try { BindingManagerBase binMng=BindingContext [dsMyMovie, "MOVIE"]; binMng.SuspendBinding(); } catch(Exception ex) { MessageBox.Show(ex.Source); MessageBox.Show(ex.Message); } Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74933
  - 12
    - Problem with GUID's Hello all, I have an application that reads guids from sql server and stores them as the value in a drop down list. Once they are stored as strings I can't figure out how to get it back to a guid type for the sql server's sproc. I keep getting an invalid cast from string.....type string cannot be converted to guid. The problem is that I need the string converted back to guid so that I can qry the db using the guid. Any ideas would be greatly appreciated. Thanks in advance Pat Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74931
  - 13
    - Clearing SQL-Server connection pool We use an automated testing tool and I restore the database before each testcase that modifies the database. Therefore I need to kill all open connections to the SQL- Server database (using the T-SQL KILL statement). Unfortunately, the SQL connection pool isn't notified that the connection is cancelled. So when a new connection is opened (that is retrieved from the pool) a 'General Network Error' occurs. I have solved this to disable connection pooling while testing (setting "pooling='false'" in the connection string). I would rather flush the connection pool, but I cannot find a way to do this from a .NET environment. Does anyone know how to manage the connection pool from within a .NET application? Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74919
  - 14
    - Get a String for a month in a drop down I want to do a Stored Procedure or query from an SQL database that fills a drop down list. The text member will be the month, and the value member will be the number of the month. I can get the number out of SQL, but how about the month? Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74918
  - 15
    - DataTable Column DataType If I am going to be retrieving a "UniqueIdentifier", what should the "typeof()" value be in the constructor for the Datacolumn dtSkaters.Columns.Add("EventID",typeof(int)); Thanks in advance for your assistance... Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74917
  - 16
    - Creating DataTables through the IDE in an inherited DataSet In the IDE, if you create a DataSet, you can drag tables from the Server Explorer and it will automatically create a DataTable for you inside the DataSet. Is there a way for it to automatically create a DataTable for you from a "SELECT" statement that you give it. For example, I have a SELECT statement that has a bunch of JOINs in it. I would like to have a DataTable that perfectly matches the columns that are returned from the query. Thanks in advance. Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74916
  - 17
    - Binding a ComboBox in a Windows Form to a Hierarchical DataSet I have two tables in a parent-child relationship. Details on the tables are as shown below: Table1 ------- Item_ID (primary key) Item_Owner (foreign key to Table2) Table2 ------- Owner_ID (primary key) Owner_Name I wish to display, on a form designed for maintenance of the data in Table1, a combobox which displays owner names (Table2.Owner_Name), but returns as its bound ValueMember the item owner's ID (Table1.Item_Owner). Can I do it? Thanks! -- Greg Dunn Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74913
  - 18
    - Efficient find in dataset Can I set up a primary key on a dataset after it has been populated - like after the query has been run? I'm trying to do a look up on a dataset, but I believe that using the find method is more efficient than looping thru the dataset. Is this correct? Generally speaking? -- Regards, Alvin Bruney Got DotNet? Get it here http://home.networkip.net/dotnet/tidbits/default.htm Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74912
  - 19
    - Using SetDataBinding question Hi If a Table row is being changed in the code after the call has been made for grid.SetDataBinding, do I need to call this grid SetDataBinding method again after I call the Table.AcceptChanges (), or will it automaticaly update the grid info? The DataRow is being changed in the code and the grid is read only. Thanks, Ronen Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74910
  - 20
    - Win98 memory bottleneck for using XML in MSDE2000 Used to read newsgroup for answers, now have to ask for them as well. I have an application (C#, .NET 1.1) that connects to local db on MSDE 2000 SP3a (using ADO from MDAC 2.71) on one side and to a web service on the other (not relevant I guess). Some stored procedures consume xml produced by DataSet objects (values as elements) using OPENXML statements. The application should be distributed among users having also Win98. Established that I require min 128 MB of physical memory to run it. However on Win98 I need to set 'min server memory' value to 128 otherwise even small OPENXML statement, which is first in the application lifecycle (so I could not have missing sp_xml_removedocs statments before) ends up with an error 'server memory low, use sp_xml_removedocument ...'. It turns out that users having even 256MB get that error as well, when larger XML is consumed by MSDE. That I could understand, but I managed to configure application to run on Win98 with 128MB!!! Only after some time users started to receive that errors, and even restarts and running the application without any other applications running at the same time, didn't help. What could have changed in memory management assuming no other apps were installed? Tried setting up 'min memory per query' to even 32MB; tried to set up 'min/max server memory' to 128 (and more); tried to set up 'min/max server memory' and 'set working set size' to 1 (it should reserve memory for SQLserver process). I used 'reconfigure' statments and performed restarts after having set above values as well. Is there any other way I could force Win98 to give memory to MSDE or to parsuade xml parser to be more memory efficient? What I also know: - MSDE instllation does not have msxml2.dll, so I included it in my installation package (downloaded msxml2.msi from Microsoft with dll file ver 8.30.9523.0, looks pretty new to me) - XML parser in MSDE 2000 (any SQL 2000) uses 1/8 of memory available for SQLserver, and that value cannot be changed (or can it?) - MSDE 2000 cannot use XML other than MSXML2, and nothing can change it, so I guess no help comes from MSXML upgrade - XML parser uses A LOT of memory, and can consume several times more memory that XML size - memory management in Win98 sucks, but I cannot leave Win98 out of my application distribution list If you got that far in my post, thanx for that. Rgds, Andrzej Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74907
  - 21
    - Sorting DataTable without DataView I'm using DataTable in console application and I have to sort the rows. Is it possible to sort DataTable without using DataView.Sort property? I'm accessing DataRow by DataTable->Rows->Item[int] Is it possible to avoid additional layer that DataView enforces? I don't have any logical or GUI controls that I bind data to. Thanks in advance for any solution. Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74903
  - 22
    - Dumb question about strongly typed datasets Okay, I am sure this is right in front of my nose, but I cannot figure out how to do this... I have a strongly typed dataset (STDS) generated by xsd in CSharp. I have the code in place to populate the various tables (7 of them) with datarows. How do I now update this back to the database? Do I need 7 SqlDataAdapters, each one with the appropriate Command members? If so, where can I get the 7 SELECT statements? They are not stored in the STDS anywhere. If I have to remember the queries used to generate the STDS, then where is the benefit? I should be able to tell the STDS to 'save yourself' back to the table(s) you were designed from'. Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74902
  - 23
    - Moving in DataSet...Manually (code)?? Greetings, After an ugly expiernce with form data-binding, I will be very thankfull if someone please can show me how to move in dataset manually, through code?? MTIA, Grawsha Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74901
  - 24
    - Generate Tables and Sproc with vb.net Hi, I need to generate my sql tables and stored procedures. I have made a .sql file where I have all my tables and stored procedures with Sql Server Enterprise Manager So the question is how to generate all of them from a vb.net ? The best would be to read the file from the disk and create the different tables and sproc. Thanks for your help Stan Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74900
  - 25
    - Database Access Base Class I thinking that I want to write a class which handles all database access hiding from the calling program what type of database which is being accessed and all of the database specific things. I would include methods to bind the dataset/datareader to the control, returning a datatable and the dataset if necessary. All updates would be done through methods, etc. One of the problems that I can see which is somewhat of a challenge to deal with are stored procedure parameters. There is some commonality of the datatypes across the various databases (OleDB, SQL, Oracle), but there is not uniformity. I was thinking that I would use the generic DbType and have the calling program pass this data type and then translate it to the appropriate type of the database which is actually being accessed, but this would not handle all situations. Any idea how I can overcome this? Is there a better design approach? Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74899
- Next
  - 1
    - XML and SqlServer Hello, I trying to use the For XML for the first time and am trying to figure out the "Explicit" option. Going over the example in the documentation, they show a sample which looks like the following: SELECT 1 as Tag, NULL as Parent, Customers.CustomerID as [Customer!1!CustomerID], NULL as [Order!2!OrderID] FROM Customers I am hoping someone can confirm my interpertation here. The first line, the "1" is used merely for sorting purposes to sort the "structure" in front of the data. The second line is specifying that for the first field retrieved, it has no parent. The 3rd line is telling that it should map the "CustomerID" field as an attribute of the Customer Element. The forth line is saying to map an attribute of OrderID to a Element of Order. Is that about right? Questions.. Why does the 4th line specify "Null" while the 3rd specifies "Customers.CustomerID". I guess I really do not understand how to properly use this column. In the output, below - where did "cid=C1" come from? I am guessing this is CustomerID field? How did it get associated with "cid". Does the "pid='P1'" is this related to the Tag Number? Why is it needed? This is the output they are creating in this example... <Customer cid="C1" name="Janine"> <Order id="O1" date="1/20/1996"> <OrderDetail id="OD1" pid="P1"/> <OrderDetail id="OD2" pid="P2"/> </Order> <Order id="O2" date="3/29/1997"> ... </Customer> Thanks in advance for your assistance!!!!!!! Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74894
  - 2
    - Switching from ADO to ADO.NET example needed I've been developing in VB6 & DAO for quite some time. I have figured out how to use ADO (see the following code sample) but want to drop ADO and move to ADO.NET. Can someone please point me to an article or book or re-do the code below so I can move on. I have the MSDN article "ADO.NET and You" which got me started, I have a good connection string but just can't figure out how to get a single record, grab it's value, and update it if necessary. Thanks! Rick Lederman, rick@soaringsoftware.com, www.soaringsoftware.com Dim cnFAMax As New ADODB.Connection cnFAMax.Provider = "Microsoft.Jet.OLEDB.4.0;" cnFAMax.CursorLocation = ADODB.CursorLocationEnum.adUseServer cnFAMax.Open("Data Source=" & sCDatabaseName & "; Jet OLEDB:Database Password=" & sMasterDatabasePassword & ";") sSql.Remove(0, sSql.Length) sSql.Append("SELECT PARAMETERS_.* FROM PARAMETERS_;") Try rsSearch.Open(sSql.ToString, cnFAMax, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic) Catch ex As Exception MsgBox("The Recordset failed to open") End Try 'MyOptions.PercentRemainingRed() rsSearch.Find(("NAME_ = 'MyOptions.PercentRemainingRed'")) If rsSearch.EOF = True Then MyOptions.PercentRemainingRed = 30 rsSearch.AddNew() rsSearch.Fields("NAME_").Value = "MyOptions.PercentRemainingRed" rsSearch.Fields("VALUE_DOUBLE").Value = 30 rsSearch.Update() Else MyOptions.PercentRemainingRed = rsSearch.Fields("VALUE_DOUBLE").Value End If rsSearch.MoveFirst() ' Then I do another .Find to find the next appropriate record & test it's value the same. Thanks again! Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74893
  - 3
    - [ANN] PgSqlClient 1.0 Beta 5 released. Hello: Beta 5 version of PgSqlClient an ADO.NET Data Provider for PostgreSQL 7.4+ released. Beta 5 ( 18-12-2003 ) ---- - - -- -- ---- - * Bug fixes. * Minor improvements in PostgreSQL 3.0 protocol implementation. PgSqlClient 1.0 Beta 5 source code is available at: http://prdownloads.sourceforge.net/pgsqlclient/PgSqlClient-1.0-Beta5-Src.zip?download PgSqlClient 1.0 Beta 5 binaries for .NET 1.0 available at: http://prdownloads.sourceforge.net/pgsqlclient/PgSqlClient-1.0-Beta5-NET1.0.exe?download PgSqlClient 1.0 Beta 5 binaries for .NET 1.1 available at: http://prdownloads.sourceforge.net/pgsqlclient/PgSqlClient-1.0-Beta5-NET1.1.exe?download -- Best regards Carlos Guzmán álvarez Vigo-Spain Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74890
  - 4
    - ADO.NET Parameterized Queries - Better Performance ? Hi, I dont have stored procedures since my app needs to be Database independent in the sense that I should be able to use SQL Server or Oracle. I have wrapped the entire data access functionality with a custom data layer through which all database calls would be made. Right now, the sqls are being built by string concatenation. Will changing this to parameterized queries using OldDbParameter objects increase performance ?? Regards, Vikram Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74889
  - 5
    - Constraint-Problem Hello NG, I've a dataset which gets it's data from a sql= "select usr,grop from tab1 where ..." where usr is primary key field in this ORA-Table. But creating the primary-Key-Constraint will cause an error because "values are not unique" (correct translation?? in german "nicht eindeutig") With cmd .CommandText = SQL .Connection = cnORA End With da.SelectCommand = cmd da.Fill(ds, "PRF_tab1") With ds.Tables("PRF_tab1") ERROR-> .Constraints.Add("USR_KEY", .Columns("USR"), True) End With I've tried the select in ORA-Worksheet, I cannot find any double values. Where is the problem?? thanks! Peter Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74885
  - 6
    - A connection pooling error has occurred I just upgraded a webservice to VS 2003 / Framework 1.1. Since the upgrade, when I run the test harness against it, I get the error messag "A connection pooling error has occurred". It occurs when calling the .Close() in a wrapper class. It appears to be closing the connection, when I break on the line the error is about to occur on, the connection state is "Open". When the error occurs, I check the connection state again and it's closed. Code follows: #region Constructors public SQLTextComponent() { InitializeComponent(); Core.EdenConnectionInitializer.InitializeConnection(this._edenConnection); this._edenConnection.Open(); } #endregion #region Destructors ~SQLTextComponent() { if (this._edenConnection.State == ConnectionState.Open ) { this._edenConnection.Close(); // <-- Error occurs on this statement } } #endregion Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74884
  - 7
    - Newbie question about DataGrid Hello! If I add new row into databinded DataGrid by selecting for example certain product code from columns drop down list, is it possible to automatically show for example description in the next cell to the right for this selected product cell, but when saving content of the grid just save product codes column data using DataAdapter.Update-method? I mean it's like INNER JOIN query to the 'products' -tables 'description'-field in DB. Hopefully you understand my question, I'm finnish. -- Mika Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74879
  - 8
    - Possible bug in System.Web.UI.Utils.QuoteXmlValue ? I might have found a possible bug in the static, internal method QuoteXmlValue of the class System.Web.UI.Utils: to find out if one of the characters & < > or " (isn't ' missing?) is in the unquoted-string: unquoted.IndexOf ("&<>\"") is used. Isn't this wrong? Shouldn't it be unquoted.IndexOfAny("&<>\"'".ToCharArray()) ? Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74878
  - 9
    - Execute Command Question Hello, I have a sub, ExecuteCommand(), that I pass Insert, Update, and Delete commands to, Inside this sub I create a Command and DataAdapter object that executes the incoming command. The question I have is should I create these objects as Local DIM's everytime the SUB is called or should I create them as Private instance variables of the class and reuse them? Thanks, Rob Panosh Advanced Software Designs. Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74877
  - 10
    - ANN- www.knowdotnet.com finally released We finally released www.knowdotnet.com , a general .NET web site focusing on Regular Expressions, ADO.NET, C#, VB.NET, Visual Studio .NET Add-ins and everything else .NET. Currently we have about 80 new articles posted with many more to come... enjoy. -- W.G. Ryan bill@leavethisout.devbuzz.com dotnetguru.LeaveThisOut@comcast.ThisToo.net Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74876
  - 11
    - Additional functions in DataColumn.Expression Any one know of a way to make additional functions available in a DataColumn.Expression? I'm thinking of things like date manipulation (DateDiff, etc.). Is it possible to inherit from DataColumn? Would I have to handle Changed events in the columns on which the Expression was dependant, and then do the calculation myself. Are there any third party DataSet controls that would do this kind of thing? Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74871
  - 12
    - Dataset for specific table structure for CheckBoxList This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C3C561.D82B93E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello! I wonder what is the best way to create a dataset for the table = structure below and use it with a CheckBoxList. Table structure Contacts Events ContactEvents ContID EventID _ContID ContName EventName _EventID =20 Example of data Contacts Events ContactEvents 230, Elvis Presley 13, Golf 230, 29 234, Bill Clinton 14, Soccer 234, 29 237, Stuart Graham 17, Hockey 234, 28 21, Basket 234, 17 28, Fotball 237, 13 29, Music 237, 14 In example above you can see, that Elvis likes Music. Bill likes Music, = Fotball and Hockey. Stuart likes Golf and Soccer. I have a CheckBoxList with all the Events where the user should be able = to check or uncheck the different events. If I want to add Music event = to Stuart my save function deletes all rows in ContactEvents with = _ContID=3D237, return the CheckedItems, and inserts three new rows with = _ContID=3D237. This doesn't seem to be the best solution. I don't get = how to do this, and how to write the select query for the dataadapter to = get all Events (so a commandbuilder can be used). I think I should be = able to use less code and letting the components do the work?!?! The = CheckBoxList has the Datasource property (and Displaymember/Valuemeber), = but I can't find the benifits of using it. Should I use another component? Regards Magnus ------=_NextPart_000_0008_01C3C561.D82B93E0 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.2713.1100" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>Hello!</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I wonder what is the best way to create = a dataset=20 for the table structure below and use it with a = CheckBoxList.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2><U>Table structure</U></FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2><FONT=20 face=3D"Courier = New">Contacts          =      =20  <FONT=20 size=3D2>Events         &nbs= p;=20 ContactEvents</FONT></FONT></FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2>  =20 ContID           &= nbsp;   =20   =  EventID         =20 _ContID</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2>  =20 ContName          &nbsp= ;  =20    EventName       =20 _EventID</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2>  </FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2><U>Example of = data</U></FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Courier New" size=3D2> <DIV><FONT size=3D2><FONT=20 face=3D"Courier = New">Contacts          =     =20   <FONT=20 size=3D2>Events         &nbs= p;=20 ContactEvents</FONT></FONT></FONT></DIV></FONT><FONT face=3D"Courier = New"=20 size=3D2>   230, Elvis = Presley       13,=20 Golf         230, = 29</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2>   234, Bill=20 Clinton        14,=20 Soccer       234, 29</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2>   237, Stuart=20 Graham       17,=20 Hockey       234, 28</FONT></DIV> <DIV><FONT face=3D"Courier New"=20 size=3D2>          &nbs= p;           &nbsp= ;     21,=20 Basket       234, 17</FONT></DIV> <DIV><FONT face=3D"Courier New"=20 size=3D2>          &nbs= p;           &nbsp= ;    =20 28, Fotball      237, 13</FONT></DIV> <DIV><FONT face=3D"Courier New"=20 size=3D2>          &nbs= p;           &nbsp= ;    =20 29, Music        237, 14</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2><FONT = face=3DArial></FONT></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>In example above you can see, that = Elvis likes=20 Music. Bill likes Music, Fotball and Hockey. Stuart likes Golf and=20 Soccer.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I have a CheckBoxList with all the = Events where the=20 user should be able to check or uncheck the different events. If I want = to add=20 Music event to Stuart my save function deletes all rows in = ContactEvents=20 with _ContID=3D237, return the CheckedItems, and inserts three new = rows with=20 _ContID=3D237. This doesn't seem to be the best solution. I don't get = how to do=20 this, and how to write the select query for the dataadapter to get = all=20 Events (so a commandbuilder can be used). I think I should be = able to=20 use less code and letting the components do the work?!?! The = CheckBoxList has=20 the Datasource property (and Displaymember/Valuemeber), but I can't = find=20 the benifits of using it.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Should I use another = component?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Regards = Magnus</FONT></DIV></BODY></HTML> ------=_NextPart_000_0008_01C3C561.D82B93E0-- Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74869
  - 13
    - ANN: Report Sharp-Shooter 1.6 has just been released! 9Rays.Net is pleased to announce: Report Sharp-Shooter 1.6 has just been released! New features include: -New report designer - Unlimited undo/redo - Document tree - Data Sources tree with drag'n'drop - Possibility of building custom designer from blocks (ToolBox, ToolBar, PropertyGrid, DocumentTree etc.) - Full design time for third party business objects (not ADO.NET) - Many improvements -New fast excel export filter (does not require installing of Microsoft Excel) -RichText control -More stable work in ASP.NET applications -New exception handling mechanism with easy bug-tracking -New examples Visit us at www.9rays.net for more info. -- Eugene Akinshin, PhD 9rays.net (Reporting and instrumentation components) Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74867
  - 14
    - TextBox databinding (using endcurrentedit) Hi, I have a .NET textbox bound to a DataColumn (String data type). What I want is that when the the user leaves the focus from the textbox, the changes are automatically updated to the the DataTable (ie containing the Datacolumn to which the textbix is bound). The method I use is to call the 'EndCurrentEdit' method for the corresponding CurrencyManager. This method works fine except under the following condition: The textbox undergoes a modification such that the length of the Text property in the TextBox does not change (ie is the same as that of the String in the DataColumn). This happens for example when a user makes a type and changes one letter (or two) instead of adding new words or deleting words. In this case, the datarowview (referenced by the 'Current' property in the corresponding CurrencyManager) is not in edit mode (ie 'IsEdit' is false). Calling 'EndCurrentEdit' will not update the DataColumn at all. Can anyone confirm this is a .NET bug? Is there a workaround for this? Does this happen in any other .Net controls? Thanks in advance. A sample code is available. John Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74864
  - 15
    - Oracle Client Namespace I am getting an error ORA-12154: TNS:could not resolve service name the following code i am using Dim oraconn As New OracleConnection("server=exxxx1;user id=xxxxxxx;password=xxxxxx;Integrated Security = true") The following code generate the error below: Dim oraconn As New OracleConnection ("server=xxxxx1.xx.xx.com;user id=xxxxxxx;password=xxxxxx;Integrated Security = true") ORA-01004: default username feature not supported; logon denied Dim oraconn As New OracleConnection("Data Source=xxxxx1.xx.xx.com;user id=xxxxxxx;password=xxxxxx;Integrated Security = true") ORA-01004: default username feature not supported; logon denied I tries using oledb and odbc also. I am unable to connect to the oracle. I read in one of the articles that since the ASP.NET is running a impersonate account in the windows it may not access OCI. But i given Admin acess to asp.net account. Am i missing something? Thanks Ravi Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74858
  - 16
    - Auto Incrementing Values I have an Invoice table in my database with 'InvoiceID' as its primary key. I would like the InvoiceID field to auto increment values in the format INV1, INV2, INV3........INV100.so on and so forth. How do I go about it? Thanks! Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74851
  - 17
    - Multiple Fill() calls crash system I'm using ODBC with MySQL, and am having difficulties updating a DataSet when using a parameterized query multiple times. The SELECT queries I'm using work fine with multiple Fill() commands if they don't have parameters, but the param. versions generate the following ODBC error when run the second time: [MySQL][ODBC 3.51 Driver][mysqld-3.23.40-nt] SQLBindParameter not used for all parameters I've tried calling Clear() on the DataSet to no avail. In stepping through the code, I've found that everything is initialized and all parameters have values, the only difference seems to be that a few internal variables of OdbcParameterCollection named CollectionIsBound and BindingIsValid start out False before the first Fill() and end up True after it. Furthermore, and ODBC trace shows that before the first Fill(), there are some calls to: SQLBindParameter. Before the second Fill(), there are no such calls. It seems like ADO is not sending the parameters to the ODBC driver after the first Fill(). Any suggestions? Thanks, Jim Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74850
  - 18
    - insert failes I'm tring to insert a new row to a table but it seems that it failes (I think) because the values of the new Row are null. here is the defenition of the table, I suspect that my problem is in the defenition. create table aa.dbo.Tasks ( ID int primary key identity(1,1), Done bit, TaskGroup varchar(30), Subject varchar(40), Initiator int, Resource int, Note varchar(200) ) Do I need to define default values? Yoramo Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74848
  - 19
    - default value in SQL Hi all, Does anyone know how to retrieve the default value set in Sql server in ASP.Net? any help or guildence will be appreciated. Calvin Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74847
  - 20
    - SQL Server Desktop Installation I recently bought a copy of Visual C#.NET Deluxe Learning addition. I was under the impression that this comes with SQL Server Desktop Engine. I installed everything I should have (I think), but when I type the commands to grant access to SQL at the DOS prompt, it tells me that SQL Server doesn't exist. The actual error message reads as follows: [DBMSLCPN]SQL Server does not exist or access denied. [DBMSLCPN]ConnectionOpen (Connect()). The problem might be that I also bought a learning addtion of Visual Basic.NET, and it told me it was installing "different" components than those already installed. However, I have two DIFFERENT installations of the .NET framework now; one that allows for C# development and one that allows for VB development. I can't imagine that ALL components were overwritten. I suppose I could re-install C# and hope for the best. Does anyone out there have any experience with this? Thanks in advance for your help. Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74844
  - 21
    - No Results Hello, I have looked at this and then looked at it somemore, but I can't see anything wrong... Here is my senario. I wrote a stored procedure to return information about the parms in a stored procedure. The idea being is that I will build all my Parameters for any stored procedure mechanically. I run this procedure in Query Analyzer and it runs fine I run the procedure in VS.Net as a stand alone proc and it runs just fine (says it returned 2 rows). I run the same procedure in a C# program, and it executes but no results ever comeback. I get a return code of 0, but no results. I put some code in and wrote all all the parm names and their values in the debug window, cut and pasted those values into Query Analyzer and ran those exact same parm names and values - and it ran fine - bringing back results. The only difference is that there were two parms in which I loaded "DBNull.Value" and I had to type "null" in query analzer. I have tried using a DataReader and a DataAdapter with each running successfully, but still no rows. How in the world could it run everywhere else other in my c# code? Here is some code... Set up my parms... cmd.Parameters.Add("@procedure_name",SqlDbType.NVarChar,390).Direction = ParameterDirection.Input; cmd.Parameters["@procedure_name"].Value= ProcName; cmd.Parameters.Add("@procedure_owner",SqlDbType.NChar,384).Direction = ParameterDirection.Input; cmd.Parameters["@procedure_owner"].Value=dbOwner; cmd.Parameters.Add("@procedure_qualifier",SqlDbType.NChar,384).Direction = ParameterDirection.Input; cmd.Parameters["@procedure_qualifier"].Value=dbName; cmd.Parameters.Add("@column_name",SqlDbType.NChar,384).Direction = ParameterDirection.Input; cmd.Parameters["@column_name"].Value=DBNull.Value ; cmd.Parameters.Add("@ODBCVer",SqlDbType.Int,2).Direction = ParameterDirection.Input; cmd.Parameters["@ODBCVer"].Value=System.DBNull.Value ; cmd.Parameters.Add("@RETURN_VALUE",SqlDbType.Int).Direction = ParameterDirection.ReturnValue ; My Command... cmd = new SqlCommand(); cmd.CommandText= dbName + "." + dbOwner + "." + ProcName; cmd.CommandType = CommandType.StoredProcedure; My Open cmd.Connection.Open(); The DataReader SqlDataReader dr = cmd.ExecuteReader(); The Read... while (dr.Read()) { Do Somthing - never get in here } Any Ideas? Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74835
  - 22
    - Connection won't disappear from SQL Server until app closes I have no problems connecting to SQL Server 2000 from VB.net and using all it's functions. However, when I close the connection, it stays active on the server until the application is closed. I have tried running commands with the drop connection parameter, closing the connection with close, dispose and setting it to nothing. Here is a sample of the code. The results of the code below is that the connection stays active. Is there a setting in VB, ADO.NET or SQL Server I can tweak to fix this? thanks in advance! Dim myConnection As New SqlConnection("data source=SRV-DC-MULTI1;database=Technical;Integrated Security=True") myConnection.Open() MessageBox.Show("ServerVersion: " & myConnection.ServerVersion & ControlChars.Cr & _ "State: " & myConnection.State.ToString()) myConnection.Close() myConnection.Dispose() myConnection = Nothing MsgBox("pause 2") Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74834
  - 23
    - Bug in SqlConnection, SqlClient connection pool or DTC? SqlConnection throws an exception when disposed if it is manually enlisted in a distributed transaction: System.InvalidCastException: Specified cast is not valid. Server stack trace: at System.Data.SqlClient.ConnectionPool.PutConnectionManualEnlisted(SqlInternalConnection con) at System.Data.SqlClient.ConnectionPool.PutDeactivatedConnection(SqlInternalConnection con) at System.Data.SqlClient.SqlConnection.Close() at System.Data.SqlClient.SqlConnection.Dispose(Boolean disposing) at System.ComponentModel.Component.Dispose() The error occurs when the transaction is cast to UCOMIConnectionPoint. I have tried to enlist in a distributed transaction created by a serviced component and a transaction created by the DTC proxy. Both yield the same error. The problem seems to be that the transactions created by my DTC doesn't support IConnectionPoint (I use Windows XP pro). I guess that the connection point is used to get a notification when the transaction ends and it is safe to return the connection to the connection pool. (OracleClient doesn't fail (the same way). It doesn't need the connection point. It returns connections directly to the connection pool when the they are disposed even if they still participate in a distributed transaction!) Is this a bug in SqlConnection, the SqlClient connection pool, the DTC or my code? Below is a short sample that generates the error. I need to enlist in the distributed transaction manually, because I want to use distributed transactions without using COM+. Any suggestions? Regards Søren Mondrup -----demo.cs---------------------------------------------- using System; using System.Reflection; using System.Data; using System.Data.SqlClient; using System.EnterpriseServices; using System.Runtime.InteropServices; [assembly: AssemblyKeyFileAttribute("demo.snk")] class App { static void Main(string[] args) { if (args.Length == 0) { Console.WriteLine("Usage: demo.exe <server_name>"); return; } try { string connStr = "Server=" + args[0] + ";Trusted_Connection=SSPI;Database=pubs;Enlist=false;"; using (ServicedFoo foo = new ServicedFoo()) { foo.DoTransaction(connStr); } } catch(System.Exception e) { Console.WriteLine(e); } } } [Transaction(TransactionOption.RequiresNew)] public class ServicedFoo : ServicedComponent { public void DoTransaction(string connStr) { ITransaction tx = (ITransaction) ContextUtil.Transaction; if( tx == null ) throw new Exception("Failed to create transaction."); using (SqlConnection conn = new SqlConnection(connStr)) { conn.Open(); conn.EnlistDistributedTransaction(tx); Console.WriteLine("Enlisted in transaction"); using (SqlCommand cmd = new SqlCommand("update sales set qty = qty + 1", conn)) { cmd.ExecuteNonQuery(); } ContextUtil.SetComplete(); Console.WriteLine("Has voted in favor of commit. Now disposing connection."); } // conn.Dispose() is called and an exception is thrown } } ----------------------------------------------------------- compile sample with sn ?k demo.snk csc demo.cs Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74829
  - 24
    - Binding forms? Hi, Do I have to release binding of form controls to dataset every time I do form search of filling?I mean, is there a shorter way than this? 'Binde textbox1 to dataset textbox1.databindings.add("text",ds,"Employees.firstname") 'unbinde for ReUse of binding prpty. Loop through all controls that were bound. textbox1.databindings.clear MTIA, Grawsha Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74828
  - 25
    - DataReader Hello, I am transitioning from VB to C# and I can't tell if my problem is to do with the format of my command or something else. I am getting an error of "Object reference not set to an instance of the object" when it hits this line of code.. int rtnValue = (int) cmd.Parameters["@RETURN_VALUE"].Value; I set my Parameter up as follows: cmd.Parameters.Add("@RETURN_VALUE",SqlDbType.Int).Direction = ParameterDirection.ReturnValue ; I used a "foreach" to loop through each of my parms, with the @RETURN_VALUE being the last one. Each time this loop generates the same error when it gets to the "@RETURN_VALUE". I do not see anything wrong with how I have set it up. Does the procedure that I am executing "HAVE TO" use the "return statement in order to properly populate the parm? Any ideas? Thanks inadvance for your assistance!!!!!!!!! Tag: Accessing Remote MSAccess Database with ADO.Net Tag: 74825

Hi,

How can I connect to an access database located over a remote server
through internet?

Is it possible if updating a remote database is done in background and
application doesn't affect by delay in accessing remote Server?

Best Regards,

Wasim

Top

Re: Accessing Remote MSAccess Database with ADO.Net by Miha

Miha
Fri Dec 19 05:26:59 CST 2003

Hi Voyager,

Since access database is a file, you will have to enable access/modifying
security of the file and probably of the folder where file resides (since
access will want to create also ldb file).
If you are using security within access I believe you will have to also need
to access security file (mdw or something).
You can use a asynchronous delegate or a thread for updating.

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"Voyager" <wsabir@yahoo.com> wrote in message
news:557088f9.0312190312.4cbfecfd@posting.google.com...
> Hi,
>
> How can I connect to an access database located over a remote server
> through internet?
>
> Is it possible if updating a remote database is done in background and
> application doesn't affect by delay in accessing remote Server?
>
> Best Regards,
>
> Wasim

Top

Re: Accessing Remote MSAccess Database with ADO.Net by Paul

Paul
Fri Dec 19 10:08:13 CST 2003

On 19 Dec 2003 03:12:24 -0800, wsabir@yahoo.com (Voyager) wrote:

¤ Hi,
¤
¤ How can I connect to an access database located over a remote server
¤ through internet?
¤
¤ Is it possible if updating a remote database is done in background and
¤ application doesn't affect by delay in accessing remote Server?
¤

You need to use the Remote (Data Services) OLEDB Provider:

http://www.able-consulting.com/MDAC/ADO/Connection/MSRemote.htm#MSRemoteAccess

If I understand your second question, you will need to start another thread for
your application if you want the operation to run in the background:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcn7/html/vaconFreeThreadingExample.asp

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Top