Re: Advice for working with MS SQL Server 2000?
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