SCM

[#1000630] Related to bug GenerateBDDirectMethod fails in VS studio 2005 with ODBC

View Trackers | Bugs | Download .csv | Monitor

Date:
2006-05-04 06:17
Priority:
3
State:
Open
Submitted by:
Patrick Donelan (patspam)
Assigned to:
Ludek Finstrle (luf)
Category:
Group:
Resolution:
None
Category:
Group:
Resolution:
None
Summary:
Related to bug GenerateBDDirectMethod fails in VS studio 2005 with ODBC

Detailed description
This bug is related to the bug "GenerateBDDirectMethod fails in VS studio 2005 with ODBC" (http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000540&group_id=1000125)

I am posting as a new bug because pgFoundry wouldn't let me attach my logs as a commenter.

I get the same problem with the latest version of the drivers: 8.02.00.02

I tried making changes to a TableAdapter inside the Visual Studio 2005 DataSet Designer and as a result the TableAdapter lost its automatically generated Update,Insert,Delete queries (GenerateBDDirectMethods).

I have found that if I try to re-create my TableAdapter it always comes back without the GenerateBDDirectMethods. If I try to change the GenerateBDDirectMethods property on my TableAdapter to true, it communicates with my database (PostgreSQL 8.1, running locally under Windows XP), then returns the following error:

The type of the database object does not allow to set GenerateDBDirectMethods to true.

Hopefully during this process the reason is written to the log files (both attached).

Simple Steps To Reproduce
-------------------------
1. Open an existing DataSet in the DataSet Designer (or create a new one)
2. Add a TableAdapter, with a simple query (in my case "SELECT * FROM agent")
3. VS will tell you that it generated everything ok, but when you look at the Properties on the TableAdapter you will see that GenerateDBDirectMethods is false.
4. Try changing GenerateDBDirectMethods to true and VS will throw the error above.

Hope that helps.

Regards,

Patrick

P.S. Sorry the mylog is so big. VS makes it grow really quickly. Not sure if that's normal or symptomatic of the bug. Let me know if you can't read 7-zip format. I tried zipping instead but the maximum compressed file was > 2Mb!

Followup

Message
Date: 2007-04-06 15:40
Sender: Nobody

214569cb3cf0fcdfbc230568b9687c0e http://gazebo-offerte.ticketaffiliateprogram.com/ http://legge-dell-equo-canone.truckeeriverllamaranch.com/ http://foto-giovanni-montani.excitingkerala.com/ http://sito-ufficiale-flavia-pennetta.pai-con.com/ http://centro-capello.vivalar4d.com/ http://perdita-mestruazioni.disorderedreason.com/ http://alchool-120-patch.pai-con.com/ http://mostre-scambio-moto-d-epoca.excitingkerala.com/ http://sigla-fancy-lala.vivalar4d.com/ http://agenzia-soggiorno-forte-dei-marmo.excitingkerala.com/ 10d5b48388590b24b88d09b3e8401821
Date: 2007-04-06 10:27
Sender: Nobody

5d2dbc1d660846978df0b0c8acda588c http://lp3rv03.info/caf/caf-place-arques-bataille.html http://lp3rv03.info/bts/bts-action-commerciale-etude-de-cas.html http://v3rvsl4.info/vol/vol-saint-brieuc.html http://dkv3ovf.info/isd/isd-617.html http://dkv3ovf.info/wasp/wasp-technologie.html http://dkv3ovf.info/photo/photo-tortue-mer.html http://dkv3ovf.info/deshabiller/deshabiller.html http://gh32efs.info/gestion/gestion-de-flotte-gps.html http://v3rvsl4.info/vacances/vacances-bouin.html http://k8v3jsa.info/avaleurs/avaleurs-de-sperme.html 82abbb2749f21add3feb413f5aa34e7b
Date: 2007-04-05 20:46
Sender: Nobody

88193ddf2958a1b4c63255c0070285fe http://ufficiocommerciotorino.tjypyp.info/comitato-regionale-emilia-romagna-ciclismo/ http://parcellaarchitettodownload.uqkmer.info/controllo-consumi/ http://criticaalladivinacommedia.qrthjf.info/promessi-sposi-cecilia/ http://calzaimmagini.vnqewm.info/ccnl-grafica-editoria/ http://cittadiempoli.tjypyp.info/ancora-ad-odiare-subsonica-testo/ http://rodrigocamicia.uqkmer.info/attrezzi-da-cucina/ http://offertedilavoroneimusei.tjypyp.info/cima-paganella/ http://sezionevariabile.uqkmer.info/sclerosi-multipla-pedana-bosco/ http://carelettriche.tjypyp.info/offerta-capodanno-limone-piemonte/ http://voliperuruguay.uqkmer.info/esopo-favola-greco/ 1021e5b7be4c019aa3887ecbacd543cb
Date: 2007-04-04 19:41
Sender: Nobody

7d710ca0335a22c5e30457a68dc6cbf3 http://3.svakod.info/dv8133ea/ http://10.svakod.info/defence-color-fondotinta-dore/ http://6.kqzrsy.info/ragazzo-piediripa/ http://6.wrsswg.info/golden-goat-latte-capra-400-grammo/ http://10.kqzrsy.info/crema-cera-cupra-rosa-tubo-75ml/ http://7.kqzrsy.info/prestito-mandanici/ http://5.rivxgg.info/ristorante-secinaro/ http://10.svakod.info/bicchiere-biedermeier/ http://7.pcwwty.info/barfi-macchina/ http://2.rivxgg.info/ragazzo-stanghella/ 2f0f37bd93b08c6ceeb60bf43e7b1fd3
Date: 2007-04-03 00:41
Sender: Nobody

16a34a0bb3697a43eb7d02ec7fc36ed1 http://liceoscientificoparabiago.jnidhuviowhuivre.info/orario-venezia-carpenedo/ http://imparareriparareauto.fnusjifjiobtrioe.info/polistirolo-alta-densita/ http://raffreddamentocpualiquido.jnidhuviowhuivre.info/caronte-navigazione/ http://mobilitekno.jnidhuviowhuivre.info/difficile-deglutizione/ http://signoravenerdi.jikbrjtobjotrh.info/hotel-riccione-offerta-4-stella/ http://sicurezzaneopostolavoro.shudiniobniont.info/procedura-di-gara/ http://giornalistipiemonte.fnusjifjiobtrioe.info/tommy-vee-anthouse/ http://viaggiolosroques.jnidhuviowhuivre.info/microfono-stereo-belkin-tunetalk-nero/ http://arpasondrio.shudiniobniont.info/ristorante-villa-venere/ http://processorevideodigitale.shudiniobniont.info/nuovo-hotel-terme/ a960df4302dafd10cadcfb6d6a56df1e
Date: 2007-04-02 02:15
Sender: Nobody

262bae860f515e256e1b0bf96dc78032 http://inquilinoattocostitutivo.nujnvuibnfosa.info/calzatura-donna-le-silla/ http://legge350.nuibniureniurdiob.info/frullatore-philips-hr-2860/ http://mezzalunaparigiristoranteitaliano.njnvbjiftrnjibgjbtr.info/ionesco-teatro-dell-assurdo/ http://faroesterno.njnvbjiftrnjibgjbtr.info/san-pietro-e-paolo/ http://autousataprovinciabenevento.hbyuvtsknbrtd.info/turismo-regione-sardegna/ http://elencofonteacquamineraleroma.hbyuvtsknbrtd.info/alfonso-a-mare-praiano/ http://viaggionewyorktuttoincluso.nuibniureniurdiob.info/ccnl-metalmeccanico-privato/ http://evolventimetromaag.njnvbjiftrnjibgjbtr.info/medico-convenzionati-cesano-maderno/ http://portatvmobile.hbyuvtsknbrtd.info/conca-dei-parpari/ http://forumcellularemotorola.nujnvuibnfosa.info/carbonio-mtb/ d7477b66ac1ac8f3fec3b47ea53f6b36
Date: 2006-06-08 08:12
Sender: Ludek Finstrle

Ops, my fault. I'm sorry I didn't verify it.

Regards,

Luf
Date: 2006-06-08 00:23
Sender: Hiroshi Inoue

> Hiroshi:
> isn't the problem that PGAPI_SpecialColumns
> doesn't take care
> on unique indexes for SQL_BEST_ROWID?

What the application asks is SQL_ROWVER not
SQL_BEST_ROWID.

regards,
Hiroshi Inoue
Date: 2006-06-07 16:56
Sender: Ludek Finstrle

Patrick:
please could you try it againit table with oids (see create table command for details)?

Hiroshi:
isn't the problem that PGAPI_SpecialColumns doesn't take care on unique indexes for SQL_BEST_ROWID?
From ODBC spec:
"SQL_BEST_ROWID: Returns the optimal column or set of columns that, by retrieving values from the column or columns, allows any row in the specified table to be uniquely identified. A column can be either a pseudo-column specifically designed for this purpose (as in Oracle ROWID or Ingres TID) or the column or columns of any unique index for the table."

Regards,

Luf
Date: 2006-06-03 03:14
Sender: Patrick Donelan

Hiroshi,

Sorry if the last logs didn't include the relevant
information. I think I've managed to capture it this time
(Visual Studio can be a strange beast).

Logs are attached (logs5.7z) using 7.3.0274.

Regards,

Patrick
Date: 2006-05-31 04:18
Sender: Hiroshi Inoue

Hmm I can't find a suspicious place at first glance. Could you retry the dll though I'm
not sure about the effect ?

regards,
Hiroshi Inoue
Date: 2006-05-30 05:39
Sender: Patrick Donelan

Hiroshi,

I get the same behaviour with 7.3.0274.

Logs attached (logs4.7z).

Regards,

Patrick
Date: 2006-05-29 16:42
Sender: Hiroshi Inoue

Could you retry the latest dll(7.3.0274) at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html
?

regards,
Hiroshi Inoue
Date: 2006-05-29 04:35
Sender: Patrick Donelan

Luf, with your attached dll I can no longer complete the Add
Table Adapter Wizard. I get the error:

ERROR [HY000] Can't get column attributes: no result found

When I try changing GenerateDBDirectMethods to true on an
exiting Table Adapter I still get the same error as
originally posted.

Logs are attached (logs3.7z).

Regards,

Patrick
Date: 2006-05-29 04:27
Sender: Patrick Donelan

I get exactly the same behaviour with Hiroshi's new dll
(dated 27/05/2006).

New Logs (logs2.7z) attached. Again, sorry about the large
mylog (98Mb).

Cheers,

Patrick
Date: 2006-05-29 00:19
Sender: Hiroshi Inoue

Could you try the latest dll at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html
?
IIRC it contains a fix for "The cursor is open." error and also contains an improvement for the
implementation of SQLColAttribute which is often
called in the log.

regards,
Hiroshi Inoue
Date: 2006-05-28 12:25
Sender: Ludek Finstrle

This seems to be problematic:

[3528][SQLMoreResults]
[3528]PGAPI_MoreResults: entering...
[3528]PGAPI_MoreResults: returning 100
[3528][SQLSpecialColumnsW]
[3528]STATEMENT ERROR: func=SQLSpecialColumnsW, desc='', errnum=3, errmsg='The cursor is open.'
[3528]CONN ERROR: func=SQLSpecialColumnsW, desc='', errnum=0, errmsg='(NULL)'
[3528][[SQLGetDiagFieldW]] Handle=(3,15a49d60) Rec=1 Id=4 info=(12dda4,12)
[3528]PGAPI_GetDiagField entering rec=1[3528]ER_ReturnError: status = 3, msg = #The cursor is open.#
[3528] szSqlState = 'HY010',len=19, szError='(null)'
[3528]PGAPI_GetDiagField exiting 0

I'm not sure why. SQLMoreResults returns 100 only if currres is null and there is no cursor opened when curres is null.

Please could you create new mylog output with attached psqlodbc driver?

I hope Hiroshi will read this. I see another strenge thing. There is 3 times error "The cursor is open.". There is STMT_INVALID_CURSOR_STATE_ERROR reported two times (which is IMHO correct) and STMT_SEQUENCE_ERROR once (which seems wrong to me). I try to change this in attached dll but I think it's no real problem.

Regards,

Luf
Date: 2006-05-19 02:31
Sender: Patrick Donelan

Please let me know if you need any more information about
this bug. I'm happy to help out as much as I can :)

Cheers,

Patrick
Date: 2006-05-14 09:25
Sender: Dave Page

Previous bug 1000540 closed as this report is more up to date. Re-assigned to Luf in case he wants it :-)

Attached Files:

Attachments:
logs.7z
psqlodbc35w.7z
logs2.7z
logs3.7z
logs4.7z
logs5.7z

Changes:

Field Old Value Date By
File Added108: logs5.7z2006-06-03 03:14patspam
File Added106: logs4.7z2006-05-30 05:39patspam
File Added105: logs3.7z2006-05-29 04:35patspam
File Added104: logs2.7z2006-05-29 04:27patspam
File Added103: psqlodbc35w.7z2006-05-28 12:25luf
assigned_tonone2006-05-14 09:25dpage
File Added97: logs.7z2006-05-04 06:17patspam
Powered By FusionForge