Thread Subject: Problems with SQL connectivity

Subject: Problems with SQL connectivity

From: Steven

Date: 9 Oct, 2008 14:05:04

Message: 1 of 1

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?

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
sql Steven 9 Oct, 2008 10:05:06
sql express Steven 9 Oct, 2008 10:05:06
odbc Steven 9 Oct, 2008 10:05:06
database Steven 9 Oct, 2008 10:05:06
rssFeed for this Thread

Contact us at files@mathworks.com