UNIDAC DBF connection errors
Posted: Mon 17 Jun 2019 14:40
Hello,
For a while now, I have been trying to have a stable basic connection with dbf files using TUniDAC components but I couldn’t succeed. I have am encountering some errors in different conditions.
My platform is : Win 7, Delphi XE7, Unidac Components 6.02
(I have created a sample exe and prepared my sample dbf files. I want to send them as well with the mail but I couldnt. I think I do it seperately. I would appreciate if you tell me how.)
1 - [Microsoft][ODBC Driver Manager] Invalid string or buffer length
I get this error whenever I try to connect to a dbf file wit a name longer than 16 chars (with the dot and extensiton)
(With the sample program, please try to connect to the file: NameExceedsTheLimit.dbf)
2 – Turkish characters not showing.
Even though I have read that Unidac DBF have Turkish character set support, no, Turkish characters are not showing. Is there an option I should play with?
(With the sample program, please connect and see the changed Turkish characters in the File: TRChars.dbf)
In the field ‘MAHALLE’ the values must have showed as:
YETM¦ÌB¦R EVLER MAHALLES¦ -> YETMİŞBİR EVLER MAHALLESİ
AR¦F¦YE MAHALLES¦ -> ARİFİYE MMAHALLESİ
GÍKMEYDAN MAHALLES¦ -> GÖKMEYDAN MAHALLESİ
YETM¦ÌBE̦NC¦YIL MAHALLES¦ -> YETMİŞBEŞİNCİYIL MAHALLESİ
and so on….
3 – [Microsoft][ODBC Driver Manager] Unexpected Error from External Database Driver (8961)
When I try to connect to a certain file, this error I get. I couldn’t find any clue why.
Please connect and see the changed Turkish characters in the File: PARSEL.dbf)
These are my obstinate errors so far. Couldn’t find a way to walk around them so I will be grateful if you could help.
What I also wonder is, why I get ODBC errors while I am connecting with Unidac DBF provider?
Thanks in advance.
Aslı
For a while now, I have been trying to have a stable basic connection with dbf files using TUniDAC components but I couldn’t succeed. I have am encountering some errors in different conditions.
My platform is : Win 7, Delphi XE7, Unidac Components 6.02
(I have created a sample exe and prepared my sample dbf files. I want to send them as well with the mail but I couldnt. I think I do it seperately. I would appreciate if you tell me how.)
1 - [Microsoft][ODBC Driver Manager] Invalid string or buffer length
I get this error whenever I try to connect to a dbf file wit a name longer than 16 chars (with the dot and extensiton)
(With the sample program, please try to connect to the file: NameExceedsTheLimit.dbf)
2 – Turkish characters not showing.
Even though I have read that Unidac DBF have Turkish character set support, no, Turkish characters are not showing. Is there an option I should play with?
(With the sample program, please connect and see the changed Turkish characters in the File: TRChars.dbf)
In the field ‘MAHALLE’ the values must have showed as:
YETM¦ÌB¦R EVLER MAHALLES¦ -> YETMİŞBİR EVLER MAHALLESİ
AR¦F¦YE MAHALLES¦ -> ARİFİYE MMAHALLESİ
GÍKMEYDAN MAHALLES¦ -> GÖKMEYDAN MAHALLESİ
YETM¦ÌBE̦NC¦YIL MAHALLES¦ -> YETMİŞBEŞİNCİYIL MAHALLESİ
and so on….
3 – [Microsoft][ODBC Driver Manager] Unexpected Error from External Database Driver (8961)
When I try to connect to a certain file, this error I get. I couldn’t find any clue why.
Please connect and see the changed Turkish characters in the File: PARSEL.dbf)
These are my obstinate errors so far. Couldn’t find a way to walk around them so I will be grateful if you could help.
What I also wonder is, why I get ODBC errors while I am connecting with Unidac DBF provider?
Thanks in advance.
Aslı