Consume a regular asmx web service in a dll projectI would like to open DBF-files, including the NTX-indexes in VB.NET which are used in FoxPro / Alaska Xbase. how to open both DBF nd NTX, because only open DBF-files would result in corrupt index (NTX) files.
View 2 Repliesi have to start out saying that I have never used VFP before, so this is all new to me. However, I am running into issues that seems to have nothing to do with logic or reason. Let me explain.
[Code]...
I'm trying to connect foxpro table (dbf) to VB.NET. I'm trying to display the records of that table to listview in VB.NET. Here is my code:I got an error message here, the error says "cannot open the file"
Imports System.Data.SqlClient
Imports System.Data.OleDb
Public Class Form3
[code]....
I am creating a VB.NET application that will use a FoxPro database as it's main datasource.The problem I've got is that I can browse existing databases and pull out data with no problems at all but as soon as I try and create my own database I get an error message saying "One or more errors occurred during processing of command." (which is helpfully vague).[code]
View 1 RepliesI want to create an index on a foxpro table. I used the following command
Code:fcn = New ADODB.Connection fcn.ConnectionString = "provider=VFPOLEDB.1;Data Source=" & tablefolderpath fcn.Open() fcn.Execute("INDEX on D:myfoldersales.dbf (BRAND)")But i get Command contains unrecognized phrase/keyword. message
I am trying to index on the brand field of sales.dbf table?
I wanted to write a small piece of vb code to synchronize a few FoxPro dbf tables to SQL tables that having the same structure or at least a few fields that i selected. I had tried a code which I found on the net that running row by row and column by column to update the SQL tables but this code is too slow. In my dbf table it contains around 3000 records at least.
View 12 RepliesI dusted off VB.net, and now im trying to connect to a local FoxPro DB. Problem is, its not working. Ive been at this for about an hour or so, trying many misc things, but without any luck. [Code]. 'C:aaaCF21000.DBF' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. Suggestions? That path is 100% valid, I can copy/paste that and open up the Database without error. I also tried other code I found on the web, some of them I cant even get them to run.
View 5 RepliesI have an application that can read certain types of files, and I have it working so that if you do "open with" from windows, it automatically starts the application and opens the selected file.
Unfortnately, I cannot get it to work for more than one file.
System.Environment.GetCommandLineArgs() contrains the following:
System.Environment.GetCommandLineArgs(0) = name and path to the .exe
System.Environment.GetCommandLineArgs(1) = name and path to the first file selected to be opened
System.Environment.GetCommandLineArgs().Length is 2 when the user tries to open 1 file, which makes sense since the first argument is the .exe itself and the 2nd is the path to the file, but it does not increase to 3 if the user tries to open 2 files... meaning that System.Environment.GetCommandLineArgs(2) is never populated Here is some sample code that shows the problem: It will recognize no files or 1 file being opened, but if you try to open multiple it will only show the first.
[Code]...
I have been tasked with converting Foxpro programs and forms into Visual Basic .NET and web application. Does anybody know of a tool I can use to convert Foxpro programs and forms and dbf into Visual Basic.net?
View 3 RepliesI'm using VB.NET 2008 with a DataGridView and I'm interfacing to a Visual Foxpro 6 database using the vfpoledb.1 driver. When I change a value in the description field, it changes in the DataGridView but the database never gets updated. Do I need to use code to force the changes to take place?Here's the code I'm using:
Imports System.Data.OleDb
Public Class Form1
Dim sConString As String = "Provider=vfpoledb.1;Data Source=C:MyDatabase.dbc;Mode=3;"
Dim con As OleDbConnection = New OleDbConnection(sConString)[code].....
So, I have successfully loaded dbf's into my VB project.What I need to know now is how exactly do I utilize the VFP language in addition to SQL?
Say I wanted to replace all fields (REPLACE ALL field1 WITH field2) with another field, how would I send that instruction to the DBF utilizing the VFPOLEDB.dll?
I think what I have here is an environmental issue. When I attempt to fill a dataset from a VFP table I am getting an error message that says "Index Not Found". The reason I feel its environmental is because the process was working perfectly fine last week. The client I am trying to run this program for runs it once per month to integrate one of their FoxPro systems with SQL. It's been in working order since November of last year, but suddenly now I'm getting this error. Some things I have looked at already are updating VFP drivers for both OleDB and ODBC.
'--- FOX variables
Dim cnFOX As OleDbConnection
Dim cmdFOX As OleDbCommand
[code].....
I have a foxpro table <b> INVENT.DBF</b> linked in MS ACCESS. When I tried to do a search in the table from vb.net application, it is taking a long time. So I want to index the foxpro table and then use it for search.
Here is the sample code I wrote in vb.net <i>
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:database.mdb;Persist Security Info=False")
cn.open()
cmd = New OleDbCommand("Create INDEX itmno_idx ON INVENT(ITEM_NO) ", cn)
cmd.ExecuteNonQuery()</i>
But I am getting error "Cannot execute data definition statements on linked data sources"
What needs to be done to index a linked foxpro table using VB.NET.
As part of a larger application, I need to IMPORT (not link) a FoxPro 2.6 DBF into a Access DB.I toyed with using a Access MODULE and in the module, using the docmd.TransferDatabase method.I have looked for days at different samples and I cannot seem to find the answer.This application is intended to be distributed with NO ASSURANCE the user will have the FoxPro OLE driver installed. Knowing that the ODBC driver will most likely be installed as part of MDAC, it is pretty safe to use the ODBC driver that is already installed - Visual FoxPro Tables
View 1 RepliesI am new to VB and trying to use it to update and merge some foxpro free tables. I have a connection and trying to use the update command but getting an exception. Once the code hits the ExecuteNonQuery line it throws the exception {"Command contains unrecognized phrase/keyword."} Do I need to create the command using parameters? Just not sure. Is the connection string correct - I did not get any issue with the cn.Open
[Code]...
i am using vb/vb.net and the database is visual foxpro 6.0 then i want to create the tables from the application using sql statement.i need to add the number field into the table. i can not add the number field in the tableres.open "CREATE TABLE Customer ( CustName char(50), CustId int(2))",conXavier
View 2 RepliesSo Im working on updating our company's program from Visual FoxPro to VB and this is the first step. I can access and read data from the table
Code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[code].....
VS 2010, VB.NET, WINFORMS. In my app i have a need to import foxpro database tables and exclude the deleted records. The problem is that FOXPRO tables keep deleted items inside the same table. I have tried using DELETED=NO in the connection string but vb throws "Format of the initialization string does not conform to the OLE DB specification."
My function is as follows:
Dim _DBConn1 As String = "provider=vfpoledb.1; Data Source = " & file1 & ";DELETED=NO"
Dim _DBConn2 As String = "provider=vfpoledb.1; Data Source = " & file2 & ";DELETED=NO"
Dim _DBConn3 As String = "provider=vfpoledb.1; Data Source = " & file3 & ";DELETED=NO"
Google results pointed me in the direction of DELETED=NO but its throwing that exception error now that I have added it..
im used to C programming.
Private Sub SaveAsToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SaveAsToolStripMenuItem.Click
timedate.Stop()[code]......
The problem is that if I save a file I get "myfile.GDL" if I overwrite that I get a new file "myfile.GDL.GDL" ect.the other problem being that the filtering in the windows save/open dialog wont show .GDL files unless I select "all files".
How do i open exe files with in my form with a command button
View 4 RepliesMy project is a PDF file format database. How can I view these PDF files in VB.net? And what database should I use to store these PDF Files?
View 1 RepliesHow do I open Visual Basic .vbp files?
View 1 RepliesI have many container files on a hard drive, inside of them are many images. I have to get a particular image by using an ID to do this I have to go trough each of the container files and find the one which has the ID in it then I can retrieve the image.
I think I have 3 options:
load all the images at start up into memory, some images may or may not be used. as I need each image go through all the container files and open the image into memory. create a dictionary of IDs and what file they are in at start up and then get each image as I need it without have to go through all the container files.
I'm working on a piece of software using vb.net that should allow the user to open sketch up files '.skp' and perform some measure on it.how to get vb.net to open SKP files?
View 2 RepliesCan I have two files open at the same time to write text into, in VB .net?[code]...
View 1 RepliesI am using Visual Studio 2008 Professional Edition, and I have a large windows forms project I have been working on. My computer froze up and I had to reboot. After reboot I opened my project, all the files loaded although I got a message telling me that the document load was skipped because of the way the project opened the last time. I am able to debug and run the program so the app is ok. but when I double click on a form to open it nothing happens. Even if i right click it and select "View Designer" or "View Code" nothing happens. No errors just nothing. I was able to open other projects with no problem but not this one, and this project is the only one that matters.
View 6 RepliesThere was an error about VB 2008 not being able to open vb files, i fixed that by re-installing but now when i try and make a project or open one i get this error:Warning1Extensibility DTE object unavailable.00
View 6 RepliesI have created a small application to open the Flash File from my VB.Net Windows Application. To open the Flash file - I have used the Shockwave Flash Object. When I run the application directly from the Solution, the flash files are opening perfectly. But, once I created the EXE and tried to open the same file, I could not. But I can still open other files such as XML, PDF, and Word file from the same directory.
View 2 RepliesOk first i want to say im sorry if i put this inthe wrong section i have no idea what the thing im doing is called "I call it a notepad" Ok i made a notepad saved it ect now i got the .exe file i tryed making that my default notepad but when i click on a .txt file i get an error massage
C:Documentsand SettingsUserDesktopTry.txt is not a valid Win32 application
i dont get the point in making a program and not using it..The Notepad is only a simple one "My first project" Only has features like
[Code]...
Edit 1 If anyone can tell me the diffrence between TextBox and RichTextBox would be nice also
In our application, when you go to "Menu > Help...", it opens our help files in Internet Explorer, which is the desirable effect. However, we have the shortcut key "F1" set to open the help files as well. It still opens the help in Internet Explorer... but it also opens them up at the same time in the user's default web browser![code]...
View 1 Replies