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 - 2002-10-03 : 09:48:37
|
| Puneet writes "I am trying to connect to SQL Server from the client machine(Where SQL Server is not installed) over the web by opening a recordset in visual basic. It works fine on some machines and it is unable to connect to the SQL Server on some machines. I am not able to debug this problem. Can anyone help me out. I will be thankful to you.Waiting for a reply...." |
|
|
solart
Posting Yak Master
148 Posts |
Posted - 2002-10-03 : 14:14:49
|
| This is not really my area. But will share some thoughts with you.I assume the application has a connection string. Does this connection string require a DSN (Data Source Name) definition on the client machine?I assume the application require a connection path, such as ODBC or Ole DB. Is there a connection path on the client machine?Hopefully, you will get a reply from someone who knows their stuff in this area!!!! |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-10-03 : 14:18:44
|
| The machines that are not working, did you install the right version of MDAC (or any version) on them?Where are you storing your connection string? Registry? DSN?Are you using SQL Authentication or Intergrated security?Are you using TCP/IP or Named Pipes?What operating system are the client PC's?What version of IE are they running?Do they have MDAC installed? What version?Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
|
|
|
SQL Server Connectivity Problem