| |
| Publicado el 30,enero 2018 - 10:32 |
Hi All
Can somebody with clairon experience help?
I have a tps file which I can read through ODBC and load in excel.
However I would like to have a windev program access the same data.
The problem is that I cannot see the ODBC connection in windev.
any help appreciated.
Thanks
Noel |
| |
| |
| | | |
|
| | |
| |
| Publicado el 31,enero 2018 - 08:03 |
Hi Noel,
First you need the Clarion 5 (that's the latest one) ODBC driver.
I think you have a 64 bit version of windows and the ODBC driver is not 64 bit
You can start the 32Bit ODBC Admin with c:\Windows\System32\odbcad32.exe
Once you have create a User DSN or a System DSN you can use the this to loead the data. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 31,enero 2018 - 10:25 |
Hi,
there seems to be a problem with windev not 'seeing' the created DSN.
Excell 'sees' it ok and I can get the data but can get it in windev.
I though there might be some not so obvious way to do it on the windev side.
regards
Noel |
| |
| |
| | | |
|
| | |
| |
| Publicado el 31,enero 2018 - 10:49 |
64Bit Windev?
The driver can be used in a 16bits and 32 bits environment |
| |
| |
| | | |
|
| | |
| |
| Publicado el 31,enero 2018 - 13:40 |
Be careful that whatever you do, when you use external tools (like an odbc driver, a scanner driver, etc) the whole chain of exes/dll must EITHER be ALL 32 bits, or ALL 64 bits...
Furthermore, except if you are working on a project with THOUSANDS of pages/windows or files, the 64 bits windev editor will NOT give you any benefit...
Best regards |
| |
| |
| | | |
|
| | |
| |
| Publicado el 31,enero 2018 - 17:56 |
Hi all
I will have to install a 32bit windev and check. I think I had insatalled 64 bit windev and perhaps that is why these are not visible
Can some body tell me how to check if windev is 64 or 32 bit?
Thanks
Noel |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
105 mensajes |
|
| Publicado el 31,enero 2018 - 20:28 |
You can check your task manager in windows if windev is running. Look at the running processes and windev64.exe is the executable for the 64bit version.
You can also look at the path on the shortcut used to launch the environment. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 01,febrero 2018 - 00:16 |
It should work, I'm migrating a system in clarion to windev and I can
connect me by odbc, I pass a fragment of the code where I import the data to
a table object and process it to windev.
CN is Data Source
TableDeleteAll (TABLE_Affiliate)
HourGlass ()
bCON is boolean = HExecuteSQLQuery (CN, Connection_TPSODBC,
hQueryWithoutCorrection, "SELECT * FROM BOOK") // where FECALT> =
{d'2016-01-01 '}
IF bCON = True THEN
BuildBrowsingTable (TABLE_Affiliate, CN, taFillTable)
// FOR EACH CN
// TableAdd (TABLE_tps, CN.NROSOCIOS + TAB + CN.APELLIDO + TAB + CN.BARRIO)
// END
END
// TableDisplay (TABLE_tps, taInit)
HourGlass (False)
I hope you find it useful.
For you to consider windev 32 and the C: \ Windows \ SysWOW64 \ odbcad32.exe
to configure.
Victor
---
El software de antivirus Avast ha analizado este correo electrónico en busca de virus.
https://www.avast.com/antivirus |
| |
| |
| | | |
|
| | |
| |
| Publicado el 01,febrero 2018 - 00:21 |
I have to say that you must use the following connection
ODBC access OLEDB and it shows you odbc and should appear.
regards
Victor
---
El software de antivirus Avast ha analizado este correo electrónico en busca de virus.
https://www.avast.com/antivirus |
| |
| |
| | | |
|
| | |
| |
| Publicado el 07,marzo 2018 - 00:45 |
Hi
Do not quite understand you question
But to tell if 32 or 64 is installed look at the very top of the screen and right hand side, next to
Minimise control you will see a small 32 or 64
Easy hey.
Keep safe and well
Peter |
| |
| |
| | | |
|
| | |