I have been using the ODBC driver to extract information, although the
connection is quite flaky.
Often I have to close down the query tool and reconnect.
I'm now testing the update side of the driver.
The following statement
UPDATE _eservice SET mailstop= 'Room 106' , assistant = 'Corporate IT', L
= 'Main Office'WHERE NDS_FullName= 'allanr.FIN.IS.FFS.VIEW.VC'
produced the following error
<eb1>ISAM error
State:S0000,Native:4,Origin:[Novell][ODBC Driver For eDirectory][ISAM]
</eb1>
I have had some success updating a single column, but the flaky connection
problems still occur.
Any thoughts anyone ?
Alan
The ODBC Driver infor from 'Query Tool' is
Cursor Library is Not Loaded
Driver Info
-----------
Data Source Name - edir
Database Name - NDS:\\SC_TREE\SC\VC\VIEW
User Name -
Server Name -
DBMS - ODBC Driver for eDirectory version 2.11.03
Driver - Odbcnds.dll version 02.10.0000
Driver ODBC Ver. - 02.10
ODBC Version - 03.52.0000
API Conformance - Level 1
SQL Conformance - Minimum
SAG CLI Conformance - Yes
Optional SQL IEF - Not Supported
Active Connections - No Limit
Active Statements - No Limit
Multiple Result Sets - Not Supported
File Usage - <n/a>, Driver not single-tier
Read/Write Status - Data source is read-write
Accessible Procedures - Yes
Accessible Tables - Yes
ODBC API Functions
------------------
SQLAllocConnect - Supported
SQLAllocEnv - Supported
SQLAllocStmt - Supported
SQLBindCol - Supported
SQLCancel - Supported
SQLColAttributes - Supported
SQLConnect - Supported
SQLDescribeCol - Supported
SQLDisconnect - Supported
SQLError - Supported
SQLExecDirect - Supported
SQLExecute - Supported
SQLFetch - Supported
SQLFreeConnect - Supported
SQLFreeEnv - Supported
SQLFreeStmt - Supported
SQLGetCursorName - Supported
SQLNumResultCols - Supported
SQLPrepare - Supported
SQLRowCount - Supported
SQLSetCursorName - Supported
SQLSetParam - Supported
SQLTransact - Supported
SQLColumns - Supported
SQLDriverConnect - Supported
SQLGetConnectOption - Supported
SQLGetData - Supported
SQLGetFunctions - Supported
SQLGetInfo - Supported
SQLGetStmtOption - Supported
SQLGetTypeInfo - Supported
SQLParamData - Supported
SQLPutData - Supported
SQLSetConnectOption - Supported
SQLSetStmtOption - Supported
SQLSpecialColumns - Supported
SQLStatistics - Supported
SQLTables - Supported
SQLBrowseConnect - Not Supported
SQLColumnPrivileges - Not Supported
SQLDataSources - Supported
SQLDescribeParam - Not Supported
SQLExtendedFetch - Not Supported
SQLForeignKeys - Supported
SQLMoreResults - Supported
SQLNativeSql - Not Supported
SQLNumParams - Not Supported
SQLParamOptions - Not Supported
SQLPrimaryKeys - Supported
SQLProcedureColumns - Not Supported
SQLProcedures - Not Supported
SQLSetPos - Not Supported
SQLSetScrollOptions - Not Supported
SQLTablePrivileges - Not Supported
SQLDrivers - Supported
SQLBindParameter - Supported
SQL Conversion Functions
------------------------
Convert() - Supported
SQL Numeric Functions
---------------------
Abs() - Supported
Acos() - Supported
Asin() - Supported
Atan() - Supported
Atan2() - Supported
Ceiling() - Supported
Cos() - Supported
Cot() - Supported
Degrees() - Supported
Exp() - Supported
Floor() - Supported
Log() - Supported
Log10() - Supported
Mod() - Supported
Pi() - Supported
Power() - Supported
Radians() - Supported
Rand() - Supported
Round() - Supported
Sign() - Supported
Sin() - Supported
Sqrt() - Supported
Tan() - Supported
Truncate() - Supported
SQL String Functions
--------------------
Ascii() - Supported
Char() - Supported
Concat() - Supported
Difference() - Supported
Insert() - Supported
LCase() - Supported
Left() - Supported
Lenght() - Supported
Locate() - Supported
Locate2() - Supported
LTrim() - Supported
Repeat() - Supported
Replace() - Supported
Right() - Supported
RTrim() - Supported
Soundex() - Supported
Space() - Supported
Substring() - Supported
UCase() - Supported
SQL System Functions
--------------------
DBName() - Supported
IfNull() - Supported
UserName() - Supported
SQL Time/Date Functions
-----------------------
CurDate() - Supported
CurTime() - Supported
DayName() - Supported
DayOfMonth() - Supported
DayOfWeek() - Supported
DayOfYear() - Supported
Hour() - Supported
Minute() - Supported
Month() - Supported
MonthName() - Supported
Now() - Supported
Quarter() - Supported
Second() - Supported
TimeStampAdd() - Supported
TimeStampDiff() - Supported
Week() - Supported
Year() - Supported
Supported SQL
-------------
ALTER TABLE Support - <none>
Column Aliases - Not Supported
Correlation Names - Supported
ORDER BY Expressions - Not Supported
GROUP BY NonAggregate - GROUP BY Contains SELECT
LIKE Escape Character - Not Supported
ORDER BY in SELECT - No
Outer Join Support - Yes
Positioned Statements - <none>
Subquery Support - Correlated,Comparison,EXISTS,IN,Quantified
UNION Support -<none>
Data Types
----------
Native type SQL Type Precision Min Scale Max Scale
----------- -------- --------- --------- ---------
CHAR SQL_CHAR 254 <n/a> <n/a>
VARCHAR SQL_VARCHAR 254 <n/a> <n/a>
INTEGER SQL_INTEGER 10 <n/a> <n/a>
BIT SQL_BIT 1 <n/a> <n/a>
TIMESTAMP SQL_TIMESTAMP 23 3 3
Native type Nullable Unsigned Auto Inc Money Case Sensitive
----------- -------- -------- -------- ----- --------------
CHAR Yes <n/a> <n/a> No No
VARCHAR Yes <n/a> <n/a> No No
INTEGER Yes No No No No
BIT Yes <n/a> <n/a> No No
TIMESTAMP Yes <n/a> <n/a> No No
Native type Lit. Prefix,Suffix Create Params Searchable
----------- ------------------ ------------- ----------
CHAR ',' max length Yes
VARCHAR ',' max length Yes
INTEGER <n/a>,<n/a> <none> Yes
BIT <n/a>,<n/a> <none> Yes
TIMESTAMP <n/a>,<n/a> <none> Yes
Native type Convert() Conversions
----------- ---------------------
CHAR SQL_BIGINT,SQL_BINARY,SQL_BIT,SQL_CHAR,SQL_DATE
SQL_DECIMAL,SQL_DOUBLE,SQL_FLOAT,SQL_INTEGER,SQL_NUMERIC
SQL_REAL,SQL_SMALLINT,SQL_TIME,SQL_TIMESTAMP,SQL_TINYINT
SQL_VARBINARY,SQL_VARCHAR
VARCHAR SQL_BIGINT,SQL_BINARY,SQL_BIT,SQL_CHAR,SQL_DATE
SQL_DECIMAL,SQL_DOUBLE,SQL_FLOAT,SQL_INTEGER,SQL_NUMERIC
SQL_REAL,SQL_SMALLINT,SQL_TIME,SQL_TIMESTAMP,SQL_TINYINT
SQL_VARBINARY,SQL_VARCHAR
INTEGER SQL_BIGINT,SQL_BINARY,SQL_BIT,SQL_CHAR,SQL_DECIMAL
SQL_DOUBLE,SQL_FLOAT,SQL_INTEGER,SQL_NUMERIC,SQL_REAL
SQL_SMALLINT,SQL_TINYINT,SQL_VARBINARY,SQL_VARCHAR
BIT SQL_BIGINT,SQL_BINARY,SQL_BIT,SQL_CHAR,SQL_DECIMAL
SQL_DOUBLE,SQL_FLOAT,SQL_INTEGER,SQL_NUMERIC,SQL_REAL
SQL_SMALLINT,SQL_TINYINT,SQL_VARBINARY,SQL_VARCHAR
TIMESTAMP SQL_BINARY,SQL_CHAR,SQL_DATE,SQL_TIME,SQL_TIMESTAMP
SQL_VARBINARY,SQL_VARCHAR
Identifiers
-----------
Driver-Specific Keywords:
-------------------------
Identifier Case - Mixed
Quoted Identifier Case - Mixed
Search Pattern Escape - \
Identifier Quote Char - "
Qualifier Location - Start
Qualifier Separator -
Owner Term -
Procedure Term -
Qualifier Term -
TableTerm - table
Special Characters:
-------------------
<none>
Limits
------
Max Binary Literal Length - 255
Max Char Literal Length - 255
Max Column Name Length - 63
Max Columns in GROUP BY - 20
Max Columns in Index - <none>
Max Columns in ORDER BY - 20
Max Columns in SELECT - <none>
Max Columns in Table - <none>
Max Cursor Name Length - 19
Max Index Size - <none>
Max Owner Name Length - <none>
Max Procedure Name Length - <none>
Max Qualifier Name Length - <none>
Max Row Size - <none>
Max Rowsize Includes Long - Yes
Max Statement Length - <none>
Max Table Name Length - 63
Max Tables In SELECT - <none>
Max User Name Length - 63
Timestamp Add Intervals:
Second,Minute,Hour,Day,Week,Month,Quarter,Year
Timestamp Diff Intervals:
Second,Minute,Hour,Day,Week,Month,Quarter,Year
Miscellaneous
-------------
Transaction Capabilities - None
Cursor Commit Behavior - <n/a>
Cursor Rollback Behavior - <n/a>
Trans. Isolation Levels - <none>
Default Trans. Isolation - <n/a>
Multiple Active Trans. - <n/a>
Bookmark Persistance - <none>
Lock Types - <none>
Static Sensitivity - <none>
Need Long Data Length - No
Non-Nullable Columns - Not Supported
Null Concatenation - Result is not NULL
Null Collation - Low
Procedures - Not Supported
Row Updates - No
Fetch Direction - <none>
Get Data Extensions - Any Column,Any Order,Bound
Positioned Operations - <none>
Scroll Concurrency - <none>
Scroll Options - Forward Only
Owner Usage - <none>
Qualifier Usage - <none>
|