firebird-odbc-devel — All about development of Firebird ODBC driver donated by IBPhoenix

[Firebird-odbc-devel] Creating, Editing Remote-Views with FoxPro

[<sc...@de...>]

Hi,

when creating a remote-view with visual foxpro, the SQLPrepare()
is not called with the correct sql-statement.
The driver always prepends "SYSDBA." before the specific table.
eg:
	SELECT * FROM SYSDBA.TEST 
instead of:
	SElECT * FROM TEST

...
I guess the username was used (putted before the relationname),
but how could it happen?
-->
The statement was formed by VFP, but this only happens with this driver . Which 
method/function tells VFP to do so?.
-----
A last another proposal concerning VFP-Views:

in ODBCStatement.cpp line794ff:

use this code:
RETCODE OdbcStatement::sqlNumResultCols(SWORD * columns)
{
	clearErrors();

	if (!resultSet ){
		// if the resultSet does not exist, execute it, to get a valid resultSet
		// Foxpro calls this function to get all column-descriptions for its
		// remote-views. 
		// This fixes the bug : ' I can't edit my remote-views in Visial FoxPro'
		this->executeStatement();
	}
	
	.....

---------
If someone has a better idea to get a valid resulSet ... please let me know

[Firebird-odbc-devel] DllRegisterServer AND Connection String

[Carlos G.A. <car...@ho...>]

Hello:

1. - I have a fix for the DllRegisterServer function ( Setup.cpp ), this 
function don´t work under Win2000/XP
( I think that this fix is correct but i want to know if it really is ):

STDAPI DllRegisterServer (void)
{
................

	/*
	* The original code uses the string "OdbcJdbc" instead of
	* "Firebird/InterBase(r) driver" but this gives the error
	* "Can´t found the component in the registry"
	*/
	if (!SQLConfigDriver (
			NULL,
			ODBC_INSTALL_DRIVER,
			"Firebird/InterBase(r) driver",
			NULL,
			"OdbcJdbc driver was installed successfully",
			64,
			NULL))
		{
		/*
		* The original code uses GetLastError() but this don´t report the true 
error
		*/
		char message [SQL_MAX_MESSAGE_LENGTH];
	      WORD		errCodeIn = 1;
		DWORD *	errCodeOut = 0L;

		SQLInstallerError(errCodeIn, errCodeOut, message, sizeof (message) - 1,
			NULL);

		msg.Format ("Config Install (%s, %s) failed with %d\n%s\n",
						fileName, pathOut, errCodeOut, message);

		AfxMessageBox (msg);
		return FALSE;
		}
...........
}


2.- I have a fix for make to work the connection string under the Views 
definition of Visual foxpro, it´s a simple fix that consist in
change the order of the elements and adds the database to the Connection 
String ( OdbcConnection::sqlDriverConnect ):

RETCODE OdbcConnection::sqlDriverConnect(SQLHWND hWnd, const SQLCHAR * 
connectString, int connectStringLength, SQLCHAR * outConnectBuffer, int 
connectBufferLength, SQLSMALLINT * outStringLength, int driverCompletion)
{
.....

	r = appendString (r, "DSN=");
	r = appendString (r, dsn);

	if (!driver.IsEmpty())
	{
		r = appendString (r, ";DRIVER=");
		r = appendString (r, driver);
	}

	if (!databaseName.IsEmpty())
	{
		r = appendString (r, ";DBNAME=");
		r = appendString (r, databaseName);
	}

	if (!account.IsEmpty())
		{
		r = appendString (r, ";UID=");
		r = appendString (r, account);
		}

	if (!password.IsEmpty())
		{
		r = appendString (r, ";PWD=");
		r = appendString (r, password);
		}

	if (!role.IsEmpty())
		{
		r = appendString (r, ";ROLE=");
		r = appendString (r, role);
		}
....
}



Best Regards
Carlos Guzmán Álvarez

P.D.: Sorry about my bad english but i´m spanish


_________________________________________________________________
Envíe y reciba su correo de Hotmail desde el móvil: http://mobile.msn.com

[Firebird-odbc-devel] connection string

[T. <ft...@sn...>]

Hello,


I can test your driver with a dsn but i can't find the nonnection string to
use with ADO from vb.


Can you help me.

Thanks

Re: [Firebird-odbc-devel] Re-installing ODBCJDBC driver

[Paul R. <pr...@ib...>]

Graeme Edwards wrote:
> I have removed the Firebird ODBC driver while trying to resolve issues with
> Crystal reports and now I cannot get it to re-install. It goes through the
> process of installing but does not install either of the dll files
> (odbcjdbc.dll or odbcjdbcsetup.dll) in the windows system directory or add
> any ODBC drivers to the registry. I have manually removed all reference to
> these drivers from the registry previously.
> Before reinstalling I tried to manually unregister the odbcjdbc.dll file and
> got some kind of windows error about a corrupt file that should be unloaded
> from memory.
> I am running windows 2000 service pack 2. I have tried the re-install many
> times restarting in between with the same results.
> 
> Anyone got any ideas about this?
> 

The install routine is not very clever and was not written with Win2K in 
mind.

You could try to manually copy the IscDbc.dll, OdbcJdbc.dll and 
OdbcJdbcSetup.dll into the system32 directory and then run regsvr32.exe 
from the command line thus:

   c:\path\to\system32\regsvr32.exe x:\path\to\OdbcJdbcSetup.dll

That is all the install package is doing, so I suspect it won't succeed. 
The error most likely resides in OdbcJdbcSetup itself. Win2K is probably 
not helping things, either.

To get the files out of the installation package run the install as 
normal. When you get to the readme (after the dialog asking you to 
specify the install location) go to the %TEMP% directory and locate the 
temporary folder containing the driver. Copy the dlls somewhere safe. 
They get automatically deleted at the end of the install.

If you get really desperate here are the registry entries I have. (Pay 
attention to word wrap, btw):


[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI]

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Firebird/InterBase(r) driver]
;This should perhaps be dword:00000001
"UsageCount"=dword:0000000e
"Driver"="C:\\WINNT4\\System32\\OdbcJdbc.dll"
"Setup"="C:\\WINNT4\\System32\\OdbcJdbcSetup.dll"
"FileExtns"="*.gdb"
"APILevel"="1"
"ConnectFunctions"="YYN"
"FileUsage"="0"
"DriverODBCVer"="03.00"

