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:


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”.


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.



  1. 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

  2. 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

  3. 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

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

  5. 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

  6. 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

  7. 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

  8. 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

  9. 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

  10. 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

  11. 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

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

  13. 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

  14. 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

  15. 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

  16. 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

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

  18. 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

  19. 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

  20. 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

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

  22. 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

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

  24. Get Data Science Certification from top-ranked universities UTM, Malaysia, and IBM.
    data scientist training in malaysia

  25. Why is there a casino in North Korea whether it is unlawful for locals to gamble and even enter one? Almost all of the sellers, pit bosses, and cashiers are mostly Chinese. The higher-ups are mostly hailing from Macau whereas the entry-level positions are crammed with employees from Dandong, China. Understandably, the principle language spoken within the premises is Chinese. The casino is largely a business institution to attract foreigners, 1xbet mostly prosperous Chinese businessmen, to gamble.