• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 292
  • Last Modified:

DBI files?

hello,

i'm not familar with delphi at all. the payroll department at my company switched to a new program which stores all the data in dbi and idx files. the data in those files needs to be imported into MS SQL Server 2000 everyday. i did a search online and it said that dbi files are Delphi Database Information files.  so my question is, is there any way to convert these files into a format that sql server can import?? any help is greatly appreciated.

thanks.
0
xorcrack
Asked:
xorcrack
  • 10
  • 5
  • 2
  • +2
2 Solutions
 
ILECommented:
BOUTH SQL SERVER 2000 AND DELPHI HAVE A LOT OF TOOLS TO TRENSVER DATABASES ONE TO ANOTHER
USE ENTERPRISE MANAGER FROM SQL SERVER 2000 TO ACCOMPLISH ALMOST ENY CAIND OF TRANSVER

AND U HAVE A DATAPUMP FROM DELPHI 7 WHERE U CEN EASILY TRANSVER ANY INFORMATION IN SQL SERVER (EVRY RECOGNIZED TYPE FROM DELPHI APPLICATION IS ALOWED)
0
 
xorcrackAuthor Commented:
i don't have delphi, just the dbi files. in ms sql server, under Import Data, dbi files are not listed as a type i can import
0
 
xorcrackAuthor Commented:
i don't have delphi, just the dbi files. in ms sql server, under Import Data, dbi files are not listed as a type i can import
0
[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

 
mocartsCommented:
do you know in what language is written this application? is it some web application or standalone exe? do you looked in these files with some file viewer, what data they contains?
mo.
0
 
xorcrackAuthor Commented:
im guessing its made with delphi. it is definitely a stand alone app. i opened the file with wordpad and i could read some data in it, but got mostly garbage.
0
 
ILECommented:
If you are shure is writen by delphi
then delphi tool datapump will be solution for yor problem
data pump recognize all delphi formats




if no then if u have some conection to that data like ODBC
u cen use sql tolls enterprise managerand copy from that data connection
0
 
xorcrackAuthor Commented:
what odbc driver could i use? has anyone done this before?
0
 
xorcrackAuthor Commented:
what odbc driver could i use? has anyone done this before?
0
 
ILECommented:
my english i say if u have a odbc driver who "look" in that dbi files..........
0
 
xorcrackAuthor Commented:
oh ok...i dont think there is one included with the software.
0
 
ILECommented:
if it is not too big send mi files on ile@unet.com.mk
and i will see does is writen in delphi or not
0
 
xorcrackAuthor Commented:
ok great
0
 
xorcrackAuthor Commented:
ok great
0
 
ILECommented:
there is no standard file to read this
definitly not any standard file

now the posibilites
someone intentionaly change the file extension
in that case this is not
PARADOX  i try
DBASE i try it


oh yes how i know i never hear for delphi database information files ???
like i see when i look in the hex editor that contains just information for base (headers)
i cennot see any records



0
 
Stuart_JohnsonCommented:
How big are the files, xorcrack?  What is the program called that you are trying to interface from?

To be honest, I'm betting that this file format is a proprietry format - meaning it's not a BDE or an ODBC compatible data file - it's a binary flat file.  DBI is definately not something the BDE will look at natively and it's certainly not a format I've ever heard of.

Suggestion: Contact the author/publisher of the program and ask if they can tell you what format the data files are, and if there is a header or driver available for them.

Stu.
0
 
xorcrackAuthor Commented:
stuart - i'm beginning to think that it is proprietary too. the application is Preview for a payroll company called PayChex. it's strange though, borland defines a dbi file as a Delphi Database Initialization Explorer file or something like that. i've contacted the company, so i will have to see what solution they offer. thanks.
0
 
xorcrackAuthor Commented:
the files range in size from about 8k to 500k.
0
 
Stuart_JohnsonCommented:
If you are sending ILE a file, do you want to send me one as well - gtho1971@hotmail.com (justm make it a smallish one).  Although I seriously doubt we'll be able to get much out of it if it is a proprietry file.

Keep us all informed of what the company says.

Stu
0
 
CleanupPingCommented:
xorcrack:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 10
  • 5
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now