Thanks, works now. I can finally access the Microsoft DB from EntityModeler and from my D2W App.
---markus--- > On 18 Mar 2019, at 14:30, Theodore Petrosky <tedp...@yahoo.com> wrote: > > Markus, > > what about the properties?? > > from: > Class ERXConfigurationManager > > Global: > dbConnectServerGLOBAL = myDatabaseServer > dbConnectUserGLOBAL = me > dbConnectPasswordGLOBAL = secret > dbConnectPluginGLOBAL = com.webobjects.jdbcadaptor.MicrosoftPlugIn > Per Model for say model ER: > ER.DBServer = myDatabaseServer > ER.DBUser = me > ER.DBPassword = secret > ER.DBPlugin = com.webobjects.jdbcadaptor.MicrosoftPlugIn > > in my case I normally use postgresql: > > dbConnectDriverGLOBAL=org.postgresql.Driver > > I never set this EOModeler unless I have to reverse compile a database > > is this what you are looking for? > > Ted > > > >> On Mar 18, 2019, at 6:31 AM, Markus Ruggiero <mailingli...@kataputt.com >> <mailto:mailingli...@kataputt.com>> wrote: >> >> Folks, >> >> It took a while because I was busy with other things but now I have to come >> back to this topic. >> >>> On 28 Feb 2019, at 10:19, René Bock <b...@salient-doremus.de >>> <mailto:b...@salient-doremus.de>> wrote: >>> >>> Hi, >>> >>> unless you need to use ERXMigrations for schema creation, you may simply >>> use the com.webobjects.jdbcadaptor.MicrosoftPlugIn. >> >> No migrations required. >> How would I use the plug-in? Possibly silly question, but when I create an >> EOModel I cannot specify the plug-in to use (MSSQL is not in the popup list) >> and therefore I have no prototypes available. I might be missing something >> here simply because it's possibly too trivial and everything has always >> worked out of the box so far. >> >> Thanks for some hand holding >> ---markus--- >> >>> >>> If you need ERXMigrations, things become bit hairy, since Microsoft did >>> some strange sql extensions: >>> >>> utf-8 Support: varchar don't support UTF-8 characters. You have to use >>> nvarchar, ntext, columns if you need to store utf-8 characters >>> text-bolb: text (and ntext) are deprecated. Microsoft encourage to use >>> varchar(MAX), which is not really standard sql :-( At least I wasn't able >>> varchar(max) text blobs using the default EOSchemaGeneration mechanism. >>> >>> Chuck once did write an (experimental) ERXMicrosoftPlugIn, to address >>> migration-support. Unfortunately, didn't find it's way into WOnder. >>> Fortunately I got a copy of chucks plugin and added the nvarchar/ntext >>> migration support. But my implementation required some changes in >>> ERPrototypes, which are not backward compatible... >>> >>> >>> >>>> Am 27.02.2019 um 10:40 schrieb Markus Ruggiero <mailingli...@kataputt.com >>>> <mailto:mailingli...@kataputt.com>>: >>>> >>>> We are about to get a new project but the customer requires the >>>> application to run against an existing Microsoft SQL Server (version not >>>> yet known). When I create a new EOModel there is no selection for an MS >>>> SQL Server plug-in. No support in Wonder for Microsoft? >>>> >>>> Does anyone have experience running a Wonder App against a Microssoft >>>> database? >>>> >>>> Please help and advise >>>> ---markus--- >>>> >>>> _______________________________________________ >>>> Do not post admin requests to the list. They will be ignored. >>>> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com >>>> <mailto:Webobjects-dev@lists.apple.com>) >>>> Help/Unsubscribe/Update your Subscription: >>>> https://lists.apple.com/mailman/options/webobjects-dev/bock%40salient-doremus.de >>>> >>>> <https://lists.apple.com/mailman/options/webobjects-dev/bock%40salient-doremus.de> >>>> >>>> This email sent to b...@salient-doremus.de <mailto:b...@salient-doremus.de> >>> >>> Mit freundlichen Grüßen >>> >>> René Bock >>> >>> -- >>> Telefon: +49 69 650096 18 >>> >>> salient GmbH, Lindleystraße 12, 60314 Frankfurt >>> Telefon Zentrale: 069 / 65 00 96 - 0 | www.salient-doremus.de >>> <http://www.salient-doremus.de/> >> >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com >> <mailto:Webobjects-dev@lists.apple.com>) >> Help/Unsubscribe/Update your Subscription: >> https://lists.apple.com/mailman/options/webobjects-dev/tedpet5%40yahoo.com >> <https://lists.apple.com/mailman/options/webobjects-dev/tedpet5%40yahoo.com> >> >> This email sent to tedp...@yahoo.com >
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com