June 18, 2003 at 9:59 pm
At our company we have migrated some of our desktops to XP professional. However i am getting users coming to me saying that the connection to the SQL server (2k) is broken. Sometimes reconnecting sometimes not? any ideas on this. Not sure if this is the right forum for this
FACTS
Client = XP professional
connects to server via ODBC link
SERVER = 2000 server SP3
SQLserver 2000 - No SP's yet
I have checked user permissions/rights. Roles etc but cannot see the issue
I will be installing the SP's on the SQLserver in a couple of weeks as a last resort
Just wondering if there are any tricks of the trade with XP that need to be done to ensure 99% connection up time. !
thanks in advance !
------------------------------
Life is far too important to be taken seriously
June 19, 2003 at 12:06 am
It could be an MDAC issue. For instance there are known issues going from MDAC 2.5 to 2.6/2.7. What are the pre-XP and XP MDAC versions and service packs?
Cheers,
- Mark
June 19, 2003 at 9:26 am
Or it could be coding errors or network problems. I've been running XP, as are some others here and while we don't constantly make ODBC connections, I use QA, which does run the OLEDB DLLs, which is probably what your clients are running and I don't have dropped connection issues.
Steve Jones
June 19, 2003 at 5:25 pm
I use XP Pro everyday, no issues connecting to SQL2K SP3.
Andy
June 22, 2003 at 5:23 pm
Hi MDACs have been checked and we have upgraded MDACS to the pre XP machines to XP standard and they still work but the XP's dont. Maybe I need to get back to basics again with the XP machines and recheck everything... I suppose i was just wanting to make sure that there are no known XP issues with SQL !
Thanks very much for your time!
------------------------------
Life is far too important to be taken seriously
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply