
Crystal Reports - No default driver specified???
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.*-*-*.com/
Before you buy.