Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. swetab

    Set girdview.EditIndex to last row

    Jason you are absolutely correct with set the edit index before binding the grid. Thanks for looking into my thread and responding so quickly I appreciate for looking deeper into my code and suggesting valuable technique.
  2. swetab

    Set girdview.EditIndex to last row

    Hi, On button click I set the editindex, it doesn't apply when I click the button again it shows the row set in the edit mode why? I have grid view and a button "Add" control on aspx page and when I new is clicked I need to add the set the editindex of the grid to last column: this is what I...
  3. swetab

    DTS:Transform Data task destination connection not updating at runtime

    Hi, I am using DTS which has Dynamic properties, Transform data task to migrate data between table (7 tables) from source to destination sql server, and global variables which will set my source and destination SQL server name and database. While developing the source and destination server...
  4. swetab

    DTS- Data transfer from Multiple tables between database

    I didn't get your reply clearly. I have created a DTS package which holds sql connection and Transform data task links for each table that needs to be transfered. Are you saying what I am doing is best approach? Or is there something I am missing. Thanks
  5. swetab

    DTS- Data transfer from Multiple tables between database

    Hi, I need the best approach that is suitable to transfer the data from multiple tables between SQl server databases. All I am doing now is using "Tranform Data Task" in between the two sql server connections for each table.And adding Transform data task link everytime for each table. Is...
  6. swetab

    Windows login username and password problem

    Hi, first thing i did was in .net application set <identity impersonate="true" /> and developer here had given wrong line of code and it worked after commenting it out xmlHttp.setrequestheader("Connection","Close"); See if connections are getting closed any where abruptly. Check from your...
  7. swetab

    Windows login username and password problem

    Hello, The web application created in .net works fine on windows xp system. But when published and setup on windows 2003 system, The first few pages, which does basic select from the database -SQL server works fine. When you want to do some save, delete operation on the same page it requests...
  8. swetab

    Windows authentication and database role

    I found something, when a user is given db_datareader permission, it was erroring out when executing the stored procedures, so from sql server EM I gave the user exec permissions and the application ran succesfully. Thanks
  9. swetab

    Windows authentication and database role

    I am using conObj.CursorLocation = adUseServer, I think this is causing the problem, just read that "adUserServer property is read/write on a Connection." And as u said I will use readonly for locktype and try and execute it at the client side. Thanks
  10. swetab

    Windows authentication and database role

    I am sorry, i posted the error message wrongly Error : "Invalid procedure call or argument." I tested the .udl file connection was succesful.
  11. swetab

    Windows authentication and database role

    Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=test; Data Source=k36; Hello I have created a exe in vb6.0 using the above connection string, Users can access the application only by windows authentication. In SQL server 2000 i gave the access to a windows user with db_datareader...
  12. swetab

    VB Data report Error :713, application defined or object defined error

    When I run the exe on other computer, I get this error Runtime error 713 Application-defined or object-defined error. When I do the package and deploy the same on other computers it works perfectly fine. But my client does not want package, and needs a EXE only. So I started registering all...
  13. swetab

    how to get previous page url from current web page

    hi, What is the alternative for this, to store in hidden variable and passing the value to next page, so then i have the back url value? Let me know if there is any other way. Thanks
  14. swetab

    how to get previous page url from current web page

    Hi I used this and return be nothing.. in the alert basically blank. I have a page 1.htm after clicking a button it takes me to 2.htm and the code for 2.htm is as follows <html> <body> <form> <input type="button" value="submit" onclick="javascript:alert(document.referrer);" > </form> </body>...
  15. swetab

    how to get previous page url from current web page

    Hi, I need the url of the previous web page from the current webpage. History.back and history.go actually send u to previous page, butI just need the URL of the previous page from the current web page. Thanks
  16. swetab

    insert data from another SQL server database

    I tested inserting data record from one SQL server (SERVER_A) to another SQL server_B with Transactions Both being Windows server 2000. It works perfect with < 1 sec. All that i had to give is "set xact_abort on" Next on windows server 2003 cluster I will try configuring and enabling the MS...
  17. swetab

    insert data from another SQL server database

    Here is details: I am trying to insert a single record from one SQL server (SERVER_A) to another SQL server_B with Transactions The environment is as follows: Server_A Windows 2000, SQL server 2000 SERver_B Windows 2003 enterprise edition , sql server 2000 Question:Should I enable the network...
  18. swetab

    How to set output Global Variable in a SQL Task and read it from Activ

    How to set output parameter value for Global Variable in a SQL Task and read it from ActiveX script DECLARE @ErrOutputMsg varchar(50) exec SE_LOAD @ErrOutputMsg OUTPUT Select @ErrOutputMsg AS OutTest Then I go to Parameters- Output parameter - select Row value - pass this output parameter to...
  19. swetab

    Need to use wildcard while using &lt;= and &gt;=

    You can try this WHERE (EM_PAYROLL_UNIT >= '[0-9][0-9][0-9][0-9]') AND (EM_PAYROLL_UNIT <= '[A-Z][0-9][0-9][0-9]') I am not sure is this is what you are looking at. Good luck
  20. swetab

    insert data from another SQL server database

    Hello, I wanted to update that I found y its was not completeing the execution when I run the stored procdure Because I had Transactions in the stored procedure. Once i commented all the transaction lines its working fine now. I am able to copy the data from source to destination server...

Part and Inventory Search

Back
Top