;!!!Amend this as required!!!
;[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Core]
;"UsageCount"=dword:00000007

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers]
"Firebird/InterBase(r) driver"="Installed"


Don't blame me if I've just given you some more rope to hang yourself 
with, btw. This is untried and untested and at your own risk.


Paul
-- 

Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase

[Firebird-odbc-devel] Re-installing ODBCJDBC driver

[Graeme E. <ged...@sp...>]

I have removed the Firebird ODBC driver while trying to resolve issues with
Crystal reports and now I cannot get it to re-install. It goes through the
process of installing but does not install either of the dll files
(odbcjdbc.dll or odbcjdbcsetup.dll) in the windows system directory or add
any ODBC drivers to the registry. I have manually removed all reference to
these drivers from the registry previously.
Before reinstalling I tried to manually unregister the odbcjdbc.dll file and
got some kind of windows error about a corrupt file that should be unloaded
from memory.
I am running windows 2000 service pack 2. I have tried the re-install many
times restarting in between with the same results.

Anyone got any ideas about this?

Graeme Edwards

Re: [Firebird-odbc-devel] More things about the driver

[Carlos G.A. <car...@ho...>]

Hello:

Thanks you very much i already have a little implementatio but don´t work 
fine with big blobs, i will try your implementation soon.... :))


Best regards
Carlos G.A.


