SambaPOS Forum

English Boards => Tutorials => Topic started by: ericrevollo on January 26, 2013, 11:31:45 pm

Title: How I connected a client with SQL
Post by: ericrevollo on January 26, 2013, 11:31:45 pm

After  many hours of frustration following all the instructions about connecting a client trough SQL Express, and after much google, I finally managed to get it working,  I will explain now, but first I’ll assume you already have installed SQL EXPRESS on your computer, I use version 2005 because my PC doesn’t support higher versions,  please see if it works on other versions.
OK Let’s go to business! Please follow these steps, that's what I did!

1.- follow the instructions on this tutorial I made, I aplogize for the quality:D:
http://ericrevollo.hostei.com/uploads/SAMBA/sambawork.htm (http://ericrevollo.hostei.com/uploads/SAMBA/sambawork.htm)

2.- go to this site and follow all the steps mentioned:
http://faq.instant-tech.com/2009/09/sql-express-will-not-accept-remote.html  (http://faq.instant-tech.com/2009/09/sql-express-will-not-accept-remote.html)(you may need to use the arrow keys for scrolling)

I really hope this can help you if you have questions I'll try to help, but please remember I know nothing about that SQL thing, it was just a matter of investigating on the net and playing arround with the programs good luck!!!

Title: Re: How I connected a client with SQL
Post by: Isaac on June 29, 2013, 09:21:54 am

Thanks dude

Great illustration, worked for me.

Title: Re: How I connected a client with SQL
Post by: Stelzi79 on July 24, 2013, 11:25:33 pm

First I think you have to install the Management Studio to the corresponding SQL-Version. As I know the Management Studio isn't normaly in an express version and hast be installed seperatly. Here I found a HowTo on the 2012 SQL http://en.competence.prevero.com/index.php?title=Microsoft_SQL_Server_2012_Management_Studio_Express (http://en.competence.prevero.com/index.php?title=Microsoft_SQL_Server_2012_Management_Studio_Express)

For more "simple" works or forensics I use a neat little thing called LinqPad (http://www.linqpad.net/ (http://www.linqpad.net/) ) which also connects to sdf or mdb and to the SQL CD-Servers out of the box. In there you can lookup and alter things in the Database with C#, SQL and other languages. Also a neat little thing to quickly test programmcode.

Title: Re: How I connected a client with SQL
Post by: JohnS on July 25, 2013, 12:08:04 pm

Did anyone have a look here (http://forum2.sambapos.org/index.php/topic,461.msg2577.html#msg2577)?