Thread Subject: Linking MySQL using VQB

Subject: Linking MySQL using VQB

From: Gurudath Vashist

Date: 20 Mar, 2010 22:35:04

Message: 1 of 4

Hey

I have a MySQL database on godaddy.com. I have all the details necessary. I am following all the instructions on the documentation provided with MATLAB. But i consistently get a "JDBC Driver error:name.Driver not found/loaded" when i try to define JDBC data source
I get a dialog for entering my uname and pwd. I'm sure i got that right. even then, this error pops up
this is what i enter:
name-->name of my database
driver-->location of the driver on my hard disk
url-jdbc:mysql://biomsuite.db.5027900.hostedresource.com:3306(hostwithportno.)/nameofmydatabase
also, do I just have to add the location of the driver into classpath.txt or is there more to it?
This is a very urgent requirement. My entire algorithm is based on my ability to get this data into matlab. pls help me out
What am I doing wrong?

Subject: Linking MySQL using VQB

From: Oleg Komarov

Date: 20 Mar, 2010 23:02:05

Message: 2 of 4

> driver-->location of the driver on my hard disk
> also, do I just have to add the location of the driver into classpath.txt or is there more to it?

Type javaclasspath and check that you added correctly the path to the driver.
Second, you don't supply the location of the driver but the drirer name as shown in the documentation.

oleg

Subject: Linking MySQL using VQB

From: Gurudath Vashist

Date: 20 Mar, 2010 23:20:04

Message: 3 of 4

how do i add the path correctly and where do i type javaclasspath?
(I'm sorry if this might seem trivial, but i dont know)
I also have ODBC drivers installed. It cant connect either. ODBC seems simpler as it recognizes my driver.

Thanks for all the help

Subject: Linking MySQL using VQB

From: Oleg Komarov

Date: 22 Mar, 2010 08:05:09

Message: 4 of 4

"Gurudath Vashist" <guru_dath_in@yahoo.com> wrote in message <ho3l74$o4u$1@fred.mathworks.com>...
> how do i add the path correctly and where do i type javaclasspath?
> (I'm sorry if this might seem trivial, but i dont know)
> I also have ODBC drivers installed. It cant connect either. ODBC seems simpler as it recognizes my driver.
>
> Thanks for all the help

Check this out: http://www.mathworks.com/access/helpdesk/help/toolbox/database/ug/bre07n6.html

I find it very selfexplanatory, sure more than I could do.

Hope it helps.

Oleg

Tags for this Thread

Everyone's Tags:

Add a New Tag:

Separated by commas
Ex.: root locus, bode

What are tags?

A tag is like a keyword or category label associated with each thread. Tags make it easier for you to find threads of interest.

Anyone can tag a thread. Tags are public and visible to everyone.

Tag Activity for This Thread
Tag Applied By Date/Time
database toolbox Gurudath Vashist 20 Mar, 2010 18:39:05
visual query bu... Gurudath Vashist 20 Mar, 2010 18:39:05
sql Gurudath Vashist 20 Mar, 2010 18:39:05
mysql Gurudath Vashist 20 Mar, 2010 18:39:05
odbc Gurudath Vashist 20 Mar, 2010 18:39:05
jdbc Gurudath Vashist 20 Mar, 2010 18:39:05
import Gurudath Vashist 20 Mar, 2010 18:39:05
rssFeed for this Thread

Contact us at files@mathworks.com