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

"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

There was an unexpected error (type=Not Found, status=404). No message available in Springboot

Image
 in my scenario, it was because I missed one of the dependencies. I referred to this :  https://stackoverflow.com/questions/36819277/issue-with-spring-there-was-an-unexpected-error-type-not-found-status-404 and got fixes it by adding the bellow code piece in pom.xml.           <dependency>         <groupId>org.apache.tomcat.embed</groupId>         <artifactId>tomcat-embed-jasper</artifactId>         <scope>provided</scope>     </dependency>     <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-thymeleaf</artifactId> </dependency>
Read more