Hi,

Has anyone been able to access a SQLServer database from STX?
Either by ODBC or in another way?
If so, please give an example of how this is done.

Regards,

Jan

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...

Hi John,

I would expect the ODBCSession.
What error do you get when connecting to the ODBC datasource?

Best regards,

Jan

John,

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?

Jan

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...