Application Role And SQL Express (2005)
Hello,
Can I confirm whether pooling=false in the connection string is still required for SQL Server 2005 (Express Edition)?
Various google searches say pooling has to be turned off for SQL Server 2000, but I was just wondering whether it is still a limitation for SQL Server 2005
Thanks
John
View Complete Forum Thread with Replies
Related Forum Messages:
Uploading SQL Express To SQL Server 2005 - Role's Causes Application Error With SSE Provider
I am very frustrated. Everything works on the local host but when I upload to server I can login to the admin role I created, but when I try to access pages that have role priveleges I get the following error: The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file. The ASPNETDB.MDF database was uploaded using the Database Publishing Wizard. Please help!
View Replies !
Web Application And Role Management In Sql Server 2005
Hi every body I'm developing a web application and i like to use the sql server 2005 role management features istead of developing a role management package in my program, I can do it on my tables and othe database items but I have no idea about using database access rights in my web pages to permit some one viewing or updating a web form... Is there any system table or system stored procedure showing access rights in my data base? or is there another idea to do this?? by Thanks Javaneh
View Replies !
SQL Server 2005 Application Role's Problem
Hi all. I have developed a VB6 program which will activate an Application Role to UPDATE and INSERT some tables in SQL Server 2005. My program will login with a username, say USER and then run with the rights of the Application Role which will SELECT, UPDATE and INSERT the following tables: 1) Table A 2) Table B 3) Table C The USER login is a restricted user which has only SELECT permission to Table A, B and C. I encounter a problem in which my program can only UPDATE table B and table C but Table A. I have double checked the settings of Table A, Table B and Table C. Theirs are all same. Fyi, the column which can't be updated is of type "datetime". Once i grant USER login UPDATE permission to Table A, my program works perfectly in which it can UPDATE all the tables including Table A. I have tried for almost 2 days but am still clueless. Any ideas? Thank you so much.
View Replies !
Sending SQL 2005 Dbmail When Using Application Role
I am attempting to use dbmail from an application that logs in to my database using an application role. Since the application role does not exist outside the database, I created an spSendEmail in the database with "execute as login='mailagent'" in it: I set the database to trustworthy, created a 'mailagent' account and added it to the msdb database with the databasemailuser role rights. Email works just fine on the server when I use the execute as login='mailagent' to fire off the msdb..sp_send_dbmail. But from the .NET application, I get the error: "Cannot execute as the server principal because the principal 'mailagent' does not exist, this type of principal cannot be impersonated, or you do not have permission." When I run my spSendEmail stored procedure from the calling database, I get the same error.
View Replies !
SQL Server 2000 And 2005 - Application Role - Sp_setapprole
Hi All, Is there any limitation for setting password to an approle (like it should be 8 character long, should not start with numbers) ? If so, what are those limitations ? Does the same is applicable for sp_setapprole which uses the same password ? please confirm, for both SQL Server 2000 and 2005 versions. thanks in advance, Regards, Kailai
View Replies !
Application Role, App Role
Hi all, I am trying to connect to the database using application role. But gives an error An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) for the given connection string Dim connstring As String = "Data Source=Northwind;Initial Catalog=OrderProcessing;Persist Security Info=True;UserID=application_login;Password=wewewe;" Dim cmd As SqlCommand Dim param As SqlParameter Dim cookie As Byte() Dim cn As New SqlConnection(connstring) If (cn.State = ConnectionState.Closed) Then cn.Open() End If Please help.. Thanking you, Nirmala
View Replies !
Application Role
I am confused . What is considered an application and how SQL would know ? If I have a web site accessing SQL VIA IIS will SQL Server treat it as an application ? How about MS Excel ? Also , If I was to use the application of Power builder , using app role , how do control which user can use the app ? Thanks
View Replies !
Application Role
With reference to Mr. Eric Charron's article about Implementing Application Roles in SQL7, I have used this tips in my application. But I am facing the following problems. I am looking for some solution from this User's Group. Problem: I am using application (VB6/SQL7) role. I have number of reports. To display reports I follow the following steps. 1) Open Connection 2) Set application role 3) Execute procedure for the report 4) Close the connection Since I have no. of reports, I go through the aboue steps no. of times. For first 2 times it works fine but 3rd time, it gives error ie. application role not set properly. RM Joseph
View Replies !
Application Role
hi all ! first time i created application role with read and write permissions , once application accessing automatically it assigns rd and wr permissions to that users or previously wht permissions are there in logins will it be reflected to that application role. once we create the appliation role , is there any changes we have to do in coding part pls clear my doubt. regards manoj
View Replies !
How To Deploye SQL 2005 Express With My Application
Hello,I have an application that uses SQL Server express. I'd like to be able topackage the SQL Server Express set up file and deploy it with my applicationbut all the searching I've done only tells me how to deploy SQL ServerExpress manually (i.e. how to set it up yourself). I can script my set upto see if an instance of SQL Server Express already exists but if itdoesn't, I'd like to know the best way to deploy this on the target machineautomatically.Any help or direction would be greatly appreciated.Thanks!Rick
View Replies !
MSSQL 2005 Express For Web Application?
Hi, I'd like to get the experts' advice on whether SQL server 2005 Express edition (SSE) is suitable for medium scale web applications. I have looked through the reviews of SSE. From what I understand, its limitations over the MSSQL 2005 Standard are: 1. SSE limits database size to 4GB and memory to 1GB. 2. Support for only 1 CPU. 3. No analysis or reporting services. 4. No full text indexing 5. No SQL Agent. I have a web application that is currently running on a shared web host with a shared MSSQL 2000 database. I'm thinking of shifting to a Virtual Private Server, where I can install SSE for free. Currently my app has about 14,000 page views a month, and each of them pulls out data from the database. I don't use any analysis or reporting services, or full text indexing or SQL Agent (for now). My questions: 1. Is 1GB memory sufficient for this type of application? 2. Is there any reason I should not be using SSE for my type of application? Thanks in advance for the help.
View Replies !
Troubleshooting A New Application Role
Hi all, This one is a real X FIle, just without Mulder, Scully or the Lone Gunmen! I have a database, to which access must be restricted via a sole application. So, I have to use an application role. I go in the database and run these statements to add and activate the roles, respectively; Exec sp_addapprole 'Sirius', 'password' (The system confirms the role is created.) Exec sp_setapprole 'Sirius', 'password' 'odbc' (The system confirms the role is activated.) Right, now I should not be able to connect using anything but this role, agreed? But here's where things go wrong. I can then successfully connect from another computer by using MS query from Excel, from a login that is not even a member of the Public Role! I tried again, started and stopped the Server/DTS/Agent services and dropped the old role after each successful login before recreating it. I've checked my syntax exhaustively. I must be doing something wrong, or overlooking something, otherwise MS has a major security problem! (Just hope the Cancer Man doesn't find out!!) Thanks in advance everyone, Jaishel.
View Replies !
Security For Application Role
We have an application use Approle to read from database. If the client login to windows as administrator or a name that has the administrator rights, the application can get all data. If the client login to windows as a domain user that has limited rights, the application can't get all data. I run profiler and found that it seems, when application use approle to access a database, the login name is the domain user that log into windows. Is there anybody know what type of right the window login name should have in order to get all data from a database? Second question, when I log in to window as domainusername( username is not administrator, but has administrator rights). In the profiler, I can see the application use this domainusername access database. However, under sql server login node, I didn't find domainusername. Is this because, the domainusername belongs to buildinadministrator? Thanks
View Replies !
Application Role And SSRS
Hi dear reader I made an application that uses a Sql Server 2005 Express DataBase. In the database I made a application role. When the user logs into my application I run this procedure: If Not sqlConnectionCR Is Nothing Then If Not sqlConnectionCR.State = ConnectionState.Open Then sqlConnectionCR.Open() SqlConnection.ClearAllPools() ConsultasSqlCommand = New SqlCommand ConsultasSqlCommand.CommandType = CommandType.Text ConsultasSqlCommand.CommandText = "sp_setapprole 'appRole', 'drowssap" ConsultasSqlCommand.Connection = sqlConnectionCR ConsultasSqlCommand.ExecuteNonQuery() End If Else.... I understand that this procedure connects to my sqlserver database as my application role Ok, so far no problems in reading and manipulating data. The problem comes with the reports in my application. For example: I have a reportviewer with a serverreport but when I try to show the report gives an error about permissions and grant access.... I think that is because the Server Report uses the user account (domain/user) to read the database. No user (besides admin) has access permissions in the database (only admin and application role). So, my cuestion is: How can I tell Report Server to use the application role to display reports? Thank you for your time and help. Giber
View Replies !
How To Get A Web Application To Connect To SQL Server 2005 Express
All, I'm a newbie here so forgive me if I have missed something completely obvious. I have bought a shopping cart script of a well known company (Evolve Merchant 5) and I wish to set it up locally on my development server, I created a virtual directory, set the web application up and get the asp pages to display perfectly. However, in the configuration file (global.asa & web.config) for the application it reguests information to be provided: <add key="DBName" value="Database name" /> <add key="DBServer" value="IP address of server" /> <add key="DBUserName" value="User name" /> <add key="DBPassword" value="password" /> <add key="AltPassword" value="password" /> What I can't determine is what the SQL Server 2005's IP address is? the pages of this application show when I type http://localhost/catalogue into IE, so I presumed the server address would be the IP of localhost, when typed ping localhost into command promt it gives me 127.0.0.1, but when I enter this into the config file and try to load the application it just hangs and then eventually says: "Microsoft OLE DB Provider for ODBC Drivers (0x80004005)[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied./catalogue/global.asa, line 54" I have created a new database in SQL Express called: merchant509 and restored the tables to it as the manufactures help files state, I created a new login called shop which uses SQl authentication, so as I can provide a password. So the settings should look like this: <add key="DBName" value="Database name" /> <add key="DBServer" value="127.0.0.1" /> <add key="DBUserName" value="shop" /> <add key="DBPassword" value="1684" /> <add key="AltPassword" value="1684" /> But it doesn't work, does anyone know what i have done wrong?? the SQL server is runnign on the same computer as I am trying to access it from, it is set to accept all forms of comunication i.e. TCP/IP etc.. in the server configuration manager the IP address part of TCP/IP in protocols shows IP1 as 192.168.2.2 active yes enabled yes, and IP2 as 127.0.0.1 active yes and enables yes, I have tried the 192.168.2.2 and this gives the same errors, this is my registed IP on my home network. I'm now stumped, I haven't a clue what else I can try, I would be very greatfull if anyone has any ideas. Regards, Daniel Coates
View Replies !
Installing SQL 2005 Express As Part Of An Application
We are developing an application that makes use of SQL 2005 Express and we are installing SQL 2005 Express as part of our applications installation. We are wanting to know if anyone has had any paticular issues with the installation of SQL 2005 express and would share those expereinces with us? Thank you
View Replies !
Can .NET Application Access SQL 2005 Express Remotely?
I am tring to access the SQL 2005 Express which installed in remote machine. Front end app is on Visual Studio 2005. Try to connect SQL Express using the application Layer which is installed on the computer where SQL Express is installed. Could not fetch data from the SQL Express. What could be the problem? With Regards, ADK
View Replies !
BULK INSERT And APPLICATION ROLE
I want to add bulkadmin permission to my applicatio role. Is it aposible.My windows account havo only public permission on database.I'm using application roleEXEC sp_approlepassword 'MyRole', 'password';Therefore I want to BULK some data with BULK INSERT command.Error is:The current user is not the database or object owner of table'tablename'. Cannot perform SET operation.Thanks in advance.
View Replies !
Use SQL 7.0 Application Role With Crystal 8.0 Crpe32.dll
using vb6 and crystal global32.bas to make function calls to the crpe32.dll and there doesn't seem to be any calls to pass the application role id with password. ap roles must be passed at the ad hoc level, which means i have to execute the system stored procedure for the ap role thru crystals connection to the sql server. HELP....seagate has tried to help, but want me to use odbc dsn, which is exactly what i'm trying to avoid. oledb provider works like a champ, except for app roles with crystal.
View Replies !
Connecting To A Database From VB Using An Application Role
I know how to create an Application role in SQL server 7. Now how do I connect to the database from VB using that Application Role? I can't find anything about this topic anywhere. Is this the purpose of an Application role or am I way off? Thanks for the help Steven Abt StevenA@grsgroup.com
View Replies !
Create Database With Application Role...
Hi, I want my application to create database and I do the following things: 1)Create application role 2)Grant create database to application role 3)Activate application role 4)Create database and I get the answer: CREATE DATABASE permission denied in database 'master'.
View Replies !
Application Role Losing Connection?
Hi, I'm testing the use of application roles for security. The customer I work for has still a lot of ASP intranet applications running. We're migrating the databases to a SQL Server 2005 server. I've changed the connection string to a user without any permissions but to log on. After that I use an application role for permission to select different tables and to execute Stored Procedures. The first queries do execute but after that I get "Permission denied", like I haven't got the application role anymore. Any ideas? Adrian
View Replies !
Moving A Database Application To SQL Server 2005 Express
I have been programming an application with VC++ 2005 and SQL Server 2005. I have converted an old 16-bit database to 32-bit managed code and SQL server and the application seems to be good. Now I want to deploy the application to another server for testing. I have installed XP SP2, Windows Installer 3.1, Net framework 2.0 and SQL Server 2005 express to the test server. I have transferred the application with WI 3.1 and the program works well in the test server till the first SQL command. I have made a back up of the database and restored it in the test server. In the test server I can log in the database with Server Management studio and I can read the data there correctly. I have enabled both named pipes and TCP/IP for the database in the test server. With Surface Area Configuration I have enabled Local and Remote Connections Using both TCP/IP and named pipes. I only need Windows authentication at this time. After all this when I come to the first SQL command in the application on the test server I receive the error message: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 €“ Could not open a connection to SQL Server). My connection string to the database is: 'connection->ConnectionString = "Persist Security Info=False; Integrated Security =SSPI;" "Data Source=TESTSERVER; Initial Catalog=TESTDATABASE;";' When I use "Data Source=DevelopmentServer", the application works well on the development server. Can't understand what is still wrong. Can you possibly have an answer for me?
View Replies !
Installing SQL Server 2005 Express As Part Of My Application
I have found a lot of info on MS site regarding installing SQL Server 2005 Express as part of an application. I have found these articles to be extremely inaccurate or at best incomplete. 1. The documentation says all I need is the setup.exe from SQLEXP but this is not true. 2. When I do launch setup.exe during my app's install, it fails because setup.exe trys to run the support.msi. Of course this causes failure because my install is also an msi. So, does anyone know how to install SQLEXPRESS as part of my app's install? Thanks.
View Replies !
Get Sql Err Message 15422 When Activating Application Role.
Running VB 2005 Express Edition and Sql Server 2005 Express Edition (SQLX). Developing a desktop application which calls a local instance of ".sqlexpress". This app needs to set data base options and add/del various table columns. When activating the application role, I get the following message: HariCari SQL Error/s 15422 - Application roles can only be activated at the ad hoc level. Anyone know what this message means? I have searched SQL Server Books On-Line and been unable to find a list of Sql err numbers. Either I have missed the obvious or Books On-Line has missed the obvious. Thanks Gary
View Replies !
Login Failed For 'user' (Application Role)
I've created a database in SQL Express and I have a Windows form attempting to connect to it through SQL Authentication. Connection string: private string connString = @"Data Source=.sqlexpress;Initial Catalog=SQLTestDatabase;User ID=SearchAppRole; Password=password;"; The role I have added to the database is an Application Role. It has been added to the Database permissions with Grant checked for "Select" and "Authenticate". If I test this with query analyzer, it returns expected results (if I remove Grant from 'Select', it fails) sp_setapprole 'SearchAppRole', 'password' select * from recipe If I edit my connection string (for testing purposes) to use the sa account, the application can connect and run the Select statement: private string connString = @"Data Source=.sqlexpress;Initial Catalog=SQLTestDatabase;User ID=sa; Password=sa_password;"; However, I cannot get the application to successfully logon and run the select statement when using the user id and password of the Application Role. I get error: System.Data.SqlClient.SqlException: Login failed for user 'SearchAppRole'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj I can't find much information on Application Role...I just want one basic permission for the application as a whole. Any help is appreciated. Thanks.
View Replies !
Insert Arabic Text To Sql Express 2005 (windows Application)
Hi, I need your help guys. Am devolving a windows application by c#. I have problem of insert Arabic text to sql express 2005. I always get ???? instead of the Arabic letters. I change the collation of the database field to windows collation and choose Arabic but still I get the same problem. Your help is appreciated
View Replies !
Application Role How Query A View Whose Reference Table Is In Another Db?
Hi everybody. I created an application role in a database (DB1) and gave it all the rights on a view in DB1 which refers to a table located in another db (DB2). I also gave the rights to the app role on a table of DB1 I tried to use this app. role through the sp_setapprole launched by a user (server principal?) which is SQL Server administrator (and local administrator (Win 2003 Server)). With the following query SELECT USER_NAME() I see that the approle is being used. Than, if I query the table on DB1 everything works, but if I query the view, referring a table in db2 I get following error: The server principal "NameOfServerPrincipal" is not able to access the database "DB2" under the current security context. What should I do to make it work? The table in DB2 has the same schema of the view in DB1 which refers to it. I put the DB1 TrustWorthy and both the database have the db_chaining option activated. Any idea on how to solve the problem would be widely appreciated. Thank you very much. Vania
View Replies !
Problem Migrating Application Database From SQL Server 2000 To Express Edition 2005
Hi there I am new to SQL Server, but the current project that I am working on has the following requirement:- 1) Migrate the application (a servlet based web application on Apache Tomcat) from Solaris to Wintel 2) Migrate the supporting database from SQL Server 2000 to Sql Server 2005 3) Get IIS to communicate with Tomcat for serving servlet/jsp etc to the client Though I successfully completed item 1 above, am stuck at item 2. Details are below Actions taken for item 2 A. Installed MS 2005 B. Created new database in MS 2005 (logged in as user 'sa') C. Generated SQL scripts (such as create table table_A etc) from existing MS 2000 D. Genearted SQL scripts (such as insert into table_A etc) from existing MS 2000 E. Created new schema in MS 2005 F. Ran scripts C & D in the new schema. All tables are records populated. G. Obtained new JDBC driver and test run to see if connection is working fine, and it worked. Even ran an sql statment Code Block[select count(*) from sa.table_A] and got appropriate response. H. When I made the application to talk to this new database (which is a copy of Production from step C, D above), it's behaving as though it cannot find the record. I. When I further debugged, I realised that the web application is excuting queries without mentioning the schema. For eg. Code Block[Select firstName, lastName from table_A] Or rather it assumes that the user connecting to database is same as the schema name. J. To further ascertain my point, I ran the query Code Block[Select firstName, lastName from sa.table_A] and it worked! Now the real problem is that I cannot modify the existing code to append a schema name and this approach is rather not recommended best practise. I tried to match the user name with the schema name, even made this schema as default to the user. But still not finding any luck. I request all you experts out there to help me out with this problem. Regards, prad.nair
View Replies !
How To Connect To SQL Server Express 2005 Database At The Same Time From Both SSMSE And VB2005 Application ?
Here is the situation: I have SQL server express 2005 installed on my pc as instance SQLEXPRESS. I have created a Visual Basic applicaion with the following as connection to the SQL server express 2005 running on the same PC: **************************************************************************************************** Dim lconnectionString As String Dim builder As New SqlConnectionStringBuilder Dim cmd As New SqlCommand Dim reader As SqlDataReader Dim parameter As SqlParameter builder("Data Source") = ".SQLEXPRESS" builder("Initial Catalog") = "" builder("AttachDbFilename") = "C:My DocumentsVisual Studio 2005Projectsabcabcabc.mdf" builder("Integrated Security") = True builder("User Instance") = True lconnectionString = builder.ConnectionString Dim sqlConnection1 As New SqlConnection(lconnectionString) cmd.CommandText = "SP_add_collection" cmd.CommandType = CommandType.StoredProcedure cmd.Connection = sqlConnection1 sqlConnection1.Open() ******************************************************************************************************************* It seems that i can not connect to the abc.mdf in SSMSE while the VB program is running. (ERROR: Database 'C:My DocumentsVisual Studio 2005Projectsabcabcabc.mdf' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. (.Net SqlClient Data Provider) ) If i connect to the abc.mdf first in SSMSE, then run the VB program afterwards, it gives me the error on this line -- sqlConnection1.Open() I want to be able to access the abc.mdf database with both SSMSE and VB at the same time. Could anyone help me on this ? Thanks very much ! apple
View Replies !
ODBC Connection For Client Application To SQL Server 2005 Express Installed On Network Computer
Hi All, I've developed an application that connects to a SQL Server 2005 Express database. I created a DSN to connect to the database through ODBC. Currently, I am testing locally and everything works fine. I would now like to install my application on another workstation and connect remotely to the database located on my development machine. The client workstation does not have SQL Server 2005 Express installed on it because I would just like my application to connect remotely by creating the DSN and using ODBC. What I'm missing here are the database drivers. The "SQL Natice Client" is not available on this client workstation. How can I deploy the necessary drivers with my installation file so that I may create the required DSN name using the SQL Native Client driver? Thanks!
View Replies !
Can't Make Database Role A Member Of Another Database Role In 2005.
In sql server 2000, I created some custom database roles called ProjectLeader and Developer. I would make these roles a member in the fixed database roles so that I would only have to add the user to the ProjectLeader or Developer role once and they would presto-magico have the security I wanted them to have with no unecessary mouse clicking. I'm not sure how to repeat this process in 2005? Management Studio doesn't seem to allow you to add a role as a member in another role. Is there a work around or solution for this?
View Replies !
Creating An Application On SQL Server 2005 Express That Will Be Migrated To SQL Server
I have several general questions about this but I thought I would describe what I am doing first. My senior project team is developing a web application that will wind up using SQL Server for the database. We are writing it in ASP.net and developing the database on SQL Server Express. My job is to develop and deploy the database. I have an ERD designed and am getting ready to start coding the tables, constraints and stored proceedures but am unsure of a couple of things. 1) How do I create a new schema? 2) I can see how to create tables in the GUI but what I am trying to do is create scripts that can be used to create the tables and objects on the actual server that our client will be using. How do I create scripts in 2005 Express? Do I just go click on the new query button? 3) Are scripts that work for Express going to have any problem executing on SQL Server?
View Replies !
SQL Express And Console Application
I have created a Web application that uses a SQL Express file Database (mdf). I have also created a console application that looks to the (mdf) in the Web Directory to process some server-side tasks, (Email, process data, etc). Everything works well on my Development Machine, however when I Publish my Web App and Console application to a server, the Web App works fine, the Console App is buggy. The main error I get is ;that the user logged into the server cannot access the Database. (User domcholman cannot access). However this is not always the case, sometimes it works. Question is, how does SQL Express authenticate credentials when in Windows Auth mode? Shouldn't it allow the Service account to access the database? Are there any best practices? Should I use an account and password instead? thanks...
View Replies !
Cannot Connect To SQL Express From My Application
Hey everyone, I'm having trouble connecting to my sql express instance through my vb.net application. I can connect to it from Visual Studio and the management tools, but get an error when connection with a connection string. What should my connection string look like? I'm using the a default SQLEXPRESS instance.
View Replies !
Deploying SQL Express With ASP.Net Application
I have a small ASP.Net application developed in VS 2005 that I would like to deploy with SQL Express. I have included the MDF file in the Application and added SQL Express as a pre-requisite for the Setup and Deployment project. It installs SQL Express but when it tries to connect I receive: "This is not a valid login Cannot open user default database. Login failed. Login failed for user 'NT AUTHORITYSYSTEM'." I don't seem to have any options using the "prerequisite options in VS 2005 in terms of command line deployment parameters. Likewise I would prefer to attach the database to the instance (because I need to write a connection string from a PDA using RDA and I have zero clue how to do RDA directly back to the file). Thanks for any help!
View Replies !
Edited Data Won't Propagate Back To The Database (VB 2005 Express && SQL Server 2005 Express)
Hi, I'm trying to learn some VB programming with the VB 2005 Express Absolute Beginner Series video tutorials (which I think is great) and have come across a problem that I can't solve. When I follow the instructions in Lesson 9 (Databinding Data to User Interface Controls) my application will display the data from the database correctly and I can edit it (and as long as the debugger is running the data remains changed). However, the changes won't propagate back to the database. I don't get any error messages but after I edit the data, save (with the save button on the BindingNavigator toolbar), and end debugging the data in my database remains unchanged. When I use a MessageBox to show how many rows where edited/updated in the Me.myTableTableAdapter.Update(Me.myDatabaseDataSet.myTable) I get the correct number back. I'm sure the problem is not due to coding errors since I've also tried running the accompanying Lesson 9 project file that can be downloaded from MSDN and the problem persists. I'm using Windows XP SP2, SQL Server 2005 Express Edition and VB 2005 Express Edition. I've tried installing SQL Server 2005 Express with a number of different settings, including default settings, but it doesn't make any difference. Would greatly appreciate any feedback on this as I'm keen to resolve this problem so I can get on with the next tutorial lesson. Thanks, Ieyasu
View Replies !
SQL Server 2005 / Securityadmin Role / SSMS
Experiencing a little weirdness with SQL Server Management Studio...Have created a login, that has fixed server role "securityadmin".The login can create/drop logins, add/remove them as users indatabases, etc.The login can change another login's password, using SQLfrom a query window (e.g. alter login bob with password='abc')However, the login *cannot* change another login's password,using SSMS GUI (e.g. "Security", "Logins", double-click "Bob",change password, say "OK"). The error text is:Change password failed for Login 'Bob'. (Microsoft.SqlServer.Smo)Additional information:An exception occurred while executing a Transact-SQL statement orbatch.(Microsoft.SqlServer.ConnectionInfo)Cannot alter the login 'Bob', because it does not exist or you donot have permission.(Microsoft SQL Server, Error: 15151)Has anybody else experienced this?
View Replies !
Problem Adding Securityadmin Role To Sa In 2005
Hi Guys, I'm trying to add the securityadmin server role to the sa user but have been unable to due to an error occuring. The error says "Add member failed for server role 'securityadmin'. Cannot use the special principal 'sa' Microsoft SQL Server error 15405." I assumed that the sa account would already have the required permission to perform most operations on the server but I have been asked to try assiging this server role to sa by a support guy for our third party product. Has anyone got any ideas why this error is occuring? I have been looking on loads of forums but cannot find anything relevant to me. Thanks in advance for any help!
View Replies !
Visual Basic 2005 Express And SQL Server 2005 Express - Display Image
Hi Guys, I created a Product database table using Visual Basic 2005 Express and SQL Server 2005 Express. I have just added a new column [Picture] to the database table, which of course, should store an image or picture of a product. I am writing to kindly ask you guys for help . i) How do I include image files into this column [Picture]? ii) How do I get this image to display on Visual Basic 2005 Express form, so that when a product is selected the product image is displayed accordingly? Your help much appreciated. Thanks. Paul
View Replies !
|
TRACKER
