"Guy" <noSpam_guyj@cox.net> wrote in message
news:e7Mcf2LUDHA.2220@TK2MSFTNGP11.phx.gbl...
> I'm having a problem with setting the connection string in the new
> System.Data.Odbc namespace. I have previously used the
Microsoft.Data.Odbc
> namespace successfully. Now when I attempt to use the exact same
connection
> string it fails with an error:
> System.ArgumentException: Format of the initialization string does not
> conform to specification starting at index XXX
>
> Index XXX is the location of the DATABASE parameter of the following
connect
> string:
> DRIVER={Oracle ODBC Driver for Rdb};UID=guy; Pwd=xyz123; DATABASE=attach
> 'filename DB_RDB'; TLO=0; DSO=0; DBA=W; CSO=2; XPT=2; CLS=generic;
> SVR=DBServerName
>
> The new Odbc appears to not like the quoted attach 'filename DB_RDB'
> statement which is required for this to work with this database. I'm
> guessing that the ' is what is bugging the ConnectionString parser.
>
> The database is an Oracle RDB database running on an OpenVMS server.
>
>
>