Error connecting to Visual FoxPro database

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
 - PLEASE READ CAREFULLY MAKE MONEY FAST AND EASY HURRY!!!! Make Money Fast A little while back, I was browsing these newsgroups, just like you are now, and came across an article similar to this that said you could make thousands of dollars within weeks with only an initial investment of $6.00! So I thought," Yeah, right, this must be a scam", but like most of us, but I was curious, so I kept reading. Anyway, it said that you send $1.00 to each of the 6 names and address stated in the article. You then place your own name and address in the bottom of the list at #6, and post the article in at least 200 newsgroups. (There are thousands) No catch, that was it. The main difference between this system and others is that you have a mailing list of 6 instead of 5... This means that your average gain will be app. 15 times higher!!! So after thinking it over, and talking to a few people first, I thought about trying it. I figured what have I got to lose except 6 stamps and $6.00, right? Like most of us I was a little skeptical and a little worried about the legal aspects of it all. So I checked it out with the U.S. Post Office (1-800-725-2161) and they confirmed that it is indeed legal! Then I invested the measly $6.00.............plus postage Well GUESS WHAT!!... Within 7 days, I started getting money in the mail! I was shocked! I still figured it would end soon, and didn't give it another thought. But the money just kept coming in. In my first week, I made about $20.00 to $30.00 dollars. By the end of the second week I had made a total of over $1,000.00!!!!!! In the third week I had over $10,000.00 and it's still growing. This is now my fourth week and I have made a total of just over $42,000.00 and it's still coming in rapidly....... It's certainly worth $6.00, and 6 stamps, I spent more than that on the lottery!! Let me tell you how this works and most importantly, why it works.... also, make sure you print a copy of this article NOW, so you can get the information off of it as you need it. The process is very simple and consists of 3 easy steps STEP 1 Get 6 separate pieces of paper and write the following on each piece of paper "PLEASE PUT ME ON YOUR MAILING LIST." Now get 6 US$1.00 bills (or equivalent in your local currency) and place ONE inside EACH of the 6 pieces of paper so the bill will not be seen through the envelope to prevent thievery. Next, place one paper in each of the 6 envelopes and seal them. You should now have 6 sealed envelopes, each with a piece of paper stating the above phrase, your name and address, and a $1.00 bill. What you are doing is creating a service by this. THIS IS ABSOLUTELY LEGAL! Mail the 6 envelopes to the following Addresses: #1) J Alex Biley 69 Manningham St. Parkville, Vic 3052; Australi #2) Suranga Sampath 237/a Bell St. Coburg, Vic 3058; Australi #3) Greg Davidson 1370 South Madison Ave. Clearwater, Fl 3375 #4) J. Schlundt 190 Brookline St. Newton Ma 0245 #5) D. Hale Jr. 407 Edgewood Ave. Pittsburgh, Pa 1521 #6) Nimai Jaekley; 3311 Landon Dr. West Unit A; Bullhead City, A 8642 STEP 2 Now take the #1 name off the list that you see above, move the other names up (6 becomes 5, 5 becomes 4, etc...) and add YOUR Name as number 6 on the list. (Use your 'delete" key to remove name #1 and move all other names up. Then change numbers and add your name as #6) STEP 3 Change anything you need to, but try to keep this article as close to original as possible. Now, post your amended article to at least 200 newsgroups. (I think there is close to 24,000 groups) All you need is 200, but remember, the more you post, the more money you make! Don't know HOW to post in the newsgroups? Well do exactly the following: THAT'S IT! All you have to do is jump to different newsgroups and post away, after you get the hang of it, it will take about 30 seconds for each newsgroup! **REMEMBER, THE MORE NEWSGROUPS YOU POST IN, THE MORE MONEY YOU WILL MAKE!! BUT YOU HAVE TO POST A MINIMUM OF 200** That's it! You will begin receiving money from around the world within days! You may eventually want to rent a P.O. Box due to the large amount of mail you receive. If you wish to stay anonymous, you can invent a name to use, as long as the postman will deliver it. **JUST MAKE SURE ALL THE ADDRESSES ARE CORRECT** Now the WHY part: Out of 200 postings, say I receive only 5 replies (a very low example). So then I made $5.00 with my name at #6 on the letter. Now, each of the 5 persons who just sent me $1.00 make the MINIMUM 200 postings, each with my name at #5 and only 5 persons respond to each of the original 5,that is another $25.00 for me, now those 25 each make 200 MINIMUM posts with my name at #4 and only 5 replies each, I will bring in an additional $125.00! Now, those 125 persons turn around and post the MINIMUM 200 with my name at #3 and only receive 5 replies each, I will make an additional $626.00! OK, now here is the fun part, each of those 625 persons post a MINIMUM 200 letters with my name at #2 and they each only receive 5 replies, that just made me $3,125.00!!! Those 3,125 persons will all deliver this message to 200 newsgroups with my name at #1 and if still 5 persons per 200 newsgroups react I will receive $15,625.00! With an original investment of only $6.00! AMAZING! And as I said 5 responses is actually VERY LOW! Average is probable 20 to 30! So lets put those figures at just 15 responses per person. Here is what you will make: at #6 $15.00 at #5 $225.00 at #4 $3,375.00 at #3 $50,625.00 at #2 $759,375.00 at #1 $11,390,625.00 When your name is no longer on the list, you just take the latest posting in the newsgroups, and send out another $6.00 to names on the list, putting your name at number 6 again. And start posting again. The thing to remember is, do you realize that thousands of people all over the world are joining the internet and reading these articles everyday, JUST LIKE YOU are now!! So can you afford $6.00 and see if it really works?? I think so... People have said, "what if the plan is played out and no one sends you the money? So what! What are the chances of that happening when there are tons of new honest users and new honest people who are joining the internet and newsgroups everyday and are willing to give it a try? Estimates are at 20,000 to 50,000 new users, everyday, with thousands of those joining the actual internet. Remember, play FAIRLY and HONESTLY and this will work. You just have to be honest. Make sure you print this article out RIGHT NOW, also. Try to keep a list of everyone that sends you money and always keep an eye on the newsgroups to make sure everyone is playing fairly. Remember, HONESTY IS THE BEST POLICY. You don't need to cheat the basic idea to make the money!! GOOD LUCK to all and please play fairly and reap the huge rewards from this, which is tons of extra CASH. TRUST ME IT DOES WORK! I am sure this will work out, try it and see. Tag: Error connecting to Visual FoxPro database Tag: 72035
 - 2
 - calling a dataAdapter Update in DataTable.DataRowChanged Event At some part of my application I want to hide the idea of a cache (dataset) from my user, so went the user deletes a row using the data bound UI, which deletes the row from the corresponding data table, I want to make a call to commit the changes to database as well, so what I did is I registered an event handle for the DataRowChanged Event and tried to call DataSet.GetChanges. The problem is DataSet.GetChanges return null. Is is because the DataSet is still in edit mode when the DataRowChange event fires? So how can I commit data at the same time as it is deleted from the dataset apart from putting a separate 'commit' button? thx in adavance Tag: Error connecting to Visual FoxPro database Tag: 72030
 - 3
 - Behind the scenes -- how is a DataTable implemented? When one gets a row from a database (ie, a DataTable), the row contains a typed value in each column. How is this typically implemented behind scenes. I want to build this functionality myself. The reason I want to do this is because I need an in-memory table without any of the overhead of a DataSet or DataTable. Thanks! Tag: Error connecting to Visual FoxPro database Tag: 72027
 - 4
 - sp results into dataset I'm having problems with creating a crystal reoport from a stored procedure in VS .Net. When trying to add a chart onto the report I get an error about 'Convert' native error: 156. There is one input parameter on the stored procedure (which is a date) could this be causing my problem? Any help would be great. Thanks in advance Tag: Error connecting to Visual FoxPro database Tag: 72026
 - 5
 - Stop deleting a Row in the Changing event within a DataGrid Hi! I wan't to prevent a user to delete some Rows showed in a DataGrid. I registered for the DataTable.RowDeleting event and tried to throw an exception when deleting occours but is forbidden(as proposed in the msdn). Problem: Nobody catches the error, so an application Exception gets shown to the user. How can I catch the exception or prevent deleting a row in an other way? Thanks in advance Benedikt Tag: Error connecting to Visual FoxPro database Tag: 72022
 - 6
 - XML fix to MSDN Survey Sample - datarelation.nested?? Dear all, Does anyone have a fix / working solution to the "bug" in the MSDN Survey Sample? Setting the nested property of the datarelation to true throws "A column named 'Answer' already belongs to this DataTable: cannot set a nested table name to the same name" in the AdjustQuestionPrimaryKey sub which is according to the documentation (1.1.1) of the framework. The issue seem to be with the XML... My question is: have anyone a workaround/fix to this issue? Thanks /BS Tag: Error connecting to Visual FoxPro database Tag: 72018
 - 7
 - thanx thanx, it is. oDataSet.Tables(0).Rows.Count Tag: Error connecting to Visual FoxPro database Tag: 71989
 - 8
 - XML to MSAccess (OleDb) It's a breeze to take an MSAccess table to XML, but how to you do the reverse? Given an XML file created from a DataSet using the WriteXML method, including the Schema, how would you then read that XML file into a dataset and then write the dataset to an Access Database table? Reading into a dataset is easy: DS.ReadXML(filename), BUT once I have the dataset, what's the best way to get it back out to a database Table? Thanks Eric Robishaw Tag: Error connecting to Visual FoxPro database Tag: 71988
 - 9
 - Windows Forms semi-connected data-access best practice I have looked around and have not found a best practice or pattern regarding the use of data in a semi-connected multi-user windows form application. What I have is this, a Windows Forms Client-Server application which ties in to Microsoft SQL Server 2000. Currently the application acquires data on clients from the database when it loads so that the end user can work on said data. When changes are made they are made to the dataset to track changes and properly manage new record creation. When the user exits, or clicks save, changes are submitted using a variety of DataAdapters to properly hierarchally update the data. I believe though that although this has worked for single-user systems, this is not the best practice for a multi-user system as data can become inconsistent as changes are made by each application. Would it be better to: * Transmit transacted changes immediately to the database once the DataSet can perform its constraint checks, rather than wait until the user clicks "Save" * Find or put together a means to constantly check for updates to actively changing and highly used tables (such as clients) and freshen the data as soon as is possible. I would rather this application be as connected as possible to the database server, and that updates be as real-time as possible. I have seen "some" examples of a semi-connected application using a web-service and performing some type of polling for connectivity however I do not wish to expose the business logic as a web service at this time. None of the examples explain how to manage a consistent state for real-time or pseudo-real-time data. -- Ron A. Buckton, MCP ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ President Chronicles Design Url: http://www.chroniclesdesign.com begin 666 Ron A. Buckton.vcf M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..D)U8VMT;VX[4F]N.T$N#0I& M3CI2;VX@02X@0G5C:W1O;@T*3U)'.D-H<F]N:6-L97,@1&5S:6=N#0I4251, M13I396YI;W(@+DYE="!3;VQU=&EO;G,@1&5V96QO<&5R+"!-0U -"D%$4CM7 M3U)+.CL[.U!I='1S8G5R9V@[4$$[,34R,S<[55-!#0I,04)%3#M73U)+.T5. M0T]$24Y'/5%53U1%1"U04DE.5$%"3$4Z4&ET='-B=7)G:"P@4$$@,34R,S<] M,$0],$%54T$-"E@M5T%"+4=%3D1%4CHR#0I54DP[2$]-13IH='1P.B\O=W=W M+F-H<F]N:6-L97,N;W)G#0I54DP[5T]22SIH='1P.B\O=W=W+F-H<F]N:6-L M97-D97-I9VXN8V]M#0I%34%)3#M04D5&.TE.5$523D54.G)B=6-K=&]N0&-H M<F]N:6-L97-D97-I9VXN8V]M#0I2158Z,C P,S$Q,3E4,C$R,#(R6@T*14Y$ (.E9#05)$#0H` ` end Tag: Error connecting to Visual FoxPro database Tag: 71987
 - 10
 - End Of File Scenario: I have a SqlDataAdapter that I used to populate a dataset. oAdapter = New SqlDataAdapter(oCmd) oDataSet = New DataSet() oAdapter.Fill(oDataSet) I then use the dataset to populate a datagrid. dgFilings.DataSource = oDataSet dgFilings.DataBind() Problem: I don't want to populate the datagrid if there were no records return from the query. So how do i check if the dataset or the DataAdapter is empty or not? In classic asp this would be done with the recordset method eof(). thanks for your help, aymer aymerb[@].yahoo.com Tag: Error connecting to Visual FoxPro database Tag: 71974
 - 11
 - System.Data.Odbc I am trying to work through some non-specific provider work and can't seem to get the System.Data.Odbc provider. According to the MSDN documentation, http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataodbc.asp, this namespace is supported in version 1.1 of the framework. I have 1.1 installed and the namespace is nowhere to be found. Any help would be greatly appreciated. Thanks, Steve Bering Tag: Error connecting to Visual FoxPro database Tag: 71973
 - 12
 - *very* basic question about design of ado.net Sorry in advance for my ignorance. Any help would sure be appreciated. I'm writing a fairly simple application with VB.Net and am obviously a bit of a newbie. This application will be used by 1, 2 or at most 3 people concurrently and I'm using Access 2003 for my data source. We are not dealing with a large amount of data (5 or 6 tables, for a total of maybe 3,000 records - one table having the majority of that). This application is using a fairly simple form, but upon leaving certain text boxes, I want to fill in some data. For instance, I might have one field that is for a competition number - when I leave it, I want to populate a description. The next field might be a competitor number and when I leave it, I want to populate a field with the competitor name. Enough of the background - I created a module to open my connection and a function within that to handle my DataReader. In that module I have: Imports System.Data Imports System.data.oledb Imports System.Data.sqlclient Module Main Public strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=f:\mydatabase.mdb" Public cn As New OleDbConnection(strConn) Function ExecuteReader(ByVal sSQLString As String) As OleDb.OleDbDataReader Dim dr As OleDbDataReader Dim cmd As OleDbCommand = New OleDbCommand(sSQLString, cn) Try If cn.State = ConnectionState.Closed Then cn.Open() dr = cmd.ExecuteReader() cmd.Dispose() Catch ex As OleDbException MsgBox(ex.Message, MsgBoxStyle.Exclamation) End Try Return dr End Function End Module And that's pretty much it so far. In my main code I have: Private Sub txtCompNum_Leave(ByVal sender As Object, ByVal e As System.EventArgs) Handles txtCompNum.LostFocus Dim dr As OleDbDataReader dr = ExecuteReader("SELECT * FROM competition where compnum = " & "'" & txtCompNum.Text & "'") While dr.Read txtDance.Text = dr.GetString(2) End While dr.Close() End Sub Private Sub txtCompetitor_Leave(ByVal sender As Object, ByVal e As System.EventArgs) Handles txtCompetitor.Leave Dim dr As OleDbDataReader dr = ExecuteReader("SELECT * FROM dancer where cardnum = " & txtCompetitor.Text) While dr.Read txtName.Text = dr.GetString(3) & ", " & dr.GetString(4) End While dr.Close() cn.Close() End Sub These seem to work well and fast. But there are a few questions: 1. Is there a "right" way to structure creating the different components necessary to populate my form and if so, is mine along the right lines so far? 2. Should I use "Leave" or "Lost_Focus" for my text boxes? I used to use "Lost_Focus" with VB6, but was wondering if there was a difference or if one was preferred. 3. If the two datareaders above only return one record, is there some other reader I should use to improve performance? Any other suggestions would sure be appreciated. I'm a bit wet-behind-the-ears so I'd love some help. Thanks! Steve Tag: Error connecting to Visual FoxPro database Tag: 71970
 - 13
 - ADO.NET Bug re: Autoincrement Columns "Value ... is already present" VS2003 v7.1.3088 .NET v 1.1.4322 SQL Server 2000 Hi, I am getting these "Value is already present" errors occasionally on my autoincrement columns. I am not doing anything special here, just using the code that is generated by the Visual Studio designer. I have tried autoincrement seeds on the table of both 1 and 100, but it doesn't make any difference. Most of the time, it works, but every once in a while, I get this problem... usually when the table is "young" but not necessarily on the first inserts. I am 99% certain that SQL Server is not the source of the fault. The fault, I believe, is with the SQL generated by Visual Studio and/or the manner in which ADO.NET handles the merging of the INSERT results into the original table. If you look at the SQL statement generated by Visual Studio, you will see that it SELECTS the results of the insert. I believe that Visual Studio is immediately attempting to merge the results into the source dataset, so if there are still rows in the dataset waiting to be inserted and the IDENTITY result of the first insert happens to coinicide with the "Fake" ADO.NET identity in one of the pending insert rows, then ADO.NET throws an exception. This would be a bug in ADO.NET, in my opinion. I do not want to have to customize the INSERT statements for all of my SQL commands. This would be a lot of work, and also essentially renders the Visual Studio designer useless. My question is: Is there a known workaround for this problem? I have seen this suggested: http://groups.google.ca/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&safe=off&selm=KQ5HdGMFDHA.2580%40cpmsftngxa06.phx.gbl ...but you would have to remember to repeat this step every time you regenerated the dataset, not good. The only other idea is temporarily turning off constraints during the insert... would it work? See code examples below... names have been changed to protect the identities of the innocent. FYI, the dataset is being generated by a client app, the data updates are done by an EnterpriseServices component (COM+). Otherwise, this is 100% plain-jane Visual Studio generated code. >>>>> Visual Studio's generated SQL statement <<<<<<< Me.SqlInsertCommand2.CommandText = "INSERT INTO X(Y_Id, Z_Id) VALUES (@Y_Id, @Z_Id); SELECT X_Id, Y_Id, Z_Id, FROM X WHERE (X_Id = @@IDENTITY)" >>>>> ERROR MESSAGE <<<<<<<< Column 'X_Id' is constrained to be unique. Value '115' is already present. >>>>> DATASET SOURCE <<<<<<<< ... <xs:element name="X_Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" /> ... >>>>> TABLE SOURCE <<<<<< CREATE TABLE [X] ( [X_Id] [int] IDENTITY (100, 1) NOT NULL , [Z_Id] [int] NOT NULL , [Y_Id] [int] NOT NULL , ... CONSTRAINT [PK_X] PRIMARY KEY NONCLUSTERED ( [X_Id] ) ON [PRIMARY] , CONSTRAINT [FK_X_Z_Y] FOREIGN KEY ( [Z_Id], [Y_Id] ) REFERENCES [X_Y] ( [Z_Id], [Y_Id] ) ON DELETE CASCADE ) ON [PRIMARY] Tag: Error connecting to Visual FoxPro database Tag: 71966
 - 14
 - HELP PLEASE "DataBinding could not find a row in the list that is suitable for all bindings" Hi all, i have this error "DataBinding could not find a row in the list that is suitable for all bindings" and this happens when i press my button to cancel using this "Me.BindingManager.CancelCurrentEdit()" i have in my datatable 4 string fields , one autonumber ( key ) and 1 date field, when i press the add button using Me.BindingManager.Addnew() and i press imediatly the Me.BindingManager.CancelCurrentEdit() it throws the error .. one note: i don´t have any row in my datatable. datatable.rows.count = 0 can anyone assist me .. ? thks JSB Tag: Error connecting to Visual FoxPro database Tag: 71965
 - 15
 - Handling of a ConstraintException Hi. I got so much help out of the dotnet Groups, so I thought I'd share a little wisdom I found out. Forgive me if the solution I present is already well known (honestly, it is stupid simple) - But I found only questions like mine asked in the header, and no answers. Brief description of the problem: You load your tables using a dataadapter into your dataset. Tables are master/child, the dataset enforces the relation. Somehow, one of the masters got deleted - and the children are stranded. When enforcing the constraint, you get the exception. You want to find out, which child rows cause the trouble. The exception does not deliver this data in one of it's properties. Brief description of my solution: The data has been loaded fine already, so you can do the following (in the catch ex as ConstraintException-block): For each dr as DataRow in ChildTable if dr.GetParent is Nothing then dr.delete Next DataAdapter.Update(ChildTable) Dataset.EnforceConstraint = True Now the rows causing the trouble are gone, and the changes are put back to the database. In my solution, deleting the rows was the best idea - you might need to do something else, but once you know the rows, you can handle them as you like! After Enforcing the constraint yourself, your Dataset is ready to go, as if nothing ever happened to it! Bye, Ralf Tag: Error connecting to Visual FoxPro database Tag: 71956
 - 16
 - Restating -- Conditional SubQuery in WHERE. Hi All, I wasn't very clear before. I am trying to see if there is a way to have conditional subqueries in the WHERE part of an SQL statement. Generally I am trying to return rows matched to the subquery when there are rows returned by the subquery. No problem using IN. What I want is,, If there are no rows in the subquery returned, I want to see all rows in the outer select. In other words I would like to turn off this portion of the WHERE statement (or trick it to have no impact in the WHERE. EX/ Alter Procedure PrefProv @UserID VarChar(50), @Flag BIT SELECT Name, Address1, HCity FROM table1 WHERE table1.ID IN (SELECT Table1ID FROM dbo.table2 WHERE UserID = @UserID) AND Flag = @Flag The subquery will return Table1ID 's that match the UserID = @UserID, Then table1 columns where ID is in the list of Table1ID 's returned by the subquery AND if Flag = @Flag. If the table2 subquery returns no records I would like the statement to act like. SELECT Name, Address1, HCity FROM table1 WHERE Flag = @Flag In other words disable the portion of the WHERE which is related to the subquery. I have tried CASE but CASE doesn't want to work with IN. CASE works fine with =,<,> or LIKE. I have also looked at EXISTS but the examples in Books Online show equivalent IN statements. I could (and may have to) use IF..ELSE and change or leave out various WHERE terms but I have many variations and would make for a very complex PROC. Also if someone could explain EXISTS to me and how it may differ from IN I would appreciate it. From Books Online: The EXISTS keyword is important because often there is no alternative, nonsubquery formulation. Although some queries formulated with EXISTS cannot be expressed any other way, all queries that use IN or a comparison operator modified by ANY or ALL can be expressed with EXISTS. Bob T Tag: Error connecting to Visual FoxPro database Tag: 71953
 - 17
 - SqlException What would cause SqlDataAdapter.Update() to throw SqlException ('System error')? -- Thanks, Brian Toothill Tag: Error connecting to Visual FoxPro database Tag: 71950
 - 18
 - TableMappingsCollectionEditor breaks with custom Data Provider I have a custom DataAdapter which derives from System.Data.Common.DbDataAdapter and therefore inherits a property of type System.Data.Common.DataTableMappingCollection. When I place an instance of my adapter on a WinForm in VS.NET 2003, configure the SelectCommand (using my custom data provider again) and try to edit the DataTableMappingCollection, the Microsoft.VSDesigner.Data.Design.DataTableMappingCollectionEditor complains that it is "Unable to retrieve the schema from the database table. Source column mapping information will not be available" and then fails with a "Specified Cast is not valid" error. So what is the DataTableMappingCollectionEditor expecting of my DataAdapter? If it is trying to get schema information, it must be doing so through the SelectCommand and it's corresponding Connection, but schema retrieval is not a documented part of IDbCommand or IDbConnection. What is it the cast that is failing here? Thanks, Steve Tag: Error connecting to Visual FoxPro database Tag: 71948
 - 19
 - COM+ removes spaces in field Hi, I have come across the error "Concurrency violation: the UpdateCommand affected 0 records." and have found out that when I use a serviced component to fetch a dataset, fields which have only spaces in them are being "trimmed" which makes the dataadapter/commandbuilder fail the update since the field in the database still has it's spaces ('' <> ' '). If I don't make the component "serviced" everything works fine. The database is Oracle 8.1.7 and the field with spaces is a Varchar2(20) field. Is there something I can do to keep the spaces in the fields or do I have to skip the CommandBuilder and create my own update command? Thanks in advance, Jeppe *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: Error connecting to Visual FoxPro database Tag: 71947
 - 20
 - DataGrid-DataView-XML-Sorting strings as numerics I am populating a DataGrid with xml. I need to be able to sort some of the columns. However, the DataView.Sort is treating my strings (which are numbers in string form from the xml) as strings and not formatting them as numbers. So, I get: 1,11,2,22 instead of: 1,2,11,22 How do I get the DataView.Sort to treat these strings as a numeric type? Thanks. Tag: Error connecting to Visual FoxPro database Tag: 71929
 - 21
 - SqlCommand.Parameters I'm setting SqlDataAdapter.UpdateCommand (.CommandText and .Parameters). Say the table to which I'm applying this command has a lot of columns - does that mean I have to add a parameter (.UpdateCommand.Parameters.Add()) for every column that I want to update (or every column that may potentially change)? On the same note, does that mean I have to add (to CommandText) something simliar to "columnN = @colN" for every column? So if my table has 50 columns, then my UpdateCommand will have 50 Parameters? Am I asking the right questions / going about this the 'done' way? -- Thanks, Brian Toothill Tag: Error connecting to Visual FoxPro database Tag: 71926
 - 22
 - New to ADO.NET - How to update a database... Here's my code... Private oConn As New OleDb.OleDbConnection() Private oCommand As New OleDb.OleDbCommand() Private oDataAdapter As New OleDb.OleDbDataAdapter() Private oDataSet As New DataSet() Public Event Err() Public Sub Init() Dim Row As DataRow oConn.ConnectionString = _ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ Application.StartupPath & _ "\WinMUX.mdb;Persist Security Info=False" oCommand.CommandText = "SELECT Name FROM Objects" oCommand.Connection = oConn oCommand.CommandTimeout = 30 oDataAdapter.SelectCommand = oCommand oDataAdapter.Fill(oDataSet, "Objects") For Each Row In oDataSet.Tables("Objects").Rows MsgBox(Row("Name")) If Row("Name") = "Brimstone" Then Row("Name") = "NotBrimstone" End If Next oDataAdapter.Update(oDataSet, "Objects") End Sub I know it isn't the prettiest code but I'm just trying to figure this Data Access stuff out in .NET. How do I update the data in the database with what has been changed in the Dataset? I'm completely lost. With ADO you used to just call the adoRecordset.Update method. What do you do now? Andrew Cooper aecooper@earthlink.net Tag: Error connecting to Visual FoxPro database Tag: 71925
 - 23
 - Typed Dataset "Region" Table Hello Whenever I create a typed dataset using Northiwnd Database and add "Region" table. I don't know why I am getting "_" ahead of "Region" when I try to access "Region" table. The Sample Code is as follows. The typed Schema <xs:schema id="dsRegion" ..> <xs:element name="dsRegion" msdata:IsDataSet="true"> <xs:complexType> <xs:choice maxOccurs="unbounded"> <xs:element name="Region"> <xs:complexType> <xs:sequence> <xs:element name="RegionID" type="xs:int" /> <xs:element name="RegionDescription" type="xs:string" /> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> <xs:unique name="dsRegionPK" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:Region" /> <xs:field xpath="mstns:RegionID" /> </xs:unique> </xs:element> </xs:schema> And the code I used to access is Dim lmyRegionDataSet As ADO.dsRegion Dim lmyTable As DataTable lmyTable = lmyRegionDataSet._Region() Now why there is "_" ahead of region table? Why can't i access it like lmyTable = lmyRegionDataSet.Region() like other tables Regards Mark Tag: Error connecting to Visual FoxPro database Tag: 71916
 - 24
 - SET SHOWPLAN_ALL Hi all, I want to retrieve the execution plan for a SQL statement, so need to prepend the SET SHOWPLAN_ALL ON command to the statement before submission, but am not sure how to do so. Any ideas? SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.Text; command.CommandText = "SET SHOWPLAN_ALL ON; SELECT * FROM some_table; SET SHOWPLAN_ALL OFF"; IDataReader reader = command.ExecuteReader(); etc...doesn't work, because SHOWPLAN_ALL must be the only command in a batch? Thanks in advance, Ben Tag: Error connecting to Visual FoxPro database Tag: 71913
 - 25
 - SqlCommand I'm defining an SqlCommand (in C#), with the following members: - .Connection = myConnection; .CommandText = "INSERT INTO myTable (columnOne) VALUES (@col1)"; .Parameters.Add("@col1", SqlDbType.Char, 10, "columnOne"); In the Parameters.Add(), is it necessary to specify all that data? Can't I just specify "@col1"? (I can't at the moment, I get an exception when I call SqlDataAdapter::Update()). Why do I need to specify the column data type, size, and name, to avoid an exception? -- Thanks, Brian Toothill Tag: Error connecting to Visual FoxPro database Tag: 71910
- Next
 - 1
 - Newbie - connection to SQLServer via network Hi group, how can I define an SQLConnection to SQLServer over network instead of setting a local file via Dim connection As New SqlConnection.... Cheers Jenny Tag: Error connecting to Visual FoxPro database Tag: 71906
 - 2
 - Strange HasChanges behaviour Hi All, I'm experiencing some strange behaviour of the DataSet.HasChanges() method, the situation is as follows:- 1) Populate a DataSet with 2 tables Master and Details. 2) Setup a DataRelation between the 2 tables. 3) Configure the relation to have cascade Deletes on the ChildKeyConstriant. 4) Delete a record from the Master table and the child records are also removed. At this point everything works as expected, checking the row count of both tables and the record have been removed. Now checking the HasChanges() method returns false? Any ideas as to what could be causing this? TIA Paul Tag: Error connecting to Visual FoxPro database Tag: 71905
 - 3
 - loadxml is it possible to convert during the loading process datatypes ds1.ReadXml(reader, XmlReadMode.Auto) my problem is a date format from rss which comes a string Fri, 09 May 2003 09:53:17 GMT and is then not usefull sortable in dataview -- Gruss Hannes www.asp-konferenz.de - das Event für den MS Webentwickler www.aspnet-professional.de - das Magazin www.devtrain.de ASP und .NET Community Site www.vbmoves.de VB bewegt sich doch www.ppedv.de Company Site Tag: Error connecting to Visual FoxPro database Tag: 71904
 - 4
 - Rowfilter TOP 10 How to set a rowfilter expression to show the first 10 datarows (in conjunction with sort) -- Gruss Hannes www.asp-konferenz.de - das Event für den MS Webentwickler www.aspnet-professional.de - das Magazin www.devtrain.de ASP und .NET Community Site www.vbmoves.de VB bewegt sich doch www.ppedv.de Company Site Tag: Error connecting to Visual FoxPro database Tag: 71903
 - 5
 - How to create a tasting clock or Pie-chart from single value Hi guys, I'm trying to create a pie chart, like a taste clock, from a single value. My problem is that when I fetch the value from the dataset I can't figure out how to display the value as colored part of the pie. Max value is always 120 and DB-value can be any value below 120. A sample of what I try to accomplish and display can be found on http://www.systembolaget.se/pris/owa/sokPipe.SokVarunr?p_varunr=22040&p_back=plAlla&p_butnr=0 -- Yours / Anders Sundberg Tag: Error connecting to Visual FoxPro database Tag: 71902
 - 6
 - ASP.NET & Popup windows hi hi hi, i am using window.showModalDialog("sample.aspx",...) to show a sample.aspx file, popup window appears which display a hyperlink say "sample1" which links to sample1.aspx file. according to the above process 1 sample.aspx popup window will appear 2 when i click sample1 link in popup window should show the content of sample1.aspx in same popup window, but it opens blank IE window and shows sample1.aspx i want to display sample1.aspx content in same popup window i used target="_self" also thanks Raja Balaji R Tag: Error connecting to Visual FoxPro database Tag: 71899
 - 7
 - Parameter 1_? has no default value Sir, I have already designed a programe inventory control using VB as= frontend and MS Access as Backend. I m facing a problems to save datareport to a file. i m able to= print the report but i m not able to save the report to a file. If i m not passing any parameters to report i m able to save the= report to any file format, but here i m passing some parameter= from VB Form to datareport. when i click the Icon to save the= data report it gives a error. "Parameter 1_? has no defaul= value" Pls help me how to solve the problem With best Regards. Nurul Hassan. Tag: Error connecting to Visual FoxPro database Tag: 71889
 - 8
 - Legacy Hi All, I have a legacy ADOCE dll that I need to get working with an application that uses ADO.NET. We use this legacy component for database access... Is there any way to work ADOCE with ADO.neet? thanks, Fred Tag: Error connecting to Visual FoxPro database Tag: 71887
 - 9
 - How do you pass null values to a command object parameter??? I'm sure the answer to this is simple...I hope anyway... Given the following (C#): sqlCommand command = new sqlCommand(); command.Connection = someOpenConnectionObject; command.CommandText = "INSERT INTO myTable ( myTextField ) VALUES ( @myTextField )"; SqlParameter parameter = new SqlParameter(); parameter.ParameterName = "@myTextField"; parameter.Size = 8000; parameter.DbType = System.Data.DbType.String; parameter.Value = ARatherBigString; parameter.IsNullable = true; command.paramaters.add( parameter ); command.ExecuteNonQuery(); If ARatherBigString contains text, all is well and a new record is inserted into myTable. However, if ARatherBigString is null, i get a "Prepared statement ... expects parameter @myTextField " exception from SQL Server. But if ARatherBigString is null, i *would* like to insert a record with a null value. So my question is, what is the best way to do this? TIA// Tag: Error connecting to Visual FoxPro database Tag: 71885
 - 10
 - how would transaction work with this. Hi All, I'm using the SqlCommandBuilder which automatically generates all the sql commands, but how do I set the Transaction for it in case it fails... SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = new SqlCommand( "SELECT * FROM QueryInfo", connection ); SqlCommandBuilder builder = new SqlCommandBuilder( adapter ); ... adapter.Update( dataSet ); Where would the Transaction come in play ? thanks, Tag: Error connecting to Visual FoxPro database Tag: 71877
 - 11
 - how would transaction work with this. Hi All, I'm using the SqlCommandBuilder which automatically generates all the sql commands, but how do I set the Transaction for it in case it fails... SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = new SqlCommand( "SELECT * FROM QueryInfo", connection ); SqlCommandBuilder builder = new SqlCommandBuilder( adapter ); ... adapter.Update( dataSet ); Where would the Transaction come in play ? thanks, Tag: Error connecting to Visual FoxPro database Tag: 71876
 - 12
 - Calling Sybase SPROC With ODBC.NET I found reference to a previous post by Ken Robison helping out a sybase user. Attached at the bottom of this message is the original question. I have found that I also cannot get results returned from a Sybase SPROC through ODBC. I have ben over my code several times and it is virtually identical to what you and others have written about this. The crux is that when I call a sproc that does not require parameters I get results. When I call a sproc that requires parameters (and I supply them as you have) I get 0 results. Is there something wrong with my Sybase ODBC driver configuration? Any gothchas that I have to be aware of? Any ideas would be helpful! Hi Dayaker, I tested the following against Sybase 11.92 and it works fine. I included the Stored Procedure script and a screen shot of my table data. In this example pkey is type INT thus the OdbcType.Int, in the parameter below. You will need to modify the connection string in the following areas: YOURUSERID, YOURPASSWORD Set the following to a valid ken in your table: prm.Value = "1" In my case Response.Write(dr.GetString(1)) prints "KEN" ********************************************************************* Imports Microsoft.Data.Odbc Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim oODBCConnection As OdbcConnection Dim sConnString As String = "Dsn=SybaseDsn;" & _ "Uid=YOURUSERID;" & _ "Pwd=YOURPASSWORD;" oODBCConnection = New OdbcConnection(sConnString) oODBCConnection.Open() Try Dim cmd As OdbcCommand = New OdbcCommand("{call CustOrderHist (?)}", oODBCConnection) Dim prm As OdbcParameter = cmd.Parameters.Add("@CustomerID", OdbcType.Int, 5) prm.Value = "1" Dim dr As OdbcDataReader = cmd.ExecuteReader() While dr.Read Response.Write(dr.GetString(1)) End While dr.Close() Catch o As OdbcException MsgBox(o.Message.ToString) Finally oODBCConnection.Close() End Try End Sub **************************************** STORED PROCEDURE SCRIPT: **************************************** CREATE PROCEDURE CustOrderHist @CustomerID int AS SELECT * FROM customer WHERE pkey = @CustomerID GO ************************************ TABLE INFORMATION ************************************ pkey fname lname ----------- ----- ----- 1 Ken Robison 2 Joe Shmo 3 Mary Smith Hope this helps. Ken Robison, MCSD Email : Kennethr@Online.microsoft.com Tag: Error connecting to Visual FoxPro database Tag: 71875
 - 13
 - display different columns in table To display the table with all columns, we can do this: Dim dt As DataTable = ds.Tables(0) dgEmployeeInfo.DataSource = dt dgEmployeeInfo.DataBind() I want to create check boxes with all the columns, so that users can select which column (data field) to display. Any ideas?? Tag: Error connecting to Visual FoxPro database Tag: 71870
 - 14
 - C# - SQL - Null int problems I'm fairly new to C# and I am having some problems understanding int variables and null values. I have created a class that populates the values of it's fields from a DataReader in it's constructor. Those fields are modified during various methods in the class. One method updates the database with the values of the class fields. I have everything working fine for string fields but am running into problems with integers and null values. The problem is that if I try to set a null int field from the database to an int field in the class I get an error.... so I've had to add the following check... ================================================= if (dr["myID"] != System.DBNull.Value){ _myID = Convert.ToInt32(dr["myID"]); } ================================================= .... so now if the db value was null, then the class field never gets initialized. When I declare the variable I am not able to set the value as null, or I get the error "Cannot convert null to int because it is a value type". ================================================== private int _myID = null; ================================================== In the update method I want to be able to update the database to whatever the value of the class field is (null or otherwise). ================================================== cmd.Parameters.Add("@myID", System.Data.SqlDbType.Int, 4).Value = _myID; ================================================== ....but the problem is that if the field never got initialized, then this crashes. I want to be able to test the value if it is null, but I can't set it to null. -- How do I deal with this? -- Is there a way to check to see if this int field has been initialized? -- Is there a better way to set an int field to a null value? Any help is greatly appreciated. -Dan Tag: Error connecting to Visual FoxPro database Tag: 71868
 - 15
 - Creating a multi table select stored procedure Am in the process of learning to use C#. Need to create a stored procedure that returns a dataSet containing several tables and then access this query from an object. Tag: Error connecting to Visual FoxPro database Tag: 71867
 - 16
 - How to include columns with null values in Dataset XML I am retrieving data from a database using parameterized SQL queries. 1. When I have no parameters in my query, the DataSet that is returned does not have the column that had all null values. 2. When I have parameters in my query, the DataSet that gets returned has the columns that have all null values. However, when I do a GetXml() on it, the columns will null values get eliminated Note that I am setting the ColumnMappings to MappingType.Attribute to shorten my XML. I would like to have the the XML include the columns with null values. How can I achieve that? Thanks in advance, Indra Tag: Error connecting to Visual FoxPro database Tag: 71864
 - 17
 - DataColumn.Expression and Formatting We have a requirement to display a date range in a groupboxes text property. The dates are stored in a DataTable named "names" in the "names_beghold" and the "names_endhold" DataColumns. The default value is "1/1/1800" and is a DateTime type. We only want to show the dates if they are not the default. The text of the GroupBox needs to change as the DataColumn values change. So, we thought this would be a good case for an expression on a custom column. We can then databind the groupboxes text property to the custom column. The below expressions works: "IIF(names_beghold<>#1/1/1800# AND names_endhold<>#1/1/1800#, Convert(names_beghold,'System.String') + ' to ' + Convert(names_endhold,'System.String'), '')" Its output, when the dates are not 1/1/1800, looks like this: "5/1/2002 12:00:00 AM to 8/1/2002 12:00:00 AM" We need a way to strip off the trailing times. We were thinking about SUBSTRING, however the month and day could be 1 or 2 positions. Any other ways to strip off the "12:00:00 AM" within an expression? I'm a blogger: http://dotnetrocks.blogspot.com/ Tag: Error connecting to Visual FoxPro database Tag: 71861
 - 18
 - Extra DataColumn's in DataTable Have a strange problem using a sproc to populate a DataTable. The sproc itself is fairly simple and returns a selection of columns from three tables, a master table and two additional tables which are joined via a LEFT JOIN. The resultant DataTable schema after a fillschema looks good however after a 'fill' the DataTable has two extra columns at the end which represent the unselected columns from the two LEFT JOIN tables. These columns do not form part of the SELECT statement yet are appearing in the DataTable with all values set to null. I have tried the same query with a DataReader and see the correct columns (obviously executing the same sproc from query analyser shows the correct column set) therefore it appears to be a DataAdaptor issue which is somehow pulling down these unselected columns. This problem is a right pain as the I am binding a DataGrid to the DataTable via a DataView and the extra columns appear at the end of the grid. I know I could remove the columns via TableStyles however I might change the database schema at some point and I would need to know dynamically at run-time which columns were garbage and at the moment I can't see any properies on these columns which I could process against. This looks like a bug to me therefore interested if anyone has come across. Can post sample code (c#) and sproc if anyone would like to see. Regards Paul Tag: Error connecting to Visual FoxPro database Tag: 71859
 - 19
 - SQL - Conditional Terms in WHERE part of SQL Statement Hello, I am trying to create a somewhat complex SQL statement with many possible WHERE components. So far I have used If...ELSE statements and rewritten the entire SQL statements with variations. Is there a way to have conditional terms as part of the WHERE statements? I have tried various forms of CASE and have not been able to compile. Robert Tag: Error connecting to Visual FoxPro database Tag: 71858
 - 20
 - Batch Insert? I was wondering if anyone knows of a way to insert multiple records without using the command builder. I have to loop through a directory of files and depending on how many files there are is how many inserts that I have to do. There could be hundreds of files. I would rather try to to some sort of batch insert rather than do an insert each time it loops through. Does anyone know of a good way to approach this issue. I would really appreciate any help I could get here. Thanks, Rick Tag: Error connecting to Visual FoxPro database Tag: 71857
 - 21
 - Dataset timestamp fails to update Have tried a couple of different methods to update dataset timestamp after SQL 2000 update (batch query and sproc output parameter). I've tried both methods using ADO .NET by David Sceppa (Chapter 11) as an example. I've examined the timestamp before and after the update and it is unchanged. 1. I created DataAdapter through IDE. 2. I know using the batch query method that SQL is passing back the new timestamp (using Query Analyzer). 3. I've tried both separate and combined parameters for the timestamp (i.e. oldtimestamp as input, newtimestamp as output or timestamp as input/output). 4. I've assigned the parameters to the timestamp column in the datatable (DataSource) and have tried both using Current and then Original as SourceVersion. 5. Dataset will update once (Data changes in SQL, but SQL generated timestamp doesn't get back to the dataset). Abbreviated stored procedure (using separate parameters): Create Procedure UpdateHousehold @BuildingId uniqueidentifier, . . @OldTStamp timestamp, @NewTStamp timestamp OUTPUT AS UPDATE Household ... WHERE (BuildingId = @BuildingId) AND (TStamp = @OldTStamp); If @@Rowcount = 1 Select @NewTStamp = TStamp From Household Where BuildingId = @BuildingId IDE Generated code this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@OldTStamp", System.Data.SqlDbType.VarBinary, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "TStamp", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@NewTStamp", System.Data.SqlDbType.VarBinary, 8, System.Data.ParameterDirection.Output, false, ((System.Byte)(0)), ((System.Byte)(0)), "TStamp", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommand1.UpdatedRowSource = System.Data.UpdateRowSource.OutputParameters; I know other people have go this to work, but I am at a total loss. Any body have any ideas? Thanks, Brian Tag: Error connecting to Visual FoxPro database Tag: 71855
 - 22
 - Check out these security package --oshoavcb Content-Type: multipart/related; boundary="azfvmbqfp"; type="multipart/alternative" --azfvmbqfp Content-Type: multipart/alternative; boundary="vwlbdoclryvuillek" --vwlbdoclryvuillek Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Microsoft Customer this is the latest version of security update, the "November 2003, Cumulative Patch" update which resolves all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to protect your computer from these vulnerabilities, the most serious of which could allow an attacker to run executable on your system. Microsoft Product Support Services and Knowledge Base articles = can be found on the Microsoft Technical Support web site. http://support.microsoft.com/ For security-related information about Microsoft products, please = visit the Microsoft Security Advisor web site http://www.microsoft.com/security/ Thank you for using Microsoft products. Please do not reply to this message. It was sent from an unmonitored e-mail address and we are unable = to respond to any replies. ---------------------------------------------- The names of the actual companies and products mentioned = herein are the trademarks of their respective owners. Copyright 2003 Microsoft Corporation. --vwlbdoclryvuillek Content-Type: text/html Content-Transfer-Encoding: quoted-printable <HTML> <HEAD> <style type=3D'text/css'>.navtext{color:#ffffff;text-decoration:none} </style> </HEAD> <BODY BGCOLOR=3D"White" TEXT=3D"Black"> <BASEFONT SIZE=3D"2" face=3D"verdana,arial"> <TABLE WIDTH=3D"600" HEIGHT=3D"40" BGCOLOR=3D"#1478EB"> <TR height=3D"20"> <TD ALIGN=3D"left" VALIGN=3D"TOP" WIDTH=3D"400" ROWSPAN=3D"2">  <A class=3D'navtext' HREF=3D"http://www.microsoft.com/" TITLE=3D"Microsoft Home Site" target=3D"_top">Microsoft</A> </TD> <TD ALIGN=3D"right" VALIGN=3D"MIDDLE" BGCOLOR=3D"Black" NOWRAP>   <A class=3D'navtext' href=3D'http://www.microsoft.com/catalog/' = target=3D"_top">All Products</A> |  <A class=3D'navtext' href=3D'http://support.microsoft.com/' = target=3D"_top">Support</A> |  <A class=3D'navtext' href=3D'http://search.microsoft.com/' = target=3D"_top">Search</A> |  <A class=3D'navtext' href=3D'http://www.microsoft.com/' target=3D_top> Microsoft.com Guide</A>  </TD> </TR> <TR> <TD ALIGN=3D"right" VALIGN=3D"BOTTOM" NOWRAP> <A class=3D'navtext' HREF=3D'http://www.microsoft.com/' TARGET=3D" top"> Microsoft Home</A>   </TD> </TR> </TABLE>  <IMG SRC=3D"cid:urxfvrn" BORDER=3D"0"> <TABLE WIDTH=3D"600"><TR><TD> Microsoft Customer this is the latest version of security update, the "November 2003, Cumulative Patch" update which resolves all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to protect your computer from these vulnerabilities, the most serious of which could allow an attacker to run executable on your system. </TD></TR> </TABLE> <TABLE BORDER=3D"1" CELLSPACING=3D"1" CELLPADDING=3D"3" WIDTH=3D"600"> <TR VALIGN=3D"TOP"> <TD NOWRAP><IMG SRC=3D"cid:suvquqt" = ALIGN=3D"absmiddle" BORDER=3D"0"> System requirements </TD> <TD NOWRAP>Windows 95/98/Me/2000/NT/XP</TD> </TR> <TR VALIGN=3D"TOP"> <TD NOWRAP><IMG SRC=3D"cid:suvquqt" = ALIGN=3D"absmiddle" BORDER=3D"0"> This update applies to </TD><TD NOWRAP> MS Internet Explorer, version 4.01 and later MS Outlook, version 8.00 and later MS Outlook Express, version 4.01 and later </TD> </TR> <TR VALIGN=3D"TOP"> <TD NOWRAP><IMG SRC=3D"cid:suvquqt" = ALIGN=3D"absmiddle" BORDER=3D"0"> Recommendation</TD> <TD NOWRAP>Customers should install the patch = at the earliest opportunity.</TD> </TR> <TR VALIGN=3D"TOP"> <TD NOWRAP><IMG SRC=3D"cid:suvquqt" = ALIGN=3D"absmiddle" BORDER=3D"0"> How to install</TD> <TD NOWRAP>Run attached file. = Choose Yes on displayed dialog box.</TD> </TR> <TR VALIGN=3D"TOP"> <TD NOWRAP><IMG SRC=3D"cid:suvquqt" = ALIGN=3D"absmiddle" BORDER=3D"0"> How to use</TD> <TD NOWRAP>You don't need to do = anything after installing this item.</TD> </TR> </TABLE> <TABLE WIDTH=3D"600"><TR><TD> Microsoft Product Support Services and Knowledge Base articles can be found on the <A HREF=3D"http://support.microsoft.com/" = TARGET=3D"_top">Microsoft Technical Support</A> web site. = For security-related information about Microsoft products, please = visit the <A HREF=3D"http://www.microsoft.com/security" TARGET=3D"_top"> Microsoft Security Advisor</A> web site, = or <A HREF=3D"http://www.microsoft.com/contactus/contactus.asp" = TARGET=3D"_top">Contact Us.</A> Thank you for using Microsoft products. Please do not reply to this message. = It was sent from an unmonitored e-mail address and we are unable = to respond to any replies. <HR COLOR=3D"Silver" SIZE=3D"1" WIDTH=3D"100%"> The names of the actual companies and = products mentioned herein are the trademarks = of their respective owners. </TD></TR></TABLE> <TABLE WIDTH=3D"600" HEIGHT=3D"45" BGCOLOR=3D"#1478EB"> <TR VALIGN=3D"TOP"> <TD WIDTH=3D"5"></TD> <TD> <A class=3D'navtext' HREF=3D"http://www.microsoft.com/= contactus/contactus.asp" TARGET=3D"_top">Contact Us</A>  |  <A class=3D'navtext' HREF=3D"http://www.microsoft.com/legal/" = TARGET=3D"_top">Legal</A>  |  <A class=3D'navtext' HREF=3D"https://www.truste.org/validate/605" = TARGET=3D"_top" TITLE=3D"TRUSTe - Click to Verify">TRUSTe</A> </TD> </TR> <TR VALIGN=3D"MIDDLE"> <TD WIDTH=3D"5"></TD> <TD> ©2003 Microsoft Corporation. All rights reserved. <A STYLE=3D"color:#FFFFFF;" HREF=3D"http://www.microsoft.com/= info/cpyright.htm" TARGET=3D"_top">Terms of Use</A>  |  <A STYLE=3D"color:#FFFFFF;" HREF=3D"http://www.microsoft.com/= info/privacy.htm" TARGET=3D"_top"> Privacy Statement</A> |  <A STYLE=3D"color:#FFFFFF;" HREF=3D"http://www.microsoft.com/= enable/" TARGET=3D"_top">Accessibility</A> </TD> </TR> </TABLE> </BODY> </HTML> --vwlbdoclryvuillek-- --azfvmbqfp Content-Type: image/gif Content-Transfer-Encoding: base64 Content-ID: <urxfvrn> R0lGODlhaAA7APcAAP///+rp6puSp6GZrDUjUUc6Zn53mFJMdbGvvVtXh2xre8bF1x8cU4yLprOy zIGArlZWu25ux319xWpqnnNzppaWy46OvKKizZqavLa2176+283N5sfH34uLmpKSoNvb7c7O3L29 yqOjrtTU4crK1Nvb5erq9O/v+O7u99PT2sbGzePj6vLy99jY3Pv7/vb2+fn5++/v8Kqr0oWHuNbX 55SVoszN28vM2pGUr7S1vqqtv52frOPl8CQvaquz2Ojp7pmn3Ozu83OPzmmT6F1/xo6Voh9p2C5z 3EWC31mS40Zxr4uw6LXN8iZkuXmn55q97PH2/Yir1rbL5iVTh3Oj2cvX5Pv9/+/w8QF8606h62Wk 3n+dubnY9abB2c7n/83h9Nji6weK+CGJ4Vim6WyKpKWssgFyyAaV/0Km8Gyx6HW57FJxicDP2+Tt 9Pj8/wOa/wmL5wqd/w6V8heb91e5+mS9+VmLr4vD6qvc/b/j/Mbn/sTi9rvX6szq/tPt/9ju/dzx /+n2/+74//P6/+3w8hOh/xOW6yCm/iuu/zWv/0m4/XTH/IXK95TP9qPV9bfi/tDn9tfp9OP0/93r 9L3Izy6Vzj22/lrC/mfG/JvJ5JGntAyd6IbX/3zD6GzP/3jV/2uoxHqbqujv8g6MvJTj/2HF5pXV 606zz6Hp/63v/7j1/8Ps88b8/rbj5RKOkE2wr3OGhoKGhv7///Dx8V2alqvm4Zni1YPRvx5uVwyO X0q2hLTvw8X10gx2H4PXkkuoV5zkoQeADZu7mmzIVEO7HIXbaGfLMPz8+97d2/Px7v///+bl5eHg 4P7+/v39/fT09PLy8u7u7gAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACwAAAAAaAA7AAAI/gCVCRxI sKDBgwgTKlzIsKHDhxAjKgwiqs2kSJEgQfqyp2PHLxoxTmojSpTEkyglBrGYcU+el3n09PEDSFKg mzclAfLTRw/MPV4gjTSZsmhRURchuXwUs88fSYIGubEiqyqAq1gBNLPiRlCgPz197tE4MojRswuD JHX5UiagQILcNMtKl26zu3etuBgUaKcePXv0QIo0iSjaw8raROKYh6nbuFbmVpVlpbKby4Mya858 eWrlrV0l/fECWDBhw4hPimoJUw9NQVa0Yg6kk6dPmD9xt/Xi52kgKG4GCRLtpTjZNmZTQ5yktLXT QFNDA+qJe2wkkgkrrmWrx4tv0X6M/gvFrnzh6uaO+wCKOhzs7TzWyUesyDom7z9//EAKOh51eYKK sdWWH1D15cd78J12GFJKufRXcfwNNtR/ANYXE006UfdSfBQq1lxM3fFHWFlojRBCCA5goMMK5y3V 1B879VGdUMlRqIxaG7kUmHEikVTjQyuAcGIGDmSQwQUYzPBAA1UIKJMfUCI4Vhs2EjTJKrWYwogp mXSxY0iTTLhQAC2ocKIDHGywgAwYWPDAm3AeIIVztr3E1FiFVSnQJLXc4ksxuujyiy6npNGFYBKK WRAzKZipAgkp8ACCAyLg0MClDcD5ppIUVNCFFDL1oSF8Qvn3nyi8+KIqMH8aQwwx/66EMQcoVQxG mI/KBEBCCCSo0MIPLJSJwA6YFvsmBlFkYgopUTxwgQ8XXGBBBRUA0QUXeJp6qi2r2rKLLcAU42qs WIRhR623YpdDNM4wQ0IOInggrwfFNoCDDl20wooqqaSCCil3SHCBBgQXnAGbFmCAgQMkBKDnLsMU 4wswvPCySy3DuLpJGFiY4YodX6RrUhnOIFDDvPNeqkkXfKzCyssv8+svwM5uYPPNONusAZszEEEE GoooQsfQdRRdxyJII83I0ow04nQjjkTtCB5cVN3KMBEXA8wuFbMC6Cu5jIJFLsG4oonIQeQQQw4o a5KsI6moogrMMMvt77+kCPzB3v589+03BxdQ0IFyotyCdTFap7I1K7Z4YskmcIwSTC+9KMHGSD6S 0AIJHkRxByekkIJKv3LPXbfMeOddgQmst+466xoAIUEEEUzAQNBD02H00UkvwnTTT0s9ddV4ZPEK 1hH/qTUnlyDyRi659BJMMLiEgrkoQSwTAjMefPIJ6KKPHnfppfeLCt6cCDFDmjT8AMP7MJywwQW0 1187Aco5osUYyGNtjC+ccFwhzuCK6U0OF2uoQht8FAMEoMADnfge+M7Xrwpa8HyhI0X6JGCwDGhg fvYLoe1wRzSj9c53THsa1KRGNS6oYQxZ0AXyjKGLUlzCEoeIQxjIRjnKTYESC/7EnjJyYAIRRMF7 4Auf+Cp4vtRxghNOiEAHjxTC+k3gfsp5ghPSAIqMBeoUlkjEIeYgBzjwEBdonEIOgmgWSDlgC0h8 YgabSEcncuITUZQBwYxERftRYAIToEDtbie0EhbthL9TofBa6IT9jeEVgQpUJcZoCDEUcHqUw8UU ysBGZZQgBAvAgSfimMQMmjJ0T/SeGiKgRw3w8QKz+2Mgp/UALKamC1FYwha1AElJzkEMYiDb5HqB wE2SRIjR0MEIGoCJUUqwlKd84h0/4QlMRKACezQSLAM5A2pR6wF/JGTudofIFAaPhVW7AxWooIX9 ZSELv4hnJYA5CjQScw1rUP/jMQeCgA/gQA2ecOYzpUnQaVKzmtfM5pEkMIFpebMCtZwA/lJTBR88 YQlRcIITQBHPeNrhCEcwQhPQmM8EALEkAwnBDTBAhWYG1HukTCVMD4oJTBDBAgrNAEOnZYE/vomh 4jQk75KWyHNGrYWO0KUT1tlOWnRUCUdQQhOaoIQ12GEKsVCgEAVSAge88RIufelMxxrQal7iEkLg oCv5uFOffvOPE0XMMvjggy74IAoZ3UI8aYEEJUh1CkoggxIOUIbCbFUZyczADM4K1rI69rHVxARj kyDFtRppp9OawR8pAFQS6s6EvSuq0xZZNS444gkZ1SgVQkELWvjMr1QlQgT+pgALG+yTIDrgwAPo wFiwhtWxNZUsYxVBWYX6YAYT0CwgHwDRB0i0PNGoghTsCoQoaEIYQhCCz7ZLhCYoIAdD+ZEyQqAB C4xBEb09a3Brmt5LBE0RWYiAB/mo2EBSoJvfdG5QP3vI0JpztOgsLR8y8QTU4jUK2U2wEIagBAWU AQy3JcgIUqSF97b3wu9VhCXQwErLKpYCDvXmmygQV+UEQLpScKUPfACEFjuBCGuAhQ4gXBLxIjZa QrBEhtGL3rPyOMOWCHIiOkxfCzT0oc2lwH7J6d+lKTLAVfPIdAu8hCUAwQlCIIMBikAJCEeYIMm4 gAxmkIggB3nHOzazJcb+QIXZ6bHIIPZmT0FMYj2RyUw50EEZRIAASnzheoctSJEekIgyq/nQalaE E2QXAYHlFANx1iyILYDcJYOWqP9d4VFLi62PgEQkGAl1mI5p44HcYMxoQISqC21oIYcxDUuowOwk IAMOTDEDGAAnBR5gARyAE5Al1pMytIM5UiuEBxWwQBIOoepmO1sRd/BBBWgnMGo9a758xECmcOBr QE5Av55lMqadbNThldYjX/h0qEVyvVIDiFpEOIS85b3qOjBBBrODgL4foCZoWVsG2cZAt5fL7ToL WyAVWeAxA42QScjgAkQoRCHmrYhGgDAC+s54AjbAAQ4s4GDeFHOuvf3/ABwMQBgiUHK4L620TJP2 3J7WSEhG1MmJRKILsJzDxBfxhfLWL+MZn4AGOm5rgj2cWrJ8wAB2sAMRFEMYBtcTRUpCdXcbZDV8 sIAExoAHHuA7At2sYv3Q5PEOQmvXTE/7DlCu8kLyd6gtJzeANw3zPaRb5uwOIkoV0gY2SNsCgG+0 DFJwJFhWMbkDK7qHRcD4xjMeBxMoQAGEHYSpWz0hPlhANHxggWtyYBnMQAYIKvBwCZj+9GCHqAUc kFMdOF4EOzBAAXoA2JX3d9zAm7u5oxxzW4164doaiAM0rwwU0IAHz4hGAEDfAjH74PTQn4G0EpAA Z9HX9Y03wAEKcIAB/oDAYQc/CQkcEIBoPAMGzoDBM2KwfGa0QAMXOBLg5y8B6V/gAVNowhQogIEV 61kEDXAAPdADTVAJaKBjtgd3KCR3mrZ7nWZ36kZzx0QIV5AQGNAC5Xd+x6B+7Md8KYBN0oZkziIt E4AAKTAACtBQ8ZIA3NcBKrAMMRB+RfEAzLAM0aAMz/ACLwANyrcMyNACKXABCwA40VKEFPBwRtYE cjAHhmAEU5AAAzgFYjAHrHZmCVhODPhyvAeBtkJzNUYIs5AQNLgM5VeBV9CDoQeEIZABICADbviG FBAtRqYAzCAQAVACOSAACFACMngYFqACNRgAgiiIy+CDLQCEJCAD/yWgAV7ViHF4ATOQAFMABxI3 cWM0B6tWhQjoduIWd7nXgC20hXfHbkOBPRSYECFgAchQg4VYiMyQhikAAjdwAStgAydyIm1yARVA AQXQASvQhzYSAA2AAav4iq/4g0AYiyRwATRQAiqgAggwAxYgA7t4AAcQAjcIjBTSAgYwAySADOB4 iMkoi7uCAQuQJBYgZj3FfQOwDNpYJSnQAROAAZozjuS4AAsAfzLgAGzyACzYfXX4jlVSAmVAfQ+w MCRgAyRAAvhIMCmCXNtXAAYQAu4okHryAzaAARNgjQYJJxNAfRF5AAaQAy2QjRYpdWBQBV2QawrA gpLHfQpgAA1ggiMrYJInKWxIsRhfUAU82ZMj0Iwr8AM3qY3E9ntVV3lDWSUBAQA7 --azfvmbqfp Content-Type: image/gif Content-Transfer-Encoding: base64 Content-ID: <suvquqt> R0lGODlhDAAMANUAAP////f3//f39+/v9+/v797m987W787W5sXW5rXF76295qW975y175St75St 3pSlzoyl1oSl5oylzoycxXOU3nOMxWOM5mOM3mOE1lqE3mOEvVKE1lp7xVJ71lJ7zlJ7xVJ7vUp7 zkpzzkpzxVJzrUprvUJrxUJrvUJjtTpjtTpjrTparTpapQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACwAAAAADAAMAAAIjAABAAhwwMGFCxAQ CACwkICDDBYSLGjQwQEBhg8zDBAIYIEIBwIQdLjAoOOFgSFMIICwIUMEAxQwCBxhAgKHDh5C6DQA IIGJEyA4fPAwYoQCAAVKoEgBQsKJEidQ8CyRYumDA1VTqNBQQYXXFQofsPB6AIAKFiweNBTLoiza BxcFCjgwgQSJCQcWCggIADs= --azfvmbqfp-- --oshoavcb Content-Type: application/x-compressed; name="Q184493.zip" Content-Transfer-Encoding: base64 Content-Disposition: attachment --oshoavcb-- Tag: Error connecting to Visual FoxPro database Tag: 71853
 - 23
 - Create Dataset with a Binary Field? Hi, i got the following question, what will be the correct type when i create a Column in a datatable to store Binary Information?? if i do not set the datatype it will set it to be a string... dim dt as New Datatable with dt.columns .add("BinaryColumn", ?????????? ) ' What datatype??? end with Thanks. Alex. Tag: Error connecting to Visual FoxPro database Tag: 71852
 - 24
 - MS Access LAST Statement Hello everyone, I am trying to port an application from access to .Net but I still want to use the access mdb file for the backend. I use the LAST statement in access in one particular and .Net doesn't seem to accept that. How do I port this statement: LAST(SELECT * FROM MyTable) Thanks Tag: Error connecting to Visual FoxPro database Tag: 71850
 - 25
 - DataSet diffecences Hello, is there a simple method to get Rows which differ in their values between two different DataSets? Ondra. Tag: Error connecting to Visual FoxPro database Tag: 71842

Hello,

I am trying to create an app that connects to a visual
foxpro set of databases. When I try to use the wizard, i
receive an "There were errors trying to configure adapter"
after I select the tables I want to use. I am using the
Visual fox pro provider. Is there any known issues or
updates for this?

TIA

Top

Re: Error connecting to Visual FoxPro database by Cindy

Cindy
Sat Nov 22 14:21:44 CST 2003

"bill k" <anonymous@discussions.microsoft.com> wrote in message
news:05e401c3af12$ef7302f0$a501280a@phx.gbl...
> I am trying to create an app that connects to a visual
> foxpro set of databases. When I try to use the wizard, i
> receive an "There were errors trying to configure adapter"
> after I select the tables I want to use. I am using the
> Visual fox pro provider. Is there any known issues or
> updates for this?

Hi Bill,

Be sure you have the latest VFP OLE DB provider, available from
http://msdn.microsoft.com/vfoxpro/downloads/updates/default.aspx. Are you
connecting to a VFP database (there is a DBC file present) or a free table
directory?

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@mvps.org www.cindywinegarden.com

Top