VS 2010 Cannot Open Database - Cannot Login
Mar 14, 2012
I created a SQL DB named MainDB.mdf and a small VB 2010 application with some forms and datasets. Everything was working OK until i got a new computer and re-installed Visual Studio 2010 and SQL server 2010 on it. I copied my DB from the old to the new computer and also copied by VB 2010 project to it. I used Windows Authentication to connect to the DB in the old computer and also in the new one, i am using different Windows user account names though.
I was able to connect to the DB in the new computer in the Server Explorer section, i created a new connection string to the DB and i can seed there is data in the tables. When i run my VB 2010 application created in the old computer get error:
"Cannot open database "MainDB" requested by the login. The login failed. Login failed for user 'D630Admin'."
I need to get rid of that error and be able to add/mod/del data from my DB using my VB application as i used to.
View 4 Replies
ADVERTISEMENT
Mar 1, 2011
I got the above error when i deploy my web application into windows server 2003. How do i resolve it? [code]
View 3 Replies
Feb 21, 2010
I followed below attached tutorial but I got this error: Cannot open database "mydb" requested by the login. The login failed. Login failed for user 'NAME OF COMPUTER FOR THE NETWORKUsername'. Second question: When I deploy my application which communicates with SQL server, should I put in the installation file SQL server? If I need to deploy and SQL server, I have to configure server, right? P.S.I use SQL 2005. I changed Authentication Mode of the SQL server to: SQL Server and Windows Authentication mode.
View 12 Replies
Mar 15, 2012
I created a SQL DB named MainDB.mdf and a small VB 2010 application with some forms and datasets.Everything was working OK until i got a new computer and re-installed Visual Studio 2010 and SQL server 2010 on it. I copied my DB from the old to the new computer and also copied by VB 2010 project to it. I used Windows Authentication to connect to the DB in the old computer and also in the new one, i am using different Windows user account names though.
I was able to connect to the DB in the new computer in the Server Explorer section, i created a new connection string to the DB and i can seed there is data in the tables. When i run my VB 2010 application created in the old computer get error:
"Cannot open database "MainDB" requested by the login. The login failed. Login failed for user 'D630Admin'."
I need to get rid of that error and be able to add/mod/del data from my DB using my VB application as i used to.
View 5 Replies
Jul 16, 2010
How do I Close a Form and then open a new one straight away? Im trying to make a Login for a Program, but I want the Login Box to open first, then disappear when the credentials are correct and a new Form to load.
View 3 Replies
Jul 16, 2011
it's just for a program registration. i would store all of the registration codes in the access database, then export it to XML, then upload it to my web host. I would then somehow connect it to my Visual Basics login form (Which I have already made). If this can't be done, having them register through the form and having all the allowed codes on the internet (So i can easily edit them)!
View 5 Replies
May 8, 2012
I'm using Visual Basic Express 2010 and SQL Express 2008 in Windows XP. At first I couldn't add a datasource (the .mdf file for the database) because of a "Operating system error 32" which I seemed to have resolved by giving myself full permissions for .mdf file (by right clicking on the file and going into properties and then Security) and restarting the SQL SERVER (SQLEXPRESS) service. The dataset for the database is in my solution explorer but when I right click on a table adapter to add a query and attempt to open up the query builder, I get the error in the title above.
View 1 Replies
Jul 31, 2011
Im new to vb and mysqlHow can i make it where you type your username and password and it connects to my database hosted on my site and then if the user nameexists and password exisits it will login and if it doesn't it will get you a error message?
View 2 Replies
Feb 25, 2010
i am working on a project that involves checking that a persons login and password are that of held in the database each person has a seperate username and password i seem to have stumbled across an error. here is the code and i will underline the problems
View 8 Replies
Apr 21, 2011
i'm trying to link the program i'm designing so that it creates an entry and can refer to the record for the numerous pieces of information that was saved to it. I'm not sure what method would be the best to achieve this but I'm a bit short on time to have this done as it is a school major work and this is one of the final steps but me and my partner are stuck and the teacher refuses to help, probabaly because he doesn't know.
In the register I need to allow the user to input a Username, Password, First & Last Name, Email, Address and a Phone Number On the login it will only require a Username and a Password.
I'm really sorry I have not given any personal coding etc. but we simply don't know where to start.
View 2 Replies
Sep 21, 2011
I want to make a login for my application, not using a database, for now.
I figured something like this:
Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click
If UsernameTextBox.Text = "Josh" & PasswordTextBox.Text = "mypass1" Then
[Code].....
View 2 Replies
Jan 14, 2012
I am using the following code to backup my database...
Dim con As SqlConnection
Dim cmd As SqlCommand
con = New SqlConnection("Data Source=.SQLEXPRESS;Initial Catalog=LIC;Trusted_Connection = yes")
[code]...
But I get this error
Cannot open database "LIC" requested by the login. The login failed.Login failed for user 'mono-PCmono'.
View 1 Replies
May 8, 2012
I'm using Visual Basic Express 2010 and SQL Express 2008 in Windows XP.I created a database on my local PC HDD. At first I couldn't add a datasource (the .mdf file for the database) because of a "Operating system error 32" which I seemed to have resolved by giving myself full permissions for .mdf file (by right clicking on the file and going into properties and then Security) and restarting the SQL SERVER (SQLEXPRESS) service.The dataset for the database is in my solution explorer but when I right click on a table adapter to add a query and attempt to open up the query builder, I get the error in the title above.
View 10 Replies
Oct 1, 2011
My first time trying to log in to my local sqlserver with VS2010 was greeted by this vague, unhelpful error:
"Cannot open database "Database1.sdf" requested by the login. The login failed.[code]...
View 9 Replies
Apr 6, 2011
guys can you give me a simple login form that check if the username and the password is in the database.. im using a ms access database..
View 4 Replies
Feb 9, 2011
I m creating a Log In form at VB.NET and i have some problems The connection between the application and the web server opens fine and i can login if i use the MD5 encrypted text of the database.
View 15 Replies
Feb 26, 2011
I recently download/Installed Crystal Report for Visual Studio 2010 to work with Visual Studio 2010 Prof. Database from SQL Sever 2008 Express. Now my problem is when I run Crystal Report Viewer - Windows form : 1st message Database Login request and otherwise WRONG RECORDS DISPLAYING which I have not in my database table.
do print reports for my new Windows Application.
View 2 Replies
Jan 2, 2012
The project must have different user and each has username and password will be saved in my database but only the admin can add users.
View 5 Replies
Oct 10, 2010
I am currently working with VB.net 2005. I am trying to create a login form and use a text file as a database to login. The part login form is fine but i can't connected to the text file. When i use my coding with a database such as access or mysql is work fine.
[Code]...
View 4 Replies
Dec 9, 2009
How do I create a Login Verification routine (Login Form) in vb.net . i have an windows application with login form contain user name , password , ok button and cancel button .
as this one:
Imports System.Data.OleDb
Public Class LoginForm1
' OK button
[Code].....
but i want to run my application from desktop and will get confirmation if the user name and password correct by checking them in MS Access Database in the server.
so the the application in the desktop and the tabel of user name and password in the server.
View 12 Replies
Jun 28, 2012
I am trying to query a MSI to get the ProductCode from the MSI so I can later populate a script with the proper ProductCode.During debugging it "looks" like the database is open for read, however if I look at the oDB object I see this "Error = No further information on this object could be discovered" When it tries to do the OpenView on the SQL statement it throws an exception "OpenView, Sql" I believe that is because the MSI really isn't open for read?I have added the reference to the Microsoft Windows Installer Object Library version 1.0.0.0
Here is the code: (I pass the fully qualified path + filename of the msi)
Private Sub GetMsiProperty(ByVal sMSIFilePath As String)
Const sReadMSIDataBaseErrorStr As String = "ERROR: Could not read MSI database!"
Const msiOpenDatabaseModeReadOnly = 0
[code]....
View 6 Replies
Jan 10, 2011
I'm creating a database backup function into by program which will allow the user to locally backup a database to the selected folder. How do I go about doing this? I realise you cant copy an open database, but I cant think of any other way to do it.
View 1 Replies
Jul 26, 2010
I have the lines above to login by database. However, I really don't know why always give me the error: "Incorrect fields". I am 120% sure that all the fields of the table are right, including the text that I put into my textboxs. I have already add a user into the database. I can make login in PHP but in VB.NET I just can't.
Try
Dim MySQLConnection As New MySqlConnection("server=localhost; user id=root; password=; database=DB")
Dim MySQLQuery As String = "SELECT * FROM TableLogin WHERE Username = @username AND Password = @password"
[CODE]...
I already tried to show the data of the database into a Datagridview and it works fine, it displays to me all the rows that I had add in the database.
View 2 Replies
Jun 13, 2010
Im running a login screen (code below) but when a user logs in, how can i get visual basic 2008 express to pop up a new form. I.E. user logs onto system, then a program loads up.
Code -
Public Class Login
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs)
[code].....
View 2 Replies
Apr 22, 2010
I have it so a form opens first. But I want
LoginForm1.vb to open first.
How can I do this?
View 8 Replies
Oct 17, 2009
I created an application that opens certain Microsoft Windows built in functions depending on what button you use. I have Text Fields setup for certain things like IP/URL, Username, Password, Port, Service. Depending on what function you want it pulls data from these fields.
When someone clicks on Remote Desktop I would like it to pull from the IP/URL, Username and Passwords fields. Right now it pulls only from the IP/URL field. How can I have it populate the Remote Desktop login, pulling the data from my Username and Password fields?
I have found a Login DLL that someone wrote and also found a Remote Desktop DLL but I do not know how to tie these into my program. I somewhat know the process of using a DLL in a VB project but I don't know how to tie these in.
FYI, I would like to be able to make my application a single executable instead of having multiple files that are installed by an Setup program.
Another feature of my program is being able to stop and start a service. I can use Taskkill and have it pull the username and password just because Taskkill has this built in with switches. This is ok for ending tasks but when I try to use SC to start the tasks, it only works locally because the remote server has a different username and password. SC does not have a switch for username and password.
Also another FYI, I do not want to use a 3rd party software that may not be on the remote computer/server. i.e. PSKill, PSExec, VNC or another program..... unless these can be imported into my single executable program and not have to be on the computer. As I mentioned, I do not like having to rely on 3rd party applications.
View 1 Replies
Apr 29, 2011
I'm trying to make a login form thats opened by a button. I know how to make the button open a new form but I want the form to have a admin login,guest login and a new user button that only a logged in admin can open, it should also have a 'only admins can create new users' type messagebox. If your still understanding me I also want it to stay in the file, like you press the login button and it brings you up to the page. I don't know if it could have account control like user from limited to admin.
View 14 Replies
Nov 18, 2009
How would I open internet explorer, open a router using the ip then login. The login it asks for is a popupbox type.
[Code]...
View 2 Replies
Dec 13, 2011
I have a Main form, a Login form and a Splash form. In the project settings I've set the Splash screen.
System.Threading.Thread.Sleep(3000)
Login.ShowDialog()
If Login.DialogResult <> DialogResult.OK Then
[code].....
View 9 Replies
Jan 14, 2011
I have code on log in form but it only get the latest data on username and password column on my database
Here is my code
Public Class Users
Dim MyLogIn As New myRecords
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
[CODE]...
This is my connection:
Imports MySql.Data
Imports MySql.Data.MySqlClient
Module myconnect
[CODE]...
This is my record:
Imports System
Imports System.Data
Imports MySql.Data
Imports MySql.Data.MySqlClient
[CODE]...
View 1 Replies
