Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
drh3010
Starting Member
18 Posts |
 Posted - 2007-09-12 : 18:37:45
|
| Another newbie question...I've got SQL Server Express installed on a server. Now I need to provide a method for the clients to know where the server is.When using Access, I launched a dialog and the user navigated to the mdb file on the server. It worked fine.It seems using SQL Server I just need them to select a computer to connect to. Or can it happen silently? |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2007-09-12 : 18:41:22
|
| Yes, it can happen silently if you can use linked odbc tables in which case you define the odbc connection to the sql instance. use an access adp and connect the project to a sql server database use ado and point the connection string at the sql server database.PS: If anyone is interested in a SQL Job in Connecticut with excellent pay please send me a resume to ValterBorges@msn.com |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-12 : 21:58:09
|
| Create sql login for use and tell user what sql instance name is. |
|
|
|
|
|
|
How to connect the client to server on a LAN?