Hi Friends

-
Hi Friends,

I am using Using Delphi 5+ infomix, Delphi 5+ informix on unix, and delphi 2006+ Sql Server.(All  3 source code  has same functionality)

Now i am merging all source code to one single code(delphi 2006) but i am facing issue while connecting Infomrix unix with ADO component of delphi 2006. Informix on windows + delphi 5's souce code works fine while i used them by creating DSN. DSN of unix informix database created successfully but while i used them with any ADO component of delphi 2006 its give error like "Unspecified Error". Connection done successfully as i debug application but when i write any SQL statement and try to OPEN it then it gives error "Unspecified Error".

Any help on this is appreciated, Please let me know if you need any more details.

Comments

  1. Lars FosdalMarch 31, 2015 at 2:43 AM

    Which SKU of Delphi 2006?  Pro or Enterprise?
    There is another post here somewhere about the db drivers requiring Enterprise version - but there also was a workaround.
    Edit: Found it: https://plus.google.com/105621406928214712237/posts/Zy6rk9VfVco

    ReplyDelete
  2. Lars FosdalMarch 31, 2015 at 2:46 AM

    Duh! Strike that comment - you are already using ADO... then I don't know what is wrong.
    Have you tried making a minimum app with only a single ADO component?

    ReplyDelete
  3. Gadhavi HardipMarch 31, 2015 at 2:59 AM

    Thanks Lars Fosdal , Yes i am trying with sample application which has only one ADO connection and ADOQuery components and DSN is created successfully.
    It connecting successfully with DSN but when i execute any SQL on that, its giving error.

    I am using professional.

    ReplyDelete
  4. Lars FosdalMarch 31, 2015 at 7:28 AM

    Try using  Process Monitor from SysInternals to see if it fails at loading the drivers?

    https://technet.microsoft.com/en-us/library/bb896645.aspx

    ReplyDelete
  5. Gadhavi HardipMarch 31, 2015 at 10:23 PM

    Ok, Let me check. Thanks for help Lars Fosdal

    ReplyDelete
  6. Gadhavi HardipMarch 31, 2015 at 11:31 PM

    I think, Its not a driver loading issue, because it gives error while returning result set of query.

    If i write table name in query which is not exist, then it gives error as well that "Specified table does not exist".

    Let me check more..

    ReplyDelete
  7. Lars FosdalApril 1, 2015 at 4:02 AM

    Can it be a rights issue with the login you are using?

    ReplyDelete
  8. Gadhavi HardipApril 1, 2015 at 4:17 AM

    DSN connecting successfully  and fetching tables's names as well

    ReplyDelete
  9. Lars FosdalApril 1, 2015 at 8:54 AM

    Tricky one.  It has to be a problem with your query then.  Is it complex?  Are there typecasts or conversions in there? Can it fail on NULL value comparisons?

    ReplyDelete
  10. Gadhavi HardipApril 1, 2015 at 9:55 PM

    No, Simple "Select * From "

    ReplyDelete
  11. Gadhavi HardipApril 1, 2015 at 11:44 PM

    It works fine on sample application of  firemonkey with firedac controls, but when we try with ADO controls then it gives error like "Unspecified Error"

    ReplyDelete
  12. Lars FosdalApril 2, 2015 at 12:20 AM

    Any reason to not use FireDAC? We migrated from ADO to FireDAC for our MS SQL Server connectivity last year, and it was a good improvement in performance and stability. We did this for a Windows service, and several VCL apps.

    ReplyDelete
  13. Gadhavi HardipApril 2, 2015 at 12:25 AM

    its very big legacy system, and we require too much time to change all structure. and client also not in favor to change all this.

    ReplyDelete
  14. Gadhavi HardipApril 9, 2015 at 12:36 AM

    Hi Lars Fosdal ,
    I got solution of above matter..I just changed cursor location property from client to server for dataset and it works fine..for unix-informix dataset. Thanks for all your support

    ReplyDelete
  15. Lars FosdalApril 9, 2015 at 1:19 AM

    Glad you figured it out!

    ReplyDelete

Post a Comment