11/22/2024 9:55:45 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss the use of .NET Extensions in SalesLogix version 7 and higher. View the code of conduct for posting guidelines.
|
|
|
|
"Security Access Failure" message in SLX 7 using .Net Application
Posted: 05 Apr 07 4:03 PM
|
fiogf49gjkf0d Hi All,
I'm working on vb.net with SLX v7 project which will insert record into custom table in SLX Database.
I created username "temp" with "pass" password
Temp username needs to insert record into database. But when I try to save data my application gives this message.
"Security Access Failure"
"Connection limited to read only queries"
Temp username is able to view data; I can successfully log into my .Net application and can view data in a DataGrid as well. But I can't save it. 
if I use Admin username, I can save data successfully though. I realize it should be something very simple but if oyu could share your ideas and experience I really appreciate
Thanks
Irakli |
|
|
|
Re: "Security Access Failure" message in SLX 7 using .Net Application
Posted: 05 Apr 07 5:15 PM
|
| It could be that the user only has read access to the record in question. Is the table account-based, stand alone, etc? Are you grabbing the connection (or connection string) from the exposed SlxApplication object in the extension, or creating your own connection string to the database (in which case the database might have a RW password which you're not supplying in the connection string) |
|
|
|
Re: "Security Access Failure" message in SLX 7 using .Net Application
Posted: 05 Apr 07 9:08 PM
|
fiogf49gjkf0d Ryan,
Thanks for your reply.
This table is stand alone, it is equipment table and the third party application should be able to insert a record into this table. Well as I said, I can insert a record if I log into this application using Admin username.
------------------------------------------------------------------------------------------
Here is the connection string that I use:
"Provider=SLXOLEDB.1; Password="Pass"; Persist Security Info=True;" & _
"User ID="Temp";Initial Catalog="SLXDB";Data Source="127.0.0.1";" & _
"Extended Properties=PORT=1706;LOG=ON;"
------------------------------------------------------------------------------------------
Here is some code from "connection" sub:
Dim objCon As New System.Data.OleDb.OleDbConnection
objCon.ConnectionString = AppMgr.ConnectionString 'Above connection string is used!
objCon.Open()
-----------------------------------------------------------------------------------------
Here is Save data Sub:
Dim NewIDVal = NewID("Table")
Try
Dim strSQL As String = "INSERT INTO mytable" & _
"(ID,SerialN, Name, Type) " & _
" VALUES (?,?,?,?)"
objData = New DataCommand(AppMgr.ConnectionString)
objData.AddParam(NewID("Table"))
objData.AddParam(ID.text)
objData.AddParam(SerialN.Text)
objData.AddParam(Name.Text)
objData.AddParam(Type.Text)
objData.AddParam(TXT_RentRate.Text)
objData.ExecuteSQL(strSQL)
SaveData = (objData.RecordsAffected > 0)
objData = Nothing
MessageBox.Show("Data Saved")
Catch ex As Exception
MessageBox.Show(ex.Message)
MessageBox.Show("Not Saved")
End Try
--------------------------------------------------------------------
Ryan, Do you think I miss something in connection string?!
Thanks again
Irakli
|
|
|
| |
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|