|
Inicio → WINDEV 2024 → ODBC/OLEDB (provider=MSDASQL) access error. - conversion of data fails |
ODBC/OLEDB (provider=MSDASQL) access error. - conversion of data fails |
Iniciado por vvido, 15,ene. 2014 15:21 - 7 respuestas |
| |
| | | |
|
| |
Miembro registrado 94 mensajes |
|
Publicado el 15,enero 2014 - 15:21 |
I am trying to convert some TPS files (topSpeed data files, TPS ODBC driver) to HyperFile format.
For this purpose I have imported the files into the analysis. The conversion process creates data file definitions without any problems (all files are now in the analysis).
During the second step (copy data from TPS files to HyperFIles) most of data files (about 25 files) are copied OK, but IT FAILS CONSISTENTLY on four files with the error described below. The only difference between these problematic files and files which convert OK is the number of fields in the file definition - they have more fileds (but less than 30).
ODBC/OLEDB (provider=MSDASQL) access error. Error Number = 170129 Failure opening file.
System Error Details: Description = ODBC driver does not support the requested properties. Source = Microsoft OLE DB Provider for ODBC Drivers Error Number = -2147217887 (0x80040e21)
File: 0ALIAS_IMPORT_nabava Description = ODBC driver does not support the requested properties. Source = Microsoft OLE DB Provider for ODBC Drivers Error Number = -2147217887 (0x80040e21)
Please help !!! |
| |
| |
| | | |
|
| | |
| |
Publicado el 01,marzo 2018 - 18:06 |
vvido a écrit :
I am trying to convert some TPS files (topSpeed data files, TPS ODBC driver) to HyperFile format.
For this purpose I have imported the files into the analysis. The conversion process creates data file definitions without any problems (all files are now in the analysis).
During the second step (copy data from TPS files to HyperFIles) most of data files (about 25 files) are copied OK, but IT FAILS CONSISTENTLY on four files with the error described below. The only difference between these problematic files and files which convert OK is the number of fields in the file definition - they have more fileds (but less than 30).
ODBC/OLEDB (provider=MSDASQL) access error. Error Number = 170129 Failure opening file.
System Error Details: Description = ODBC driver does not support the requested properties. Source = Microsoft OLE DB Provider for ODBC Drivers Error Number = -2147217887 (0x80040e21)
File: 0ALIAS_IMPORT_nabava Description = ODBC driver does not support the requested properties. Source = Microsoft OLE DB Provider for ODBC Drivers Error Number = -2147217887 (0x80040e21)
Please help !!!
Hi vvido, I have the same situation, how do you solved it? can you share with me your solution?
Thanks |
| |
| |
| | | |
|
| | |
| |
Miembro registrado 94 mensajes |
|
Publicado el 02,marzo 2018 - 08:49 |
I did not find the solution. The funny thing was that it worked on some files, but no not others. I did not find a pattern. PCSoft support did not even answer to my questions.
I wanted to migrate an application from Clarion to Windev.
I wanted to create a WinDev application sitting on TPS files, later when the problems arose, just move the data to HFile. Obviously this was not a good idea. Even if this worked I had no idea about the speed or stability. Today I would choose a different approach - one time conversion of TPS data to something readable with Windev, maybe CSV and then move it into production (probably MSSQL, not HF)
Unfortunately these newsgroups do not offer so much support as Clarion newsgroups. Today the application is still maintained in Clarion.
I hope that you will have more luck. Please keep us informed. |
| |
| |
| | | |
|
| | |
| |
Publicado el 03,marzo 2018 - 22:13 |
Thanks for the answer vvido, but i didn't found solution to my problem, but I can saw a pattern, if your table have 20 field o less, the driver work fine, but if you exceed 20 field, it fail. May be you can do a partitition, two or more linked tables from the original table checking not exceed 20 fields per table. Good luck PD:I'm a Clarion programmer too, My lastest work was Clarion 6.1 but I'm working with Windev now. If you need help you can send me a mail to iovacom@yahoo.es, Santiago Chile. |
| |
| |
| | | |
|
| | |
| |
Publicado el 05,marzo 2018 - 13:51 |
Hi I have had the same problem but I found a free Clarion utility That does the job Magically, See if I can resurrect it, and I will give it to you Take Care and Keep Well Peter |
| |
| |
| | | |
|
| | |
| |
Publicado el 06,marzo 2018 - 09:18 |
OK here is some help. Go to the Repository and download. The Clarion Connection
Please let me know if this helps you
Be safe and keep well
Peter |
| |
| |
| | | |
|
| | |
| |
Publicado el 06,marzo 2018 - 09:23 |
I hope I have not posted this twice (That darn short term memory loss) Here may an answer lye Go to the repository and download the Clarion Connection. It may help you. Keep safe and keep well Peter |
| |
| |
| | | |
|
| | |
| |
Miembro registrado 94 mensajes |
|
Publicado el 21,marzo 2018 - 14:26 |
Thanks for the link. I will have a look at it. |
| |
| |
| | | |
|
| | | | |
| | |
|