>From: "Robert M." <rob...@si...>
>To: <fir...@li...>
>Subject: Re: [Firebird-odbc-devel] More things about the driver
>Date: Thu, 30 May 2002 23:04:22 +0200
>
>[SNIP]
>
> > 3.- The driver don´t have implementation for :
> > OdbcStatement::sqlParamData
> > OdbcStatement::sqlPutData
> > I´m working on it for make work the data at exec parameters when i 
>fisnish
> > it ( if i have time......... :)) ) i will post it in the list.
> >
>
>I've already made a support for SQLParamData and SQLPutData for the
>data-at-execution. I did this to support blob update and insert statements.
>The code has already been submited to Paul Reeves where is probably waiting
>for the right moment .... Just in case you would like to see how I did it
>I'm sending mine an Bernhard Schulte changes (attached to this mail) to the
>list . If you need to change something regarding the SQLParamData and
>SQLPutData you can base your work from here.
>
>P.S. Changes are done on top of the latest sources downloaded from our
>source tree! You can just overwrite the originals with sources attached to
>this mail.
>
>Robert Milharcic
><< !blobs_etc.zip >>




_________________________________________________________________
Únase con MSN Hotmail al servicio de correo electrónico más grande del 
mundo. http://www.hotmail.com

Re: [Firebird-odbc-devel] Fix in IscTablesResultSet ...

[Carlos G.A. <car...@ho...>]

Hello:


Thanks you very much for the aclaration.. :))


Best Regards
Carlos G.A.



>From: "B. Schulte" <sc...@de...>
>To: fir...@li...
>Subject: [Firebird-odbc-devel] Fix in IscTablesResultSet ...
>Date: Thu, 30 May 2002 21:56:24 +0200
>
> >
> > 4.- I want to know if this fix posted by Bernhard Schulte is correct
> > because the expandPattern is used in other files in the same way ( and
> > i want to know if i have to change the other files too... :)) ) :
> >
> > The fix:
> >
> >   c) some minor bug: IscTablesResultSet
> >   IscTablesResultSet::getTables(...)
> >   // change line 68 to this: ( replace the first %s with =  )
> >   sql += expandPattern (" where rdb$relation_name = '%s'\n",
> > tableNamePattern);
> >
>
>No.. actually this is not a real bug fix. It semms to fix some
>misbehaviour of the driver in a special case, but :
>please do NOT use this proposed fix of me.
>I discussed this with Robert Milharcic and we came to the result, that
>this is not a good idea (this means he showed me that this is not very
>clever ..)
>
>  mfG
>
>    B. Schulte
>
>-------------------------
>      ___
>  /\    /
>/  \  /   -- DELTA 7 --
>---- /
>-------------------------
>
>
>_______________________________________________________________
>
>Don't miss the 2002 Sprint PCS Application Developer's Conference
>August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm
>
>_______________________________________________
>Firebird-odbc-devel mailing list
>Fir...@li...
>https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel




_________________________________________________________________
Descargue GRATUITAMENTE MSN Explorer en 
http://explorer.yupimsn.com/intl.asp.

[Firebird-odbc-devel] Please do not panic (More things about the driver)

[Robert <rob...@ib...>]

Hello, Everyone.

-> Antigen Notification: Antigen found ExceedinglyInfected virus

This posting is untrue.  Please do not panic. The zip file only contained html
files. There is no virus called ExceedinglyInfected (sometimes also known as
ExceedinglyNested).

Robert Milharcic

[Firebird-odbc-devel] Antigen Notification:Antigen found ExceedinglyInfected virus

[ANTIGEN_MAILSERVER <ANT...@br...>]

Antigen for Exchange found !blobs_etc.zip infected with ExceedinglyInfected
virus.
The file is currently Detected.  The message, "Re: [Firebird-odbc-devel]
More things about the driver", was
sent from Robert M.  and was discovered in IMC Queues\Inbound
located at Broom/BROOMPERU/MAILSERVER.

Best Regards
IT Area Broom Peru

