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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-15 : 07:29:38
|
| nandan writes "how can i connect a remote sql server through vb and my perfomance should not effect as many users are working.My server is located in different state.reply soon" |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-08-15 : 07:40:17
|
| First of all, can you create a DSN for the server from Control Panel --> Administrative Tools --> Data Sources (ODBC)If you can successfully connect from here, then all you need to do is reference your new DSN from your VB app. |
 |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-08-15 : 08:57:37
|
| Think about Replication. A DSN across state lines?====================================================Regards,Sean RoussyThank you, drive through |
|
|
|
|
|
|
connecting remote server