- Pharo-dev - lists.pharo.org

[Pharo-project] ODBC on W7 and Pharo 1.4
by Torsten Bergmann July 26, 2012

July 26, 2012

>So to me it seems this is a problem in the ODBC Driver vor Access, but I >could not imagine that no-one ever have treated Doubles while trying to >access MS Access with Pharo. Maybe you should try the newest runtime for Access 2010: http://www.microsoft.com/en-us/download/details.aspx?id=10910 (for instance in a www.virtualbox.org installation). to see if it is really a ODBC driver problem. According to [1] and [2] this should be 15 instead of 53 for SQL_DOUBLE. Correct? Bye T. [1] http://msdn.microsoft.com/en-us/library/windows/desktop/ms716289(v=vs.85).a… [2] http://msdn.microsoft.com/en-us/library/windows/desktop/ms711786(v=vs.85).a…

2 1

[Pharo-project] ODBC on W7 and Pharo 1.4
by Torsten Bergmann July 26, 2012

July 26, 2012

>But it does not declare anything which is needed e.g for >understanding SQLDouble and the like. Because FFI is a general callout mechanism for native APIs and the ODBC package is just implemented on top of it. So why should the FFI docu cover the ODBC stuff? FFI docu just describes how to call external libs (written in C or others). The ODBC package is nothing more than a wrapper around some Win32 API functions like SQLAllocEnv, etc. The docu for them can be found in MSDN (just Google). If you want to track problems in the ODBC package check the code and see if it does correct callouts and use correct data types according to Microsoft specs. Just by looking at the code, maybe - #initializeDataTypes has a wrong definition - maybe the ODBCConstants definition is wrong - maybe #initializeResultSet:number: has a problem You should debug your problem since you have a reproducable case or switch to a newer, more supported package like DBXTalk with an active mailinglist. >Sorry, does that mean the name I gave to the Data source must be placed >in host? Yes, that worked for me. "host" is a bit misleading - for an SQLite connection it can be the local path, for ODBC its the DSN name for a network database it is the hostname or IP address. >I'm sorry but how should one know that? Note that is a general interface to databases. You can not assume that the developers of OpenDBX/DBXTalk test any kind of database (here MS Access) and give you a docu for database specific connections. DBXTalk covers typical relational databases used in enterprise these days (oracle, MSSQL, MySQL, ...), includes tests and its nice to have such an initiative. >So what am I supposed to write into database? A table name? Did you try to leave it blank or use the same name as the DB? If I were you I would create a simple DB with Access with a simple predefined table. Then setup the ODBC connection and try to connect to it. If that works do a simple query. If that communication works it should be no problem to create/query tables from Smalltalk. However - if you have DBXTalk specific questions switch to the DBXTalk mailinglist (http://dbxtalk.smallworks.com.ar then "Support") Bye T.

3 2

[Pharo-project] Focus / Selection on PluggableTextMorph
by Goubier Thierry July 26, 2012

July 26, 2012

Hi, would someone knows why the behavior of PluggableTextMorph is a bit strange with selections ? I'm using Spec and Pharo 2.0. 1 - Selecting text is Ok, blue color. Matches on the selected text elsewhere in the text morph are green. 2 - Switching to another window desactivate the selection, but maintains the matches in green (including where the selection was : it changes from blue to green). 3 - Clicking on the title of the window with the text morph... removes the green matches. So now, seemingly, there is nothing selected anymore ? 4 - Wrong! Moving back the mouse over the text morph brings back the selection (blue) and the matches (green) ! 5 - Opening a menu on the morph (right-click) also makes the selection disappear apparently. For fun, you can also do 1 - 5 - 4 and see your selection appear / disappear. So is this a feature or a bug ? How to turn it of ? 5- is very fun, because I was trying to build a menu where items are enabled depending on a selection or no selection, and, you can guess what happened : open the menu, 'et voilÃ ', no more selection -> everything disabled ! close the menu, and the selection is back :-( Thierry -- Thierry Goubier CEA list Laboratoire des Fondations des SystÃ¨mes Temps RÃ©el EmbarquÃ©s 91191 Gif sur Yvette Cedex France Phone/Fax: +33 (0) 1 69 08 32 92 / 83 95

1 0

[Pharo-project] ODBC on W7 and Pharo 1.4
by Torsten Bergmann July 26, 2012

July 26, 2012

The below works for me with MSSQL Server settings := DBXConnectionSettings host: 'NAME' port: '' database: 'MyDatabase' userName: 'user' userPassword: 'pass'. platform := DBXOdbcBackend new. connection := DBXConnection platform: platform settings: settings. connection connect. connection open. where NAME is the name given in the ODBC control panel and MyDatabase is the database name. Tell us if it works. Bye T.

