Hi,
I need to connect to a eEnterprise DB from a VB application. However, for some reason, I can only seem to get into the DB using 'sa'. Are there special security rules outside of the normal SQL security, that is built into the the DB? Also, what permissions must a user have to execute a stored procedure in the eEnterprise DB?
- First I connect to Dynamics using the ODBC thats linked to master.
strConn = "DSN=" & cmbServer.Text & ";database=DYNAMICS;UID=" & txtUID.Text & ";PWD=" & txtPW.Text & ";"
- Then I pull up available companies for that user.
rDB.Open "SELECT CMPNYNAM ,INTERID FROM DYNAMICS.dbo.SY01500 where CMPANYID IN (SELECT CMPANYID FROM DYNAMICS.dbo.SY60100 WHERE USERID = '" & txtUID.Text & "')", cDB
--I don't know eEnterprise so I am blindly building this app in VB...
Anyone that knows VB or C and eEnterprise? I would appreciate any ideas..
Thanks,
MDA
I need to connect to a eEnterprise DB from a VB application. However, for some reason, I can only seem to get into the DB using 'sa'. Are there special security rules outside of the normal SQL security, that is built into the the DB? Also, what permissions must a user have to execute a stored procedure in the eEnterprise DB?
- First I connect to Dynamics using the ODBC thats linked to master.
strConn = "DSN=" & cmbServer.Text & ";database=DYNAMICS;UID=" & txtUID.Text & ";PWD=" & txtPW.Text & ";"
- Then I pull up available companies for that user.
rDB.Open "SELECT CMPNYNAM ,INTERID FROM DYNAMICS.dbo.SY01500 where CMPANYID IN (SELECT CMPANYID FROM DYNAMICS.dbo.SY60100 WHERE USERID = '" & txtUID.Text & "')", cDB
--I don't know eEnterprise so I am blindly building this app in VB...
Anyone that knows VB or C and eEnterprise? I would appreciate any ideas..
Thanks,
MDA