I'm looking for a connection string for a file DSN to be used from an OleDbConnection
I have no problem in setting up the connection string for UDL files or connecting to CSV, XLS or MDB but I'm having a problem with DSN.
The DSN will be built by the user so I'll only know the name of the DSN file and not what database they are connecting to.
If I just put in ==> FILEDSN=c:\myData.dsn; to the connection string I get an error saying that it requires a Provider.
I'm using VS 2005 coding in VB for .NET Framework 2.0