Using SQLConfigDataSource in VB.NET doesnt work for MS text Driver

[crystalReporterNew]

Hi,
I am trying to set up a DSN for Microsoft text driver. If I write the following code, I get the error that DSN entry Failed:

intret = SQLConfigDataSource(0&, ODBC_ADD_DSN, "Microsoft Text Driver(*.txt,*.csv)", "DSN=AppliedEDSN&quot
If intret Then
MessageBox.Show("DSN Added&quot
Else
MessageBox.Show("DSN Entry Failed&quot
End If


HOwever if I replace the driver with SQL Driver or with MySQL ODBC 3.51 Driver , it adds the DSN .Can someone tell me whats wrong with the text driver? Actually the code doent work for Microsoft Access Driver(*.mdb) too

Please help
Thanks

 

[stravis]

If you transcribed the code as it is in your application, I would say that your problem is that the name of the driver is not correct. There should be a space before the parenthesis and the file list in the text driver is separated by a semi-colon not a comma. The drivers should read like the following

"Microsoft Text Driver (*.txt; *.csv)"
"Microsoft Access Driver (*.mdb)"

Hope this helps