Hi,
I wanted to play a little bit with Glorp for Pharo. Therefore I
installed/created
an MSSQL Server database locally using SQLEXPRESS. SQL Server runs locally
(127.0.0.1)
on standard port 1433 via TCP/IP. Connecting from various DB tools is possible
and works.
Now in Pharo3.0 Latest update: #30851 I installed Glorp:
Gofer it
squeaksource: 'MetacelloRepository';
package: 'ConfigurationOfGlorpDBX';
load.
Then, for installing Glorp for OpenDBX just execute:
(((Smalltalk at: #ConfigurationOfGlorpDBX)
perform: #project)
perform: #version: with: #stable)
load
At the location of the Pharo VM I extracted the OpenDBX binaries for
Windows. To be precise I grabbed the OpenDBX-1_5_0_dlls.zip from
http://web.archiveorange.com/archive/v/a1gO5ZoJReyXr6T4n5m7
and extracted it in the VM directory so the dlls could be found.
I also renamed/placed the "libsybdb-5.xxx" from the same location
as "libsybdb-5.dll" to the VM directory. If this will not be the case
one will get an error that this dll is missing at the first connect attempt.
(looks like this was linked wrongly)
So far so good.
When I now try to connect using the following expression:
NBPharoOpenDBX installAsCurrent.
sqlsrvrLogin := (Login new)
database: (SQLServerPlatform new );
username: 'sa';
password: 'password';
secure: false;
connectString: '127.0.0.1:1433_MYSHINYNEWDB'.
accessor := DatabaseAccessor forLogin: sqlsrvrLogin.
accessor login
I get an DBXRecoverableError with 'Connecting to server failed'.
When I check the log in #openConnection: I can see that the binding failed
although the
values are correct and work with other tools:
'odbx_bind: called with values: handle = a NBOpenDBX_OdbxTO( 0xC9E648 )
database = MYSHINYNEWDB
userName = sa userPassword = password'
Any comments? Anyone got a RDBMS outside of Postgress running with
DBXTalk/Glorp on Pharo?
I also tried with SQLite3Platform - but the parsing logic does not handle local
(SQLite3)
files and always expects "hostname:portNumber_db-name" like patterns.
Thanks
T.
