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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|