But all what I need is just a simple connection between my sketchup and the database to only save some coordinates of objects there to be used later by anyone, using a simple mysql table and each time just adding a couple of rows. I have no idea what advantages would the web service, or even if I want to do that, how should I start
Posts
-
RE: Connecting Sketchup's ruby with MYSQL database
-
Connecting Sketchup's ruby with MYSQL database
Hello everyone,
I'm trying right now to connect my ruby scripts for sketchup to a MYSQL database. The database is not on the same computer as mine, I'm the client, and there is a server which has this database. And yeah I'm using a windows 7, 64-bit, and I have downloaded all the remaining parts for ruby as I've read on some old threads on the forum. The ruby version I have, or sketchup has is 1.8.6. I tried loads of softwares, but usually there is an error that doesn't make me able to install it and connect to database, and usually there is an error that keeps repeating many times. So I really need help because I tried almost everything and don't know what to do. I'll put each software's case and my steps and the errors:-ODBC for Ruby: ODBC was installed successfully and was able to connect to the database, but the connection between ruby and the ODBC wasn't successful. I followed this link: http://www.ch-werner.de/rubyodbc/ to get the instalation steps. I downloaded the source of version 0.9995, and then entered this command: $ ruby -Cext extconf.rb, and here is the error I got: checking for version.h... no
checking for sql.h... no
ERROR: sql.h not found
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of
necessary libraries and/or headers. Check the mkmf.log file for more
details. You may need configuration options.Provided configuration options:
--with-opt-dir
--without-opt-dir
--with-opt-include
--without-opt-include=${opt-dir}/include
--with-opt-lib
--without-opt-lib=${opt-dir}/lib
--with-make-prog
--srcdir=.
--curdir
--ruby=C:/Ruby/bin/ruby
--with-odbc-dir
--without-odbc-dir
--with-odbc-include
--without-odbc-include=${odbc-dir}/include
--with-odbc-lib
--without-odbc-lib=${odbc-dir}/lib
and I have no idea how to solve that, and that error is the usual error I get for most softwares.-The second software used was the Ruby/MYSQL from MYSQL at: http://www.tmtm.org/en/ruby/mysql/. I downloaded version 0.2.6, and followed the steps, and on the first step ruby ./test.rb hostname user passwd I got the same error again.
- The third software was MYSQL/Ruby from also MYSQL at http://www.tmtm.org/en/mysql/ruby/ and downloaded from rubyforge version 2.8.2, and just the same error with the first step of installation
-Fourt software was the DBI software which also didn't work
I need help, I tried everything.
Thanks alot