Adaptor Info for Microsoft SQL Server problem
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