-
March 20th, 2012, 09:56 PM
#1
Crystal Report not connecting to MySQL
My Project is successfully running,. it can even load the data onto my tables from MySQL database
but the problem is,. when i open my reports which is CrystalReport based,. it prompts for a Database Login,. I am using Windows 7 64bit and Visual Basic 2008 with the latest MySQL Server.
On my CrystalReport1.rpt when i click the Main Report Preview,.
ODBC (RDO) pops up asking for Data Source Selection,. i tried filling up the connection String with:
"DRIVER={MySQL ODBC 3.51 Driver};DATABASE=sms;OPTION=3; SERVER=localhost;UID=sms;PWD=sms;"
still, it asks for Connection Information
I inputted
Server: localhost
User ID: sms
Password: sms
Database: sms
when i click Finish,. there is an error telling,.
Logon Failed.
Details: IM002:[Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|