flfmmqp
asked on
Permissions Issue?
We are using some DSN connections to retrieve and post data to our SQL database. We recently switched servers and have been having major issues. The server is 2003 R1 and the SQL is 10.0.5500 which I believe is 2008 SP3
We are getting this error:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
Our company switched to using Windows 7 boxes and it seems like off and on we keeping having issues with permissions. We had programs working 3 days ago and suddenly they are not working. Programs we have not touched in months. One in years.
It can be in applications or a web page like below. Always erroring out on the DSN connection.
strConnectString = "DSN=AR;UID=user_name;PWD= password;D atabase=AR "
if not IsObject("ojbConnection") then
set objConnection=Server.Creat eObject("A DODB.Conne ction")
objConnection.ConnectionTi meout = 15
objConnection.CommandTimeo ut = 10
objConnection.Mode = 3 'adModeReadWrite
if objConnection.state = 0 then
objConnection.Open strConnectString
end if
end if
HELP!!! Anyone have any suggestions?
We are getting this error:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
Our company switched to using Windows 7 boxes and it seems like off and on we keeping having issues with permissions. We had programs working 3 days ago and suddenly they are not working. Programs we have not touched in months. One in years.
It can be in applications or a web page like below. Always erroring out on the DSN connection.
strConnectString = "DSN=AR;UID=user_name;PWD=
if not IsObject("ojbConnection") then
set objConnection=Server.Creat
objConnection.ConnectionTi
objConnection.CommandTimeo
objConnection.Mode = 3 'adModeReadWrite
if objConnection.state = 0 then
objConnection.Open strConnectString
end if
end if
HELP!!! Anyone have any suggestions?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for trying to help. I do appreciate it and am happy to give the points just for trying to help me. Thanks.
Thx,
(In future) You can also accept your own solution (without points) and the others as assisted. It's more clear what the real solution was for people who come across this question.
(In future) You can also accept your own solution (without points) and the others as assisted. It's more clear what the real solution was for people who come across this question.
ASKER