Okay so finally I could deal with it.
Here I am sharing the soln (may be its too layman thing but still
there can be more like me :D )
Steps:
1) Create your own Access Mode as following:
a> Create Database Access Mode, name it woteva u want i called it
MySqlConnector
b> Use Provider Tempate
Driver={MySQL ODBC 5.1 Driver};Server=<%Server|text
%>;Database=<%Database|database%>;
User=<%Username|text%>;Password=<%Password|password
%>;Option=3;
c> Click on OK
2) Create Server connection using this new Access Mode.
Server= localhost
Databse=<not mandatory>
User= root
Password= <woteva it is>
3) Test Database Connection
Make Sure You Do Not Try Inserting quotes in provider template.
Boom Here is the successful DB connection :)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"RedDot CMS Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/RedDot-CMS-Users?hl=en
-~----------~----~----~----~------~----~------~--~---