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 |
|
rpc86
Posting Yak Master
200 Posts |
 Posted - 2005-11-08 : 02:49:59
|
| Hi guys,Got a problem on the VB6 program we created. This is the first time we encountered such message "Cannot connect to SQL Server". The user can log-in, update, insert, delete and view records. But in other selected modules the message is prompting. There was no problem like this before. We tried to restart the PC and the server but same problem persists. Other users do not have this kind of error.What suppose to be the problem here?Thanks. |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-08 : 03:17:00
|
| Sounds like the "other selected modules" are using a different database-connection object, and its wrongly formed somewhere along the lineKristen |
 |
|
|
rpc86
Posting Yak Master
200 Posts |
Posted - 2005-11-08 : 03:20:56
|
| Thanks,But why other users do not encounter this? We opened the same module or report with the other users that have the problem and the message does not appear on the others. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-08 : 03:41:52
|
| "Other users do not have this kind of error"Sorry, missed that in your original post.Sounds like the permissions are different. Do some of the connections use Trusted Connection / Windows Authentication and others user SQL Login? If so maybe the permissions for the users via each route are different?Kristen |
|
|
|
rpc86
Posting Yak Master
200 Posts |
Posted - 2005-11-08 : 03:46:26
|
| All users have the same permissions. Just what I have said before, there was no error like this yesterday. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-11-09 : 02:31:04
|
| are they using the same program version? connections?identical?--------------------keeping it simple... |
|
|
|
|
|
|
Cannot connect to SQL Server