Database

check is your server configured for remote connections and is it working locally or not and did you mentioned your dynamic port try this with odbc --> client configurations and assign port number to 1433 and check Best Of Regards, SOFTDEV If you have knowledge, let others light their candles at it

Their is no reason that it will not work , it works , but question here is worked means connectivity or something else ;) Best Of Regards, SOFTDEV If you have knowledge, let others light their candles at it

Take a look at this article[^], it is designed to service the user control but may give you some ideas around the DGV, it uses an XML datasource. Also look into the use of the bindingsource in the article, adds another layer but is quite useful. Remember do NOT allow your users to do inline editing in a list control (DGV, listview). I force the user to a dialog for CRUD, supply a toolstrip with Add/Edit/Delete, double click the grid also does Edit. Pop a dialog with selected or blank record for the add/edit, write back to your data store before closing the dialog and reload the grid on a successful CRUD. This may not suit the purist because there are multiple I/O to the database but it works very well and you can never lost data. Never underestimate the power of human stupidity RAH

Doesn't Access have a wizard that can export to SQL Server as standard? Doesn't work with Oracle, though, since it's SQL Server-specific.

Thank you :) Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/

u r welcomed :) Best Of Regards, SOFTDEV If you have knowledge, let others light their candles at it

I would go with the view approach, a UDF can add a large overhead to a simple query, slowing it right down - much more than you would expect. Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

:confused: Can you post what your database table looks like, and when you want to run this "proces" ie. is it when you update a row? How do you currently update the row? Is there just Old Value and NerwValue in the table? This question has a lot of detail, but is very confusing. As usual, please post what you have so far in the way of code.

Take a look at connectionstrings.com. What you have asked cannot be answered by a simple forum post, you need to do some reading and possibly a specialist site may help, SQLServerCentral.com is very useful. This search of articles[^] turns up some interesting titles as well

Vuyiswa Maseko wrote: The Problem is that the SQL Server is in another Machine and am in my Developement Machine. So the Path is not in the Machine Told you that error doesn't lie! ;P Vuyiswa Maseko wrote: How can i make the second Column as the First one. Because it tries to add records in the identity field and i get the Following Errors Have you tried the documentation on BULK INSERT[^]? The bit you're after is: FORMATFILE = 'format_file_path' The docs say: Specifies the full path of a format file. A format file describes the data file that contains stored responses created by using the bcp utility on the same table or view. The format file should be used if: * The data file contains greater or fewer columns than the table or view.

Well, I posted an entry explaining this yesterday but it seems to have disappeared. Not sure what happened there. I was having a few problems accessing the site yesterday. I can't be bothered writing it all again, but basically you cannot compact a database while it is open. If you want to run the compact from code, you must run it from a different database. Then you can use DBEngine.CompactDatabase, making sure that the data file is closed and is not in use before you do the compact.

Thanks I have done UPDATE TableName SET overtime = overtime-10 WHERE emp_id = 5

Here is the full guide how to do that. :) Life is a stage and we are all actors!

U can do this in SQL server.... Inside the SP itself create the temp table and try to insert like : INSERT INTO #TempYearEndBal exec BLYearEndLeaveTcktBalRep this will work.... But in Oracle,what is the equlent way to do this?...