I have a DBF file and a index file. I want to read index file and search records satisfy some condition. (for example: search records which its StudentName begin with "A" by using Student.DBF and StudentName.idx) How do I do this programmatically? ...
I am trying to import data from DBF file to SQL table using the following command - select * from openrowset('MSDASQL', 'Driver={Microsoft dBase Driver (*.dbf)};DBQ=E:\data\;', 'select * from E:\data\a.dbf') But it is failing saying OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC dBase Dr...
i have a PHP contact form that submits data, and an email...: <?php $dbh=mysql_connect ("localhost", "username", "password") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("guest"); if (isset($_POST['submit'])) { if (!$_POST['name'] | !$_POST['email']) { echo"<div class='error'>Error<br />P...
We need to be able to create a dBase database (.dbf file) containing numeric columns with specific width and precision. I seem to be able to set the precision but not the width. The following code shows my connection string and my command text. using (OleDbConnection oConnection = new OleDbConnection(String.Format("Provider=Microsoft.Je...
I have a Table indexed on field1 and on field2. How do I specify, in the TTable component, that both indexes are active. I tried: IndexFieldNames := 'FIELD1, FIELD2'; It didn't work. ...
I've a project that connects to a dBase format database file, that I've always done in the past with a connection string of the form of: PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=MyData.dbf;Extended Properties=dBASE 5.0 I've had to revisit this recently, and have found that when attempting to create an OleDbConnection with that ...
Hi, im connecting to dBase from java with this string: String url="jdbc:odbc:DRIVER={Microsoft dBase Driver (*.dbf)};DBQ="+databasePath+";DefaultDir="+databasePath+";DriverId=533;FIL=dBase IV;MaxBufferSize=2048;PageTimeout=5;"; Work fine, but with a SELECT statement i can retrieve only record that are not "deleted". In dBase database ...
I need to create a little program that creates a backup copy of some DBF files on demand. the files are used by a custom designed Web application. Is it safe to copy a dbf file while it is open or do I need to close the web server so the files are released before safely creating a backup? ...
how can i install dBase on cpanel/whm with php version 5.3.2, i didn't see the option on EasyApache (Apache Update) ...
First of all, I must state that I'm a complete newb when it comes to Delphi, allthough I did some Turbo Pascal programming in school, some fourteen years ago... I have a comercial Delphi program which uses dBase database and BDE for accessing them. I basically need to interface another application written in C# to this database, to be a...
I'm asking this as a follow-up to my previous question: http://stackoverflow.com/questions/3221364/what-is-a-good-way-of-accessing-dbase-files-using-bde-and-delphi It was suggested that I called upon a Delphi COM server instead of passing data though standard input/output, and I totally agree that such a solution is very limited. Basic...
I have a TQuery object, pointed to a dBase database and I'm wondering how I should go about parameterizing my insert statement. The following INSERT-query will will work fine with qry.ExecSQL: qry.SQL.Text := 'INSERT INTO KUNDE ' + '(FNAVN, ENAVN, INSTNR) ' + 'VALUES ' + '(:FirstName, :LastName, ' + IntToStr(InstructorNo) + ' )...
I am working with a Dbase table via SQL commands. I have the following free table to work with. import1 account, phone, subaccount, locationid I need the first occurrence of each uinique combination of account and phone. No one field in the table is unique. I can get a partial subset of data using the distinct qualifier but i need the...
Regarding the first byte of a .DBF file and how to detect the version of xbase used (ie, the format of the rest of the file), the most comprehensive list I can compile is: Byte 0 ----------- x xxx x 001 = 0x?1 not used 0 000 0 010 = 0x02 FoxBASE 0 000 0 011 = 0x03 FoxBASE+/dBASE III PLUS, no memo x xxx x 100 = 0x?4 dBASE 7 0 000 0 101 ...
I need to read the data in an Access 97 file that has about 400K records. I would like to use either TurboDelphi Pro or dBASE SE. I only have Access 2003. What is the easiest way of proceeding ...
Hello, I have an asp.net website that needs to connect to a dBase file on a remote server. The remote server has a ODBC System DSN connection configured but I have no idea how to connect to it. ...
Hi I'm on windows 7 trying to set up with ODBC data source administrator a dBase DSN connection. We have this on the servers and I'm trying to replicate on my local machine to test but I can't find the Microsoft dBase driver that we use on my machine. Does anyone know how to get this on Windows 7? ...
LANGUAGE: C#, System: Windows7, Excel 2007 I want to create a .DBF from some data, and i want to open it from Excel 2007. It can be either dBase or foxpro. I am currently doing in FoxPro9 (btw this code is from the internet): OleDbConnection con = new OleDbConnection("Provider=VFPOLEDB.1;Data Source=C:\\Temp\\;"); con.Open...
I need to open and read a Dbase file in my ASP.NET application. When I try to open the connection, I am getting the exception "Could not find installable ISAM." I have tried the solutions in the top answer in this question, but they did not work for me. The filepath of the data file is C:\dev\DATA.DBF. Here is the code I am using to try...
Hi, I'm generating dbf file to get imported to legacy systems that only accepts dBase II OR III. My aplication is .Net 3.5. I initially started working with this component VFPOLEDB.1 but it only generate dbf files in dBase V format which isn't backwards compatibily. Anyone knows a component or driver to generate de dbf file in dBase I...