[Firebird-odbc-devel] Antigen Notification:Antigen found FILE FILTER= *.ht* file

[ANTIGEN_MAILSERVER <ANT...@br...>]

Antigen for Exchange found
!blobs_etc.zip->!IscPreparedStatement_cpp_diff.htm matching FILE FILTER=
*.ht* file filter.
The file is currently Purged.  The message, "Re: [Firebird-odbc-devel] More
things about the driver", was
sent from Robert M.  and was discovered in IMC Queues\Inbound
located at Broom/BROOMPERU/MAILSERVER.

Best Regards
IT Area Broom Peru

[Firebird-odbc-devel] Antigen Notification:Antigen found FILE FILTER= *.ht* file

[ANTIGEN_MAILSERVER <ANT...@br...>]

Antigen for Exchange found !blobs_etc.zip->!IscPreparedStatement_h_diff.htm
matching FILE FILTER= *.ht* file filter.
The file is currently Purged.  The message, "Re: [Firebird-odbc-devel] More
things about the driver", was
sent from Robert M.  and was discovered in IMC Queues\Inbound
located at Broom/BROOMPERU/MAILSERVER.

Best Regards
IT Area Broom Peru

[Firebird-odbc-devel] Antigen Notification:Antigen found FILE FILTER= *.ht* file

[ANTIGEN_MAILSERVER <ANT...@br...>]

Antigen for Exchange found !blobs_etc.zip->!IscCallableStatement_h_diff.htm
matching FILE FILTER= *.ht* file filter.
The file is currently Purged.  The message, "Re: [Firebird-odbc-devel] More
things about the driver", was
sent from Robert M.  and was discovered in IMC Queues\Inbound
located at Broom/BROOMPERU/MAILSERVER.

Best Regards
IT Area Broom Peru

[Firebird-odbc-devel] Antigen Notification:Antigen found FILE FILTER= *.ht* file

[ANTIGEN_MAILSERVER <ANT...@br...>]

Antigen for Exchange found !blobs_etc.zip->!Connection_h_diff.htm matching
FILE FILTER= *.ht* file filter.
The file is currently Purged.  The message, "Re: [Firebird-odbc-devel] More
things about the driver", was
sent from Robert M.  and was discovered in IMC Queues\Inbound
located at Broom/BROOMPERU/MAILSERVER.

Best Regards
IT Area Broom Peru

[Firebird-odbc-devel] Antigen Notification:Antigen found FILE FILTER= *.ht* file

[ANTIGEN_MAILSERVER <ANT...@br...>]

Antigen for Exchange found
!blobs_etc.zip->!IscCallableStatement_cpp_diff.htm matching FILE FILTER=
*.ht* file filter.
The file is currently Purged.  The message, "Re: [Firebird-odbc-devel] More
things about the driver", was
sent from Robert M.  and was discovered in IMC Queues\Inbound
located at Broom/BROOMPERU/MAILSERVER.

Best Regards
IT Area Broom Peru

Re: [Firebird-odbc-devel] More things about the driver

[Robert M. <rob...@si...>]

[SNIP]

> 3.- The driver don´t have implementation for :
> OdbcStatement::sqlParamData
> OdbcStatement::sqlPutData
> I´m working on it for make work the data at exec parameters when i fisnish
> it ( if i have time......... :)) ) i will post it in the list.
>

I've already made a support for SQLParamData and SQLPutData for the
data-at-execution. I did this to support blob update and insert statements.
The code has already been submited to Paul Reeves where is probably waiting
for the right moment .... Just in case you would like to see how I did it
I'm sending mine an Bernhard Schulte changes (attached to this mail) to the
list . If you need to change something regarding the SQLParamData and
SQLPutData you can base your work from here.

P.S. Changes are done on top of the latest sources downloaded from our
source tree! You can just overwrite the originals with sources attached to
this mail.

Robert Milharcic

[Firebird-odbc-devel] Fix in IscTablesResultSet ...

[B. S. <sc...@de...>]

> 
> 4.- I want to know if this fix posted by Bernhard Schulte is correct
> because the expandPattern is used in other files in the same way ( and
> i want to know if i have to change the other files too... :)) ) :
> 
> The fix:
> 
>   c) some minor bug: IscTablesResultSet
>   IscTablesResultSet::getTables(...)
>   // change line 68 to this: ( replace the first %s with =  )
>   sql += expandPattern (" where rdb$relation_name = '%s'\n", 
> tableNamePattern);
> 

No.. actually this is not a real bug fix. It semms to fix some 
misbehaviour of the driver in a special case, but :
please do NOT use this proposed fix of me.
I discussed this with Robert Milharcic and we came to the result, that 
this is not a good idea (this means he showed me that this is not very 
clever ..)

 mfG

   B. Schulte 

-------------------------
     ___
 /\    /
/  \  /   -- DELTA 7 --  
---- /
------------------------- 

[Firebird-odbc-devel] More things about the driver

[Carlos G.A. <car...@ho...>]

Hello:

More things:

1.- The function DLLRegisterServer ( setup.cpp ) don´t register the 
IscDbc.dll ( almost to me, i test it in 2 computers and all give the same 
problem )

2.- The method OdbcConnection::sqlSetConnectAttr ( OdbcConnection.cpp ) 
don´t have code for the SQL_ATTR_TXN_ISOLATION attribute:

	....

	case SQL_ATTR_TXN_ISOLATION:
		if( connection )
			connection->setTransactionIsolation( (int) value );
	....

I check the connection because this atrribute can be set before connect, 
this make that the OdbcConnection::connect( OdbcConnection.cpp ) needs to 
set this attribute after connect ( the SQL_ATTR_AUTOCOMMIT also can be set 
before connect ) :

		......

		connection->setAutoCommit( autoCommit );
		connection->setTransactionIsolation( SQL_TXN_READ_COMMITTED );
		}
	catch (SQLException& exception)
		.....

With the set of the SQL_ATTR_TXN_ISOLATION i made a new implementation of 
the IscConnection::startTransaction ( IscConnection.cpp ) method ( the 
implementation is based on the XTG driver implementation and the Interbase 
documentation ), i think this can be interesting:

void* IscConnection::startTransaction()
{
	if (transactionHandle)
		return transactionHandle;

	ISC_STATUS statusVector [20];

	static char	iscTpb[5];

	/* Número de version de la transaccion */
	iscTpb[0] = isc_tpb_version3;
	/* Modo de acceso */
	iscTpb[1] = isc_tpb_write;
	/* Resolución de conflictos en los bloqueos */
	iscTpb[2] = isc_tpb_wait;
	/* Isolation level */
	switch( transactionIsolation )
	{
		case 0x00000008L:
			// SQL_TXN_SERIALIZABLE:
			iscTpb[3] = isc_tpb_consistency;
			break;

		case 0x00000004L:
			// SQL_TXN_REPEATABLE_READ:
			iscTpb[3] = isc_tpb_concurrency;
			break;

		case 0x00000001L:
			// SQL_TXN_READ_UNCOMMITTED:
			iscTpb[3] = isc_tpb_read_committed;
			iscTpb[4] = isc_tpb_rec_version;
			break;

		case 0x00000002L:
		default:
			// SQL_TXN_READ_COMMITTED:
			iscTpb[3] = isc_tpb_read_committed;
			iscTpb[4] = isc_tpb_no_rec_version;
			break;
	}

	isc_start_transaction( statusVector, &transactionHandle, 1, 
&attachment->databaseHandle,
			sizeof( iscTpb ), &iscTpb);

	if (statusVector [1])
		throw SQLEXCEPTION (statusVector [1], getIscStatusText (statusVector));

	return transactionHandle;
}

3.- The driver don´t have implementation for :
	OdbcStatement::sqlParamData
	OdbcStatement::sqlPutData
