When .Net first came out ODBC sup****t was not ****pped with the release
build, and you had to go to microsoft.com and download a component
which added a namespace called Microsoft.Data.Odbc. This worked fine
with Rdb, and you could use a connection string that included the
'database' keyword (e.g. "database=attach 'filename drive:[dir]root'").
With one of the later releases of .Net MS decided that ****pping ODBC
sup****t with .Net was a Good Thing and they created an "improved"
version of their ODBC package for .Net which added a namespace called
System.Data.Odbc. This does not play nicely with the Rdb "database"
keyword, complaining bitterly about the presence of single-quotes in
the connection string and refusing to connect. I've tried various ways
to work around this without success, and at present we can only connect
to Rdb database from our .Net apps by using a class which sets up
pre-defined connections. Has anyone found a *working* workaround that
allows .Net to connect to an Rdb database without using a pre-defined
connection? Any help or suggestions appreciated.
