Windows Form - Can i use SQL ODBC connector

Question

I just finished deploying my Windows Desktop application ( with database ) on Server machine but i want to ask a question. For Client machine installation, How can i use SQL ODBC connector for connecting all my 3 Clients machines to use the Server database on the LAN network. Thanks in anticipation

Salman Beg · Answer

If you have a connection string then that can be used by multiple applications. Thanks

imole ayo · Answer

Some said i can use microsoft sql ODBC ....but i don't know how....that was why i posted the question

imole ayo · Answer

i googled and read that on multiple machines.... i need to include the IP Address of the first laptop-A (where the sqlserver resides or lives) in my connection string ....So that those multiple machines laptop-B,C,D can connect to my first laptop-A sqlserverso that any CRUD operation (from multiple client machine having my application setup installed in them) will reflect and sync in the First machine Database...That is what i want to achieve , that data syncing from multiple PCs on my server that is serving them. Thanks once more for giving your time : )

imole ayo · Answer

Yeah sure. Thanks...actually am in a LAN network...and you will agree with me that - sqlserver instance name are different for different laptops ....so while developing and deploying that windows app on my laptop-A..... my laptop-A name ( or sqlserver instance name ) was HP-PC so i included it in my connection string (in development)...but am deploying it to multiple client pc now eg laptop-B,C,D etc....

Salman Beg · Answer

If you did then install your application on multiple machine. If you set the connection string properly then it should work perfectly. Thanks.

imole ayo · Answer

@Salman Beg thank you so much for replying ....but i want you to know i have all my data in sql server already ( all my data are in one place ) .....i have deployed my windows app with the sqlserver connection string .......What i want to achieve now is to install my application on multiple machines and i want all those machines to successfully run my application using my first connection string

Salman Beg · Answer

In place of odbc you can use sql server where all the table and data will be in one place and you need to use just connection string of that server and use in your application. But for odbc you need to install software in client machine then that is a very hectic process. Thanks

Windows Form - Can i use SQL ODBC connector

Answers (7)