I´m working on it for make work the data at exec parameters when i fisnish 
it ( if i have time......... :)) ) i will post it in the list.

4.- I want to know if this fix posted by Bernhard Schulte is correct because 
the expandPattern is used in other files
in the same way ( and i want to know if i have to change the other files 
too... :)) ) :

The fix:

	 c) some minor bug: IscTablesResultSet
	 IscTablesResultSet::getTables(...)
	 // change line 68 to this: ( replace the first %s with =  )
		sql += expandPattern (" where rdb$relation_name = '%s'\n", 
tableNamePattern);

For example:

	a) IscIndexInfoResultSet::getIndexInfo ( IscIndexInfoResultSet.cpp )
		if (tableNamePattern)
			sql += expandPattern (" and idx.rdb$relation_name %s '%s'\n", 
tableNamePattern);

	b) IscPrimaryKeysResultSet::getPrimaryKeys ( IscPrimaryKeysResultSet.cpp )
		if (tableNamePattern)
			sql += expandPattern(" and rel.rdb$relation_name %s '%s'", 
tableNamePattern);

	c) IscProcedureColumnsResultSet::getProcedureColumns ( 
IscProcedureColumnsResultSet.cpp )
		if (procedureNamePattern)
			sql += expandPattern (" and pp.rdb$procedure_name %s '%s'", 
procedureNamePattern);

		if (columnNamePattern)
			sql += expandPattern (" and pp.rdb$parameter_name %s '%s'", 
columnNamePattern);

	d) IscProceduresResultSet::getProcedures ( IscProceduresResultSet.cpp )
		if (procedureNamePattern)
			sql += expandPattern (" where rdb$procedure_name %s '%s'", 
procedureNamePattern);

	e) IscSpecialColumnsResultSet::specialColumns ( 
IscSpecialColumnsResultSet.cpp )
		sql += expandPattern ("\tand rfr.rdb$relation_name %s '%s'\n", table);

	f) IscCrossReferenceResultSet::getCrossReference ( 
IscCrossReferenceResultSet.cpp )
		if (primaryTable)
			sql += expandPattern (" and pidx.rdb$relation_name %s '%s'", 
primaryTable);


5.- The supportedFunctions array ( OdbcConnection.cpp ) don´t have the 
SQL_API_SQLSETCONNECTOPTION in the list.

6.- The CHAR and VARCHAR datatype and my fix:

Bernhard Schulte is right ( Thanks very much ) my fix don´t work properly 
when you have fields with both datatypes in the tables or when you have only 
CHAR fields, i´m testing it and the second part of the fix is incorrect the 
line ( in the fix ):

	data [var->sqllen] = 0;

would be like the original code of the driver:

	data [var->sqllen-1] = 0;

The first part of the fix seems to be correct ( but if any can test it i´m 
very pleased ).
I test it with CHARS only in the table ( and other datatypes like int, date, 
... ), with VARCHARS only ( witha a database with 108 tables in wich string 
fields are all VARCHAR ), and with CHARS and VARCHARS and it seems to work 
good.

If this don´t work too please tell me ... i will send the code to the 
thrash......... :))




Best Regards
Carlos Guzmán Álvarez

PD: Sorry about my bad english but i´m spanish.




_________________________________________________________________
Únase con MSN Hotmail al servicio de correo electrónico más grande del 
mundo. http://www.hotmail.com

[Firebird-odbc-devel] RE: get rid of trailing blanks

[Carlos G.A. <car...@ho...>]

Hello:

It´s possible i have made test with varchars only in the tables ( a big 
number of test ) and
with chars and varchars i don´t make serious test, with varchars only it
works very well, i have no problem in use other solution if it´s
best....jeje.

Thanks very much for your test of the fix, i´m not a master in cpp but i 
have a great in haver the driver to work well ( under Visual Foxpro ).


Best Regards
Carlos Guzmán Álvarez


