Path: news.mathworks.com!not-for-mail
From: "Karan " <ksumbaly@hotmail.com>
Newsgroups: comp.soft-sys.matlab
Subject: Re: jdbc with matlab
Date: Tue, 18 Dec 2007 08:07:28 +0000 (UTC)
Organization: Rio Tinto
Lines: 34
Message-ID: <fk7v40$32l$1@fred.mathworks.com>
References: <fek8g2$201$1@fred.mathworks.com>
Reply-To: "Karan " <ksumbaly@hotmail.com>
NNTP-Posting-Host: webapp-03-blr.mathworks.com
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit
X-Trace: fred.mathworks.com 1197965248 3157 172.30.248.38 (18 Dec 2007 08:07:28 GMT)
X-Complaints-To: news@mathworks.com
NNTP-Posting-Date: Tue, 18 Dec 2007 08:07:28 +0000 (UTC)
X-Newsreader: MATLAB Central Newsreader 897310
Xref: news.mathworks.com comp.soft-sys.matlab:442870



I dont think SQL express works with the string

'com.microsoft.jdbc.sqlserver.SQLServerDriver'

Any ideas on how one could modify this string to work for 
sql server express? 

"Steven " <burrguy.athotmailnot@msn.com> wrote in message 
<fek8g2$201$1@fred.mathworks.com>...
> 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?
> 
>  
>