Topic: Windows Home SP2 and SQL 2000

[incognito]

Has anyone else had problems with this? I am about to give up. I cannot get them to work. I get something about not being able to stablish a socket connection. SP2 it's proving to be a big headache. Note this is when connecting thru JDBC.

[Ken Fitlike]

Moved to software.

[ober]

Sorry, can't help you... I've only run SQL 2K on Windows 2K.

[hans]

Make sure you have SQL authentication enabled. Sometimes people install with NT only.
Also make sure the correct network protocols are enabled.

Those are the first things to check.

[incognito]

I have SQL authentication and have tcp/ip enabled ( i even had named pipes enabled, whatever that means), it's the same setup i have on my desktop which is running XP professional without this stupid service pack. I can't get anything done now because of this SP2.

[hans]

Code?

[incognito]

it's not a code issue, because this same code is working on my desktop, but here it is anyhow

Code: [Select]




public void OpenConnection(){
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
     con = java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databaseName=phone_dir;selectMethod=cursor","sa", "");

     if(!con.isClosed())
       System.out.println("Connected to MySql succesfully");

   } catch(Exception e) {
     System.err.println("Cannot Connect Exception: " + e.getMessage());
     e.printStackTrace();
   }
}



It's a documented problem between SQL 2000 and SP2, but none of Microsofts' fixes are really helping me.

http://www.windowsitpro.com/Articles/Index.cfm?ArticleID=43777&DisplayTab=Article


You can see from these links that M$ knows about these issues, but none of their solutions really work.

[hans]

Try using the JTDS driver maybe. It's better than the M$ one anyways. I use it for all of my development with SQL Server.

http://jtds.sourceforge.net/

Have you tried uninstalling SQL Server 2K and using the 2005 Express?

[incognito]

Try using the JTDS driver maybe. It's better than the M$ one anyways. I use it for all of my development with SQL Server.

http://jtds.sourceforge.net/

Have you tried uninstalling SQL Server 2K and using the 2005 Express?

I dont' have that other version, i've thought about doing that. Let me ::clears throat:: go out and "buy" that other version.

[hans]

Mmmm. I just tried it on my XP Pro SP2 machine (with 2005 express, which it free by the way). It didn't work. Interesting. I'm going to have to look into this a bit more. I've got the MDSE version running on an XP machine where I'm working but I'm not sure if it has SP2 installed. I'll do some more testing and get back to you.

[incognito]

I am thinking about downloading sql server 2000 sp4, is it alright to jump to sp4 if i haven't installed any of the previous service packs?

[hans]

Jumping to SP4 would be fine. I just checked the machine I'm using at work and it's SP2. You just need to do those firewall things from the articles and everything should work just fine.