Archived Months
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


all groups > dotnet odbc.net > january 2004

Oracle error
Posted by Sachi at 1/27/2004 4:31:07 AM
Hi I am getting "not a valid month\nORA-06512:" while trying to insert date value. But this is working fine with other PC. Even tried to test it from Oracle enterprise manager, It is working fine. I tried to reinstall whole Oracle itself. When I check the error source it points to Oracle ...more >>

Dispose Method
Posted by Juan Carlos at 1/23/2004 10:01:06 AM
H I have this code OdbcConnection conn = new OdbcConnection("DSN=myDSN;Uid=myUser;pwd=myPass") conn.open() OdbcCommand cmmd = new OdbcCommand("Select * from myTable",conn) OdbcDataReader dr = cmmd.ExecuteReader() while(dr.Read()) MessageBox.show(dr....more >>

Pretty P.O.'ed at .NET right now...
Posted by Gary Morris at 1/16/2004 9:42:35 PM
Hello everybody, I don't usually hang out in this group, but it looks like the only place to post this. Since I originally installed the Framework, I've had a version of SQL Server, I think it's called desktop edition or something along that line. It's nice to have and be able to use, but it ...more >>

Am I missing something?
Posted by John at 1/16/2004 1:27:24 AM
Hi I have a vb.net database with access backend. Every time I add a new field in the db, I open a separate project, run the data adapter wizard on the table, copy the code for all four commands (select, delete, insert, update) and paste into the data layer class for the relevant table in the m...more >>

ODBC Data Reader and Access 2.0 Memo fields
Posted by James Hansen at 1/13/2004 8:13:44 PM
I am trying to convert data from Access 2.0 to SQL Server 2000. I have ran into a few hurdles and worked through them all except 1. I cannot get the ODBC Data reader to return the value of a large amount of data in the memo field. If there is a small amount of data in the memo field, th...more >>

IDbTransactions and Commit/Rollback
Posted by Kev Sherratt at 1/13/2004 3:41:02 PM
We're currently looking into a generic connection/execute/commit fashion for a base object which will perform some magic to connect to a db and call a derived method to execute sql. Sometimes, however, the query sent using the transaction has a {CALL} or SELECT somewhere which seems to break t...more >>

Do i need to lock the table if i want to do an update?
Posted by babylon at 1/9/2004 12:30:12 PM
e.g. if i wanna do retrive a row from a table and increment one of the column of that row by 1 do i need to lock table do a "select" to get the row update the row/table unlock table? thx.... ...more >>

How to get list of DSN's defined on client machine?
Posted by Robb Gilmore at 1/9/2004 8:31:51 AM
Is there a function somewhere in the .NET framework that will return me a list of the DSN's defined on the machine where the app is running? thanks Robb...more >>



retrieving BLOBs from ODBC
Posted by Irin at 1/8/2004 5:39:07 AM
Hello, I am having trouble getting BLOBs out of an ODBC database, Sybase to be exact, using Visual Studio .NET. My code is in VB and the BLOBs are Word files stored as images. I set up a SELECT command, but when I call ExecuteNonQuery method to get a single file, I get "Arithmetic operation...more >>

Open connection
Posted by Juan Carlos at 1/6/2004 9:14:06 AM
Hi I have an application working with Sybase 12.5. They don't be in the same computer. When I disconnect my application from the network I receive an exception: Sybase network connection has terminated. If a transaction was in progress it has been aborted. I have two methods, one for ...more >>

Using MS Access reports
Posted by Jared at 1/4/2004 9:15:10 AM
Does anyone know of a way to display/print existing MSAccess reports using VB .NET v1.1? ...more >>

List of Tables in Database?
Posted by Bruce Vander Werf at 1/2/2004 11:20:10 PM
Is there any way to access the list of tables that are available via a particular ODBC connection? --Bruce ...more >>

Error using MS-Access/Webservice/ODBC and Insert/Update/Delete statement
Posted by Vijay Anand at 1/1/2004 9:29:33 PM
Folks. We are trying to connect to an Access DB using Webservice on ODBC. When used without the Webservice, everything seems fine and all insert statements work. But when we use webservice, the error is like "Use an updatable statement instead of insert....." We are on .NET Framework 1...more >>


DevelopmentNow Blog