| Operation must use an updateable query. (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hello, I'm having problems INSERTING into an Access 2002 database from a ASP.NET app. I keep getting the following exception message: Operation must use an updateable query. I've checked all permissions on the .mdb file/directory/IIS and it all looks good. I've also gone into Access and executed the operation successfully, it just wont work coming in over the web. Below is my simple script. Any id... |
|
| unable to update records using OdbcTransaction (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I am using ODBC.net to connect to DB2 in as4000 using its odbc drivers (IBM AS/400 Client Access Express for Windows Version 5 Release 1, Modification Level 0 Service Level S105361) I was able to query the database using select statement. I need to update a fews records in 1 go. Hence I use OdbcTransaction; so that I can rollback if there is any error. If I use the OdbcTransaction, I will enco... |
|
| Exposing the ODBC API (5 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hello, Are there any plans that anyone is aware of to expose the ODBC API in a (near) future relase of the .NET Framework? Currently is the best way to access the API functions to use PInvoke? I need to use ODBC for an application I'm developing and I'd like to use C#, but I think it might take a while to write wrapper classes for all of the stuff I need. Any thoughts? Thanks, Nick |
|
| SQL SELECT Statement....! (4 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I am a SQL newbie; I am writing a client app using ODBC .NET to retrieve data from a customers database. I wish to select a particular cell from a table. I use the following SQL query: "SELECT ["COLUMN"] FROM ["TABLE"] WHERE ["PRODUCT"] 'PROD' This works when the "PRODUCT" column is text; how do I cope when the "PRODUCT" column is Number, etc? E,g, SELECT ["COLUMN"] FROM ["TABLE"] WHERE ["PROD... |
|
| Using MySQL in VB.NET.. Really possible? (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I have installed the ODBC .NET Driver and created instances of an OdbcConnection, OdbcDataAdapter, OdbcCommand, etc.. in a VB.NET project. I tried the following connection strings and none worked: Provider MSDASQL.1;Persist Security Info False;Extended Properties "DSN myodbc3 test;DESC MySQL ODBC 3.51 TEST DSN;DATABASE mydbase;SERVER localhost;UID uname;PASSWORD upass;PORT 3306;OPT ION 10;STMT ;" ... |
|
| Cannot Generate DataSet (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| I cannot generate a typed dataset using the ODBC Connection and Adapter components. Should I be able to? I know the connection and adapter components are configured correctly because I can display data with an untyped dataset. Thanks, Bill |
|
| Informix ODBC truncate string (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hello, I've managed to get ODBC.NET to connect to an Informix database, but all of the char and varchar values that are returned are truncated. For instance, a value which should be char(3) comes back with only the first two characters, and a value which should be varchar(100) comes back with only the first 50 characters. Does anyone have some advice for me? joe The value of "ConnectionString" is ... |
|
| update dataset data (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I would like to update on the database the data binded from a dataset to a graphical control (like DG or textbox). I have tried with this: /* code that bind the data */ string strConn, strSQL; strConn "DSN db Flexicom;" "UID flex;" "PWD flex;"; strSQL "SELECT * FROM STORICO STRUTTURE"; OdbcDataAdapter da new OdbcDataAdapter(strSQL, strConn); ds new DataSet(); da.Fill(ds, "Storico Strutture"); ... |
|
| OdbcDataReader (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I'am using an OdbcDataReader Object. I have extracted all elements in it with the .Read() method. But then I need to get thoose values again. How could I set the Object's pointer to the start of it? Could I? Thanks, Enrico |
|
| Datagrid update (2 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I would like to find infos about how to automatically update a Datagrid's data (loaded from ODBC). Someone knows websites or HOW TO's? Thanks Enrico |
|
| ODBB Error (3 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, I am trying to read a table from the Sage Line 50 (Version 8) data files through their ODBC32 driver. I've installed this driver and have tested it by using Access 2002 to import the table (and hence creating the DSN at the same time). When I try to use the VB.NET command to fill a dataset with the content of the required table it comes back with the error message "Driver does not support this... |
|
| ODBC, DotNet, and DB2 on mainframe (7 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Does anyone have any experience reading and/or updating DB2 databases on the mainframe using an ASP.Net front end with ODBC? If so, what middleware do you use to connect the IIS Server to the mainframe? Are you using/it is necessary to use COM /MSDtc for two phase commit, or can you use something similar to the SQL Server commit/rollback to ensure data integrity if you are only updating mainframe ... |
|
| Is there a way to limit the number of rows returned from a query (7 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| In ODBC there was SQL MAX ROWS statement option that one could use to limit how much data (how many rows) gets returned from a database query. Is there a mechanism to do somethign similar in ADO.NET? |
|
| Which DataAdapter/Reader/etc. to use? (6 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Hi, If I need to support MS SQL Server, MS Access, Sybase SQL Anywhere, Sybase SQL Server, Oracle, and possibly IBM DB2, which data adapter and reader and etc. should I look at? I think ODBC will be the only way to go since SqlDataXXX is specifically for MS SQL Server and obviously OracleDataXXX is for Oracle.. There is the OleDbXXX methods which might work, but isn't that just an overlay of ODBC?... |
|
| Pack dBase (9 replies) |
| microsoft.public.dotnet.framework.odbcnet |
| Is there any way how to pack dBase file after delete rows. Thank you Ales |
|
