Skip site navigation (1) Skip section navigation (2)

[ psqlodbc-Bugs-1010376 ] GUID code missing in convert.c ("Unrecognized C_parameter ..") and fix

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1010376 ] GUID code missing in convert.c ("Unrecognized C_parameter ..") and fix
Date: 2011-11-02 00:01:37
Message-ID: 20111102000137.EF645532DDCC@pgfoundry.org (view raw or flat)
Thread:
Lists: pgsql-odbc
Bugs item #1010376, was opened at 2008-04-15 13:02
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010376&group_id=1000125

Category: None
Group: None
>Status: Closed
Resolution: None
Priority: 3
Submitted By: Jan-Willem Goossens (jgoossens)
Assigned to: Nobody (None)
>Summary: GUID code missing in convert.c ("Unrecognized C_parameter ..") and fix

Initial Comment:
Hi,
Either I'm missing something, or there's the GUID (UUID) implementation missing in ResolveOneParam(..) in convert.c [08.03.0100], since I'm getting "Unrecognized C_parameter type in copy_statement_with_parameters" exceptions with param_ctype == -11 (=SQL_C_GUID).

I admit I dont really know what I'm doing, but adding the following lines seems to work well:

[convert.c, line 3745]
#if (ODBCVER >= 0x0350)
	    case SQL_C_GUID:
 		{
			SQLGUID *g = (SQLGUID *) buffer;
			sprintf (param_string,
				"%08lX-%04X-%04X-%02X%02X-%02X%02X%02X%02X%02X%02X",
				(unsigned long) g->Data1,
				g->Data2, g->Data3,
				g->Data4[0], g->Data4[1], g->Data4[2], g->Data4[3],
				g->Data4[4], g->Data4[5], g->Data4[6], g->Data4[7]);
		}
		break;
#endif

[heavily inspired by http://www.opensource.apple.com/darwinsource/Current/iodbc-34/iodbc/iodbc/trace/GetData.c]

I hope this is useful..
Jan-Willem


----------------------------------------------------------------------

Comment By: Hiroshi Inoue (hinoue)
Date: 2008-05-11 10:56

Message:
Could you please try the drivers on testing for 8.3.0201 at
 http://www.geocities.jp/inocchichichi/psqlodbc/index.html
.

----------------------------------------------------------------------

Comment By: madhusudhan rao (madhuk)
Date: 2008-05-09 10:31

Message:
Hi,

I am also getting an error due to SQL_C_GUID type

WINPROJ         1680-938 EXIT  SQLBindCol  with return code -1 (SQL_ERROR)
  HSTMT               086B37F0
  UWORD                       52 
  SWORD                      -11 <SQL_C_GUID>
  PTR                0x08AD7663
  SQLLEN                    16
  SQLLEN *            0x08AD7DEB
 
  DIAG [S1003] [Microsoft][ODBC Driver Manager] Driver does not support this parameter (0)

I am just trying to integrate MS Project with PGsql and got the above error. I am a java developer and not familiar with Visual studio to recompile the driver :-( . could you please help me in getting the ANSI version of the driver with the fix.

thanks in advance. 

 

----------------------------------------------------------------------

You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010376&group_id=1000125

pgsql-odbc by date

Next:From: noreplyDate: 2011-11-02 00:02:16
Subject: [ psqlodbc-Bugs-1011099 ] SQLStatistics returns A instead of D for descending index column
Previous:From: noreplyDate: 2011-11-02 00:01:19
Subject: [ psqlodbc-Bugs-1010376 ] GUID code missing in convert.c ("Unrecognized C_parameter ..") and fix

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group