Re: MS SQL Server2000 EOModel Connection Problem
Re: MS SQL Server2000 EOModel Connection Problem
Jonathan,
I can't get connection string to work with the "\\MYSQLSERVER" part (and
don't know enough about NT to understand this part) and don't bother putting
in port because 1431 is the default and works without it. When I do get
connected, I do see several errors that I think are the same as what you are
seeing.
When you create a New model, make sure to de-select the system 'dbo' tables
and then create your user tables and that should eliminate your errors
generating the SQL from EOModeler.
Enjoy,
Brian
=================================
Brian McDerment
email@hidden
Asst. Circulation Product Manager
Harris & Baseview
http://www.baseview.com
http://www.jazbox.com
> From: "Jonathan Fleming" <email@hidden>
> Date: Tue, 27 May 2003 17:18:26 +0100
> To: email@hidden
> Cc: email@hidden, email@hidden
> Subject: Re: MS SQL Server2000 EOModel Connection Problem
>
>
>
>> From: "brianmac@baseview" <email@hidden>
>> To: "email@hidden" <email@hidden>
>> Subject: Re: MS SQL Server2000 EOModel Connection Problem
>> Date: Tue, 27 May 2003 11:08:09 -0400
>>
>> 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
>
> I've got past this bit happily, however, Brian,
>
> I have now managed to developed another problem which again is seemingly to
> do with
> EOModeller not working properly:
>
> 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;DatabaseNam
> e=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)
>
>
> And since this I have set the three .jar files that are supplied for MS SQL
> Server 2000 driver in the
> Apple\Library\Java directory
>
> msbase.jar
> msutil.jar
> mssqlserver.jar
>
> So the javaConfig.plist looks like like this:
>
> {
> Vendor = sun;
> sun = {
> VM = "$NEXT_ROOT/Library/JDK/bin/java.exe";
> DefaultClasspath =
> "$HOME/Library/Java;$NEXT_ROOT/Local/Library/Java;$NEXT_ROOT/Library/Java;$NEX
> T_ROOT/Library/JDK/lib/classes.zip;$NEXT_ROOT/Library/Frameworks/JavaVM.framew
> ork/Classes/awt.jar;$NEXT_ROOT/Library/JDK/lib/swingall.jar";$NEXT_ROOT\Librar
> y\Java\msbase.jar;$NEXT_ROOT\Library\Java\msutil.jar;$NEXT_ROOT\Library\Java\m
> ssqlserver.jar;
> DefaultBeanpath =
> "$HOME/Library/JavaBeans;$NEXT_ROOT/Local/Library/JavaBeans;$NEXT_ROOT/Libra
> ry/JavaBeans";
> Compiler = "$NEXT_ROOT/Library/JDK/bin/javac.exe";
> Headers = "$NEXT_ROOT/Library/JDK/include
> $NEXT_ROOT/Library/JDK/include/winnt";
> Library = "$NEXT_ROOT/Library/JDK/lib/javai.lib";
> DebugLibrary = "$NEXT_ROOT/Library/JDK/lib/javai_g.lib";
> };
> }
>
> However, since restarting the machine I get these errors now:
>
> If I go to Set Adaptor Info... in the Model menu, it's greyed out. I also
> now get the error below if I try to use Switch Adaptor in the Model Menu and
> Generate SQL in the property menu is greyed out too:
>
> Error Message:
> Unable to load the JDBC adaptor: classForAdaptorNamed:: Unable to load the
> bundle for the adaptor named JDBC. The possible causes for this error are:
> the adaptor executable cannot be dynamically linked into your application,
> you are on PDO and have not linked the adaptor into your application, or the
> adaptor executable is not present on your host.
>
> Is the classpath set correctly? or is this something esle?
>
> Is anyone using WO5.2.1 on a Window 2000 platform connecting a MS SQL Server
> 2000 (Developer Edition) using the standard JDBC supplied by Microsoft with
> WO5.2.1 and able to create their database tables etc using EOModeller?
> If so how did you get this thing working?
>
> For this driver Microsoft say:
> The following versions of SQL Server will be supported for use with the SQL
> Server 2000 Driver for JDBC SP1:
>
> SQL Server 2000 with Service Pack 1 or higher
> The SQL Server 2000 Driver for JDBC is supported on the following operating
> systems:
> Microsoft Windows. XP
> Microsoft Windows 2000 with Service Pack 2 or higher
> AIX
> HP-UX
> Solaris
> Linux
> The following versions of the JDK will be supported for use with the SQL
> Server 2000 Driver for JDBC:
> JDK 1.1.8
> JDK 1.2
> JDK 1.3
>
>
> Jonathan :^/
>
>>
>> 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
>
> _________________________________________________________________
> Find a cheaper internet access deal - choose one to suit you.
> http://www.msn.co.uk/internetaccess
_______________________________________________
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.