Re: Webcat and SQL - General Comments

This WebDNA talk-list message is from

2006

It keeps the original formatting. numero = 63767
interpreted = N
texte = I am in the middle (hopefully) of getting WebDNA to work with MSSQL on OSX.Already have it working on Windows IIS with MSSQL for over a year but raninto a completely unforeseen roadblock with MSSQL from OSX -- which I nowMUST make work because of my investment in OSX servers and the WebCatlicense for OSX.Regarding Windows IIS and MSSQL, it works great. We get all the benefits ofoutside access to the data as well as front end server farming to the backend data source, No memory issues with large data sets, etc. No real issuesto speak of. Some oddities with URL'ing the sql string for LIKE searches butthat's about it.Now OSX on the other hand. I have MSSQL successfully doing queries,inserting, etc. when the code is correct. Something that I am told is notsupposed to be working. However, I do NOT have any usable copy beingreturned on errors. The only thing that is NOT working I might add. On IIS aSQL error comes back as a usable string (invalid column for example). On OSXit comes back as gobbley gook.I am working with the ODBC developer to resolve this. He in turn willprobably be trying to get some advice/support from SMSI. Quite frankly myexpectation that he will not receive much support (hasn't in the past) butam hopeful (HINT HINT) that he will receive good support from them thistime! (in case SMSI missed that I said HINT HINT)So I guess it depends on what SQL you want to use, what platform you intendto do it on, but when it works, you can do some seriously complicated SQLactions without a hiccup.HTHAlexWhen I get the OSX driver setup and working I will share the needed infowith everyone here. The cost is amazingly low (if it works) and other thanthe error BS was a simple (no unix) setup in tiger.On 1/6/06 3:01 PM, "Adam O'Connor" wrote:> I think this is the direction things will probably be going, and getting> more info on the list will possibly help me, and others, save time with> further development. Also, perhaps some of us developers could team up> and write some general functions that will make sql migration easier.> Any thoughts?> > -Adam-- Alex J McCombie ~ Alex@Adventureskies.com p:315~233~9403 Adventure Skies Interactive (ASI) "You can find it all under Adventure Skies"-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

Re: Webcat and SQL - General Comments ( "Adam O'Connor" 2006)
Re: Webcat and SQL - General Comments ( Alex McCombie 2006)
Webcat and SQL - General Comments ( "Adam O'Connor" 2006)

I am in the middle (hopefully) of getting WebDNA to work with MSSQL on OSX.Already have it working on Windows IIS with MSSQL for over a year but raninto a completely unforeseen roadblock with MSSQL from OSX -- which I nowMUST make work because of my investment in OSX servers and the WebCatlicense for OSX.Regarding Windows IIS and MSSQL, it works great. We get all the benefits ofoutside access to the data as well as front end server farming to the backend data source, No memory issues with large data sets, etc. No real issuesto speak of. Some oddities with URL'ing the sql string for LIKE searches butthat's about it.Now OSX on the other hand. I have MSSQL successfully doing queries,inserting, etc. when the code is correct. Something that I am told is notsupposed to be working. However, I do NOT have any usable copy beingreturned on errors. The only thing that is NOT working I might add. On IIS aSQL error comes back as a usable string (invalid column for example). On OSXit comes back as gobbley gook.I am working with the ODBC developer to resolve this. He in turn willprobably be trying to get some advice/support from SMSI. Quite frankly myexpectation that he will not receive much support (hasn't in the past) butam hopeful (HINT HINT) that he will receive good support from them thistime! (in case SMSI missed that I said HINT HINT)So I guess it depends on what SQL you want to use, what platform you intendto do it on, but when it works, you can do some seriously complicated SQLactions without a hiccup.HTHAlexWhen I get the OSX driver setup and working I will share the needed infowith everyone here. The cost is amazingly low (if it works) and other thanthe error BS was a simple (no unix) setup in tiger.On 1/6/06 3:01 PM, "Adam O'Connor" wrote:> I think this is the direction things will probably be going, and getting> more info on the list will possibly help me, and others, save time with> further development. Also, perhaps some of us developers could team up> and write some general functions that will make sql migration easier.> Any thoughts?> > -Adam-- Alex J McCombie ~ Alex@Adventureskies.com p:315~233~9403 Adventure Skies Interactive (ASI) "You can find it all under Adventure Skies"-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Alex McCombie

DOWNLOAD WEBDNA NOW!

Re: Webcat and SQL - General Comments

2006

Top Articles:

Related Readings: