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 |
techgfx
Starting Member
2 Posts |
Posted - 2008-05-07 : 08:40:23
|
Hi, I'm using some aplications that use ODBC to connect the aplications with the database in a windows 2003 SQL server.The problem is that when the users try to see the reports there is a runtime error. The person who programmed the aplications says that it works prefectly with computers outside the domain using a XP Computer as a server.I wonder if the restrictions that the users have are not allowing them to access the databse and the ODBC without problems.I really could use some help in this matter. Thanks.Thanks in advanced |
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-07 : 15:08:32
|
Do you have error message? |
|
|
techgfx
Starting Member
2 Posts |
Posted - 2008-05-16 : 00:40:08
|
Error MessageMicrosoft SQL Server loginConnection failed:SQLstate: '01000'SQLserver Error: 10054[Microsoft][odbc sql server driver[Tcp/IP sockets]ConnectionRead (recv()).Connection failed:SQL State: '08So1'SQL Server Error: 11[Microsoft][odbc sql server driver][Tcp/IP sockets]General network error. check your network documentation.Thanks in advanced |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2008-05-16 : 10:01:27
|
when you create the odbc entry it has to be system instead of user so the credentials are carried over unless your users have individual logins to the database server--------------------keeping it simple... |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-17 : 17:09:49
|
And ensure tcp/ip is enabled on the server, can also try with other protocol. |
|
|
|
|
|