• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Adaptor Info for Microsoft SQL Server problem
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Adaptor Info for Microsoft SQL Server problem


  • Subject: Adaptor Info for Microsoft SQL Server problem
  • From: Kieran Kelleher <email@hidden>
  • Date: Tue, 28 Sep 2004 16:47:55 -0400

I have to do a project with a legacy Microsoft SQL Server 2000 database. The database is running on a PC. I am on Mac.

In EO Modeler, I have set the connection info as follows, but I keep getting the error show below:
User: userid
Password: password
URL: jdbc:microsoft:sqlserver://uspalws01:1433; Databasename=legacydb

where uspalws01 is the name of the PC and the database name is legacydb

This is the error I get

[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

I have the latest jars from Microsoft, namely mssqlserver.jar, msbase.jar and msutil.jar installed in
/Library/Java/Extensions


and my permissions seem OK.
[KieranMac:/Library/Java/Extensions] kieran% ls -al
total 5704
drwxr-xr-x 13 root admin 442 20 Sep 11:14 .
drwxrwxr-x 5 root admin 170 24 Sep 2003 ..
-rw-rw-r-- 1 root admin 68369 11 Oct 2002 OpenBaseJDBC.jar
-rw-r--r-- 1 root admin 54829 23 Aug 09:47 activation.jar
-rw-r--r-- 1 root admin 1101593 23 Aug 09:43 axis.jar
lrwxr-xr-x 1 root admin 41 15 Sep 14:31 frontbasejdbc.jar -> /Library/FrontBase/Java/frontbasejdbc.jar
-r--r--r-- 1 root admin 344516 22 Aug 11:58 mail.jar
-rwxr-xr-x 1 root admin 303185 28 Aug 2003 msbase.jar
-rwxr-xr-x 1 root admin 71033 28 Aug 2003 mssqlserver.jar
-rwxr-xr-x 1 root admin 366737 28 Aug 2003 msutil.jar
-rw-r--r-- 1 root admin 242323 29 Feb 2004 mysql-connector-java-3.0.11-stable-bin.jar
-rw-r--r-- 1 root admin 232498 23 Aug 09:40 soap.jar
-rw-r--r-- 1 root admin 109356 23 Aug 09:45 wsdl4j.jar


Any suggestions please?

Regards, Kieran

________________________________________________________________
Dev Config = OS X 10.3.4 / Java 1.4.2_05 / WO 5.2.3 / XCode v1.5 / MySQL 4.0.20 / Connector-J 3.0.11
Deploy Config = OS X 10.3.4 Server / Java 1.4.2_05 / WO 5.2.3 / MySQL 4.0.20 / Connector-J 3.0.11
My Blog: http://webobjects.webhop.org/

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

  • Follow-Ups:
    • Re: Adaptor Info for Microsoft SQL Server problem
      • From: Dirk Bajohr <email@hidden>
  • Prev by Date: [ANNOUNCEMENT] WebObjects Development Training
  • Next by Date: Re: Adaptor Info for Microsoft SQL Server problem
  • Previous by thread: Re: [ANNOUNCEMENT] WebObjects Development Training
  • Next by thread: Re: Adaptor Info for Microsoft SQL Server problem
  • Index(es):
    • Date
    • Thread