2 1

[Pharo-project] ODBC on W7 and Pharo 1.4
by Torsten Bergmann July 26, 2012

July 26, 2012

>Can you tell me if there is a usable tutorial about >FFI somewhere. Make sure you use latest FFI and ODBC package. For a FFI description use http://lmgtfy.com/?q=Squeak+FFI Can you send the CREATE/INSERT script for the table? Bye T.

2 2

[Pharo-project] ODBC on W7 and Pharo 1.4
by Torsten Bergmann July 26, 2012

July 26, 2012

Sorry - no MSAccess installation here to help you with the problem. Dont know if ODBC package is still maintained. Maybe you should switch to DBXTalk which can also be used with ODBC http://dbxtalk.smallworks.com.ar/ Guillermo currently prepares a new version for OpenDBX 1.4.6. Bye T.

2 2

[Pharo-project] [update 2.0] #20233
by Marcus Denker July 26, 2012

July 26, 2012

20233 ----- Issue 6442: Add temporal MCCacheRepository >> default http://code.google.com/p/pharo/issues/detail?id=6442 Issue 6439: Add smalltalkhub convenience method for Gofer http://code.google.com/p/pharo/issues/detail?id=6439 Issue 6438: Failing tests related to ChangeSet http://code.google.com/p/pharo/issues/detail?id=6438 Issue 6436: Removing SystemChangeNotifier dependencies from some tests http://code.google.com/p/pharo/issues/detail?id=6436 -- Marcus Denker -- http://marcusdenker.de

2 1

[Pharo-project] fuelized test failures
by Camillo Bruni July 25, 2012

July 25, 2012

>From now on all the test-failures are serialized on the build server. This allows us to quickly find the cause of a failing test: - download the .fuel file for the failing test - materialize the .fuel in the image and debug the code | aContext | aContext := FLMaterializer materializeFromFileNamed: 'PharoDebug.fuel'. Debugger openContext: aContext label: 'This is the new debugger!' contents: nil The serialized stack trace is very limited (generally only 2 contexts) but they are enough to get a decent view on what the variables are

7 17

Re: [Pharo-project] How do download a binary file as a stream with Zinc?
by Mariano Martinez Peck July 25, 2012

July 25, 2012

On Wed, Jul 25, 2012 at 11:46 AM, Sven Van Caekenberghe <sven(a)beta9.be>wrote: > Hi Mariano, > > (I can't access the file you gave as an example, probably an extra > #username:password: is needed) > > Yes, in fact, that was the problem ;) > You are making it more difficult than it has to be: this gives you the > bytes you want > > ZnClient new > get: 'http://zn.stfx.eu/zn/string.fuel'. > > With some better system parameters this becomes > > ZnClient new > systemPolicy; > beOneShot; > accept: ZnMimeType applicationOctetStream; > url: 'http://zn.stfx.eu/zn/string.fuel'; > get. > > But what you really want is something like: > > ZnClient new > systemPolicy; > beOneShot; > accept: ZnMimeType applicationOctetStream; > url: 'http://zn.stfx.eu/zn/string.fuel'; > contentReader: [ :entity | FLMaterializer > materializeFromByteArray: entity contents ]; > get. > > You can experiment with #streaming: true but that is only worth it for > large (MB) files. IMHO. > > Thanks Sven, very informative. > HTH, > > Sven > > On 24 Jul 2012, at 23:06, Mariano Martinez Peck wrote: > > > Hi Sven. How can I download a binary file to a bytearray ? > > > > I tried to download it locally doing: > > > > ZnClient new > > systemPolicy; > > accept: ZnMimeType applicationOctetStream; > > url: ' > https://ci.lille.inria.fr/pharo/view/Pharo%202.0/job/pharo-2.0-tests/Archit… > '; > > downloadTo: '/Users/mariano/Desktop'. > > > > > > but I cannot even do that. Notice that my final go is not to download it > to a file, but rather directly get the binary contents. > > > > How can I do that? > > > > Thanks, > > > > -- > > Mariano > > http://marianopeck.wordpress.com > > -- Mariano http://marianopeck.wordpress.com

1 0

[Pharo-project] How read the Pharo release version
by Dario Trussardi July 25, 2012

July 25, 2012

Ciao, i'm interested to understand the Pharo version of the image. The System menu About report : Pharo-1.0 Latest update: #10517 How i can read it with method ? Thank, Dario

2 3