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
registration for connecting to database. You are done. Repeat steps 7 and 8 on other computers.
It was nice unblock game . Very informative and expressive .things are easily play online at
ReplyDeleteunblocked games 66
Excellent Blog! I would like to thank you for the efforts you have made in writing this post. Gained lots of knowledge.
ReplyDeleteData Analytics Course
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 ...
ReplyDeleteDigital Marketing Training in Bangalore
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..
ReplyDeleteArtificial Intelligence Course
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.
ReplyDeleteMachine Learning Course in Bangalore
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.
ReplyDeleteArtificial Intelligence Training in Bangalore
I am sure it will help many people. Keep up the good work. It's very compelling and I enjoyed browsing the entire blog.
ReplyDeleteBusiness Analytics Course in Bangalore
Thank a lot. You have done excellent job. I enjoyed your blog . Nice efforts
ReplyDeleteData Science Certification in Hyderabad
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!
ReplyDeleteData Science Courses in Bangalore
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.
ReplyDeleteData Science Training in Bangalore
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.
ReplyDeleteMachine Learning Course in Bangalore
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.
ReplyDelete3Movierulz
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.
ReplyDeleteData Science Course
Great post happy to see this. I thought this was a pretty interesting read when it comes to this topic Information. Thanks..
ReplyDeleteArtificial Intelligence Course
You have done excellent job Thanks a lot and I enjoyed your blog. Great Post.
ReplyDeleteData Science Certification in Hyderabad
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.
ReplyDeleteDigital Marketing Course in Hyderabad
I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it.
ReplyDeleteData Analytics Course
ReplyDeleteI 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
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.
ReplyDeleteArtificial Intelligence Training in Bangalore
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.
ReplyDeleteDigital Marketing Training in Bangalore
What an incredible message this is. Truly one of the best posts I have ever seen in my life. Wow, keep it up.
ReplyDeleteAI Courses in Bangalore
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.
ReplyDeleteData Science Training in Bangalore
I am sure it will help many people. Keep up the good work. It's very compelling and I enjoyed browsing the entire blog.
ReplyDeleteBusiness Analytics Course in Bangalore
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.
ReplyDeleteMachine Learning Course in Bangalore
It is a very helpful and very informative blog. I really learned a lot from it thanks for sharing.
ReplyDeleteData Analytics Course
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.
ReplyDeleteData Science Training in Bangalore
Very good article and liked reading your post, very pleasant to share, I want to tweet this to my followers. Thank you!.
ReplyDeleteDigital Marketing Institute in Hyderabad
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.
ReplyDeleteData Science Online Course
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!
ReplyDeleteData Scientist Course in Gurgaon
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.
ReplyDeleteData Science Course in Nagpur
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...
ReplyDeleteData Analytics Course in Patna
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.
ReplyDeleteData Science Training Institute in Noida
Very informative Blog! There is so much information here that can help thank you for sharing.
ReplyDeleteData Analytics Training in Bangalore
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.
ReplyDeleteData Analytics Course in Noida
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.
ReplyDeleteData Analytics Course in Ernakulam
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!
ReplyDeleteData Analytics Courses in Hyderabad
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.
ReplyDeleteData Science Training in Noida
I think this is an informative and very useful and knowledgeable blog. therefore, I would like to thank you for your effort.
ReplyDeleteData Science Course in Amritsar
Nice post, you give readers a lot to think about and I appreciate that kind of writing.
ReplyDeleteData Science Course Fees
Excellent post to make this blog more wonderful, attractive and cool stuff you have. Thank You.
ReplyDeleteData Science Course in India with Placements
This is an informative and knowledgeable article. therefore, I would like to thank you for your effort in writing this article.
ReplyDeleteData Scientist Course in Chandigarh
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!
ReplyDeleteData Science Training in Bangalore
Thanks for such a great post and the review, I am totally impressed! Keep stuff like this coming.
ReplyDeleteMlops Course
Good blog and absolutely exceptional. You can do a lot better, but I still say it's perfect. Keep doing your best.
ReplyDeleteData Science Training in Nagpur
You have done a great job and will definitely dig it and personally recommend to my friends. Thank You.
ReplyDeleteData Science Online Training
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!
ReplyDeleteData Scientist Course
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.
ReplyDeleteData Science Course in Durgapur
Very educating blog, got lot of information thank you.
ReplyDeleteData Scientist Course in Amritsar
So luck to come across your excellent blog, glad i found it. Keep posting new articles. Good luck.
ReplyDeleteData Science Course Details
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.
ReplyDeleteData Science in Bangalore
Get Data Science Certification from top-ranked universities UTM, Malaysia, and IBM.
ReplyDeletedata scientist training in malaysia
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.
ReplyDelete나주출장샵
ReplyDelete나주출장샵
영동출장샵
경남출장샵
경남출장샵
목포출장샵
증평출장샵
고고출장안마
ReplyDelete고창출장안마
남원출장안마
남원출장안마
서울출장안마
서울출장안마
부안출장안마