Now most C # connection databases will be SQL Server. However, the connection and operation of some old database files is not very familiar.
Today there is this problem, to the FoxPro generated DBF file database operation.
I have been on the csdn for a long time and most of the problems have not been well restored to these operational problems.
After my experiment, it's OK to connect it with ODBC.
The following is the code that is used.
is very s
1. In fact, can not mapinfo to convert, *.shp for the ArcView data format (form file), can be directly with ArcGIS Toolbox conversion, fast and not error, the property integrity.
2..shp. shx. dbf format, which is a ArcView format, is called a row file, and a row file consists of. shp. Shx. DBF, open. SHP the other is open at the same time, the conversion only needs to turn. shp file can be, one MapInfo fil
Data | database
Now most C # connection databases will be SQL Server. However, the connection and operation of some old database files is not very familiar.Today there is this problem, to the FoxPro generated DBF file database operation.I have been on the csdn for a long time and most of the problems have not been well restored to these operational problems.After my experiment, it's OK to connect it with ODBC.The following is the code that is used.is
Original address: ArcGIS Issue: Explanation of Files of type DBF shp shx SBN SBX mdb ADF-Silent Dawn log-NetEase Bloghttp://gisman.blog.163.com/blog/static/34493388201022254341339/ These documents are explained in English as follows (can see the following Chinese explanation): Shapefile file extensions
Shp-the main file that stores the feature geometry. Required.
. shx-the index file that stores the index of the feature geometry. Required.
Tags: style blog http io ar color OS sp forUnderstand the DBF file for the first time, because there is a need to export the data and insert it into the database. Start with Excel opened it, thought it is an Excel file, think of using npoi to achieve, is obviously as a newcomer too naïve, later on someone else's blog learned that read this file there are many ways, according to different difficult to use different methods, I used the simplest one beca
Label:dbf file, cannot be saved directly as an Excel file, will lose data! You need to store the DBF data in a database and export the data to Excel from the database. Import Java.io.File; Import Java.io.FileInputStream; Import Java.io.InputStream; Import java.sql.Connection; Import java.sql.PreparedStatement; Import java.util.ArrayList; Import Java.util.HashMap; Import java.util.List; Import Java.util.Map; Import org.apache.commons.lang.ObjectUtils;
The solution for physically deleting the DBF File causes the database to fail to work properly. Because the space on the E disk where the local oracle installation is located is insufficient, the unused data file E is: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ORCL \ TCM_BM.DBF is directly physically deleted, and www.2cto.com causes normal database users to log on normally. Solution: log on to the database with the sys user and execute the command: SQL>
Article Title: script for viewing the dbf file compiled by shell. Linux is a technology channel of the IT lab in China. Includes basic categories such as desktop applications, Linux system management, kernel research, embedded systems, and open source.
Not perfect, but it's okay, and the speed is a little slow!
#! /Bin/ksh
Hd-abdA $1 | sed-n '1p' | cut-c7-70> $ HOME/tmp/FIRSTLINE $
DBFFLAG = 'awk' {print $1} '$ HOME/tmp/FIRSTLINE $'
If [$ DBFFLAG
1. Start-run, enter "Regedit" to open the registry.2. If you are using the 10.x version of ArcGIS Desktop, navigate to ' Computer \hkey_current_user\software\esri\desktop 10.x 'If it is a previous version of 9.3.1, navigate to ' My Computer\hkey_current_user\software\esri '.3, create the item ' Common ', and then create the ' CodePage ' entry under it, add ' string ', Name: Dbfdefault, health value: OEM (or 936).Note: If you install version 10.2.2, there is a 10.3 under the directory, there is a
PostgreSQL 9.3 is installed as required, before a 9.2. Database error, 9.3 version selected. The PostGIS 2.1 is then installed through the application stack bulider. Installed when you choose to create an empty database, but the installation failed repeatedly, the installation succeeded after the cancellation.After configuring the parameters for the database, select the. shp file to import, change the Srid, here in fact the srid I do not quite understand, because each srid corresponds to the cor
A solution to physically remove DBF files that cause the database to not work
Due to the lack of e-disk space in the native ORACLE installation, the E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\TCM_BM data file is not used. DBF Direct physical deletion, www.2cto.com
Causes the normal user of the database to not log on correctly.
Solution:
Log in to the database with the SYS user to execute the command:
Datagrid|xml The following source code is given in the Dbf,xls,xml,mdb file into the C#datagrid method, for you to reference.
PutInDataSet.cs's source code
Using System;
Using System.Data.Odbc;
Using System.Data.OleDb;
Using System.Data;
Using System.Collections;
Namespace Putindataset
{
Summary description of the Datasettransin.
public class Putindataset
{
File variables passed in
Private dataset my_ds;//data set for storing files
private string my
Using Java to dynamically create ODBC data sources to access DBF files requires the use of registry to modify the registry.
In fact, the main is the dynamic creation of ODBC data sources, the beginning is very simple, you can set up a data source manually, of course, can be directly generated through the program, the problem is not big. The following only say how to modify.
import com.ice.jni.registry.RegStringValue; import com.ice.jni.registry.Regi
Tags: DMI ROM file environment Leo LTE date modified ORMDisaster handling methods for Oracle data files being mistakenly deletedsteps:when the Oracle data file is mistakenly deleted after the processing Method!! 1. Close the database:sqlplus "/as sysdba";Sqlplus>shutdown abort;2. Loading the databaseSqlplus>startup Mount;3. Delete Invalid database filessqlplus>alter database datafile '/home/oracle/survey/survey.dbf ' offline dropsqlplus>alter database datafile '/home/oracle/survey/surveytemp.dbf
to the same as the previous installation path, here is "E:\oracle\product\10.2.0\db_1". At the same time, we just install the software here, the "CREATE database" before the tick off. Click Next when Setup is complete.(4) The database software is installed, open a CMD window, execute the command "Oradim-new-sid XXX" to create an instance where XXX is the previous instance name of the database. Once created, our instances are created as well. This creates an instance that needs to be started eac
1. Do not restart the DB instance2.ps-ef | grep dbw0 View ora_dbw0_ instance process ID3.cd/proc/process ID/FD can see 261-/u01/app/oracle/oradata/orcl/users01.dbf (deleted) Identity delete4.cp/proc/process ID/FD/261/U01/APP/ORACLE/ORADATA/ORCL/USERS01.DBF Copy the deleted data file back5.alter database datafile data File number offline6.recover datafile data file number;7.alter database datafile data file
Because the site of the database is still Visual FoxPro, and its own programming language is C #, can not directly access, in the online search a lot of information, finally finally found a solution in DRL, DBF database Read the problem is basically solved. Here are some notes on the process of solving this problem
1. When using "provider=microsoft.jet.oledb.12.0;", the following error is indicated:An unhandled exception of type ' System.Invalid
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.