SQL Server Application Role Not Working In App
Oct 7, 2009
This desktop app written in VB.Net within VStudio 2008 fails when one of our "power users" tries to run the program: Select permission denied on object 'AcctLogon', database 'MDS', owner 'dbo'. The author of the app is out for a few weeks and I am the "fixer" while she's out. Both of our logins for SQL have permissions for db_owner in the MDS database but our user does not. The user has a Windows user login for this instance of SQL. This login has permissions for the public role only in the MDS database.
[Code]...
View 1 Replies
ADVERTISEMENT
Aug 18, 2009
I wish to implement some role based security in my application. Has anyone got any links with some usefull info on this subject.
View 2 Replies
Oct 4, 2010
i already create new connectionstring in app.config that point to myDB i already create aspnet membership table in myDB using aspnet_regsql i already create new custom provider and set the connection string there.. what i like to ask:
1. why when the app start, it create new folder app_data which contain aspnetDB.mdf eventhough i already create new connection string ?
2. why when i'm using Membership.CreateUser method, it succesfully inserted in myDB.aspnet_Users table but when i'm using Roles.CreateRole method it doesn't inserted in myDB.aspnet_Roles table?
PS: i'm using .net 4.0, sql2008, vs2010
View 9 Replies
Apr 1, 2009
In the .NET world, what application has replaced the role that SourceSafe used to provide in Visual Studio 6?
View 23 Replies
Sep 30, 2009
I'm trying to get a VB2008 multi thread application working that connects to a local server program using sockets. Server requests for this particular system can be more quickly handled by a number of connections, so I've written some code to run any number of data request threads that I choose. The problem that I'm having is that the data returned from the server is getting mixed up and is often returned to a different thread/socket than the one that requested it. Other than that, it seems to work okay. If I use just one thread, then the system works as it should. Pls. see incuded code, which is heavily edited to remove all the other fruit salad. Is there any way to set up the sockets so that data returned to the socket/thread that requested it?
Module StaticDeclarations
Public WithEvents g_SD As New SocketDataClass(New MainThread.MTCallback(AddressOf MainThread.MTResultCallbackSub))
Public WithEvents g_MT As New MainThread(New SocketDataClass.SDCallback(AddressOf SocketDataClass.SDThreadResultCallbackSub))
[code]....
View 4 Replies
Jan 19, 2012
I'm using loop to read data from sql and then make some calculations then save it again to another table but when application loop for 3 or 4 times it's freeze but the job is done but if loop = 10 or more then it is freeze and hangup for long time .i need to learn how to make my application working better and never freeze and make application working with any count for loop without freeze .
View 7 Replies
May 29, 2012
I have an application I have developed which works great on individual PC's. However I've had some interest from a few customers that asked if I have a network version for site licencing.If my app did not save any data or write any reg entries, this might have been ok. But it does to the local computer. I also built in my own copy protection and trial function that stores data in the registry on the local computer.What would I need to do to enable my application to run on a server/network share, so that the only a serial number needed is for the server?
View 3 Replies
Aug 11, 2010
i'm tying to send email in my application directly by the smtp server but the server doesn't allow me to do that.The application its used by everyone in the company, so i set the smtp client UseDefaultCredentials to True, but the server replies with this when i try to send an email:[code].....If i set the credentials by hand, the server sends the email. So my problem is how to make this work to everyone? I don't want to have one public/friend var all time in the application with the credentials of the current user?
View 9 Replies
Apr 6, 2012
Case : I'm creating an application (desktop application) with VB.NET (actually windows form), and using SQL Server Express 2008 for its database.
[Code]...
View 1 Replies
Jun 4, 2008
I need to read the email from the mail server that is in my intranet from my application server.
View 9 Replies
Feb 10, 2010
I planing to develop an application which can connect any remote server and pick the configuration information from server and show it in my desktop.
View 4 Replies
Sep 3, 2009
An application loaded on a citrix server executes with no problem. When we try to run the same program files on a virtual server, we get silent errors and we do not even see the application window appear. The program runs for a moment in task manager, but then closes down. BTW other .net apps run on the virtual server. Here is the error we see in the event viewer application logs[code]...
View 2 Replies
Oct 6, 2011
I using vb.net 2010 and sql server management express 2008. bu I little confused what is wrong with the code for connect sql and vb.net
[Code]...
View 2 Replies
Apr 28, 2009
I have established code that calls GetShortPathName to convert, say, "r: estlongname" to "r: estlo~1". It works fine with our old server, and at various user sites. We've just got a new 64-bit server and the code no longer works, ie it does nothing so my program carries on trying to use the long name (later on in the code this causes problems because it's trying to write a batch file to perform an unzip & other functions). Any ideas why GetShortPathName isn't working? We're a small software company with no specialised network admin.
The code uses this declaration: Declare Function GetShortPathName& Lib "kernel32" Alias "GetShortPathNameA" (ByVal lpszLongPath As String, ByVal lpszShortPath As String, ByVal cchBuffer As Long)
View 3 Replies
Jul 16, 2009
I'm not very good at deployment and I'm facing a problem: First Off, I'm using Vista. i have created a windows application in vb.net which has a database file named Customerdb.mdf in it. I have selected the database and in the property, I have selected Embedded Resource option. I have used the following connection:
[Code]...
View 1 Replies
Jan 19, 2011
I am working on an application that pulls a field from a SQL Server table that has numeric values separated by commas, for example (1, 3, 4, 6). I need to load this field and somehow load it into a numeric array. However, I can't seem to come up with a good solution. Here is what I have tried:
Dim PagetoSign as Integer()
PageArray = Split(_DataRowView("PagestoSign"), ",")
Dim _PagetoSign As String = ""
[Code]....
However, I receive an error message when it enters the for each loop. I'm not married to this method if there is a more elegant way.
View 5 Replies
Sep 24, 2010
How to make clients on sql server i mean when i will install my application on clients how i will connect it with sql server?
View 6 Replies
Jan 22, 2011
I m getting the following error when i upload my site to Production Server using Database in App_Data ASPNETDB.MDF
Server Error in '/' Application.
Runtime Error
[code]..... ...
View 2 Replies
May 9, 2011
I have a query that is working fine on my local but when placed on the server it comes back with this error,
Server Error in 'Page' Application.
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. [Code]
View 1 Replies
Jun 4, 2009
In mt project im calling data from sql server to display in labels. Howerver when there is no data for a paticular customer im getting an error saying "There is no row at position 0." How can I set the row so that it doesn throw an error but just returns a blank lbl?
View 5 Replies
Aug 19, 2011
I am debug a code in server 2008 but it showing an error like vshost.exe has stopped working. I am unable to debug the code.
View 1 Replies
Jun 3, 2010
If you try to access a password protected page it does a security check and redirects you if you are not logged in, retaining the URL (ie. Members/MemberLogin.aspx?oc=/PodCast/Default.aspx)The vb script places the "/PodCast/Default.aspx" in a variable and holds it until the login process is complete.Once the user types in their username and password it is suppose to do a Response.Redirect(strRedirectURL) and go to the "/PodCast/Default.aspx" but instead it goes to the default.aspx page for logging in successfully
View 1 Replies
Nov 19, 2009
how to working with Sphorium WebDAV Server Framework?[URL]
View 1 Replies
Sep 13, 2010
Anyway, I wrote a view with a union query in SQL Server that grabs data from a linked SQL server.
Anytime I try to add this object as a dataset in VB.NET it completely bombs out on me with this ugly error message...
ERROR [42000] [Microsoft] [ODBC SQL Server Driver] [SQL Server] The operation could not be performed because the OLE DB Provider 'SQLOLEDB' was unable to begin a distributed transaction. ERROR [01000] [Microsoft] [ODBC SQL Server Driver] [SQL Server] [OLE/DB provider returned message : new transaction cannot enlist in the specified transaction coordinator] ERROR [01000] [Microsoft] [ODBC SQL Server Driver] [SQL Server] OLE DB Error Trace [OLE/DB Provider 'SQLOLEDB' lTransactionJoin::JoinTransaction returned 0x8004d00a]
I'm completely stumped as to why I can't create a dataset from a view that references a linked SQL server. It's not this specific view either, all views that reference this linked server bomb out.
View 1 Replies
Jul 21, 2010
I am having a hard time figuring this out. It's about ExecuteNonQuery() method and sql server database. I done several testing and still getting the desired result which is data captured from application window and saved into sql server database table.
Some results i gotten from my testing:Query - Senario 1:From application window, data was captured into variable memory but didnt save into database and end up with blank database. (Tested many rounds still end up in this senario)Senario 2:Used the command console in the data explorer frame, with the insert query along with required value, an entry was made. (Test a couple of rounds and i know it worked)
ExecuteNonQuery() - Tested using if/else method as shown below and the result was pass that show the method is working. This testing method was found from this link: [URL]Below is my create Method(sentence with ' are comments):
Dim DatabaseConnection As String = My.Settings.QuotationDatabase [color="#00FF00"]'Connection to Database[/color]
Dim SqlConnection As New System.Data.SqlClient.SqlConnection(DatabaseConnection) [color="#00FF00"]'Linking Database Connection via SqlClient to Application[/color]
Dim Query As String = "Insert Into Clients2 (Title, Name, Email, Designation, ResidentialNumber, MobileNumber, CompanyName,
[code]....
View 14 Replies
Oct 26, 2009
i'm newbie in this programming..i need some references or a starting guide to build an sql server and vb.net application.
View 3 Replies
Jul 16, 2009
I am creating small application (desktop search engine) which uses sql server as back end. Sql server is used to store huge data using indexing (for quick search). Is it necessary that client should have sql server on his machine to run the application? I don't want to install sql server on client's machine, because my application is just a small utility.Is there any other way so that I can store huge data using indexing?
View 2 Replies
Jan 7, 2012
I have a role called "Customer", I wish to add users who register to be to automatically added to that role. At the moment I can only assign users to roles by using ASP.net Web Site Administration Tool.If it helps: I'm using the default login.aspx and register.aspx files from Account folder in vb web profile.
View 1 Replies
Jul 6, 2011
I have an ASP.NET application on our company's intranet. And a funky security requirement.
I need to check to see if a given username is in a certain role. I cannot use
Page.User.IsInRole("MyDomainMyGroup")
because
Page.User.Identity.Name
Returns an empty string. Because of some lovely specifications for this program, I have to keep anonymous access enabled in IIS. Seems to rule out any page.user.identity stuff.
So I did find a way to (at least) get the current user (from System.Environment.UserName), but I need to bounce it against the domain group to see if they're in it. Or, better yet, get a list of users within a given domain so I can check myself. Something like...
Dim UserName as String
UserName = System.Environment.UserName
If User(UserName).IsInRole("MyDomainMyGroup") Then
[Code]....
View 1 Replies
Jun 16, 2010
I am having a problem with my roles Identification. I am try to read all the roles for a given user. No matter what I try only the first role, only 1 role for the user is being returned. My code is as follows.
[Code]...
View 3 Replies
