Welcome to MSDN Blogs Sign in | Join | Help

May 2007 - Posts

DB2OLEDB : error messages

1. Could not connect to data source 'ENTERPRIZE_UDL': A TCPIP socket error has occured (10061): No connection could be made because the target machine actively refused it. SQLSTATE: 08S01, SQLCODE: 10061 you get this error message when a) PORT Number
Posted by asmitaw | 0 Comments

DB2 Data types vs OLDB Data types

DB2 TYPE_NAME OLEDB DATA_TYPE SMALLINT DBTYPE_I2 INTEGER DBTYPE_I4 REAL DBTYPE_R4 FLOAT DBTYPE_R8 DOUBLE DBTYPE_R8 DECIMAL DBTYPE_DECIMAL GRAPHIC DBTYPE_STR VARGRAPHIC DBTYPE_STR CHAR DBTYPE_STR VARCHAR DBTYPE_STR CHAR () FOR BIT DATA DBTYPE_BYTES VARCHAR
Posted by asmitaw | 0 Comments

MSHostFileClient SQL syntax

SELECT Statements 1. SELECT <Column Collection> FROM Filename WHERE <Where Clause> 2. SELECT <Column Collection> FROM Filename AS <AssemblyName.SchemaName> WHERE <Where Clause> Details of Column Collection parsing and Where
Posted by asmitaw | 0 Comments
 
Page view tracker