When I create an ODBC definition in windows and then evaluate the following code: | session | session := SQL::ODBCSession new. session connectWithUsername:'blabla' password: 'blablaToo' dbname: 'TestDB'. session disconnect it ends with an exception: [Microsoft][ODBC SQL Server Driver][SQL Server]Cha...
I assume you are running STX under some Windows version (XP, Vista, Server ...) and have defined an ODBC datasource. Can you communicate with the database e.g. from Excel?
Hi John, Make sure you have loaded the SQL stuff by evaluating the following in a workspace: Smalltalk loadPackage:'stx:libdb/libodbc' If you don't, STX will not know the class ODBCSession. Then evaluate the following | session | session := SQL::ODBCSession new. self halt. And you will get a popup s...
I forgot to react on your other questions: i still don't understand where STX learns about "DSN=...." or "DRIVER=...". ODBC is a protocol for data access. All you need to do is define an ODBC datasource in windows. At that level you also specify the DNS and the driver, but you al...