headers
Marco Gaiarin | 3 Jan 2012 11:46
Picon

Re: [ANNOUNCE] psqlODBC 09.01.0100 Released


> We are pleased to announce the release of psqlODBC 09.01.0100. For
> details of the changes in this release, please see the notes at:
> http://psqlodbc.projects.postgresql.org/release.html

I've started to deploy this version in my organization, using WPKG
(http://wpkg.org), but if i silent remove previous version (9.0.310)
and install that (9.1.100) every DSN defined in control panel popup
me a window (even several time):

	odbcad32.exe - Immagine Danneggiata (damaged image?)
	L'applicazione o DLL C:\Programmi\psqlODBC\0901\bin\libpq.dll non è un immagine valida di Windows.
Verificare con il dischetto di instalazione.
	(the application or DLL ... it is not a valid windows image. Verify the installation)

For the rest, ODBC seems to work well: i've tried some internal app
and a quick query with excel and works as expected, without popup
errors or something like that, so seems only an (annoying) bug related
to DSN configuration.

--

-- 
dott. Marco Gaiarin				    GNUPG Key ID: 240A3D66
  Associazione ``La Nostra Famiglia''                http://www.sv.lnf.it/
  Polo FVG  -  Via della Bontà, 7 - 33078  -  San Vito al Tagliamento (PN)
  marco.gaiarin(at)sv.lnf.it	  tel +39-0434-842711  fax +39-0434-842797

		Dona il 5 PER MILLE a LA NOSTRA FAMIGLIA!
	   http://www.lanostrafamiglia.it/chi_siamo/5xmille.php
	(cf 00307430132, categoria ONLUS oppure RICERCA SANITARIA)
(Continue reading)

Permalink | Reply | 3 comments |
headers
Hiroshi Saito | 4 Jan 2012 01:40
Picon

Re: [ANNOUNCE] psqlODBC 09.01.0100 Released

Hi.

Ooops, sorry..
I made the mistake in the reference relation of an installer script.
As for 32bit instaler, 64-bit libpq.dll was contained.:-(
psqlodbc_09_01_0100-1 was rereleased about msi and mm.

Regards,
Hiroshi Saito

(2012/01/03 19:46), Marco Gaiarin wrote:
>
>> We are pleased to announce the release of psqlODBC 09.01.0100. For
>> details of the changes in this release, please see the notes at:
>> http://psqlodbc.projects.postgresql.org/release.html
>
> I've started to deploy this version in my organization, using WPKG
> (http://wpkg.org), but if i silent remove previous version (9.0.310)
> and install that (9.1.100) every DSN defined in control panel popup
> me a window (even several time):
>
> 	odbcad32.exe - Immagine Danneggiata (damaged image?)
> 	L'applicazione o DLL C:\Programmi\psqlODBC\0901\bin\libpq.dll non è un immagine valida di
Windows. Verificare con il dischetto di instalazione.
> 	(the application or DLL ... it is not a valid windows image. Verify the installation)
>
> For the rest, ODBC seems to work well: i've tried some internal app
> and a quick query with excel and works as expected, without popup
> errors or something like that, so seems only an (annoying) bug related
> to DSN configuration.
(Continue reading)

Permalink | Reply | 2 comments |
headers
Marco Gaiarin | 4 Jan 2012 09:39
Picon

Re: [ANNOUNCE] psqlODBC 09.01.0100 Released

Mandi! Hiroshi Saito
  In chel di` si favelave...

> Ooops, sorry..
> I made the mistake in the reference relation of an installer script.
> As for 32bit instaler, 64-bit libpq.dll was contained.:-(
> psqlodbc_09_01_0100-1 was rereleased about msi and mm.

Perfect! Many thanks! Works as expected.

And, excuse me: you have found the culprit, but i've forgot to say:
Windows XP sp3, 32 bit.

-- 
dott. Marco Gaiarin				    GNUPG Key ID: 240A3D66
  Associazione ``La Nostra Famiglia''                http://www.sv.lnf.it/
  Polo FVG  -  Via della Bontà, 7 - 33078  -  San Vito al Tagliamento (PN)
  marco.gaiarin(at)sv.lnf.it	  tel +39-0434-842711  fax +39-0434-842797

		Dona il 5 PER MILLE a LA NOSTRA FAMIGLIA!
	   http://www.lanostrafamiglia.it/chi_siamo/5xmille.php
	(cf 00307430132, categoria ONLUS oppure RICERCA SANITARIA)

--

-- 
Sent via pgsql-odbc mailing list (pgsql-odbc <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Permalink | Reply | 1 comment |
headers
Hiroshi Saito | 4 Jan 2012 13:50
Picon

Re: [ANNOUNCE] psqlODBC 09.01.0100 Released

Hi Marco-san.

thank you for a quick response.!

(2012/01/04 17:39), Marco Gaiarin wrote:
> Mandi! Hiroshi Saito
>    In chel di` si favelave...
>
>> Ooops, sorry..
>> I made the mistake in the reference relation of an installer script.
>> As for 32bit instaler, 64-bit libpq.dll was contained.:-(
>> psqlodbc_09_01_0100-1 was rereleased about msi and mm.
>
> Perfect! Many thanks! Works as expected.
>
> And, excuse me: you have found the culprit, but i've forgot to say:
> Windows XP sp3, 32 bit.
>

--

-- 
Sent via pgsql-odbc mailing list (pgsql-odbc <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Permalink | Reply | 0 comments |
headers
Honza Horak | 6 Jan 2012 09:56
Picon
Favicon

Errors found by static analysis tool

Hi,

I'm sending this mail again, because the first two attempts don't seem 
to be successful (sorry if it's duplicate). Trying without the 
attachments, they can be found at links below.

psql-odbc-09.00.0200 has been scanned using Coverity static analysis 
tool, which discovered several more or less severe problems [1]. Please 
note, that there can be some false positives, but many of them are real 
issues.

A patch [2] with some obvious fixes and the error report itself are 
attached.

Cheers,

Honza

[1] 
http://hhorak.fedorapeople.org/psql-odbc-coverity/120105-psql-odbc-09.00.0200-coverity.err
[2] 
http://hhorak.fedorapeople.org/psql-odbc-coverity/120105-psqlodbc-coverity.patch

--

-- 
Sent via pgsql-odbc mailing list (pgsql-odbc <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Permalink | Reply | 1 comment |
headers
Unais Muhammed | 9 Jan 2012 18:53
Picon

bug report - Transaction Rollback not successful

Dear sir,


This is to report a suspected  bug in  psqlODBC 09.01.0100 when used with Microsoft Visual Basic 6 with ADODB 

This happens when a transaction with  INSERT INTO - SELECT combination queries  rolled back on an error. The queries before the the occurance of the error ( Rollback is initiated)  found committed when some other transaction is committed. ie. the querries in the transaction block upto the rollback statement is committed when some other transaction block is committed (Eg. Sale is saved, Order is Edited etc.). 

In my case the bug noticed in the following function. This is for converting a sale order to a sale. 
--------------------------------------------------------------------------------------------------   
Public Function ConvertOrder(OrdNo As Long) As Boolean

On Error GoTo err_here
Dim IsStartTrans as boolean
IsStartTrans  = False
ConvertOrder = False
Dim RSOrd As New ADODB.Recordset
SqlStr = "Select * from orders where firm_id=" & PubFirmId & " AND   OrdNumber=" & OrdNo & " ;"
RSOrd.Open SqlStr, dbx
If RSOrd.EOF Then
    MsgBox "Order No. " & OrdNo & " Not Available for Conversion", vbInformation
    Exit Function
End If

RSOrd.MoveFirst
If RSOrd!closed = 1 Then
    'Closed Order
    Exit Function
End If

Dim SaleNo As Long

SaleNo = GetNewSaleNumber ' THIS IS A FUNCTION TO GET THE NEXT SALE BILL NUMBER

IsStartTrans = True
dbx.BeginTrans

'SQL No.1

SqlStr = "INSERT INTO sale( " & _
            "firm_id, invnumber, invdate, salesmancode, cust_number, cust_name, " & _
            "routecode, pricegroup, totalamount, totaldiff, discount, paid," & _
            "journalrefno, isrm, orderno, memo, lastbalance) " & _
"SELECT firm_id,  " & SaleNo & " as invnumber,'" & Format(Now(), "yyyy-mm-dd hh:mm:ss") & "',  salesmancode, cust_number, " & _
       "cust_name, routecode, pricegroup, totalamount, totaldiff, discount, " & _
       "paid , 0, IsRM, ordnumber, Memo, get_head_current_balance(" & PubFirmId & ", cust_number) " & _
        "FROM orders where firm_id=" & PubFirmId & " AND  OrdNumber=" & OrdNo & " ; "
dbexecute SqlStr   'dbexecute IS A FUNCTION TO EXECUTE THE QUERRY SqlStr

'SQL No.2
SqlStr = "INSERT INTO saleit(" & _
            "firm_id, invnumber, item_code, qty, rate, cost, slno) " & _
        "SELECT firm_id, " & SaleNo & " as invnumber, item_code, qty, rate, cost,  slno " & _
        "FROM orderit  where firm_id=" & PubFirmId & " AND  OrdNumber=" & OrdNo & " ;"
dbexecute SqlStr

'SQL No.3
SqlStr = "select add_item_stock(" & PubFirmId & ",item_code, (0 - qty)::real  ) FROM orderit  where firm_id=" & PubFirmId & " AND  OrdNumber=" & OrdNo & " ;"
dbexecute SqlStr

'add_item_stock is a function to modify the stock in the items table 

'SQL No.4

SqlStr = "UPDATE orderit SET SoldQty = Qty  WHERE   firm_id=" & PubFirmId & " AND   OrdNumber=" & OrdNo & " ;"
dbexecute SqlStr
 
SQL No.5
SqlStr = "update orders set Closed=true where firm_id=" & PubFirmId & " AND   OrdNumber=" & OrdNo
dbexecute SqlStr

dbx.CommitTrans
IsStartTrans = False
ConvertOrder = True
Exit Function

err_here:
if IsStartTrans  then 
     dbx.RollbackTrans
     MsgBox "Order No. " & OrdNo & " Could not Convert" & vbCrLf & Err.Description
Else
     Msgbox "Error : " & Err.Description

End if
End Function

--------------------------------------------------------------------------------------------------------------------------------------------------
Query No:1 and 2 are INSERT INTO - SELECT combination queries for taking some data (one row ) from order table and inserting to Sale table & Orderit to SaleIt Table

Query No.3 is for updating the stock. if the stock goes below zero, the function triggers an error and the error handler is executed and the transaction is rolled back. When I used ODBC  09.01.0100  the transaction is not rolled back completely. The SQL No.1 &2 are held until any other program segment tries to commit some other transaction outside this function and  new rows are found added in Sale and SaleIt tables.

This is not happening when PSQLODBC Version 8.01.02.00 is used. 

I hope this report will help improving the PSQLODBC  project. 

For any further clarification, kindly feel free to call me on +91 9447033489

Thanks & Regards

K.Muhammed Unais
System Administrator,
Kerala State Electricity Board,
Kozhikode, Kerala, india


--
---------------------------------------------------------------------------------------------------------------------------------------
If a man is called to be a streetsweeper, he should sweep streets even as Michelangelo painted, or Beethoven composed music, or Shakespeare wrote poetry. He should sweep streets so well that all the hosts of heaven and earth will pause to say, here lived a great streetsweeper who did his job well.
- Martin Luther King, Jr.


Permalink | Reply | 1 comment |
headers
Hiroshi Inoue | 10 Jan 2012 12:51
Picon

Re: bug report - Transaction Rollback not successful

Hi,

(2012/01/10 2:53), Unais Muhammed wrote:
> Dear sir,
>
> This is to report a suspected  bug in psqlODBC 09.01.0100 when used with
> Microsoft Visual Basic 6 with ADODB
>
> This happens when a transaction with  INSERT INTO - SELECT combination
> queries  rolled back on an error. The queries before the the occurance
> of the error ( Rollback is initiated)  found committed when some other
> transaction is committed. ie. the querries in the transaction block upto
> the rollback statement is committed when some other transaction block is
> committed (Eg. Sale is saved, Order is Edited etc.).
>
> In my case the bug noticed in the following function. This is for
> converting a sale order to a sale.

Could you send me the Mylog output oh the case?

regards,
Hiroshi Inoue

--

-- 
Sent via pgsql-odbc mailing list (pgsql-odbc <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Permalink | Reply | 0 comments |
headers
Hiroshi Inoue | 10 Jan 2012 12:52
Picon

Re: Errors found by static analysis tool

Hi Honza,

(2012/01/06 17:56), Honza Horak wrote:
> Hi,
>
> I'm sending this mail again, because the first two attempts don't seem
> to be successful (sorry if it's duplicate). Trying without the
> attachments, they can be found at links below.
>
> psql-odbc-09.00.0200 has been scanned using Coverity static analysis
> tool, which discovered several more or less severe problems [1]. Please
> note, that there can be some false positives, but many of them are real
> issues.
>
> A patch [2] with some obvious fixes and the error report itself are
> attached.

Thanks for the report.
I would commit the patch.

regards,
Hiroshi Inoue

--

-- 
Sent via pgsql-odbc mailing list (pgsql-odbc <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Permalink | Reply | 0 comments |
headers
Josef Springer | 26 Jan 2012 12:49

ODBC for Windows-64 ?

Hello,

where can i found the ODBC-Driver for Windows-64, thanks ?

mit freundlichen Grüßen / best regards,
Josef Springer
(Geschäftsleitung/Management)

Postal
	Address
	_Josef.Springer <at> joops.com_
	Orlando-di-Lasso Str. 2
	D-85640 Putzbrunn
Phone
	Office
	+49 (0)89 600 6920
	
	
Phone 	Fax
	+49 (0)89 600 69220
	
	
Web
	Web
	http://www.joops.com
	
	

JOOPS
	(HRB München 86239)

*-- the software company --*
Permalink | Reply | 0 comments |
headers
Fred Parkinson | 27 Jan 2012 16:32
Favicon

odbc link keep losing it senses

I have a postgresql 8.1.22 installation on a suse linux 10.1 box on a vmware virtual server.
 
I am using odbc driver 8.02.04 to link an M$ Access application to the postgresql database.
For some reason, every time I close the Access program, then re-open it and try to read from one of the tables, I get the error:
"ODBC--connection to '{PostgreSQL ANSI}<ip address>' failed."
 
Then when I use the Access menu tool File>Get External Data>Link Tables and choose the postgresql odbc option to the database, the link executes correctly and I am in.  Until the next time I open the Access app., then I have to start over.
 
Any ideas why the ODBC link is so fragile, and breaks every time I close my application?
 
Thanks.
 
 
 
Fred Parkinson
Application Programmer
Association of Bay Area Governments
510-464-7931
Permalink | Reply | 0 comments |

Gmane