Re: Adaptor Info for Microsoft SQL Server problem
Re: Adaptor Info for Microsoft SQL Server problem
- Subject: Re: Adaptor Info for Microsoft SQL Server problem
- From: "Jonathan Fleming" <email@hidden>
- Date: Fri, 01 Oct 2004 16:18:33 +0100
The trusted connection parameter is where you are set up on the server by
the admins as a trusted user using the windows authentication system
Jonathan :^)
From: Kieran Kelleher <email@hidden>
To: Jonathan Fleming <email@hidden>
CC: email@hidden, email@hidden
Subject: Re: Adaptor Info for Microsoft SQL Server problem
Date: Wed, 29 Sep 2004 13:45:13 -0400
Thanks Jonathan and Dirk .... silly me, no ping worked on the name. Using
the actual IP solved it.
By the way, what is the significance of the using the SelectMethod and
Trusted_Connection parameters with WebObjects?
-Kieran
On Sep 28, 2004, at 8:32 PM, Jonathan Fleming wrote:
try this
jdbc:microsoft:sqlserver://uspalws01:1433;DatabaseName=legacydb;
SelectMethod=cursor;Trusted_Connection=yes
HTH
Jonathan :^)
From: Dirk Bajohr <email@hidden>
To: Kieran Kelleher <email@hidden>
CC: "WebObjects (Group)" <email@hidden>
Subject: Re: Adaptor Info for Microsoft SQL Server problem
Date: Tue, 28 Sep 2004 23:11:57 +0200
Hi Kieran,
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.
just a thought: Can you ping the database server? Does the name lookup
work? Try using the IP address instead of the computer name.
Hope that helps,
Dirk
--
Dirk Bajohr
iSOLUTION - Individuelle Software fuer moderne Kommunikation
Hauptstr. 50
53757 Sankt Augustin
T +49 2241 921567-0
F +49 2241 921567-89
http://www.isolution.de
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
email@hidden
This email sent to email@hidden
_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today!
http://www.msn.co.uk/messenger
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
email@hidden
This email sent to email@hidden
___________________________________
Kieran Kelleher
SmartleadsUSA,LLC
2656 West Lake Rd
Palm Harbor, FL 34684
email@hidden
727-785-0766 x33
_________________________________________________________________
Use MSN Messenger to send music and pics to your friends
http://www.msn.co.uk/messenger
_______________________________________________
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