DataSet Error Config Wizard, colum information... ERROR [HY090] [Microsoft] [ODBC Paradox Driver] "Invalid string or buffer length"

is there better way create , edit database programatically in c#. 

i'm trying convert csv file database file add records , fields progromatically in c#.

then have seperate program edit/maintain data base.

the data starts as quatropro spread sheet converted csv sucked app dataset i'm trying dump new data base.

i'm not databases...yet.

i think may in database created start with.

we created empty paradox database 1st row of column headers , 1 row of dummy data c# form app dataset,  i'm trying open can dump data c#.

what limits?  have have @ least 1 row of valid data strings start? causing error?

heres connection string:

driver={microsoft paradox driver (*.db )};collatingsequence=ascii;dbq=c:\dev_test\acessiocsvimport\csv_import_export\data\productinfonew;defaultdir=c:\dev_test\acessiocsvimport\csv_import_export\data\productinfonew;driverid=538;fil=paradox 5.x;filedsn=c:\program files\common files\odbc\data sources\accesproductinfo.dsn;maxbuffersize=2048;maxscanrows=8;pagetimeout=5;paradoxnetpath=c:\windows\system32;paradoxnetstyle=4.x;paradoxusername=admin;safetransactions=0;threads=3;uid=admin;usercommitsync=yes

heres clip of test data in second row delphi database desktop.

first row string headers ie part numbers, costs, names, dates etc.

opps didnt paste 23 column 2 rows right 1 row headers.

thanks still learning here. ;)

...hmm maybe connection string 1 works think db file name missing in broken one?

have this.

driver={microsoft paradox driver (*.db )};collatingsequence=ascii;dbq=c:\rma\database;defaultdir=c:\rma\database;driverid=538;fil=paradox 5.x;
filedsn=c:\rma\database\rma.db.dsn;maxbuffersize=2048;maxscanrows=8;pagetimeout=5;paradoxnetpath=c:\windows\system32;paradoxnetstyle=4.x;paradoxusername=admin;safetransactions=0;threads=3;uid=admin;usercommitsync=yes

---

thanks, richard

check post:
http://social.msdn.microsoft.com/forums/en-us/adodotnetdataproviders/thread/2e35b79c-4c7e-4fdc-8474-b462679dfa08/ 

Visual Studio Languages  ,  .NET Framework  >  Visual C#