Path: news.mathworks.com!not-for-mail
From: <HIDDEN>
Newsgroups: comp.soft-sys.matlab
Subject: Problems with SQL connectivity
Date: Thu, 9 Oct 2008 14:05:04 +0000 (UTC)
Organization: Dixie State College of Utah
Lines: 19
Message-ID: <gcl32g$aop$1@fred.mathworks.com>
Reply-To: <HIDDEN>
NNTP-Posting-Host: webapp-02-blr.mathworks.com
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit
X-Trace: fred.mathworks.com 1223561104 11033 172.30.248.37 (9 Oct 2008 14:05:04 GMT)
X-Complaints-To: news@mathworks.com
NNTP-Posting-Date: Thu, 9 Oct 2008 14:05:04 +0000 (UTC)
X-Newsreader: MATLAB Central Newsreader 785751
Xref: news.mathworks.com comp.soft-sys.matlab:494348


Hello, I am running an SQL database through sql express
2005 server. I am accessing this database on two different
machines, one machine is slower running 32bit xp and the
other is faster running 64bit xp. The sql server is
on the faster machine I access this server though ODBC.
I am running two versions of matlab on each machine
2007a and 2008a. On the 32bit machine I can access
the database fine and pull large amounts of data. On
the 64bit machine, I can access the database, but intermittently.
If you restart the machine sometimes It will pull the
whole database, but then after that it will only get
the first line, or the first 63 or 300 lines
and then quit. (the database is 60000 lines). Has anyone
had a similar problem? I can setup the ODBC exactly
the same on two different machines (even pulling from the
same IP) and get different results. I think it may
be due to connectivity issues, because the configuration worked fine
until I changed ports. Is there any way to debug
this problem?