Re: MSSQL - ODBC - OSX
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 63608
interpreted = N
texte = Hi Alex WebDNA can only connect to MySQL over ODBC. This is a direct info= rmation from Le from SmithMicro. I have been pushing and yelling at Scott and others to support ot= her databases but so far have had unfortunately no success. Sorry, to give you no better news. Nitai -- eContentPark - Enterprise Asset Management System eServices - The complete SupportSuite eSurvey - Online Questionnaire made easy Redakto CMS - Content Management that simply works ComputerOil=C2=AE AG Neugutstrasse 66 8600 D=C3=BCbendorf / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.com > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On B= ehalf Of > Alex McCombie > Sent: Mittwoch, 14. Dezember 2005 21:23 > To: WebDNA Talk > Subject: MSSQL - ODBC - OSX > > Just checking in again since there has been no replies at all := -( > I have tried to follow the information at: > http://webdna.smithmicro.com/ref/UNIXODBCSetup.html > > But the problem is this was written for MySQL and I using (or t= rying to) > MSSQL. > > In fact I am using a MSSQL driver that can be found here: > http://www.actualtechnologies.com/download.php > Actual SQL Server 1.17 Microsoft SQL Server and Sybase > > > I am at a loss. The ODBC connects quickly but I cant get past t= he SQL not > Supported error. I don't mind going off this route and going th= e unixODBC > route but unfortunately the instructions provided are pretty sp= ecifically > customized for MYSQL and I admittedly am not comfortable enough= to ad-lib. > My attempts to do that (below) havent yeilded any success. > > > Can I get Scott or someone to drop me an email to see what I ca= n do to get > the supported feature working. > > Thanks > Alex > > > > > > > > > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D > I have webstar 5.4.1 running with > unix-Macintosh OS X WebSTAR V Plug-in version 6.0 > > Everything is working OK except I cant get this damn ODBC confi= gured. > > > In my library for the user account I have the ODBC.ini file wit= h the > following installed: > /Library/ODBC/Actual SQL Server.bundle/Contents/MacOS/atsqlsrv.= so > > Which was installed using the add feature of the ODBC manager o= n tiger. > The > manager confirms the connection to the MSSQL server without iss= ue but > webcat > returns the dreaded SQL not Supported error. > > > I have modified my weccatalog pref file to say > SQLLibraryPath /Library/ODBC/Actual SQL > Server.bundle/Contents/MacOS/atsqlsrv.so > > Which I believe to be the write thing to do. > Restarted and still the error. > > Now, first I thought that modifying the pref file with this pat= h would > essentially disable the error (try to do odbc connection). It h= as not. > > And of course I cant even get to the point of knowing if this v= alid ODBC > driver is going to work until I get that error to go away. > > > > > Not the best personally with unix but can bull my way through a= nything > (hence webstar and not apache). Does anyone have this OS setup=20= working for > odbc and MSSQL? I am certain the ODBC is playing nice because o= f the admin > app. Now I just have to get WEBDNA to step up to the plate. > > :_( > > Anyone? > AJ > > -- > Alex J McCombie > Adventure Skies Interactive (ASI) > Alex@Adventureskies.com > > > > ------------------------------------------------------------- > 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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- 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:
Hi Alex WebDNA can only connect to MySQL over ODBC. This is a direct info= rmation from Le from SmithMicro. I have been pushing and yelling at Scott and others to support ot= her databases but so far have had unfortunately no success. Sorry, to give you no better news. Nitai -- eContentPark - Enterprise Asset Management System eServices - The complete SupportSuite eSurvey - Online Questionnaire made easy Redakto CMS - Content Management that simply works ComputerOil=C2=AE AG Neugutstrasse 66 8600 D=C3=BCbendorf / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.com > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On B= ehalf Of > Alex McCombie > Sent: Mittwoch, 14. Dezember 2005 21:23 > To: WebDNA Talk > Subject: MSSQL - ODBC - OSX > > Just checking in again since there has been no replies at all := -( > I have tried to follow the information at: > http://webdna.smithmicro.com/ref/UNIXODBCSetup.html > > But the problem is this was written for MySQL and I using (or t= rying to) > MSSQL. > > In fact I am using a MSSQL driver that can be found here: > http://www.actualtechnologies.com/download.php > Actual SQL Server 1.17 Microsoft SQL Server and Sybase > > > I am at a loss. The ODBC connects quickly but I cant get past t= he SQL not > Supported error. I don't mind going off this route and going th= e unixODBC > route but unfortunately the instructions provided are pretty sp= ecifically > customized for MYSQL and I admittedly am not comfortable enough= to ad-lib. > My attempts to do that (below) havent yeilded any success. > > > Can I get Scott or someone to drop me an email to see what I ca= n do to get > the supported feature working. > > Thanks > Alex > > > > > > > > > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D > I have webstar 5.4.1 running with > unix-Macintosh OS X WebSTAR V Plug-in version 6.0 > > Everything is working OK except I cant get this damn ODBC confi= gured. > > > In my library for the user account I have the ODBC.ini file wit= h the > following installed: > /Library/ODBC/Actual SQL Server.bundle/Contents/MacOS/atsqlsrv.= so > > Which was installed using the add feature of the ODBC manager o= n tiger. > The > manager confirms the connection to the MSSQL server without iss= ue but > webcat > returns the dreaded SQL not Supported error. > > > I have modified my weccatalog pref file to say > SQLLibraryPath /Library/ODBC/Actual SQL > Server.bundle/Contents/MacOS/atsqlsrv.so > > Which I believe to be the write thing to do. > Restarted and still the error. > > Now, first I thought that modifying the pref file with this pat= h would > essentially disable the error (try to do ODBC connection). It h= as not. > > And of course I cant even get to the point of knowing if this v= alid ODBC > driver is going to work until I get that error to go away. > > > > > Not the best personally with unix but can bull my way through a= nything > (hence webstar and not apache). Does anyone have this OS setup=20= working for > ODBC and MSSQL? I am certain the ODBC is playing nice because o= f the admin > app. Now I just have to get WEBDNA to step up to the plate. > > :_( > > Anyone? > AJ > > -- > Alex J McCombie > Adventure Skies Interactive (ASI) > Alex@Adventureskies.com > > > > ------------------------------------------------------------- > 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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- 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/
"Nitai @ ComputerOil"
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Template transformed itself into a database? (1998)
Erotic Sites (1997)
Banner DNA (1997)
Confirmation emails classified as junk (2000)
Make sure I understand this??? (1997)
cookies crumbling (1999)
SV: Mass Mail (2000)
Showing unopened cart (1997)
[shownext max=?] armed (1997)
change the number format (1997)
WebCat2 - storing unformatted date data? (1997)
[cart] Taxrate - seriously .. (2002)
Reminder... (2003)
Secure server question (1997)
Looking for WebCat developer/contractor (2000)
Opinion: [input] should be called [output] ... (1997)
Locking up with WebCatalog... (1997)
HTML Editors (1997)
Bug? (1997)
Time for a hard questions. (1997)