>I'm not sure if I'm in the right group, but here goes.

>I can successfully connect to my database using the following:

>gdb.Open "PROVIDER=MSDASQL;driver={IBM DB2 ODBC
>DRIVER};LONGDATACOMPAT=1;patch1=1024;patch2=6;server=servername;dbalias=
>SAMPLE;uid=ADMIN;pwd=ADMIN"

>However, when I try to connect to the same database using Crystal
>Reports (RDC) I get the error message:

>'Microsoft OLE DB Provider for ODBC Drivers:
> [Microsoft][ODBC Driver Manager] Data source name not found and no
>default driver specified'

>Is there a way to specify a default driver?

>Crystal steps me through a series of forms where I type in my connect
>string; click 'Next'; type in login/pwd; click 'Next'; choose from a
>list of tables/views or type SQL; click 'Finish'.  I know that Crystal
>is connecting to my Db because it gives me a dropdown with table/view
>names.  When I click 'Finish', it bombs.

>Please help!

>Thanks,
>Joe

>Sent via Deja.com http://www.deja.com/
>Before you buy.

> >I'm not sure if I'm in the right group, but here goes.

> >I can successfully connect to my database using the following:

> >gdb.Open "PROVIDER=MSDASQL;driver={IBM DB2 ODBC
> >DRIVER};LONGDATACOMPAT=1;patch1=1024;patch2=6;server=servername;dbalias=
> >SAMPLE;uid=ADMIN;pwd=ADMIN"

> >However, when I try to connect to the same database using Crystal
> >Reports (RDC) I get the error message:

> >'Microsoft OLE DB Provider for ODBC Drivers:
> > [Microsoft][ODBC Driver Manager] Data source name not found and no
> >default driver specified'

> >Is there a way to specify a default driver?

> >Crystal steps me through a series of forms where I type in my connect
> >string; click 'Next'; type in login/pwd; click 'Next'; choose from a
> >list of tables/views or type SQL; click 'Finish'.  I know that Crystal
> >is connecting to my Db because it gives me a dropdown with table/view
> >names.  When I click 'Finish', it bombs.

> >Please help!

> >Thanks,
> >Joe

> >Sent via Deja.com http://www.deja.com/
> >Before you buy.