I was initially using Sqlbase and then converted to Oracle Express Edition and then converted to SQL Server Express Edition. Now, I feel Express Edition is not right fit for me since it supports only 1 GB RAM, 1 Core Processor and 10 GB DB Storage only. So, I thought to evaluate Postgresql and MySql and I decided to go with Postgresql since I have more stored procedures and triggers.
my question is that, Will there be anyone who uses postgresql with Team Developer 7.x ( there is a postgres fix in TD 7.0.3)? if so, just wanted to know at what extent TD supports. I just started Data migration now through TD and so far so good.
If I am getting posgresql error in TD application then error dialog window appears with the error message "Not found in Error.sql". So, I capture the proper error message through SqlGetError() to Turns off backend error mapping and reports real backend errors. OR, I enable ODBCTrace in Sql.ini to find out actual error message. but just wanted to know whether TD has any settings to show the postgresql error message in default error dialog window.
I have been using Postgresql with TD 6 and TD 7 (64bit) for quite some time now without any problems.
I got used to the behavior in case of incorrect SQL statements in TD ("Not found..."). I help myself by transferring the incorrect statement to an SQL tool (e. g. pgAdmin) and testing it there. That works fine for me.
It is bit of difficult in initial stage but I am sure this OSDBMS will start giving more features and benefits in future.
I have raised ticket with Gupta. Have you faced this challenge before?
If I use constant text, concatenation operator, apply any postgresql functions then it returns as text data type (This is postgres design I hope). So, this is not displaying with normal String data type/variable in TD. It requires Long String since the function return type is text data type.
1. Create a table with one columns as varchar(15)
create table test123
2. Insert a string value to col1.
insert into test123 values ('i am upper case')
3. Run the TD application AS-IS
col1 - shows the value in the TD as the col1 is VARCHAR data type
col2 - does not show the value in the TD as posgresql upper function is returning text data type
col3 - shows the value in the TD due to work around
col4 - does not show as this is constant text as it returns data type is text
However, For col3, cost of converting for all SQLs is huge and work around design is not a good approach.
4: Change col2 & col4 in Grid to Long String and strCol1 and strcol4 variable to Long String.
col1 - shows the value in the TD
col2 - shows the value in the TD
col3 - shows the value in the TD
col4 - shows the value in the TD
However this work around is also requires more cost and design is not right.
my clarification is that, the application should work with string if the size is less than or equal to 254 and long string for more than 254.
I hope this is major issues and hope if TD supports for posgresql ( I hope it is yes since there is a bug fix even in TD 7.0.3) then this issue would have been raised before.
Can you please let me know how to proceed on this before I explore MySQL/MariaDB as an alternative option.
I see the connection parameters in gupta.ini.
and tried to check with TextAsLongVarchar=No in the above DSN though this is not rigght way but no effect.
Sample file is attached.
I tried out your sample and it works fine with TD 7.0.3 (64bit), without any changes, all colums are type of String!
Tis is amazing! I also struggled with the same problems before and solved it the the way you discribed it as workaround. For my opinion, it was not a TD bug, because PG returned "unknown" as data type for string constants (or even NULL as constant) and "text" for aggregate functions. So now I´m glad to see that it works in a much more "natural" way!
I will now carry on testing my programs, for to see, if it is now possible to get rid of all of them cast functions.
Thanks. That's right. I have tested in TD 6.3.2 and got this issue. I got response from Gupta (JM) too ,saying that, it works in TD 7.0.3. so, I tested in TD 7.0.3 using win32 ODBC/.NET ODBC (ANSI & Unicode) and both are working fine.
I am bit relaxed and conversion is in progress now
These are my questions:
- which version of ODBC driver do you use? Those from [https://www.postgresql.org/ftp/odbc]?
- Have you tested with 32-bit TD?
- Any issue with dates and blob fields?
- unicode support is ok?
- performance issues?
- SQL error trapping and reporting?
I'm actually using oracle as my preferred DBMS (with TD 6.2), but i'm evaluating to adopt PGSQL (+TD 7.0.3) for new projects...
Migration from SQL Server is still in progress. I had more procedures and triggers so it takes time to complete and then I need to change TD SQL statements in few places. Planning to complete this in next 3 months.
Will list out here if there is any issues.
if you are looking for a free database edition, you could also consider DB2 Express-C. It has a limitation of 2 Cores, 16 GB RAM and 15 TB Data.
Ok. That's nice. I have used Oracle Express and SQL Server express edition earlier but thinking to move to database where there is no limitation . And PostgreSQL ORDBMS is having lot of features and it is placed in better ranking - https://db-engines.com/en/ranking
Who is online
Users browsing this forum: Ccbot [Crawler] and 0 guests