Anoop Kumar [Mon, 19 Sep 2005 13:31:59 +0000 (13:31 +0000)]
Socket code is removed from the source. Now, psqlodbc driver relies completely on Libpq for the communication.
Dave Page [Sat, 17 Sep 2005 22:58:51 +0000 (22:58 +0000)]
Don't lose notices that don't come from a query.
Dave Page [Sat, 17 Sep 2005 22:27:24 +0000 (22:27 +0000)]
This patch fill fix the notice handler so that the odbc driver doesn't output notices from the backend to stderr.
[Scot Loach]
Dave Page [Sat, 17 Sep 2005 22:16:08 +0000 (22:16 +0000)]
This patch corrects the previous fix for returning 08S01 error code for the server disconnecting.
The previous patch sent this error code for any error on the statement (such as a primary key collision).
[Scot Loach]
Dave Page [Fri, 16 Sep 2005 23:12:17 +0000 (23:12 +0000)]
Remove old doc file.
Dave Page [Fri, 16 Sep 2005 23:10:28 +0000 (23:10 +0000)]
Bump version number
Dave Page [Fri, 16 Sep 2005 23:05:00 +0000 (23:05 +0000)]
Don't include win_unicode.c twice
Dave Page [Fri, 16 Sep 2005 16:01:43 +0000 (16:01 +0000)]
Backout previous rowcount patch which seems to be causing some odd errors with MS ADO.
Dave Page [Thu, 15 Sep 2005 08:16:55 +0000 (08:16 +0000)]
Fix paths for new build targets
Dave Page [Thu, 15 Sep 2005 08:09:43 +0000 (08:09 +0000)]
Allow SQLRowCount to work following SELECT queries [Scot Loach]
Dave Page [Thu, 15 Sep 2005 07:45:44 +0000 (07:45 +0000)]
Fix identifier case sensitivity [Chris Ingram]
Dave Page [Tue, 6 Sep 2005 15:19:13 +0000 (15:19 +0000)]
Explain which driver users should choose.
Dave Page [Tue, 6 Sep 2005 07:47:26 +0000 (07:47 +0000)]
Re-enable ANSI/Unicode compilation.
Dave Page [Fri, 2 Sep 2005 14:31:42 +0000 (14:31 +0000)]
Remove unnecessary query length limitation, and clean up so dodgy code.
Dave Page [Fri, 2 Sep 2005 08:40:59 +0000 (08:40 +0000)]
Add basic support for savepoints [Hiroshi Saito/Dave Page]
Dave Page [Thu, 1 Sep 2005 14:45:16 +0000 (14:45 +0000)]
Only mark the connection dead when it actually fails, not for any error.
Dave Page [Wed, 31 Aug 2005 07:31:44 +0000 (07:31 +0000)]
Please find the patch for the other bug pointed out by Scot. (Thanks to
Sivakumar)
"Another difference is the "state" that is returned from SQLGetDiagRec
when a connection is lost during a query. This used to return 08S01.
It now returns HY000."
Dave Page [Tue, 30 Aug 2005 14:57:50 +0000 (14:57 +0000)]
Bloody line ends. Grrr.
Dave Page [Tue, 30 Aug 2005 11:27:07 +0000 (11:27 +0000)]
Fix line ends.
Dave Page [Tue, 30 Aug 2005 10:28:32 +0000 (10:28 +0000)]
Test commit - ignore
Anoop Kumar [Tue, 30 Aug 2005 09:19:50 +0000 (09:19 +0000)]
Fix for making the SQLGetConnectAttr API work with SQL_ATTR_CONNECTION_DEAD attribute.
Dave Page [Tue, 30 Aug 2005 08:37:06 +0000 (08:37 +0000)]
Allow SSL modes to be translated [Hiroshi Saito]
Dave Page [Sun, 28 Aug 2005 19:43:47 +0000 (19:43 +0000)]
Don't install docs by default, as most likely only developers/sysadmins will need them.
Dave Page [Sat, 27 Aug 2005 23:19:32 +0000 (23:19 +0000)]
Update installer:
- Install in configurable directories.
- Add documentation, with a shortcut from the start menu.
- Update the banner bitmap.
Dave Page [Sat, 27 Aug 2005 22:16:46 +0000 (22:16 +0000)]
Wix got finickity about short filenames.
Dave Page [Sat, 27 Aug 2005 22:00:54 +0000 (22:00 +0000)]
Add FAQ.
Dave Page [Sat, 27 Aug 2005 20:14:55 +0000 (20:14 +0000)]
Further documentation updates
Dave Page [Sat, 27 Aug 2005 19:44:47 +0000 (19:44 +0000)]
Move docs into the source tree.
Anoop Kumar [Wed, 24 Aug 2005 06:09:52 +0000 (06:09 +0000)]
Fixed the SQLExecDirec bug which returned SQL_SUCCESS instead of SQL_NO_DATA when no row got affected in UPDATE/DELETE. (Thanks to Sivakumar)
Dave Page [Fri, 12 Aug 2005 09:47:55 +0000 (09:47 +0000)]
Fix SQLRowCount [Anoop Kumar]
Dave Page [Fri, 12 Aug 2005 09:19:42 +0000 (09:19 +0000)]
Oops, missed this commit
Dave Page [Thu, 11 Aug 2005 15:35:16 +0000 (15:35 +0000)]
Further column length tweaks
Dave Page [Thu, 11 Aug 2005 14:08:28 +0000 (14:08 +0000)]
Improve field length setup. Use the correct values for varchar and char, and SQL_NO_TOTAL for bytea and text.
Dave Page [Fri, 5 Aug 2005 15:19:45 +0000 (15:19 +0000)]
Contrary to what SQLGetInfo thinks, PostgreSQL doesn't support catalog names.
Dave Page [Fri, 5 Aug 2005 12:37:20 +0000 (12:37 +0000)]
Post release version number bump
Dave Page [Fri, 5 Aug 2005 12:19:48 +0000 (12:19 +0000)]
Fix default numeric precision.
Dave Page [Thu, 4 Aug 2005 13:39:28 +0000 (13:39 +0000)]
Fix leak in SC_Destructor [Kelly Burkhart] - archives.postgresql.org/pgsql-odbc/2005-03/msg00091.php
Dave Page [Thu, 4 Aug 2005 12:26:57 +0000 (12:26 +0000)]
If I bind a 32 bit integer using SQL_INTEGER/SQL_C_LONG and pass a value of -1, the insert fails with an 'integer out of range' error. The reason this happens is the sprintf near line 2658 of convert.c. [Kelly Burkhart]
http://archives.postgresql.org/pgsql-odbc/2005-03/msg00126.php
Dave Page [Wed, 3 Aug 2005 08:19:28 +0000 (08:19 +0000)]
Fix per bug ref 1187 [Scot Loach]
Dave Page [Wed, 3 Aug 2005 08:09:33 +0000 (08:09 +0000)]
Handle SQL_DATE from ODBC2 apps, per bug report 1292 [ alic <NOSPAM> sokrates.hr]
Dave Page [Wed, 3 Aug 2005 07:27:30 +0000 (07:27 +0000)]
Add comment about a known leak bug that needs fixing
Dave Page [Wed, 3 Aug 2005 07:26:01 +0000 (07:26 +0000)]
Fix bug that stopped Use Declare/Fetch working, and prevented ODBC bench running in multi-thread, multi-transaction mode.
Dave Page [Wed, 3 Aug 2005 07:24:49 +0000 (07:24 +0000)]
Fix some logging that was bugging me
Dave Page [Tue, 2 Aug 2005 13:31:46 +0000 (13:31 +0000)]
Remove commented out code.
Dave Page [Tue, 2 Aug 2005 12:52:03 +0000 (12:52 +0000)]
Fix unicode copy & convert bug. SQLGetData with SQL_C_WCHAR now returns SQL_SUCCESS once the whole string is sent, and doesn't lose odd characters like it did.
Dave Page [Mon, 1 Aug 2005 20:56:46 +0000 (20:56 +0000)]
Fix memory leak per gborg bug 1356 [pauldaugherty]
Dave Page [Mon, 1 Aug 2005 20:38:37 +0000 (20:38 +0000)]
Fix SQL_MAX_IDENTIFIER_LEN per gborg bug ref: 1348
Dave Page [Mon, 1 Aug 2005 20:17:43 +0000 (20:17 +0000)]
Include win_unicode.c in Unix build because it contains functions that are used under unix.
Dave Page [Wed, 27 Jul 2005 07:36:21 +0000 (07:36 +0000)]
Japanese GUI update from Hiroshi Saito
Dave Page [Tue, 26 Jul 2005 09:29:09 +0000 (09:29 +0000)]
Get proper error messages from the server, rather than just saying the database doesn't exist.
Dave Page [Mon, 25 Jul 2005 20:38:31 +0000 (20:38 +0000)]
Add SSL support.
Dave Page [Fri, 22 Jul 2005 22:11:38 +0000 (22:11 +0000)]
In SQLGetDescFieldW:128 blen is not initialised before sent to utf8_to_ucs2(). The same thing exists in SQLColAttributeW:287 and SQLGetDiagFieldW:345, per Tomas Skäre
Dave Page [Fri, 22 Jul 2005 22:05:57 +0000 (22:05 +0000)]
In SC_pos_reload_needed:2189 rows_per_fetch is uninitialised, if create_from_scratch is false, per Tomas Skäre
Dave Page [Fri, 22 Jul 2005 21:52:31 +0000 (21:52 +0000)]
Fix some errors found by static source analysis (using Klocwork). [Tomas Skäre]
Dave Page [Fri, 22 Jul 2005 21:17:35 +0000 (21:17 +0000)]
Bump version number
Dave Page [Wed, 20 Jul 2005 14:50:21 +0000 (14:50 +0000)]
self->pgconn needs to be set as NULL after PQfinish(self->pgconn) on line 3117. [Marko Ristola]
Dave Page [Wed, 20 Jul 2005 11:54:36 +0000 (11:54 +0000)]
Remove exit_nicely function, along with it's exit(1) call, per Marko Ristola.
Dave Page [Tue, 19 Jul 2005 10:17:36 +0000 (10:17 +0000)]
Fix memory leak spotted by Marko Ristola
Anoop Kumar [Tue, 19 Jul 2005 06:40:28 +0000 (06:40 +0000)]
Removes an unnecessary call to PGgetisnull, and reduces the memory leakage (Patch from Dave Page)
Dave Page [Fri, 15 Jul 2005 10:14:09 +0000 (10:14 +0000)]
Re-add previously removed variable, ifdef'd appropriately.
Dave Page [Fri, 15 Jul 2005 09:53:34 +0000 (09:53 +0000)]
Remove an usued variable, and initialise another to zero to fix compiler warnings.
Anoop Kumar [Fri, 15 Jul 2005 09:08:50 +0000 (09:08 +0000)]
To fix the bug of PQgetvalue returning an empty string instead of a null value.
Dave Page [Wed, 13 Jul 2005 19:55:02 +0000 (19:55 +0000)]
Post-snapshot version number bump
Dave Page [Wed, 13 Jul 2005 19:50:05 +0000 (19:50 +0000)]
Fix format string [Marko Ristola]
Dave Page [Wed, 13 Jul 2005 15:41:31 +0000 (15:41 +0000)]
Rename driver for parallel testing with stable version. Update installer.
Dave Page [Wed, 13 Jul 2005 14:23:36 +0000 (14:23 +0000)]
New version of the driver with libpq based comms layer, courtesy of Anoop Kumar of Pervasive PostgreSQL. Version number bumped, and extra strings modified in the resource file to make it obvious when the libpq version of the driver is being run.
Dave Page [Thu, 30 Jun 2005 09:30:38 +0000 (09:30 +0000)]
According to MSDN docs for SQLSetStmtAttr, if you try to request a
cursor type which isn't supported, the driver should fall back to a
supported type, set an appropriate SQLState and return
SQL_SUCCESS_WITH_INFO.
Currently, if a SQL_ATTR_CURSOR_TYPE of SQL_CURSOR_DYNAMIC is requested,
we fall back to SQL_CURSOR_FORWARD_ONLY and no warning is given; this is
simply because we don't explicitly check for SQL_CURSOR_DYNAMIC.
A better solution is to check for SQL_CURSOR_DYNAMIC, fall back to
SQL_CURSOR_KEYSET_DRIVEN and set a warning accordingly.
Also, currently if SQL_CURSOR_KEYSET_DRIVEN is requested and only static
cursors are supported, we fall back without returning a warning.
[Mark G. Adams]
Dave Page [Wed, 27 Apr 2005 10:34:00 +0000 (10:34 +0000)]
Bug ref: 1262
When specifiying a client_encoding, the driver will always use UTF-8.
The problem is in connection.c, line number 1024, the code that reads:
if (!self->client_encoding || stricmp(self->client_encoding, "UNICODE"))
should read:
if (!self->client_encoding || !stricmp(self->client_encoding, "UNICODE"))
(the check with stricmp will always be true when client_encoding is different from UNICODE, not when it is UNICODE, wich is what's intended).
[melkor <NOSPAM> odyssey.com.uy]
Dave Page [Wed, 27 Apr 2005 10:27:29 +0000 (10:27 +0000)]
Bug ref: 1276
When I attempt to bind a null-terminated Unicode string parameter using
SQLBindParameter, the database engine receives a string representation of
today's date instead of the data I passed. The same issue does not occur if
I explicitly specify the length of the string instead of using SQL_NTS.
[jeremy <NOSPAM> accessdata.com]
Dave Page [Mon, 25 Apr 2005 08:08:22 +0000 (08:08 +0000)]
This patch returns the remarks (description) on a table, if available. If there is no description, it returns an empty string when SQLTables API is called. This patch works for versions with schema support.
[Anoop Kumar]
Dave Page [Mon, 25 Apr 2005 07:54:17 +0000 (07:54 +0000)]
Bump version to 08.01.0102
Peter Eisentraut [Fri, 18 Mar 2005 15:34:48 +0000 (15:34 +0000)]
When inserting SHRT_MIN into an int2 column, the ODBC driver comes up
with the following SQL:
insert into dbc_test ( i16 ) values ( -32768::int2 );
This fails with an out of range error. Changed to:
insert into dbc_test ( i16 ) values ( (-32768)::int2 );
patch by Kelly Burkhart
Dave Page [Sat, 5 Mar 2005 11:46:00 +0000 (11:46 +0000)]
Fix driver registration
Dave Page [Sat, 5 Mar 2005 10:33:02 +0000 (10:33 +0000)]
Fix version number
Dave Page [Wed, 2 Mar 2005 15:11:09 +0000 (15:11 +0000)]
The following patch allow users to configure the Unix domain socket path, using the "Uds" property.
I took some code from the unixODBC PG driver and performed the necessary adjustments.
Please note that unlike unixODBC, I have followed the current convention, which means that:
1) "Uds" is considered only if "Servername" is empty.
2) Default path is "/tmp".
3) The provided path should point the folder that comtains the UDS node.
[Ramon Danieli]
Dave Page [Wed, 2 Mar 2005 15:02:24 +0000 (15:02 +0000)]
Post-release version number bump
Dave Page [Wed, 2 Mar 2005 14:37:52 +0000 (14:37 +0000)]
Include installer.
Dave Page [Wed, 2 Mar 2005 14:11:30 +0000 (14:11 +0000)]
Version bump for release.
Dave Page [Wed, 23 Feb 2005 20:59:33 +0000 (20:59 +0000)]
Correct version number
Dave Page [Wed, 23 Feb 2005 20:49:21 +0000 (20:49 +0000)]
Show version number in installer.
Dave Page [Wed, 23 Feb 2005 16:49:41 +0000 (16:49 +0000)]
Remove unused icon.
Dave Page [Wed, 23 Feb 2005 16:42:32 +0000 (16:42 +0000)]
We don't implement SQLSetScrollOptions
[Joost Kraaijeveld]
Dave Page [Wed, 23 Feb 2005 16:41:50 +0000 (16:41 +0000)]
Don't barf when parsing queries with functions in the table list (eg. SELECT * FROM version() )
[Joost Kraaijeveld]
Dave Page [Mon, 14 Feb 2005 13:07:11 +0000 (13:07 +0000)]
Increase SOCK_BUFFER_SIZE to 8192 per report from Karol Szkudlarek
Dave Page [Sun, 13 Feb 2005 18:09:40 +0000 (18:09 +0000)]
Fix directory used for debug builds
Dave Page [Sun, 13 Feb 2005 18:06:29 +0000 (18:06 +0000)]
Fix missing " win32.mak
Dave Page [Thu, 10 Feb 2005 15:41:30 +0000 (15:41 +0000)]
Note the need for vcvars32.bat when compiling in Windows on the command line.
Dave Page [Tue, 8 Feb 2005 15:11:21 +0000 (15:11 +0000)]
Bump version to 08.00.0005
Dave Page [Sat, 29 Jan 2005 23:34:23 +0000 (23:34 +0000)]
New WiX based installer.
Dave Page [Fri, 28 Jan 2005 12:03:41 +0000 (12:03 +0000)]
08.00.0004 Version bump
Dave Page [Mon, 17 Jan 2005 10:27:33 +0000 (10:27 +0000)]
Bump version for new snapshot
Dave Page [Mon, 17 Jan 2005 10:12:52 +0000 (10:12 +0000)]
With CVS HEAD, numeric values are not read correctly.
The SQL_NUMERIC_STRUCT is filled with
.precision=3, .scale=5 for a number like 500.00123, which MSDASQL will
interpret as .00123 (noticed when MSDASQL had to convert it to a
string). Obviously the precision should be 8 or more.
The attached patch corrects this.
[Andreas Pflug]
Dave Page [Tue, 21 Dec 2004 15:07:41 +0000 (15:07 +0000)]
There is a 16-byte leak for every statement handle that has SQLFetch called on it.
I have tracked this leak down to its source:
SC_Fetch calls extend_getdata_info, which allocates memory for the stmt.getdata_info.
However, this memory is never freed when the statement is deallocated.
[Scot Loach]
Dave Page [Thu, 11 Nov 2004 09:21:19 +0000 (09:21 +0000)]
Return type names without parens. Originally changed by Hiroshi for unknown reasons. Fixes reported SQL problems such as "CREATE TABLE foo(bar varchar()(12));" [Scot Loach]
Dave Page [Wed, 27 Oct 2004 07:48:03 +0000 (07:48 +0000)]
Updated Japanese dialog from Hiroshi Saito
Dave Page [Fri, 8 Oct 2004 09:44:05 +0000 (09:44 +0000)]
Ignore search_path in SQLTables
Dave Page [Fri, 8 Oct 2004 09:43:48 +0000 (09:43 +0000)]
Bump version number
Dave Page [Fri, 8 Oct 2004 08:50:08 +0000 (08:50 +0000)]
OK, finally think this SQLInfo unicode string length bug can be put to rest.
Tested and working in Access 2K3, MS ODBC Testsuite, and some of my own test and live project code.
Dave Page [Thu, 7 Oct 2004 21:49:31 +0000 (21:49 +0000)]
2nd attempt at the previously rolled back fix. This bug causes errors in MS Access when linking tables.
These occur when *pcbInfoValue returns a value that Access doesn't believe is correct (http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaraccess/html/msdn_odk.asp)
Previously, string size was assumed to be WCLEN * len in Unicode. This is wrong as it meant we included 1 extra character.
Dave Page [Wed, 6 Oct 2004 11:16:15 +0000 (11:16 +0000)]
Back out previous revision. Can't see or recall why it was made and it just doesn't seem right somehow.