configure maria db to create crystal report (to get values from phpmyadmin to make crystal reports)

'MUST' download version 2 of maria db connector (if it is 32 bit it will be helpful even your laptop supports 64bit) from https://mariadb.com/downloads/?showall=1&tab=connectors&group=mariadbconnectors&product=ODBC%20connector#connectors


go to control pannel > Administrative tools >ODBC Data Sources (32-bit)
then 
go to System DSN
add new
select mariodb  odbc 2.0 driver 

give a custom name like test or what ever you want

add your server name
add the user name and password of PHPMyAdmin login

then select your database

next, all the rest of the interfaces then finish


now go to the visual studio
create a crystal report then go to field explorer
select database explorer
right-click and select the database expert
then create new connection
select OLE DB (ADO)

now add Microsoft OLE DB ODBC provider for ODBC driver
now select the name of your created System DNS name (ex: test)

give your User name and password of PHPMyAdmin login
then finish

keep in mind to download the version two it does not support for other versions

Comments

Post a Comment

Popular posts from this blog

Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]:

Image
 Error: org.springframework.beans.factory.BeanCreationException : Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Invocation of init method failed; nested exception is org.hibernate.service.spi.ServiceException : Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] org.hibernate.boot.registry.selector.spi.StrategySelectionException : Unable to resolve name [org.hibernate.dialect.MYSQL5InnoDBDialect] as strategy [org.hibernate.dialect.Dialect] in my case, it was caused by this  spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MYSQL5InnoDBDialect instead of that you may use spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5Dialect The difference between MYSQL5InnoDBDialect and MYSQL5Dialect can be found by referring to this link : https://stackoverflow.com/questions/4368195/hibernate-w...
Read more

"status": 404, "error": "not found", "message": "no message available", "path": "/api/employee"

Image
  first, make sure the YourController.java file that has the @Controller and the YourSpringBootFile.java file that has the @SpringBootApplication are in the same package. If you want your controller to be in a different package outside of YourSpringBootFile.java's package, then follow these instructions =  Spring: Run multiple "SpringApplication.Run()" in application main method There are 2 methods to overcome this Place the bootup application at the start of the package structure and rest all controllers inside it. Example : package com.spring.boot.app; - You bootup application(i.e. Main Method -SpringApplication.run(App.class, args);) You Rest Controller in with the same package structure Example: package com.spring.boot.app.rest; Explicitly define the Controller in the Bootup package. Method 1 is more cleaner. referred to:  https://stackoverflow.com/questions/31318107/spring-boot-cannot-access-rest-controller-on-localhost-404 https://stackoverflow.com/questions/3413520...
Read more