Problems with ADO and r/w access to csv files
-
I am trying to createn an app in VB6.0 and Win98 to edit a simple csv (comma separated values)-file. The csv is not very big, so memory is no problem. But I wanted to make life easy by using SQL-commands, so I decided to use ADOdc and MSHFlexGrid(e.g.) I figured out some solutions, but noone works. If somebody could help me to get just one to work I would be glad. (I thought using ADO woudl be RAD, but if I needed a long time to understand that db-Stuff. If I not succeed fastly, I will use a ListView and populate it "by hand" :( ) First Idea: (Without ADO) MSData-Control and MSDBGrid. I can display the Data in the Grid. ok. But when I try to edit the data I get: "[Microsoft][ODBC Text Driver] ISAM doesn't support updating Data in a connected Tabel" (or sth like this, I translate from German) 1) How to solve this? 2) What (the hell) ist ISAM? Second Idea: (With ADO) ADOdc: Provider: MS OLE DB Provider for ODBC Drivers, ADOdc: DataSource Name: Text-Files ... ADOdc: Test connection: ok! But also same message like above after editing: "[Microsoft][ODBC Text Driver] ISAM doesn't support updating data in a connected Tabel" (or sth like this, I translate from German) (MY FAVOURITE IDEA!!) 1) (Questions like above) Another idea: creating a db1.mdb (MS Access), creating a macro to import the my.csv, creating another macro to export it. Idea: Start Import, then access the mdb by ADOdc-control, finally export. 1) How to get rid of fixed path in MS Access file-import? 2) The .mdb-File can be used without MS Access installed on the machine. Am I right? 3) How can I start MS-Access-macros from my VB app?? And another idea: .udl | Provider "OLE DB for MS Directory Services" has worked with MSData Control, but just under W2K. In W98 the checkboxes for "Share Deny None" etc are greyed, and it doesn't work. 1) Whats MS Directory Services? (This "Active Directory??) 2) Does this work on WinNT? (its the SYS to run on) Are there some "Packets" to install "MS Directory Services" to get it to work? My last idea: Do some registy-manipulation (I havn't done yet and want to avoid this): http://support.microsoft.com/default.aspx?scid=kb;de;245524 Friedrich