Hi there, I have writing easy to moderate SQL in the DataSet Designer and Query Builder, using a Jet 4.0 connection to an Access 2003 DB. I am running VB.NET 2005 sp1. As soon as I try to do anything more than the most trivial SQL (e.g. simple JOINs, more than 1 parameter other than in t...more >>

I am trying to take a very strangely delimited text file and put it into access. So far I was able to get the text file into a dataset and figured from there I could get it into access. I am trying to use the code below but the insert query(oledbcommandbuilder) just will not work. I am work...more >>

Hi, I've a method in my web service..which makes a call to db and sends back a dataset.. the query takes 2 mins to fetch the results..by that time i'm seeing a 'operation has timed out error' on my screen.. is there any to get rid of this error?...more >>

The following code would fail, with the error: "The '' string cannot be converted to the double type." when trainTable contains rows with DBNull in some of the columns. How can I pass NULL to MSAS? using (AdomdCommand comm = connAS.CreateCommand()) { comm.CommandText = "INSE...more >>

The following code would fail, with the error: "The '' string cannot be converted to the double type." when trainTable contains rows with DBNull in some of the columns. How can I pass NULL to MSAS? using (AdomdCommand comm = connAS.CreateCommand()) { comm.CommandText = "INSE...more >>

Using data reader against one of my Oracle tables is crashing with following error: System.Data.OracleClient.OracleException: ORA-01406: fetched column value was truncated. This happens with Microsoft ADO driver to Oracle. Oracle ADO driver works just fine. Error happens only with some...more >>

Hello. Using XP Pro w/SP4 and VS 2003. I wrote my program with the connection string and the path for loading the Maps as follows: C:\MVB.NDbProJim\Ch7\ROE6AllRecords2\Maps. The Maps sub-directory containes all 116 Maps of the Lots and also the ROE6.mdb database. But when I deplay this app to...more >>

hi, i'm facing a strange problem.. In my requirement , I'm suppose to load the data from datagrid into excel file. make the required changes in the file and load the file back into the datagrid. i'm able to export to excel but after i make changes in the excel and load it into grid,...more >>

I have a web page where a user can select multiple items for use in a select statement. SELECT columns FROM table WHERE ID in (1,2,3). Since its a web application I use a stored procedure to get the results. Currently my sproc GetResults (@EventIdList varChar(@256)) uses a table value func...more >>

Hello All, Can anyone tell why one sql statement works with the data reader but not the other. To test, I uncomment the string I need. Dim QueryString As String ***This string does not work 'QueryString = "SELECT * FROM print_server WHERE LS = (SELECT LS FROM vw_turboinfo WHERE tsn = '08...more >>

I need some help! I have a webapp in ASP.NET 2 running on 2003 R2 that doesn't seem to want to bring up a connection pool. When I run a trace on the DB server I can see Audit Logoff and Audit Logon between query batches, which leads me to believe that this is occurring. This is a replace...more >>

Hi, I;ve a requirement wherein the need to export the data from grid to excel file using .net 1.1.. While I do the export to file, sfew columns in teh excel file should be locked, in the sense..use shouldn't be able to edit the values in those columns... is this possible thru C#? any samp...more >>

Why won't this code add a row to my database? It runs as expected but when I look in the SQL database using SQL Server Management Studio the table is empty. DataRow newRow = this.dsHealthClub.NotInHouse.NewRow(); newRow["Name"] = dsEmployees.Employees....more >>

System.Data.Odbc.OdbcConnection conn = new System.Data.Odbc.OdbcConnection(@"Driver={Microsoft Access Driver(*.mdb)};Dbq=C:\abc.mdb;Uid=Admin;Pwd="); when invoke conn.Open(); the program throw an OdbcException ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and n...more >>

Hello, is there are ready component (maybe an data adapter) existing which has advanced features like paging (with server cursors) but still allows merging? Thank you, Frank...more >>

I am running an Update routine that calls a function. It appears that the function never executes because I receive: Must Declare The Scalar Variable @Country. Code: Dim newCustomer As New Customer newCustomer.CustomerID = customer.CustomerID Me.PutCus...more >>

Hi EveryBod: I have an object cmd as SqlCommand object and and I face problem with safe large data by using this object there is an errore appear tell me that the excution time out. Sombody can tell me how can I increase the Excution time? I am using SQL server 2005 any help will be ...more >>

I have a need for a SqlConnection.Open that times out in an predictable matter (i.e. if the server does not answer, I do not have to wait for TCP or NIC timeouts to find out). The "Connection Timeout" in the connectionstring will not help, as this only applies to the connection to the SQL Server...more >>

Hi Is there a way to disable EnforceConstraints on a dataset? I have this statement ds.EnforceConstraints = true in MyDataSet.Designer.vb but I am reluctant to set it to false as the designer may overwrite the code. I only wish to do it temporarily to speed up fill operations. Thanks ...more >>

I have a stored procedure that when called from SQL 2005 Management Studio takes less than one second to execute. The same SP, when called from .NET code takes about 13 seconds. I am using a SqlCommand object with CommandType set to StoredProcedure and I am passing arguments through the parame...more >>

Hi I have a master data set. I need to populate a copy of this data set in the background (via background thread?) and once filled to replace master data set with the newly filled dataset. Is there a code example of this that can see? Thanks Regards ...more >>

I have 2 separate DataTables in a DataSet. These tables are in no way related to one anohter with Relations. When I Fill one table, it causes a row's RowState in the other table to change from Unchanged to Modified. In the absence of editing the row! Can anyone think of ways to figure out w...more >>

Anyone, I'm looking for a way to load flat files into a datatable in vb.net (2005) My flat files are tabbed delimited files with the field names on the first row I could dump the data into a sqlserver via DTS and then query against a table, but I'd like to figure out how to go directly fr...more >>

Greetings, I use OleDB from my c# application to populate an excel sheet. I open the connection in a using clause (which automatically close the connection after exit) and the excel file is created. However, I am not able to view excel file before I exit the application. It seems that there i...more >>