On Tuesday 03 November 2009 01:11:58 pm Ed Leafe wrote: > How about installing MsSQL Express on your machine, create a copy of > the real > DB, create the AppWizard script. Then edit the script to change the > connectinfo to allow you to connect to the real DB.
I was trying to provide a way for the poster to solve his current issue ( a work around for now). So you are responding to the wrong email right? > No, the answer is to get a better understanding of just what each > backend would need, and adjust the interface dynamically. That's why a > general "pass the kwargs" solution is not a good idea: we need to know > what the options are. I think you are trying to answer my other questions as to why my patch is not the way to go. I don't disagree that it would be nice to have a dynamic solution for each of the DB's. Passing the 'extra' via the **kwargs lacks error checking etc. But it brings up other questions. I don't think hard coding the 'extra' parameters is right. Although, it might just be just another method of the DB adapter. It's just that they (the parameters) can change depending on the version of the DB. For example SSL was not available for earlier versions of Postgres. Meaning how will Dabo know what version of the 'extra' parameter to use without making a connection. And it can't make the connection without the 'extra' parameter. I guess we could supply several different DB adapters based on the DB versions. Something a kin to the windows "Data Source Administrator" and the Drivers tab which includes all the versions. But even "Data Source Administrator" has "Other" to create the Network libraries Over time there will be plenty of changes and new features for each of the DB's Dabo supports. And then there is all the possible values for each of the 'extra' parameters i.e Postgres's SSL has four. The 'extra' parameters and the values can get complex in a hurry. Meaning a maintenance PIA. If we were talking about any other prg I'd say "sounds like we need a database" to hold all the different options and their values. Johnf _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev Searchable Archives: http://leafe.com/archives/search/dabo-dev This message: http://leafe.com/archives/byMID/[email protected]
