|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 April 2007 May 2007 June 2007 July 2007 August 2007 November 2007 March 2008 |
Query is too complex error Posted by Peter at 2/29/2004 10:57:05 PM I am updating Access database using System.Data.Odbc
I am using the following code:
////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////
foreach(DataColumn cl in dsNew.Tables[0].Columns)
{
dataRowDe...more >>
ODBC Connection Pooling with ADO.NET and Oracle RDB Posted by Thomas Heder at 2/27/2004 3:55:09 PM Hi!
I believe I am not getting ODBC connection pooling in ADO.NET to work
correctly. I am connecting to an Oracle RDB database with Oracle RDB ODBC
driver 3.1.0.0.
With a test project in VB6 I start out with this call to enable pooling on
the ODBC level.
SQLSetEnvAttr(0&,SQL_ATTR_CONNECT...more >>
System.Data.OracleClient Problem: Not closing open connection Posted by ajaykrishna at 2/26/2004 11:28:37 PM Hi
Could any one tell me what is the latest version of System.Data.OracleClient? Currently I'm using version 1.0.1012.0 in my project which is giving problem of not closing connection eventough I'm issuing connection Close() statement.I am trying to connect Oracle 8i from ASP.NET framwork 1.1 in m...more >>
"CREATE TABLE" for files *.dbf with a custom float column Posted by news.microsoft.com at 2/24/2004 2:22:49 PM
How to create dbase file based on SQL-92 which have a FLOAT column like
float(14,2):
=> xxxxxxxxxxxxxx,xx <=
Thanks in advance,
Patrice
...more >>
Securing method calls on a remote object Posted by Ben at 2/23/2004 6:21:05 AM Hi
I have a remote object (which may be hosted in either IIS or a Windows Service - undecided at this time) that is going to be publicly available over the web. I have several method calls on this object that I want to only be available from behind the firewall. What is the best way to do this
...more >>
ERROR [22001] [Microsoft][ODBC Excel Driver] The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less Posted by Gopinath Munisifreddy at 2/21/2004 11:15:25 AM Hi,
I'm using ODBC DSN less connection to load an EXCEL file into a dataset.
It's raising the error
"ERROR [22001] [Microsoft][ODBC Excel Driver] The field is too small to
accept the amount of data you attempted to add. Try inserting or pasting
less data."
The problem is one of the colum...more >>
"Connection is dead" on ODBC insert of decimal into DB2 Posted by jdatbp NO[at]SPAM yahoo.co.uk at 2/17/2004 12:08:03 PM I am having problems inserting Decimal values into a DB2 database via
a .NET/C# application which is using an OdbcDataAdapter. Other field
types such as VarChar, Int, Date, etc work ok, and I can insert
literal values into a decimal field, but any attempt to insert a
decimal field via an OdbcPar...more >>
ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure 'ABC' expects parameter '@abc', which was not supplied. Posted by Chris Hayes at 2/14/2004 8:47:08 PM Greetings,
I am getting this error when I try to populate a DataTable by executing a
stored procedure on a SQL Server 2000 database through an ODBC in a VB.NET
application: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL
Server]Procedure 'ABC' expects parameter @abc, which was not suppli...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Date Formats in ODBC.Net Posted by John Read at 2/11/2004 1:46:05 PM Does anyone know what date formats ODBC.Net expects dates to be in? I'm used to converting dates to {d'yyyy-mm-dd'} in my insert and update statements. This no longer works. DateTimes required {ts'yyyy-mm-dd hh-mm-ss'}
Do you know where I look up this ODBC.Net SQL Syntax like this? Lists of OD...more >>
ODBCDataReader and multiple returns Posted by Patrick Wong at 2/11/2004 2:57:08 AM Hello,
I'm trying to execute the following SQL statement on a database:
SELECT Client_Id, Contact_Number from U_EMAIL_ADDRESS WHERE U_EMAIL_ADDRESS
= [rcptEmailAddress]
[rcptEmailAddress] is the value that I am searching for (recipient's email
address). The code below will return all matc...more >>
About ADOX with Oracle Posted by Mohammad Abu Sharkh at 2/9/2004 12:34:58 PM Hi,
I am trying to use ADOX to get the names of tables on certain Oracle
Database. I did install Oracle Client first and its working fine.
I made an instance from ADOX.Catalog object and I set the ActiveConnection
property to :
"Provider=msadora;User ID=xxx;Password=xxx;Data Source=<local...more >>
Using Visual Basic.Net SQL Server and MSDE Posted by diracsoftware NO[at]SPAM optusnet.com.au at 2/6/2004 4:25:08 PM Help!!!!
I have recently purchased a copy of Visual Basic.net with the intent
to use it in a databaseing application with SQL Server/MSDE.
I also purchased a book on how to do it and It reccomends you download
the evaluation version of SQL server (See link)
http://microsoft.com/sql/evaluati...more >>
AS400 Rollback does not work ! Posted by Mohan at 2/5/2004 8:36:05 PM I had tried OLEDB (IBMDA400) with .net for Transactions. Transactions are not supported at all with OLEDB and AS400. Now I am trying ODBC.NET for transaction. Rollback does not work with ODBC.NE
Can anybody help? If Transactions are not supported also in ODBC.NET , how to lock records and execute ...more >>
Distribute/deploy latest Jet 4.0 with MDAC 2.8 Posted by Alex Ramos at 2/1/2004 6:21:08 PM Hello,
Problem: Trying to deploy a .Net application using ADO and MSAccess DB. But, MDAC 2.8 doesn't contain the Jet 4.0 engine.
Althou I'm currently using Windows 2000, I'm using a newer version of Jet 4.0. (I checked) than the Windows XP computer that I'm deploying to. I believe this is causi...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |