MS SQL Server2000 EOModel Connection Problem
MS SQL Server2000 EOModel Connection Problem
- Subject: MS SQL Server2000 EOModel Connection Problem
- From: "Jonathan Fleming" <email@hidden>
- Date: Sat, 24 May 2003 13:51:52 +0100
Hi Guys, happy days,
Using two different connection with and without the user and password
appended I am having problems establishing a connection to MS SQL Server
2000.
Can any one who uses this database direct me where i am going wrong? I've
only just started using this and know very little about it, but getting
connected to the thing would be a big step forward.
I'm reading the documentation for MS SQL Server 2000 but it's started to get
all jumbled in my head (information overload), if someone can give me some
guided steps on what to set for a connection or to simply correct my problem
I would appreciate it very much.
Thanks Jonathan :^)
ps. I have already created a new database using the SQL Server Enterprise
Manager
and by default it sets a User by name of dbo with Login Name of
SILVER-BACK\Jonathan and Database Access set to permit.
Below is what happens when i use this connection:
jdbc:microsoft:sqlserver://10.0.0.1:1433;DatabaseName=JandM;SelectMethod=cursor;User=dbo;Password=myPassword
When I go to set Adaptor Info on the Model menu of the EOmodeller
Application:
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
When I go to generate the SQL in EOModeller:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection.
Below is what happens when i use this connection:
jdbc:microsoft:sqlserver://SILVER-BACK\\DEVBOXSQLSERVER;User=dbo;Password=password
When I go to set Adaptor Info on the Model menu of the EOmodeller
Application or When I go to see if I can generate the SQL in EOModeller, I
get this error message:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection.
Somehow i'm not connecting to the database properly but the adapteor seems
to be working now though i still would like to know what this means which I
got from the command line tool by the given script:
C:\>Javap com.microsoft.jdbc.sqlserver.SQLServerD
river
No sourcepublic class com.microsoft.jdbc.sqlserver.SQLServerDriver extends
com.m
icrosoft.jdbc.base.BaseDriver {
static {};
public com.microsoft.jdbc.sqlserver.SQLServerDriver();
public static void main(java.lang.String[]);
}
BTW I can't even connect to Northwind example db with this:
jdbc:microsoft:sqlserver://10.0.0.1:1433;DatabaseName=Northwind;SelectMethod=cu
rsor;[with or without User=guest appended]
I get the same connection error messages as above, yet that has guest user
permitted.
_________________________________________________________________
Get Hotmail on your mobile phone http://www.msn.co.uk/msnmobile
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.