Using Easysoft ODBC-ODBC bridge and Microsoft SQL Server 2005 had the following errors during make test:
t/12blob................DBD::ODBC::db selectall_arrayref failed: [unixODBC][Easysoft ODBC (Server)]Memory allocation error (SQL-HY001) at t/12blob.t line 120. DBD::ODBC::db selectall_arrayref failed: [unixODBC][Easysoft ODBC (Server)]Memory allocation error (SQL-HY001) at t/12blob.t line 120. t/20SqlServer...........DBD::ODBC::st execute failed: [unixODBC][Easysoft ODBC (Server)]Memory allocation error (SQL-HY001) at t/20SqlServer.t line 77. dubious t/rt_38977..............DBD::ODBC::st execute failed: [unixODBC][Microsoft][ODBC SQL Server Driver]Warning: Partial insert/update. The insert/update of a text or image column(s) did not succeed. (SQL-HY000) [state was HY000 now 42000] [unixODBC][Microsoft][ODBC SQL Server Driver][SQL Server]The text, ntext, or image pointer value conflicts with the column name specified. (SQL-42000) at t/rt_38977.t line 89. # Failed test (t/rt_38977.t at line 92) # Execute for insert into varchar(max) failed with DBD::ODBC::st execute failed: [unixODBC][Microsoft][ODBC SQL Server Driver]Warning: Partial insert/update. The insert/update of a text or image column(s) did not succeed. (SQL-HY000) [state was HY000 now 42000] # [unixODBC][Microsoft][ODBC SQL Server Driver][SQL Server]The text, ntext, or image pointer value conflicts with the column name specified. (SQL-42000) at t/rt_38977.t line 89. # Some SQL Server drivers such as the native client 09.00.1399 driver fail this test with a HY104, "Invalid precision error". You have driver esoobclient at version 02.00.0000. There is a free upgrade from Microsoft of the native client driver to 10.00.1600 which you will need if you intend to insert into varchar(max) columns. DBD::ODBC::st execute failed: [unixODBC][Microsoft][ODBC SQL Server Driver]Warning: Partial insert/update. The insert/update of a text or image column(s) did not succeed. (SQL-HY000) [state was HY000 now 42000] [unixODBC][Microsoft][ODBC SQL Server Driver][SQL Server]The text, ntext, or image pointer value conflicts with the column name specified. (SQL-42000) at t/rt_38977.t line 126. DBD::ODBC::st execute failed: [unixODBC][Microsoft][ODBC SQL Server Driver]Warning: Partial insert/update. The insert/update of a text or image column(s) did not succeed. (SQL-HY000) [state was HY000 now 42000] [unixODBC][Microsoft][ODBC SQL Server Driver][SQL Server]The text, ntext, or image pointer value conflicts with the column name specified. (SQL-42000) at t/rt_38977.t line 126. t/rt_39841..............# [unixODBC][Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification (SQL-22018) # 22018 # # NOTE: Your SQL Server ODBC driver has a bug which can describe parameters # in SQL using sub selects incorrectly. In this case a VARCHAR(8) parameter # is described as an INTEGER # # Checking you can work around bug in SQL Server ODBC Driver # Yes you can # [unixODBC][Microsoft][ODBC SQL Server Driver]String data, right truncation (SQL-22001) # 22001 # Bug 39841 is back in some unexpected way # Please report this via rt # Failed test (t/rt_39841.t at line 267) # Looks like you failed 1 test of 28. Any help with these errors would be appreciated... Brian Becker
