Coldfusion Datasource issues
I have created the system DSN and as well User DSN on my system control panel successfully by ODBC Connector against MySQL 8 server DB. now i want to use this this database on my ColdFusion server and for this i am creating the Data-source on my ColdFusion server. But there showing errors . Please guide me that how can i use this database or DSN on my ColdFusion server and what type of driver i have to select in ColdFusion administration for creating Data-source .
Thanks In advance!
Thanks In advance!
I'd recommend using JDBC. You can find complete instructions here.
In case the link breaks, a summary of the instructions - download a recent JDBC driver, at least 5.1.46 or higher. Copy the jar into WEB-INF/lib and restart the CF service. Then create a DSN of type "Other" and enter these settings:
Though for better security, don't use "root". Instead, create a new user account with the right permissions and use that for the DSN.
In case the link breaks, a summary of the instructions - download a recent JDBC driver, at least 5.1.46 or higher. Copy the jar into WEB-INF/lib and restart the CF service. Then create a DSN of type "Other" and enter these settings:
* CF Data Source Name: YourDatasourceName
* JDBC URL: jdbc:mysql://127.0.0.1:3306/YourData baseName
* Driver Class: com.mysql.jdbc.Driver
* Driver Name: com.mysql.jdbc.Driver
* User name: root
* Password : (your password)
Though for better security, don't use "root". Instead, create a new user account with the right permissions and use that for the DSN.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you sir so much i got fixed the problem by the help of your suggestion and tips. God may Bless upon you
You're welcome. Glad it helped :-)
Are you required to use ODBC? Typically, JDBC is preferred.