_________________________________________________________________
Hable con sus amigos en línea, pruebe MSN Messenger: http://messenger.msn.es

RE: [Firebird-odbc-devel] chars are too long ?

[Carlos G.A. <car...@ho...>]

Hello:

See the solution of this problem in my mail BUGS of 29/4/2002

Best Regards
Carlos Guzmán Álvarez

"B. Schulte" <sc...@de...> escribió en el mensaje de noticias
3CD6F621.11516.604240A@localhost...
> I used the latest drivers downloaded from ibphoenix.com,
> built an application with BDE.
> Took my favorite "test-table" with a field of "CHAR(10)" but in my
> dalphi-Application this field is shown as "CHAR(11)",
> TQuery.size=11 and TQuery.display size=11.
> You can find the same behaviour, when connecting to this Database
> (by this DSN) with MS-Visual-Foxpro..
> -->
> I tried to correct the odbc-driver but don't really know where to begin
> (which function/method).
> Maybe someone can give me a hint.
>
> Bernhard
>
>
> _______________________________________________________________
>
> Have big pipes? SourceForge.net is looking for download mirrors. We supply
> the hardware. You get the recognition. Email Us: ban...@so...
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>

[Firebird-odbc-devel] get rid of trailing blanks

[B. S. <sc...@de...>]

 

Hi,
I'm sorry, but have to say, that your proposal is not the right way.
It _seems_ to work it really doesn't. I tried more than once to use this changes,
but at least you can not use yarchar and char-fields in your table 
followed by another char-field.
I always got either memory-errors or at least the wrong output (every second field gets corrupt or blank)!

> 
> 
> Hello:
> 
> Yo have to change another line in IscStatement.cpp i transcribe here
> the part of this error of the post 'BUGS' here.
> 
> 
> Sqlda.cpp:
> 
> 1.- Sqlda::allocbuffer makes that the data returned by a SQLStatement
> was incorrect and that SQLColAttributes returned bad results for
> SQL_COLUMN_LENGTH. SQL_COLUMN_DISPLAY_SIZE, ..., i fixed this
> commenting this line:
> 
> var->sqllen = length;
> 
> With this line commented it´s neccesary other change in:
> 
> IscStatement.cpp
> 
> In the method IscStatement::setValue:
> 
> ....
> 
> case SQL_TEXT:
> {
> char *data = (char*) var->sqldata;
> data [var->sqllen] = 0;
> value->setString (data, false);
> }
> break;
> 
> 
> Best Regards
> Carlos G.A.
> 
> PD: Sorry about my bad english but i´m spanish
> 
> _________________________________________________________________ MSN
> Photos es la manera más sencilla de compartir e imprimir sus fotos:
> http://photos.msn.com/support/worldwide.aspx
> 
> 
> 
> 
> --__--__--
> 
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
> 
> 
> End of Firebird-odbc-devel Digest
> 


 mfG

   B. Schulte 

-------------------------
     ___
 /\    /
/  \  /   -- DELTA 7 --  
---- /
------------------------- 

[Firebird-odbc-devel] Re: chars are too long ? (delta7.de)

[Carlos G.A. <car...@ho...>]

Hello:

Yo have to change another line in IscStatement.cpp i transcribe here the
part of this error of the post 'BUGS' here.


Sqlda.cpp:

1.- Sqlda::allocbuffer makes that the data returned by a SQLStatement was
incorrect and that SQLColAttributes returned bad results for
SQL_COLUMN_LENGTH. SQL_COLUMN_DISPLAY_SIZE, ..., i fixed this commenting
this line:

var->sqllen = length;

With this line commented it´s neccesary other change in:

IscStatement.cpp

In the method IscStatement::setValue:

....

case SQL_TEXT:
{
char *data = (char*) var->sqldata;
data [var->sqllen] = 0;
value->setString (data, false);
}
break;


Best Regards
Carlos G.A.

PD: Sorry about my bad english but i´m spanish

