raj85
08-27-2013, 08:36 AM
Hi Mates,
I am connecting to Sybase DB using ADODB object and DSN and I have given dropdown to user to select environment to connect (PROD/QA). Sometimes It works for QA perfectly and not for PROD and vice versa.
I am executing a SP to check database access level of user
"sp_helpuser 'test' and pulls record in a recordset.
In case of one environment it works perfectly and pull data and for other it not pulling anything.
I really surprise how this can be possible.
:banghead:
Please help me with this
: pray2:
ConnStr = CStr("DSN=" & DSN & ";Uid=" & .[G2] & ";Pwd=" & .Pass_Text)
End With
CnSrc1.Open ConnStr
Sql = "exec sp_helpuser '" & UID & "'"
Rs1.Open Sql, CnSrc1
I am connecting to Sybase DB using ADODB object and DSN and I have given dropdown to user to select environment to connect (PROD/QA). Sometimes It works for QA perfectly and not for PROD and vice versa.
I am executing a SP to check database access level of user
"sp_helpuser 'test' and pulls record in a recordset.
In case of one environment it works perfectly and pull data and for other it not pulling anything.
I really surprise how this can be possible.
:banghead:
Please help me with this
: pray2:
ConnStr = CStr("DSN=" & DSN & ";Uid=" & .[G2] & ";Pwd=" & .Pass_Text)
End With
CnSrc1.Open ConnStr
Sql = "exec sp_helpuser '" & UID & "'"
Rs1.Open Sql, CnSrc1