Re: MS SQL Server2000 EOModel Connection Problem
Re: MS SQL Server2000 EOModel Connection Problem
Jonathan,
I still don't think the issues you are reporting are related to EOModeler. I
ran into same exact issues with JDBC connection from my own java swing app.
The only default user connection I could connect to Northwind was:
jdbc.microsoft.sqlserver://10.1.1.254/DatabaseName=Northwind;User=sa;Passwor
d=sa
Feel free to contact me offlist if you are still having trouble.
Enjoy,
Brian
=================================
Brian McDerment
email@hidden
Asst. Circulation Product Manager
Harris & Baseview
http://www.baseview.com
http://www.jazbox.com
>
> Message: 1
> From: "Jonathan Fleming" <email@hidden>
> To: email@hidden, email@hidden,
> email@hidden
> Subject: MS SQL Server2000 EOModel Connection Problem
> 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=curso
> r;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=pass
> word
>
> 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=c>
u
> 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.