| Running a DTS Package from .NET? (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Is this possible? There were DTS objects that you could use in VB6 to run DTS packages, is there some ADO .NET equivalent? I can't seem to find any reference to this... |
|
| can I persist a dataset to disk? (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| I like the dataset object very much, but if I'm to use it then I need lots and lots of Rams in the server. A recordset can be persisted to disk and deleted after it has done its work. Can the same thing be done with Dataset. If it's not possible then the usage for Dataset is very limited in my book. Placing hundreds of users' shopping cart and other information gathering in memory is a definite no... |
|
| Data Form Wizard's form results in concurrency error (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| There has been some discussion about this problem (I think) but either I'm not smart enough to relate the answer to my situation, or my situation hasn't been specifically addressed. I want to be able to generate a data form using the .NET ide's Data Form Wizard, and modify a table that way. I'm connecting to an Access database using oleDb stuff. I have read and followed the readme relating to one ... |
|
| how to connect oracle db through ODBC.net? (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| I have my connection string set up like this: Dim MyConnection As odbcConnection Dim MyCommand As odbcDataAdapter MyConnection New odbcConnection("Provider ODBC.NET Data Provider;DSN wrc;uid tsadmin;password sept24") when I run this code, i got this error message: ERROR [28000] [Oracle][ODBC][Ora]ORA 01005: null password given; logon denied ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's S... |
|
| ODBC datatype bug (6 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| We are having an issue using the ODBC.Net beta 1 driver for a very specific situation. When accessing DATE and DECIMAL datatypes from an NCR Teradata database we encounter errors. All other datatypes work fine, but these two do not. The errors are as follows: For DECIMAL type: Error: Value null was found where an instance of an object was required. The call stack: at System.Data.Odbc.OdbcDataReade... |
|
| Using ADOX in a Vb.net Application (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Why does the following code fail with a "System.ArgumentException" exception? dim cn as new adodb.connection dim dbInfo as new adox.catalog cn.open ("... Some provider String") dbInfo.ActiveConnection cn This line fails! |
|
| Updating constriants to database (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi I had created datarelation between two tables in a dataset. I need to update the relation in the SQL Server database. Is it possible to do so? |
|
| how to get table schema in odbc.net (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi Everyone, Is there a way to obtain the schema information of a database in ODBC.Net. I know that in OleDB data provider you can call GetOleDbSchemaTable. Also, when Microsoft going to release next version of ODBC.net provider. Thank you Alex |
|
| ??OLE DB FOR ODBC PROVIDER (4 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| ok don't laugh but I am trying to connect to a foxpro database stored on another server lets say \\dotfred\data. They are Fox Free tables DBF. ALL MACHINES ARE RUNNING XP WITH THE LATEST. SERVER IS RUNNING WHISTLER ADVANCED SERVER. ******** THIS WORKS IN VB6 WITHOUT A PROBLEM: ******** conn.ConnectionString "Driver {Microsoft Visual FoxPro Driver};SourceType DBF;SourceDB \\dotfred\data;" conn.Open... |
|
| Is there such thing as a multiple datasource dataset??? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| New to .NET but learning quickly! This stuff is great! Going through the quickstart tutorials located at (http://localhost/quickstart/aspplus/) if you have it installed on your machine. As I go through the examples, particularly those in database access, I notice that they show .DataSource properties with only ONE table. What do you do if you want to go after data in more than one table? I've hear... |
|
| Execute Oracle Function call without using parameters (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Is there any way to execute an Oracle function in .NET (using C#) without using parameters? Using older versions of ADO we were able to run function calls as a string with the parameters already built in (i.e. "FN TEST(a 1)"). But now in ADO .NET it appears you MUST use parameters, and the command text should only be the name of the function. Unfortunately, this makes it much harder to create func... |
|
| Are there any updates for ODBC.NET? (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Are there currently, or are there going to be any service releases for ODBC.NET Beta 1? The version I have is unusable for the databases I wish to access, and the OLEDB option has been taken away from me in Beta 2, so I really really could do with an update that fixes some of the many issues already reported here. Kind Regards ()z |
|
| update a dataset (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello everyone! I want to update a dataset and return the modification to the database. Can anyone tell me how I can do this or tell any web site with an example of this? I'm using C#. Thank you MarcoG |
|
| "Concurrency violation" error (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, Sorry to cross post from the odbcnet group, but there isn't much traffic there so I haven't received a reply. I was hoping perhaps someone here maybe able to help. Please see my original post to the odbcnet group below. Thanks, Daniel. Hi all, We're using .NET Beta 2 to access Ingres 2.0. We're having problems updating the DB via the command builder. If we specify the update string manually ev... |
|
| moving from sql server to access (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hello, I have been designing an application using Sql Server and I need to deploy it on an access DataBase. I don't want to change all my data objects, so I thought I could rely on ODBC and SqlConnection for that. Now 2 problems arise: 1 Once I created an odbc data source for my access db, how do I format the connection string? 2 are there type conversions problems that I should be aware of? Thank... |
|
| How to get SqlDbType ? (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi : How can I get SqlDbType from a DataColumn ? CODE : MessageBox.Show ("DataColumn.DataType.ToString()); RESULT : System.String CODE : public void CreateSqlParameter() { SqlParameter myParameter new SqlParameter(); myParameter.ParameterName "@Description"; myParameter.IsNullable true; myParameter.Offset 3; myParameter.SqlDbType SqlDbType.VarChar; myParameter.Direction ParameterDirection.Output; ... |
|
| RDS implementation (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi! As any implementation to RDS (ADO) in dotNET? Not with IIS!!! Only simple TCP channels. |
|
| Errors Filling Dataset - from OleDBAdapter (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello, this may be a better group to post this in. I am trying to fill a dataset, however there will be times when there are no rows returned by the SELECT statement. Here is a basic code snippet for what I am trying to do: strSQL "SELECT VoteDate, VoteIP FROM Votes WHERE SiteID " & Session("VoteID") & " AND VoteIP LIKE '" & TestIP & "'" Dim objData as New OleDbDataAdapter(strSQL, objConn) objData... |
|
| Performace related to OleDbCommand (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi. I read few article about ADO.NET performance tuning. My question is that OleDbCommand is faster than OleDbAdapter or not. I'll use one of them to fill DataSet. No update/ delete/insert operation will occur. What class do I have to use? Which is faster? |
|
| paging through data with ado.net (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hey there, How can I page through the data in a table with ado.net? In ado I used something like this: Set rsData New Recordset rsData.PageSize 15 rsData.CacheSize 15 rsData.Open querystr, connstr, 3, 1, &H1 How do I do this in .net? thanks, Bertus Dam |
|
| Help:New Table from DataSet to DataBase??? (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| I have create a new Table in a DataSet with Clone and ImportRow. But, how can I get the new Table to my DataBase with the OleDbDataAdopter? I have try it with: Dim custCB As OleDbCommandBuilder New OleDbCommandBuilder(oleadapter) oleds.Tables.Add(sqlds.Tables("test").Clone) For i 0 To sqlds.Tables("test").Rows.Count 1 oleds.Tables("test").ImportRow(sqlds.Tables("test").Rows(i)) Next i oleadapter.U... |
|
| Auto incrementing value (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello, I am inserting data in a table which has an auto incrementing int64 column. How can I get the value of the auto increment? Currently, I'm doing this pretty dumb thing: SqlCommand cmd new SqlCommand("insert into mytable ( a,b,c ,.... )values(@a,@b,@c,,,)"); cmd.Parameters.Add("@a",a); cmd.Parameters.Add("@b",b); .... cmd.ExecuteNonQuery(); // do the actula insert cmd.CommandText "select coun... |
|
| How do I create a copy of a DataTable that copies all the data too? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| If I use DataTable.Clone(), that seems to copy the schema, but how do I copy the data too? I don't have to loop through all the rows, do I? |
|
| Bug when Inherit from DataRow ? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Sample code follows (console app) code using System; using System.Data; namespace data { public class maRow : DataRow { public maRow(DataRowBuilder rb) : base(rb) { } } public class maTable : DataTable { protected override Type GetRowType() { return typeof(maRow); } } class Class1 { static void Main(string[] args) { maTable table new maTable(); table.NewRow(); } } } /code Why this code raises an A... |
|
| Some ADOX -> ADO.Net questions (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| How do you determine if a table already exists in a database via ADO.Net? If the table does not exist, how do you create a new table in a database? I've created a new DataTable object, and added the table to my Dataset object, but now I am confused as to what I should do next to add the new table to the backend database. I do NOT want to add any rows. I just want to create an empty table if the ta... |
|
