Re: [Pharo-users] Pharo 5 ODBC
I'm using UDBC2 without any problem. Try this: ~~~ Gofer it smalltalkhubUser: 'TorstenBergmann' project: 'UDBC'; configuration; load. (Smalltalk at: #ConfigurationOfUDBC) loadBleedingEdge. ~~~ Cheers, Offray On 20/03/17 15:28, Glenn Swanlund wrote: Hi, I'm trying to connect to a .xls file on Windows 7. I will also need to connect to an Access database. My application database is SQLite3. I used the following excerpt from an email I found: Gofer it smalltalkhubUser: 'TorstenBergmann' project: 'UDBC'; configuration; load. (Smalltalk at: #ConfigurationOfUDBC) loadBleedingEdge. Gofer it smalltalkhubUser: 'DBXTalk' project: 'Garage'; configurationOf: 'GarageGlorp'; load. #ConfigurationOfGarageGlorp asClass project stableVersion load. Gofer it smalltalkhubUser: 'DBXTalk' project: 'Glorp'; package: 'Glorp-SQLite3'; load. GlorpSQLite3CIConfiguration new configureSqlite3. GlorpDemoTablePopulatorResource invalidateSetup. On Mon, Mar 20, 2017 at 1:12 PM, Benoit St-Jean via Pharo-users <pharo-users@lists.pharo.org <mailto:pharo-users@lists.pharo.org>> wrote: -- Forwarded message -- From: Benoit St-Jean <bstj...@yahoo.com <mailto:bstj...@yahoo.com>> To: Any question about pharo is welcome <pharo-users@lists.pharo.org <mailto:pharo-users@lists.pharo.org>> Cc: Bcc: Date: Mon, 20 Mar 2017 20:12:48 + (UTC) Subject: Re: [Pharo-users] Pharo 5 ODBC Can you give the URL of what exactly you loaded? There's a bunch of ODBC packages/versions out there so I'd need more details. I've used ODBC on Pharo 5 before without any problem. Besides, what OS and database are you using? - Benoît St-Jean Yahoo! Messenger: bstjean Twitter: @BenLeChialeux Pinterest: benoitstjean Instagram: Chef_Benito IRC: lamneth Blogue: endormitoire.wordpress.com <http://endormitoire.wordpress.com> "A standpoint is an intellectual horizon of radius zero". (A. Einstein) *From:* Glenn Swanlund <glennswanl...@gmail.com <mailto:glennswanl...@gmail.com>> *To:* pharo-users@lists.pharo.org <mailto:pharo-users@lists.pharo.org> *Sent:* Monday, March 20, 2017 3:50 PM *Subject:* [Pharo-users] Pharo 5 ODBC Does Pharo 5 support ODBC? I loaded the UDBC package and can't see how to make an ODBC connection. There is a class UDBCODBCConnection but it is empty. Any pointers? Regards, Glenn
Re: [Pharo-users] Pharo 5 ODBC
Hi, I'm trying to connect to a .xls file on Windows 7. I will also need to connect to an Access database. My application database is SQLite3. I used the following excerpt from an email I found: Gofer it smalltalkhubUser: 'TorstenBergmann' project: 'UDBC'; configuration; load. (Smalltalk at: #ConfigurationOfUDBC) loadBleedingEdge. Gofer it smalltalkhubUser: 'DBXTalk' project: 'Garage'; configurationOf: 'GarageGlorp'; load. #ConfigurationOfGarageGlorp asClass project stableVersion load. Gofer it smalltalkhubUser: 'DBXTalk' project: 'Glorp'; package: 'Glorp-SQLite3'; load. GlorpSQLite3CIConfiguration new configureSqlite3. GlorpDemoTablePopulatorResource invalidateSetup. On Mon, Mar 20, 2017 at 1:12 PM, Benoit St-Jean via Pharo-users < pharo-users@lists.pharo.org> wrote: > > > -- Forwarded message -- > From: Benoit St-Jean <bstj...@yahoo.com> > To: Any question about pharo is welcome <pharo-users@lists.pharo.org> > Cc: > Bcc: > Date: Mon, 20 Mar 2017 20:12:48 +0000 (UTC) > Subject: Re: [Pharo-users] Pharo 5 ODBC > Can you give the URL of what exactly you loaded? There's a bunch of ODBC > packages/versions out there so I'd need more details. I've used ODBC on > Pharo 5 before without any problem. Besides, what OS and database are you > using? > > - > Benoît St-Jean > Yahoo! Messenger: bstjean > Twitter: @BenLeChialeux > Pinterest: benoitstjean > Instagram: Chef_Benito > IRC: lamneth > Blogue: endormitoire.wordpress.com > "A standpoint is an intellectual horizon of radius zero". (A. Einstein) > > > -- > *From:* Glenn Swanlund <glennswanl...@gmail.com> > *To:* pharo-users@lists.pharo.org > *Sent:* Monday, March 20, 2017 3:50 PM > *Subject:* [Pharo-users] Pharo 5 ODBC > > Does Pharo 5 support ODBC? I loaded the UDBC package and can't see how to > make an ODBC connection. There is a class UDBCODBCConnection but it is > empty. Any pointers? > > Regards, > Glenn > > > >
Re: [Pharo-users] Pharo 5 ODBC
--- Begin Message --- Can you give the URL of what exactly you loaded? There's a bunch of ODBC packages/versions out there so I'd need more details. I've used ODBC on Pharo 5 before without any problem. Besides, what OS and database are you using? - Benoît St-Jean Yahoo! Messenger: bstjean Twitter: @BenLeChialeux Pinterest: benoitstjean Instagram: Chef_Benito IRC: lamneth Blogue: endormitoire.wordpress.com "A standpoint is an intellectual horizon of radius zero". (A. Einstein) From: Glenn Swanlund <glennswanl...@gmail.com> To: pharo-users@lists.pharo.org Sent: Monday, March 20, 2017 3:50 PM Subject: [Pharo-users] Pharo 5 ODBC Does Pharo 5 support ODBC? I loaded the UDBC package and can't see how to make an ODBC connection. There is a class UDBCODBCConnection but it is empty. Any pointers? Regards,Glenn --- End Message ---
[Pharo-users] Pharo 5 ODBC
Does Pharo 5 support ODBC? I loaded the UDBC package and can't see how to make an ODBC connection. There is a class UDBCODBCConnection but it is empty. Any pointers? Regards, Glenn
[Pharo-users] Pharo and ODBC
Hi, I try to use the ODBC framework presents in the configurations list and named ODBC (TorstenBergmann.5) I want connect Pharo to a Postgresql server and I installed the latest version of the ODBC driver. The datasource is configured as system datasource. The connection test is ok. My computer uses Windows 7 64 bits. In Pharo, I try to connect with the following code: connection := ODBCConnection dsn: 'mysource' user: 'myuser' password: 'mypassword'. connection close. The connection fails and I get an error message: The data source (DSN) has a specified architecture incompatibility between the driver and the application. Someone have an idea about this problem ? Someone works with the ODBC solution ? Best regards Olivier
Re: [Pharo-users] Pharo and ODBC
Hello Olivier, did you create the DSN using C:\WINDOWS\SysWow64\odbcad32.exe ? The 32 Bit ODBC Adminstration Console is located in SysWow64, if you just start the ODBC Adminstration Console from the system admin tools, you will get the 64 Bit version, which is located in C:\WINDOWS\system32 :)
Re: [Pharo-users] Pharo and ODBC
Plausible Pharo 32 bit / 64 bit conflict..? http://msdn.microsoft.com/en-us/library/ms712362%28v=vs.85%29.aspx If you use the 64-bit odbcad32.exe to configure or remove a DSN that connects to a 32-bit driver, for example, Driver do Microsoft Access (*.mdb), you will receive the following error message: On Thu, Nov 20, 2014 at 1:35 PM, olivier auverlot olivier.auver...@gmail.com wrote: Hi, I try to use the ODBC framework presents in the configurations list and named ODBC (TorstenBergmann.5) I want connect Pharo to a Postgresql server and I installed the latest version of the ODBC driver. The datasource is configured as system datasource. The connection test is ok. My computer uses Windows 7 64 bits. In Pharo, I try to connect with the following code: connection := ODBCConnection dsn: 'mysource' user: 'myuser' password: 'mypassword'. connection close. The connection fails and I get an error message: The data source (DSN) has a specified architecture incompatibility between the driver and the application. Someone have an idea about this problem ? Someone works with the ODBC solution ? Best regards Olivier
Re: [Pharo-users] Pharo and ODBC
Thanks for your help. The ODBC source must be declared with C:\WINDOWS\SysWow64\odbcad32.exe and use 32 bits mode. 2014-11-20 9:56 GMT+01:00 S Krish krishnamachari.sudha...@gmail.com: Plausible Pharo 32 bit / 64 bit conflict..? http://msdn.microsoft.com/en-us/library/ms712362%28v=vs.85%29.aspx If you use the 64-bit odbcad32.exe to configure or remove a DSN that connects to a 32-bit driver, for example, Driver do Microsoft Access (*.mdb), you will receive the following error message: On Thu, Nov 20, 2014 at 1:35 PM, olivier auverlot olivier.auver...@gmail.com wrote: Hi, I try to use the ODBC framework presents in the configurations list and named ODBC (TorstenBergmann.5) I want connect Pharo to a Postgresql server and I installed the latest version of the ODBC driver. The datasource is configured as system datasource. The connection test is ok. My computer uses Windows 7 64 bits. In Pharo, I try to connect with the following code: connection := ODBCConnection dsn: 'mysource' user: 'myuser' password: 'mypassword'. connection close. The connection fails and I get an error message: The data source (DSN) has a specified architecture incompatibility between the driver and the application. Someone have an idea about this problem ? Someone works with the ODBC solution ? Best regards Olivier