Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connection or SQL sentence error

Status
Not open for further replies.

boboleft

MIS
Apr 11, 2007
55
US
Hi

When I try to run a report this error message pop up

Connection or SQL sentence error (DA0005)

Detail:
Exception: CS, Specified network layer is invalid: ODBC

Can anyone let me know what the problem is? Did I setup my MS access odbc data source incorrectly??

thanks

Connection or SQL sentence error
 
Hi,
Did you test the connection when you created it?

Is the database on the same machine as the report?



[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
how do i test a connection?? i did it via the control panel, administrative tools, datasource odbc. Yes the report is on the same machine.I am doing a BO training and the training universe is use this ODBC data source to locate the MS Access database on my c drive. I don't think the universe recognize this datasource.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top