hotshottools
asked on
Using a file DSN with an OleDbConnection
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I'll give that a shot later today (It sounds like it will)