Problems with SQL connectivity

Steven — Thu, 09 Oct 2008 14:05:04 -0400

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?

MATLAB Central Newsreader - Problems with SQL connectivity

Problems with SQL connectivity