On Sep 30, 2008, at 8:57 PM, Shaun Higgins wrote:
I am having problems connecting Entity Modeler to SQL Server 2005
DB. I am using webobjects v5.4.3
If you have any choice in the matter, I'd choose a different
database. Any other database.
First of all I found the last two articles on this subject extremely
helpful. Each article got me closer to connecting to the database. I
had the same problem as displayed in "RE: Microsoft SQL support" http://lists.apple.com/archives/Webobjects-dev/2007/May/msg00354.html
. This corrected my Driver not found in Java Runtime error.
However, the error that I now get is: Failed to Generate SQL. No
suitable driver.
I have tried placing Microsoft the 2005 JDBC Driver (sqljdbc.jar) in
Library/Java/Extensions. Used all the versions I could find 1, 1.1,
1.2 and 2.0. All with the same result
This is the driver I use:
http://www.microsoft.com/downloads/details.aspx?FamilyID=6d483869-816a-44cb-9787-a866235efc7c&DisplayLang=en
My URL is
jdbc:sqlserver://192.168.0.4:1433;databaseName=YouNameHere
The driver is
com.microsoft.sqlserver.jdbc.SQLServerDriver
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
