Wednesday, September 15, 2010

Connecting to your SQL Server Database

If you have AccuSQL and have set up the MS SQL Server database and transferred your database to it, then you are now ready to connect other installations of AccuSQL to this SQL Server database.  This blogs shows you how to do this.

NOTE: The steps are the same whether you are connecting a regular AccuSQL installation to the SQL Serer database or if you are connecting the SQL Computer Lab Plug-in Advanced software. 

These steps assume that you already have completed transferring your database and have an existing AccuSQL database on the SQL Server.  If you have not done this already, then start by checking the “Creating your SQL Server Database” blog.

There are more than one way to connect the AccuSQL or Plugin SQL software its SQL Server database. First lets take a look how to do that using AccuSQL or Plug-in software itself. Here are the steps:

clip_image002

1)  Launch AccuSQL software and log in as a root administrator.

2) In the bottom left area of AccuSQL, click on the Expanded View radio button.

3) Now access the Database --> Database Location screen and click the SQL Server radio button and click the Next button.

4) Select “SQL Server” option and click “Next”.

5) In the Application Share Path area specify a shared network folder that everyone has full access rights (Full control, read, write, modify).

6) In the SQL server connection info area, enter your server name, authentication mode (Windows authentication is preferred but SQL server authentication needs less expertise), and if authentication is SQL server mode your username and password – limited account’s username and password if you opted to create it.

7) In the Database drop-down menu, select the database you created earlier. Tip: After entering server, username, password information click on Database drop down’s ‘down arrow’. If it displays a list populated with your database in it then that verifies that you have a valid connection to the SQL Server database.

8) Now press the Test Connection button. If all is well, you will get a "Test connection succeeded" message. If not, you will get an error message. Verify all the information is correct and retest until you get a success message.

9) Press the Save button and then press Close Form.

10) Now press the main “Exit AccuSQL” button to close the application.

11) When you re-launch AccuSQL, you will be connected to the SQL Server database. Congratulations!

A second way to connect

The second way is easier and faster.

1. Go to your application folder using windows explorer (right click application shortcut, select properties and then “Find target”. In Windows 7 you can also right click and directly select “Open file location”). The application folder is typically “c:\Program Files\AccuSQL”.

2. Locate “SetDataPath.exe” file and run it by double clicking it.

3. You would see the same user interface that you get when you use Database -> Database Location in AccuSQL.

4. Fill in the information as explained above and click “Save”.

clip_image004

Yet a third way to connect!

The third way doesn’t actually create and save the connection information as the previous two above did. Instead it creates an encrypted connection information file in XML format that you can copy and use on multiple computers. This is especially useful to create the connection information on one computer and then deliver it to multiple Plug In computers without manually entering the information for each computer. Here is how you do it:

1) Go to your application folder using windows explorer (right click application shortcut, select properties and then “Find target”. In Windows 7 you can also right click and directly select “Open file location”). The application folder is typically “c:\Program Files\AccuSQL”.

2) Locate “CLDataPath.exe” file and run it by double clicking.

3) You would see the same user interface that you get when you use Database -> Database Location in AccuSQL.

4) Fill in the information and click “Save”.

5) You will see a ‘Save as’ dialog box prefilled with “DbCon.XML”. Change the location if you need to and save. This will create a file named “DBCON.XML”. Important: Do NOT rename that file.

6) Copy this file to a USB stick or network drive which you can access from other computers (you may also want to copy “DbConnector.exe” file from your application folder. This file is normally installed on initial installation and already exists on other computers but you may have a later version on your application folder. It is recommended that you copy and use the one from your application folder).

7) Go to any of the client computers and copy “DbCon.xml” file to application folder (and “DbConnector.exe” as well). Important: Copy the file(s) into application folder and not into any other folder.

8) After the file(s) are copied, double click dbconnector.exe to run it. It would create the necessary

Technorati Tags: ,

registration for connecting to database. You are done. Repeat steps 7 and 8 on other computers.

clip_image006clip_image008

