• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Advice for working with MS SQL Server 2000?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Advice for working with MS SQL Server 2000?


  • Subject: Re: Advice for working with MS SQL Server 2000?
  • From: Robert Walker <email@hidden>
  • Date: Fri, 8 Oct 2004 23:26:24 -0400

Kieran,

I have not worked with MS SQL Server with WO so I'm not completely sure how it normally handles PK generation. However, if it normally uses EO_PK_TABLE, and the plug-in does not support DB native PKs, then you will have to find or create an adaptor plug-in to use the DB PKs.

I suggest searching around for a plug-in that supports MS SQL Server native PKs. If you don't wish to delve into it yourself, maybe you could find someone to write you a plug-in to support this. I'd be surprised if one doesn't already exist somewhere.

On Oct 8, 2004, at 1:52 PM, Kieran Kelleher wrote:

I have a project where we are adding "web front-end functionality" to an existing MS SQL Server 2000 database that supports a 1-800 service. The web functionality is for customers to add more 1-800's to their account, setup mailboxes, view call history, etc.

Right now as the database stands there are primary keys defined on most of the tables, however all of the keys are "auto increment" field. I need advice from anyone with experience of WO and MS SQL Srvr 2000

- How do I get primary key generation for new records without existing EO_PK_TABLE since both my WO app and the existing C++ app will be interacting with the same tables?
- Anyone have or can point me to an EOProtoTypes model for MS SQL Server?
- Any "watch out" or "beware" advice/tips for working with MS SQL Server?


Regards, Kieran


________________________________________________________________
Dev Config = OS X 10.3.5 / Java 1.4.2_05 / WO 5.2.3 / XCode v1.5 / MySQL 4.0.20 / Connector-J 3.0.11
Deploy Config = OS X 10.3.5 Server / Java 1.4.2_05 / WO 5.2.3 / MySQL 4.0.20 / Connector-J 3.0.11
My Blog: http://webobjects.webhop.org/


_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
email@hidden


This email sent to email@hidden
--
Robert Walker
www.robertwalker1.com

"There are 10 kinds of people in the world. Those who think binary and those who don't."

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden


References: 
 >Advice for working with MS SQL Server 2000? (From: Kieran Kelleher <email@hidden>)

  • Prev by Date: Components in Packages
  • Next by Date: Re: Components in Packages
  • Previous by thread: Advice for working with MS SQL Server 2000?
  • Next by thread: WONewYork Meeting Next Wed @ Apple SOHO
  • Index(es):
    • Date
    • Thread