Hi... Well the better way to connect to MSSql from pharo is with freetds platform. Not via ODBC.
You need check a couple things: 1: all dll's are on the path. 2: freetds.conf is on. 3: the sql server accept tcp conexion, not name pipes or shared memory. 4: the enviroments variables are right configurates 5: check the server accept dual mode authentication 6: you can enable the debug mode, for your tds connection from freedts.conf , for more information and register activity in a log file. For more detail, you can check http://www.squeakdbx.org in the documentation section. The configuration section for freetds for linux apply for windows too. Best D. Pd: pharo 1.3 is unstable yet. The dbx team (previously squeakdbx) are working in a refactoring and uptade over 1.3 but this version we are working yet. Pd2: if you wanna more customized support(check conexion string, check a MNU etc.), can sendme an email a private email. Pd3: this version of squeak dbx dont support Blob data types (like Blob, image, Clob, Text, etc). I guess those data types, will be supportes in nexts versions. Enviado desde mi BlackBerry® de Claro Argentina -----Original Message----- From: Alain rastoul <alr....@free.fr> Date: Tue, 10 May 2011 14:00:21 To: <libopendbx-devel@lists.sourceforge.net> Reply-To: OpenDBX devel list <libopendbx-devel@lists.sourceforge.net> Subject: [opendbx] Mssql connection failed I dowloaded opendbx binaries and freetds sources, mingw, msys and built freetds. I installed opendbx in my pharo1.3 with the gofer script found in docs. Connection to my sql server with the freetds tsql utility was ok, but from pharo I always got «connection failed» then a crash (pharo process exit). I saw in opendbx docs that from a windows client odbc backend is prefered, changed backend of DBXMSSQLPlatform to 'odbc' then connection to my server with a system dsn was ok, but I have «unknow problem with executeStatement» when I execute a «select * from mytable» Is there a better way to proceed with opendbx-mssql? Can I connect without a dsn ? Any advice or comments are welcome. TIA Cheers -- Alain_rastoul ------------------------------------------------------------------------------ Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay _______________________________________________ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX ------------------------------------------------------------------------------ Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay _______________________________________________ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