63 comments:

  1. It was nice unblock game . Very informative and expressive .things are easily play online at
    unblocked games 66

    ReplyDelete
  2. Excellent Blog! I would like to thank you for the efforts you have made in writing this post. Gained lots of knowledge.
    Data Analytics Course

    ReplyDelete
  3. Awesome article. I enjoyed reading your articles. this can be really a good scan for me. wanting forward to reading new articles. maintain the nice work!
    Data Science Courses in Bangalore

    ReplyDelete
  4. What an incredible message this is. Truly one of the best posts I have ever seen in my life. Wow, keep it up.
    AI Courses in Bangalore

    ReplyDelete
  5. I have voiced some of the posts on your website now, and I really like your blogging style. I added it to my list of favorite blogging sites and will be back soon ...

    Digital Marketing Training in Bangalore

    ReplyDelete
  6. Wow, happy to see this awesome post. I hope this think help any newbie for their awesome work and by the way thanks for share this awesomeness, i thought this was a pretty interesting read when it comes to this topic. Thank you..
    Artificial Intelligence Course

    ReplyDelete
  7. Truly incredible blog found to be very impressive due to which the learners who go through it will try to explore themselves with the content to develop the skills to an extreme level. Eventually, thanking the blogger to come up with such phenomenal content. Hope you arrive with similar content in the future as well.

    Machine Learning Course in Bangalore

    ReplyDelete
  8. I found Habit to be a transparent site, a social hub that is a conglomerate of buyers and sellers willing to offer digital advice online at a decent cost.

    Artificial Intelligence Training in Bangalore

    ReplyDelete
  9. I am sure it will help many people. Keep up the good work. It's very compelling and I enjoyed browsing the entire blog.
    Business Analytics Course in Bangalore

    ReplyDelete
  10. I need to thank you for this very good read and i have bookmarked to check out new things from your post. Thank you very much for sharing such a useful article and will definitely saved and revisit your site.
    Data Science Course

    ReplyDelete
  11. Your site is truly cool and this is an extraordinary moving article and If it's not too much trouble share more like that. Thank You..
    Digital Marketing Course in Hyderabad

    ReplyDelete
  12. Thank a lot. You have done excellent job. I enjoyed your blog . Nice efforts
    Data Science Certification in Hyderabad

    ReplyDelete
  13. Awesome article. I enjoyed reading your articles. this can be really a good scan for me. wanting forward to reading new articles. maintain the nice work!
    Data Science Courses in Bangalore

    ReplyDelete
  14. I bookmarked your website because this site contains valuable information. I am very satisfied with the quality and the presentation of the articles. Thank you so much for saving great things. I am very grateful for this site.

    Data Science Training in Bangalore

    ReplyDelete
  15. The Extraordinary blog went amazed by the content that they have developed in a very descriptive manner. This type of content surely ensures the participants explore themselves. Hope you deliver the same near the future as well. Gratitude to the blogger for the efforts.

    Machine Learning Course in Bangalore

    ReplyDelete
  16. Thank you for another informative blog. Where else could I get that type of info written in such a perfect approach? I have an undertaking that I’m simply now working on, and I’ve been on the lookout for such information.
    3Movierulz

    ReplyDelete
  17. Nice Post thank you very much for sharing such a useful information and will definitely saved and revisit your site and i have bookmarked to check out new things frm your post.
    Data Science Course

    ReplyDelete
  18. Great post happy to see this. I thought this was a pretty interesting read when it comes to this topic Information. Thanks..
    Artificial Intelligence Course

    ReplyDelete
  19. You have done excellent job Thanks a lot and I enjoyed your blog. Great Post.
    Data Science Certification in Hyderabad

    ReplyDelete
  20. Thanks Your post is so cool and this is an extraordinary moving article and If it's not too much trouble share more like that.
    Digital Marketing Course in Hyderabad

    ReplyDelete
  21. I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it.
    Data Analytics Course

    ReplyDelete

  22. I am really enjoying reading your well written articles. I am looking forward to reading new articles. Keep up the good work.
    Data Science Courses in Bangalore

    ReplyDelete
  23. A good blog always contains new and exciting information, and reading it I feel like this blog really has all of these qualities that make it a blog.

    Artificial Intelligence Training in Bangalore

    ReplyDelete
  24. It is late to find this act. At least one should be familiar with the fact that such events exist. I agree with your blog and will come back to inspect it further in the future, so keep your performance going.

    Digital Marketing Training in Bangalore

    ReplyDelete
  25. What an incredible message this is. Truly one of the best posts I have ever seen in my life. Wow, keep it up.
    AI Courses in Bangalore

    ReplyDelete
  26. A good blog always contains new and exciting information and as I read it I felt that this blog really has all of these qualities that make a blog.

    Data Science Training in Bangalore

    ReplyDelete
  27. I am sure it will help many people. Keep up the good work. It's very compelling and I enjoyed browsing the entire blog.
    Business Analytics Course in Bangalore

    ReplyDelete
  28. I am more curious to take an interest in some of them. I hope you will provide more information on these topics in your next articles.

    Machine Learning Course in Bangalore

    ReplyDelete
  29. It is a very helpful and very informative blog. I really learned a lot from it thanks for sharing.
    Data Analytics Course

    ReplyDelete
  30. I wanted to leave a little comment to support you and wish you the best of luck. We wish you the best of luck in all of your blogging endeavors.

    Data Science Training in Bangalore

    ReplyDelete
  31. Very good article and liked reading your post, very pleasant to share, I want to tweet this to my followers. Thank you!.
    Digital Marketing Institute in Hyderabad

    ReplyDelete
  32. I really enjoyed reading this post and keep up the good work and let me know when you can post more articles or where I can find out more on the topic.
    Data Science Online Course

    ReplyDelete
  33. Really this article is truly one of the best in article history and am a collector of old "items" and sometimes read new items if i find them interesting which is one that I found quite fascinating and should be part of my collection. Very good work!
    Data Scientist Course in Gurgaon

    ReplyDelete
  34. A good blog always contains new and exciting information, and reading it I feel like this blog really has all of these qualities that make it a blog.

    Data Science Course in Nagpur

    ReplyDelete
  35. I read your excellent post. It's a great job. I enjoyed reading your post for the first time. I want to thank you for this publication. Thank you...

    Data Analytics Course in Patna

    ReplyDelete
  36. Very interesting blog and lot of the blogs we see these days don't provide anything that interests me but i am really interested in this one just thought I would post and let you know.
    Data Science Training Institute in Noida

    ReplyDelete
  37. Very great post which I really enjoy reading this and it is not everyday that I have the possibility to see something like this. Thank You.
    Best Online Data Science Courses

    ReplyDelete
  38. Very informative Blog! There is so much information here that can help thank you for sharing.
    Data Analytics Training in Bangalore

    ReplyDelete
  39. Well done for this excellent article. and really enjoyed reading this article today it might be one of the best articles I have read so far and please keep this work of the same quality.
    Data Analytics Course in Noida

    ReplyDelete
  40. Very useful message. This is my first time visiting here. I found a lot of interesting things on your blog, especially your discussion. It really is a great article. Keep on going.

    Data Analytics Course in Ernakulam

    ReplyDelete
  41. Excellent work done by you once again here and this is just the reason why I’ve always liked your work with amazing writing skills and you display them in every article. Keep it going!
    Data Analytics Courses in Hyderabad

    ReplyDelete
  42. This is really nice which is really cool blog and you have really helped a lot of people who visit the blog and give them useful information.
    Data Science Training in Noida

    ReplyDelete
  43. I think this is an informative and very useful and knowledgeable blog. therefore, I would like to thank you for your effort.
    Data Science Course in Amritsar

    ReplyDelete
  44. Just a shine from you here and have never expected anything less from you and have not disappointed me at all which i guess you will continue the quality work. Great post.
    Data Science Training in Gurgaon

    ReplyDelete
  45. This is a great inspiring blog.You have shared really very helpful information thank you.
    Data Scientist Course in Amritsar

    ReplyDelete
  46. Nice post, you give readers a lot to think about and I appreciate that kind of writing.
    Data Science Course Fees

    ReplyDelete
  47. I read your excellent blog post. It's a great job. I enjoyed reading your post for the first time, thank you.
    Data Science Institutes in Bangalore

    ReplyDelete
  48. Excellent post to make this blog more wonderful, attractive and cool stuff you have. Thank You.
    Data Science Course in India with Placements

    ReplyDelete
  49. This is an informative and knowledgeable article. therefore, I would like to thank you for your effort in writing this article.
    Data Scientist Course in Chandigarh

    ReplyDelete
  50. Wonderful illustrated information. Thank you. It will certainly be very useful for my future projects. I would love to see more articles on the same topic!

    Data Science Training in Bangalore

    ReplyDelete
  51. Thanks for such a great post and the review, I am totally impressed! Keep stuff like this coming.
    Mlops Course

    ReplyDelete
  52. Good blog and absolutely exceptional. You can do a lot better, but I still say it's perfect. Keep doing your best.

    Data Science Training in Nagpur

    ReplyDelete
  53. You have done a great job and will definitely dig it and personally recommend to my friends. Thank You.
    Data Science Online Training

    ReplyDelete
  54. I just got to this amazing site not long ago was actually captured with the piece of resources you have got here and big thumbs up for making such wonderful blog page!
    Data Scientist Course

    ReplyDelete
  55. I was very happy to find this site. I wanted to thank you for this excellent reading !! I really enjoy every part and have bookmarked you to see the new things you post.

    Data Science Course in Durgapur

    ReplyDelete
  56. Very educating blog, got lot of information thank you.
    Data Scientist Course in Amritsar

    ReplyDelete
  57. So luck to come across your excellent blog, glad i found it. Keep posting new articles. Good luck.
    Data Science Course Details

    ReplyDelete
  58. It was a wonderful opportunity to visit this type of site and I am happy to hear about it. Thank you very much for giving us the opportunity to have this opportunity.

    Data Analytics Course in Durgapur

    ReplyDelete
  59. Happy to chat on your blog, I feel like I can't wait to read more reliable posts and think we all want to thank many blog posts to share with us.

    Data Science in Bangalore

    ReplyDelete
  60. Embark on a journey to achieve your professional goals by enrolling in the Data Scientist course in Bangalore. Learn the skills of collecting, extracting, analyzing, preparing, visualizing, and presenting results to make valuable decisions. Master the concepts of data science through hands-on projects and case studies to learn the latest trends and skills in this field.
    Data Science Course in Calicut

    ReplyDelete
  61. The new wave of innovation that is changing the way people do business is called data science. Gain expertise in organizing, sorting, and transforming data to uncover hidden patterns Learn the essential skills of probability, statistics, and machine learning along with the techniques to break your data into a simpler format to derive meaningful information. Enroll in Data science in Bangalore and give yourself a chance to power your career to greater heights.
    Data Science Training in Bangalore

    ReplyDelete
  62. Acquire a firm grounding in the theory of Data Science by signing up for the Data Science courses in Bangalore. Master the relevant skills along with all the essential tools and techniques of Data Science. Get to avail benefits like Flexible timings, Best industry trainers, and a meticulously crafted curriculum with hands-on projects that will give you exposure to a real-world working environment.
    Best Data Science Training in Bangalore

    ReplyDelete
  63. Learn the fundamentals of Data Science and master the skills to handle epic amounts of data collected by organizations today. Gain expertise in organizing, analyzing, and transforming data to uncover its hidden power. Drive your career forward with a Data Science course in Bangalore and learn to uncover insights to present critical findings using visualization tools. Not only this, avail the best-in-class content delivered by stellar faculty who use a blended approach of theory as well as practical knowledge to ensure all the concepts are crystal clear.

    Best Data Science Institute in Bangalore

    ReplyDelete