Search found 6 matches

Return to advanced search

Re: SQLServer

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...
by JayBee
19. Mar 2010, 23:09
 
Forum: General Help
Topic: SQLServer
Replies: 10
Views: 26841

Re: SQLServer

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...
by JayBee
19. Mar 2010, 23:03
 
Forum: General Help
Topic: SQLServer
Replies: 10
Views: 26841

Re: SQLServer

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
by JayBee
14. Mar 2010, 12:35
 
Forum: General Help
Topic: SQLServer
Replies: 10
Views: 26841

Re: SQLServer

Hi John,

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

Best regards,

Jan
by JayBee
27. Feb 2010, 16:31
 
Forum: General Help
Topic: SQLServer
Replies: 10
Views: 26841

Re: SQLServer

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...
by JayBee
9. May 2009, 18:19
 
Forum: General Help
Topic: SQLServer
Replies: 10
Views: 26841

SQLServer

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
by JayBee
15. Feb 2009, 21:30
 
Forum: General Help
Topic: SQLServer
Replies: 10
Views: 26841

Return to advanced search

Design by GB