dbf file
-
I need my program to view data from a .dbf file but I don't want to have to use a DBMS to do so. How would I go about doing this? Parse the file myself? Or is their a better way? Kevin Shaffer kshaff03@msn.com
-
I need my program to view data from a .dbf file but I don't want to have to use a DBMS to do so. How would I go about doing this? Parse the file myself? Or is their a better way? Kevin Shaffer kshaff03@msn.com
If you are not interested in using a DBMS, then your only recourse is to process the file yourself, not a trivial task by any means. See here, here and here for file format information. Why not use ODBC? Create a DSN using the ODBC applet in Control Panel. Then you can use the
CRecordsetclass to access the data. You can also create a DSN-less connection.
"The pointy end goes in the other man." - Antonio Banderas (Zorro, 1998)
-
If you are not interested in using a DBMS, then your only recourse is to process the file yourself, not a trivial task by any means. See here, here and here for file format information. Why not use ODBC? Create a DSN using the ODBC applet in Control Panel. Then you can use the
CRecordsetclass to access the data. You can also create a DSN-less connection.
"The pointy end goes in the other man." - Antonio Banderas (Zorro, 1998)
This is my first experience with a database of any sort... My program only needs to update data from a .dbf from a cd once a month, so it doesn't have to be efficient, and no writing is needed either. I cannot distribute any software with my hardware that is not already installed on windows, for example Microsoft Access, etc. If I use ODBC, (I know very little about it now) would my program be able to access the file without having to distribute a DBMS along with my own software? Kevin Shaffer kshaff03@msn.com
-
This is my first experience with a database of any sort... My program only needs to update data from a .dbf from a cd once a month, so it doesn't have to be efficient, and no writing is needed either. I cannot distribute any software with my hardware that is not already installed on windows, for example Microsoft Access, etc. If I use ODBC, (I know very little about it now) would my program be able to access the file without having to distribute a DBMS along with my own software? Kevin Shaffer kshaff03@msn.com
kshaff03 wrote: ...and no writing is needed either. If no writing is needed, then how are you going to update the .dbf file? kshaff03 wrote: I cannot distribute any software with my hardware that is not already installed on windows, for example Microsoft Access, etc. Most drivers come preinstalled with the OS. kshaff03 wrote: If I use ODBC, (I know very little about it now) would my program be able to access the file without having to distribute a DBMS along with my own software? Most likely, yes. Newer technologies exist (e.g., ADO, DAO), but I've not had the privilege of using them. One of these days I'll give 'em a whirl, though. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vccore98/HTML/\_core\_database\_topics\_.28.odbc.29.asp http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcodbc\_drivers\_overview.asp http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/dasdkodbcoverview.asp http://support.microsoft.com/default.aspx?scid=kb;en-us;110093
"The pointy end goes in the other man." - Antonio Banderas (Zorro, 1998)
-
kshaff03 wrote: ...and no writing is needed either. If no writing is needed, then how are you going to update the .dbf file? kshaff03 wrote: I cannot distribute any software with my hardware that is not already installed on windows, for example Microsoft Access, etc. Most drivers come preinstalled with the OS. kshaff03 wrote: If I use ODBC, (I know very little about it now) would my program be able to access the file without having to distribute a DBMS along with my own software? Most likely, yes. Newer technologies exist (e.g., ADO, DAO), but I've not had the privilege of using them. One of these days I'll give 'em a whirl, though. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vccore98/HTML/\_core\_database\_topics\_.28.odbc.29.asp http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcodbc\_drivers\_overview.asp http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/dasdkodbcoverview.asp http://support.microsoft.com/default.aspx?scid=kb;en-us;110093
"The pointy end goes in the other man." - Antonio Banderas (Zorro, 1998)
DavidCrow wrote: If no writing is needed, then how are you going to update the .dbf file? Actually, I am updating a text file on the harddrive with a subscription from a cd that contains a .dbf file with the data I need. Thank you very much for all your help and advice. I was under the impression that you would have to buy Access and have it installed in order for your program to use the drivers. I guess it is time to learn some database programming! Thanks again. Kevin Shaffer kshaff03@msn.com
-
DavidCrow wrote: If no writing is needed, then how are you going to update the .dbf file? Actually, I am updating a text file on the harddrive with a subscription from a cd that contains a .dbf file with the data I need. Thank you very much for all your help and advice. I was under the impression that you would have to buy Access and have it installed in order for your program to use the drivers. I guess it is time to learn some database programming! Thanks again. Kevin Shaffer kshaff03@msn.com
kshaff03 wrote: I was under the impression that you would have to buy Access and have it installed in order for your program to use the drivers. With some databases, this might be the case, but not with Access.
"The pointy end goes in the other man." - Antonio Banderas (Zorro, 1998)