Hi!<br/>I would like to use ADO to connect to MS Access 2000 database which is stored on remote computer (access via ftp). When I try to connect to database I get "Could not find installable ISAM" error. I am sure I have all the necessary drivers, so what could be wrong?<br/>Thanks, Simon

Hello everyone.How can i send string type (char* type) parameter to Stored Procedure ?I am using Visual C++ so i tried like that..VARIANT vtName;VariantInit(&vtName);vtName.vt = VT_LPSTR;char strData[20];strcpy(strData ,"Simple15");vtName.pcVal = strData;pParam = pCommand->CreateParameter("strNam...

I'm writing a little app to get data from a CSV file generated everyday by a vendor and insert it into a Table in our SQL Server database. I can get the data fine, and I can easily merge it with another dataset I pull from the existing table (which is exactly the same except for an Identity Col...

When we use typed datase and untped dataset?<br/>What is the difference between them?<br/>let me know<br/>thank you

I am running two WIN2K servers, one as web site the other as database server (using .mdb files). My asp pages used fileDSN to connect, but cannot connect unless the .mdb files are on the same server as the web site. This is the error i get.....Microsoft OLE DB Provider for ODBC Drivers (0x80004005)[...

Hi,<br/> Is it possible to connect to SQL server 2000 from my program running on a wince device? I am using Embedded vc++ as the development environment. Any web site/or sample code showing an example would be really helpful.<br/>Thanks

I'm having performance issue with this ASP.NET app. From SQL Server log there're MANY MANY log which resembles the following:SQL Server log: Login succeeded for user 'APPL_ACCOUNT'. Connection: Non-Trusted.I'm talking thousands in one morning. And I am suspecting that this i...

I tried to make this work a couple of different ways but each attempt fail. Basically I justwant to sent a batch of insert statements to Sql Server. Like:Insert Into X(Y) Values(1)Insert Into X(Y) Values(2)...Insert Into X(Y) Values(n)Does anybody have a clue about ADO+?TIA Ken...

Hi People,Can any one tell me if I have to leave the connection open when reusing a prepared statement or if I can close the connection completely and destroy all objects to the database and then later the compiled statement is still available to me?Do I have to keep the SqlCommand object alive and...

I have been using ADOX to connect to a Microsoft Jet database. This database resides on the same machine as the application. The way my application is designed, i connect to the database while i am initializing other components of the application.Particularly, ADOX takes around 5-6 sec on a 800Mhz p...

Who has had a wide experience working with MySql,<br/>Please, write what provider is better to connect with MySql 4.1.22 using ADO.NET 2.0 (preferably freeware).

Hello,Am I doing something wrong or is it a bug?What Im trying to do is this: I create a dataset. Load a schema, read my XML and bind the dataset to a datagridview.Not too complicated, but the thing is that the XML is not validated the way I want it to be validated.What I want is an XML file with ex...

Hi!I try to connect with MySql (4.1.22) using ADO.NET (2.0).OdbcConnection cn = new OdbcConnection("Driver={MySQL ODBC 3.51 Driver};Server=server.com;Database=base;Port=3306;uid=user;pwd=111;option=3");cn.Open(); // And catch the exception here:ERROR [HY000] [MySQL][ODBC 3.51 Driver]Access denied fo...

I am trying to link a table from one access database to another access database; I have deployed my project on about 30 PCs and receive an error on 3 of them. I use Visual Studio 2005 to develop. Other people have suggested the problem is probably an ODBC driver issue, since I use the same connectio...

Hi,I am developing a web application that use SQL server 2005 DB. Till now, I have made a connection with SQL server, retrieved the data from DB and showing in the GridView.Now I have two ways of storing the dataset:1. By storing dataset results in session variable2. or use sql state management.In t...

Hi friends,I am working on a windows application that resides on Production application server. The purpose is to update the "Production Database" with the data that is available in the datatable.I have the following structure of the datatable :-COLUMN-A COLUMN-B COLUMN-C COLUMN-D COLUMN-E1...

I have a project made with VB6 using RDO connection to connect to SQL 2000 to a database with collation sequence SQL_Latin1_General_CP1_CI_AS, same collation is used for the columns, This database contains Arabic Data in VARCHAR fieldsI wrote a small program with VB.Net 2005 that connect to the same...

Suppose that I have a simple table 'TAB' that consists of 3 fields: ID int PK F1 varchar(50) F2 intAll I want is to write a SQL statement that would insert data into table TAB only if there is no 'SIMILAR' row already in the table. By using word 'SIMILAR' i mean two ro...

Hello,I would like to connect with ADO ODBC to a Windev and progress databases. I know that Pc-soft let me download the odbc driver for windev but for installing i need to install (buy) windev. For progress i have no ODBC driver.Someone can help me?Thank'sGal...

Hi, im using VB2005 and SQL2005, i have a view that shows data from various tables, but only need to save on one of the tables.<br/>How i can do the trick?<br/> :confused:

Here's an example program: DataSet ds = new DataSet(); DataSet ds2 = new DataSet(); DataTable dt = new DataTable("Table1"); DataColumn dc = new DataColumn("Col1", typeof(int)); dt.Columns.Add(dc); DataTable dt2 = new DataTable("Table1"); DataColumn dc2 = new DataColumn("col1", typ...

if said we have 4 MB data, when load to DataTable, it could consume 20MB or more memory, is there any explanation? How to reduce the memory consumption?<br/>Any help will be very much appreciated.

Hi,my requirement is i want to join three tables in which first and second table are related and second and third tables are related.I want to get data from all three tables so how it is possible.<br/>Pls send me some reply.

Hi all, 1st post so be gentle, had a search and seem unable to find anything relating to this.I am currently creating a small program to take 4 tables (currently) from an Access DB where modifications are made and update 2 different Remote Server based MySQL databases. I am using C# and .NET. I also...

Hello,I wrote a code for reading data from Microsoft Access file but it gives me the following error:No value given for one or more required parameters.Here is the codeString conString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + txtPath.Text + ";Persist Security Info=False" ; Ole...

I'm connecting to an old DBF file (dBase 5.0) and after sevral commands are executed (about 570-590 times)it shows me thw following errorERROR [HY001] [Microsoft][ODBC dBase Driver] System resource exceeded.and reading the DB failes after that for good. private void CollectDBData() {...

I am using web service to retrieve data from IBM as400 server and db2 database.Can I use .net fragment caching or any other caching effectively in this case? If anybody has any reference on this, please help me out.

I'Ve a data adapter with a master-detail-relational table.In this statement I use a parameter to filter the data. Out of this adapter I've built a dataset to fill a data grid view.How can I input the parameter now in the dataset or the datagridview to filter the data during the runtime?You...

hai i got a table having the structure as D_EVENT_DATE S_USER_ID N_EVENT08/02/07 08:01:46 R12 1608/02/07 13:01:58 R12 1808/02/07 15:02:06 R12 1908/02/07 20:02:15 R12...

I added a data source to my vb.net (2005) project, selecting tables which all relate to each other. They also have referencial integrity set up on SQL server, so that if you delete a row which has multiple child rows in other tables, they will also be automatically deleted, the same goes for update...

I am getting following exception in the code belowException occurs when closing connection,Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The SqlCommandTimeout is already set 0 as you can see in the code below,When i search records f...

hello;ı want to select a table and then ı want to use its columns.for example; ı have a "my" table.ın "my" table i want to list its columns name,type,length and description.how can ı do this?maybe an example;my "id" "int" "4" "it is a description"my "name" "nvarchar" "0" "...

I have a Foxpro DB from which I need to get the unmentioned information1- DataTable dcolumn = this.connection.GetOleDbSchemaTable( OleDbSchemaGuid.Columns, new object[] { null, null, tablename});2- DataTabl...

I have a problem updating a database from dataset. In particular adding a new row in the table of the the data set. It work in the data set but when i try to update the database with Update nothing happen, neither exception messages. I think that the problem rises for the presence of a key column, b...

HelloI'm using C# 2005 as a front end to SQL Server Express 2005.I have two tables tblFSE and tblStatus. I want the tblFSE to be the main table for my form and tblStatus to be bound with a combobox on the main form. The combobox is to have 3 choices - Opened, In Progress and closed. They will b...

i have a problem:i have 2 tables on the dbone is id_names which has 2 rows: id(key) , and nameand the other one is employees_info which also have id(key) , and some more rowsi did a data relation between id_names and employees_info which are related with the idnow my problem is this:when i update th...

hi i am trying to insert multiple records into a table by selecting it from another table.but its inserting just one entire record only,not inserting rest.i think problem s with my loop construction can anyone plse help me o solve thisDim dst As New DataSet Dim sqlCmd As New SqlCommand...

Hi im having A Dataset csv wich is the Dataset of a Spetial csv file. Now i want to add a Column of this dataset to my databe using this SQL StatementDataSet csv=MyCSv2Dataset("test.csv");DataTable CSVTable = csv.Tables["CSV"]; CSVTable.TableName = "CSVTable";...

hi <br/>i am trying to insert multiple data into a table.i need to check duplicates before insertion.can anyone plse help me to chck this

hiI am trying to read data from a table using Select query(selected columns only) and inserting these data into another table.For this i am using datareader.but its always showing me error like my title(There is already an open DataReader associated with command which should be closed first)sample c...

I'm using 2.0.I love the data set editor for defining DataTables and DataRows. However, the SQL statements I need to run select many gigabytes of data and so their result sets cannot be stored in memory (DataSets). I don't need to insert/update/delete data, and I don't need to access...

Hello:I am trying to connect to SQL 2005 from a C# Windows program using a remote location via VPN, but I have been unable to get a connection. The error that I am getting is as follows:Message="An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005...

Hello,I am using a datagridview and have bound it to a bindingsource.In the datagridview i have a combo box column which gives the user a choice of either, ordered, pending, delivered. However, In this specific grid I just want to display the pending orders. But if I click on the status and select d...

ADO.NET 2.0I'm trying to populate a pair of nested repeaters using a generated dataset in VS2005.I've created a DataSet with two DataTables (Groups and Items) populated by two TableAdapters and linked by a foreign key DataRelation.My problem comes when I try to use the relation (FK_Groups_...

Hi, I'm searching the best way to fastly convert a DBF into a SQLLite DB.I've tried something like this : -Creating all connections, etc... and cnn.Open(); //Preparing parameters and insert query //<-- String[] paramFields = new string[headers.L...

I have got a problem when i delete a row.Also it has started with VS.NET 2005.I hadnt experienced it before.It's about update. The warning is "Concurrency violation: the UpdateCommand affected 0 of the expected 1 records." i wrote the code here :there's no problem when adding a rowprivate...

Hi, I needed to add 80,000 records. I do following, see following pseudo:1. While(Readline != EOF)2. Create a row3. Add the Row to the DataTable (this starts slowing down after 30,000 records, and goes completely blank around 80th,000 record)3. End While4. Dump the DataTable in to MS Access database...

Hii am using data base Access 2000.my code implemnting nestsed transactions where using more then one connection i get the following exception: "oledbexception:could not update currently locked".i cant put the whole code but i can demonstrate: if (!Modified) return;Modified=false;OleDbTransaction tr...

Hi Gurus, in my c# application i want to query some data from 3 tables:Movie-Movie_ID-TitleMovieGenre-Movie_ID-Genre_IDGenre-Genre_ID-NameNow i want to know all movies and if there are any references to the genre table i want to know the genre, too.My Database is a access data file and i suppose tha...

I have deployed an C# .NET2.0 application as a frontend for an Access Database. To fix a bug I need to modify 1 relationship in the Access Database to Enable Cascading Deletes. I am developing a patch to fix this bug a few others. Is there a way to programmatically change this relationship property...