Path: news.mathworks.com!not-for-mail
From: <HIDDEN>
Newsgroups: comp.soft-sys.matlab
Subject: jdbc with matlab
Date: Thu, 11 Oct 2007 04:23:30 +0000 (UTC)
Organization: Dixie State College of Utah
Lines: 22
Message-ID: <fek8g2$201$1@fred.mathworks.com>
Reply-To: <HIDDEN>
NNTP-Posting-Host: webapp-06-blr.mathworks.com
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit
X-Trace: fred.mathworks.com 1192076610 2049 172.30.248.36 (11 Oct 2007 04:23:30 GMT)
X-Complaints-To: news@mathworks.com
NNTP-Posting-Date: Thu, 11 Oct 2007 04:23:30 +0000 (UTC)
X-Newsreader: MATLAB Central Newsreader 785751
Xref: news.mathworks.com comp.soft-sys.matlab:432353



I want to use a sql server to store matlab data. I
downloaded sql express from microsoft and set it up. I also
set up jdbc to use with sql express and matlab. I went
through the help file and added the classpath ect. I am now
trying to connect to the database and have proved
unsuccesful, I get this message every time I try and
connect: Invalid connection

conn = database('pubs','guest','******',...
'com.microsoft.jdbc.sqlserver.SQLServerDriver',...
'jdbc:sqlserver://localhost:1433');
ping(conn);

I have tried both the querybuilder and the above code and
neither seem to work. I have two questions, Has anyone
successfully implemented jdbc with sql express? And is there
a simple way I be able to test the jdbc to ensure that the
server works properly before I connect to matlab?