MSSQL - ODBC - OSX
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 63607
interpreted = N
texte = 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 trying 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 the SQL not Supported error. I don't mind going off this route and going the unixODBC route but unfortunately the instructions provided are pretty specifically 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 can do to get the supported feature working. Thanks Alex ============================== 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 configured. In my library for the user account I have the ODBC.ini file with the following installed: /Library/ODBC/Actual SQL Server.bundle/Contents/MacOS/atsqlsrv.so Which was installed using the add feature of the ODBC manager on tiger. The manager confirms the connection to the MSSQL server without issue 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 path would essentially disable the error (try to do odbc connection). It has not. And of course I cant even get to the point of knowing if this valid 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 anything (hence webstar and not apache). Does anyone have this OS setup working for odbc and MSSQL? I am certain the ODBC is playing nice because of 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 Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
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 trying 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 the SQL not Supported error. I don't mind going off this route and going the unixODBC route but unfortunately the instructions provided are pretty specifically 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 can do to get the supported feature working. Thanks Alex ============================== 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 configured. In my library for the user account I have the ODBC.ini file with the following installed: /Library/ODBC/Actual SQL Server.bundle/Contents/MacOS/atsqlsrv.so Which was installed using the add feature of the ODBC manager on tiger. The manager confirms the connection to the MSSQL server without issue 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 path would essentially disable the error (try to do ODBC connection). It has not. And of course I cant even get to the point of knowing if this valid 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 anything (hence webstar and not apache). Does anyone have this OS setup working for ODBC and MSSQL? I am certain the ODBC is playing nice because of 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 Web Archive of this list is at: http://webdna.smithmicro.com/
Alex McCombie
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:
credit card (1997)
Multi-processor Mac info ... (1997)
WebDNA FAQ or FAQs (2004)
authenticating a second user (1997)
Another bug to squash (WebCat2b13 Mac .acgi) (1997)
WebDNA+unixODBC+MS SQL (2005)
Serving images from databases (1998)
showif and cart (1997)
virtual domain service (1997)
Encrypt (2000)
webcat method for waiting specific amount of time? (2000)
New Cart No. on same page (2003)
Getting around DOS filenames (2000)
ANSWER to: CC Merchant suggestions?? (1997)
[OT] Security in general [Was] WebDNA security (2004)
Webcat 2.0.1 date math bug -> Crash! (1997)
searching a range -still don't get it (2000)
Is there an alternative to emailer? (1999)
random prob (2003)
docs for WebCatalog2 (1997)