Re: [webobjects-newbies] MS SQL Server2000 EOModel Connection Problem
Re: [webobjects-newbies] MS SQL Server2000 EOModel Connection Problem
- Subject: Re: [webobjects-newbies] MS SQL Server2000 EOModel Connection Problem
- From: "Jonathan Fleming" <email@hidden>
- Date: Sun, 25 May 2003 13:41:08 +0100
having used the connection below as set out in EOModeller dialog box,
USER=sa
PASSWORD=xxxxxxxx
URL=jdbc:microsoft:sqlserver://192.168.0.4\\DEVBOXSQLSERVER:1433;DatabaseName=JandM;SelectMethod=cursor
DRIVER=Empty
PLUGIN=Empty
I no longer get an error message such as these:
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection.
but when I go to to the Menu, Property > Generate SQL I get
com.Microsoft..jdbc.sqlserver.SQLServerDriver come up in a dialog box with
an OK button, I click OK and all seems well still. No errors reported.
I then click the Tables button in the Generate SQL Dialog box and I can see
these tables: dbo.dtproperties, dbo.sysconstraints, dbo.syssegments,
however, when i click Execute SQL to create a table with primary and foriegn
key constraints, I get the error message below:
An unexpected error has occurred which may cause EOModeler to malfunction.
You may want to save copies of your open documents and quit EOModeler.
Error: java/lang/IllegalArgumentException:
com.Microsoft..jdbc.sqlserver.SQLServerDriver
Stack Trace:
java.lang.IllegalArgumentException:
com.Microsoft..jdbc.sqlserver.SQLServerDriver
at JDBCContext.connect(Compiled Code)
at JDBCContext._tryConnect(JDBCContext.java:246)
at JDBCContext._fetchJDBCInfo(Compiled Code)
at JDBCPlugIn.jdbcInfo(JDBCPlugIn.java:848)
at MicrosoftPlugIn.jdbcInfo(MicrosoftPlugIn.java:66)
at JDBCAdaptor.jdbcInfo(JDBCAdaptor.java:228)
at JDBCExpressionFactory.createExpression(JDBCExpressionFactory.java:22)
at
EOSQLExpressionFactory.expressionForEntity(EOSQLExpressionFactory.java:67)
at
EOSynchronizationFactory._expressionForEntity(EOSynchronizationFactory.java:984)
at EOSynchronizationFactory.createTableStatementsForEntityGroup(Compiled
Code)
at EOSynchronizationFactory.createTableStatementsForEntityGroups(Compiled
Code)
at EOSynchronizationFactory.schemaCreationStatementsForEntities(Compiled
Code)
at EOSynchronizationFactory.schemaCreationScriptForEntities(Compiled Code)
I feel close to a fix here but I could also be so very far away too.
Is there anyone out there who is working over this weekend that can help?
Regards
Jonathan :^|
From: "Ruenagel, Frank" <email@hidden>
To: "'email@hidden'" <email@hidden>
Subject: Re: [webobjects-newbies] MS SQL Server2000 EOModel Connection
Problem
Date: Sat, 24 May 2003 15:40:29 +0200
Hm. I have no problems with SQL Server (except with stored provedures with
the new ms driver)
Do you have tried to connect to the server via SQL-"QueryAnalyzer"
(isqlw.exe)
from the remote machine? Does it work?
Are there any proxys in between?
Is SQL-Server authentication (under Security->Logins in Enterprise Manager)
enabled?
Are you able to connect with the user 'sa' (=Admin)?
-----Urspr|ngliche Nachricht-----
Von: Jonathan Fleming [mailto:email@hidden]
Gesendet: Samstag, 24. Mai 2003 14:52
An: email@hidden; email@hidden;
email@hidden
Betreff: [webobjects-newbies] MS SQL Server2000 EOModel Connection
Problem
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=cur
sor;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=pa
ssword
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
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Get A Free Psychic Reading! Your Online Answer To Life's Important
Questions.
http://us.click.yahoo.com/Lj3uPC/Me7FAA/CNxFAA/nhFolB/TM
---------------------------------------------------------------------~->
To unsubscribe from this group, send an email to:
email@hidden
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
_________________________________________________________________
On the move? 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.