_________________________________________________________________
MSN Photos es la manera más sencilla de compartir e imprimir sus fotos: 
http://photos.msn.com/support/worldwide.aspx

[Firebird-odbc-devel] More Chars and Varchars

[B. S. <sc...@de...>]

Hi Folks,

after some sleepless nights about trailing blanks, memory-e...
a) in IscStatement.cpp:
void IscStatement::setValue(Value *value, XSQLVAR *var)
 	{
 	if ((var->sqltype & 1) && *var->sqlind == -1)
 		value->setNull();
 	else
 		switch (var->sqltype & ~1)
 			{
 			case SQL_TEXT:
 				{
 				char *data = (char*) var->sqldata;
 // OKok... I thought it wolud be a good idea to do  "data [var->sqllen-1 ] = 0; " but this had some horrible effects.. so let's return to the 
 good old times ...
 				data [var->sqllen-1 ] = 0;    
 				value->setString (data, false);
 				}
 				break;
 
 // BUT ! Let's treat the VARCHARS like this:
 
 			case SQL_VARYING:
 				{
 		
 				int length = var->sqllen-2;
 				char *data = var->sqldata + 2;
 				value->setString (length, data, false);
 				}
 				break;
 
 // I could not see that varchars really use the first two bytes to describe their length :-(
 
 // If we do this, we also should send the real text-length i.e.:
 
 b)  sqlda.cpp
  int Sqlda::getPrecision(...)
 // insert the following behind line 335:
 		case SQL_TEXT:
 			return var->sqllen-1;
 
 		case SQL_VARYING:
 			return var->sqllen-2;
 
 // do the same after line 279 in getDisplaySize.
 
 c) some minor bug: IscTablesResultSet
 IscTablesResultSet::getTables(...)
 // change line 68 to this: ( replace the first %s with =  )
 	sql += expandPattern (" where rdb$relation_name = '%s'\n", tableNamePattern);
 
 d) and a mistype in TimeStamp.cpp line 53:
 TimeStamp::operator =(DateTime value)
 
 // just remove the brackets ...
 
 	date = value.date / 24/60/60;
 
 I hope this will help ....
 
 -----
 Now to something completly different:
 Does someone also use VisualFoxpro ?
 

 Bernhard Schulte 

[Firebird-odbc-devel] FireBird and ODBC Driver

[Michael <mac...@in...>]

I want to reach  FireBird database on Linux, using ODBC(clients on
Win32). Can you advise me a
driver which supports
      1)Row updates/deletes using ODBC's SQLSetPos function
      2)Row concurrency check, using rowversioning or values
(SQL_ATTR_CONCURRENCY=SQL_CONCUR_ROWVER or
SQL_ATTR_CONCURRENCY=SQL_CONCUR_VALUES)

Any help will be appreciated
Thanks

[Firebird-odbc-devel] Re: chars are too long ?

[<sc...@de...>]

On 22 May 2002 at 12:15, firebird-odbc-devel-request@l wrote:

> Send Firebird-odbc-devel mailing list submissions to
> 	fir...@li...
> 

> Hello:
> 
> See the solution of this problem in my mail "BUGS" of 29/4/2002
> 
> Best Regards
> Carlos Guzm=E1n =C1lvarez
> 
Your proposal doesn't fix it really ... at the first look it seems so, but=
 :
if you comment out the line "var->sqllen =3D length;" in sqlda.cpp, you 
get awful memory-faults ! (not always, but sometimes) .
I'm just debugging it, to find out where to cut the last blank of the 
stings ....

[Firebird-odbc-devel] Re: chars are too long ?

[Carlos G.A. <car...@ho...>]

Hello:

See the solution of this problem in my mail "BUGS" of 29/4/2002

Best Regards
Carlos Guzmán Álvarez

_________________________________________________________________
Descargue GRATUITAMENTE MSN Explorer en 
http://explorer.yupimsn.com/intl.asp.