o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

Login and security error -

Hi Everybody!

I hope you can help me. I have my application logging into my SQL server 7.0 for user security. I can log in to my login screen, but the application seems to not hold on to the username and password when I try to open other forms in the application. It gives me this error:

Run-time error '-2147217843(80040e4d)':
Login failed for user '(null)'

Here is a sample of what I have on Form_load on the forms that give me the error:

Code:
Set cn = New Connection
    cn.Provider = "SQLOLEDB.1"
    cn.ConnectionString = "DATABASE=QCManager;SERVER=d248r00b;UID=" & A_Sign_On.txtuName.Text & ";PWD=" & A_Sign_On.txtPword.Text & ";"
    cn.Open
A_Sign_On.txtuName.Text and A_Sign_On.txtPword.Text are the username and password respectively. A_Sign_On is the form where the user puts in the username and password.

Any ideas on how to solve this problem?

Thanks in advance.


 

VB error 2147467259 -
hi i have created a login form using VB 6 and SQL server 2000 but i on run time i get an error ERROR -2147467259(80004005) [Microsoft][ODBC Driver Manager] Data Source name not found The connection strting used is Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=


windows XP -Login problem -
Hi I have done some security issus in admin-security policies. after that i cannot able to login into my system. Once i enter the usename and password Simply it is logoff works and again it came to login window. how to solve it and how to enter into mysystem. thanks


[2005] programmatically login -
I'm using the .net20 memberships and login defaults to handle security, but I dont' want to login to my site everytime I debug. Is there an object I can set to have it login for me when I'm debuggin? Thanks!


VB using NT login security -
Can anyone tell me if it is possible for a VB program to interact with the Windows NT security table so that a user does not have to use multiple logins? If so, how is this accomplished? It seems that it would be nice to only have to login one time even though you have NT, VB, and Ora


Connection String Again -
I am trying to create a connection string to an SQL Server database from within Dreamweaver MX with the following string : Provider=SQLOLEDB.1; Integrated Security=SSPI; Persist Security Info=False; Initial Catalog=ITPSCustomers; Data Source=TMLSERVER The problem is that when


Login / Security -
Hi, I want to add a very secure login screen to my program. I am looking for suggestions on the best way to do this.. Suggestions may include connecting to some sort of online server and if the connection is lost the program will close.. I want to make sure someone wont be able t


Login UserName & Password -
Access Table - [Security] Fields in [Security] - [Username] [Password] I used the wizard in VB to create a prog. In the wizrd it created a login screen with a username, password and two buttons; OK & Cancel. What code can I write to make the login access the database and lo


asp.net 2.0 login data -
Hi, I have implemented login security into the asp.net 2.0 web application. Now I see that there is a file called ASPNETDB.MDF in the App_Data folder of the project. I do know that during the configuration I assigned a new database in sql server to keep these security settings, i.e u


Access security question -
Who said there is no security thing with MS Access? I got a problem here I am facing a permission problem when I try to open/export an object(table or form). There is no login form for opening program but I know by default, the login user is Admin which should have full controls


Connection Error to SQL 7.0 -
Hi everyone, Briefly describe the problem. Database application written in VB for MS SQL server 7.0. Connection string: mconn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Calc;Data Source=NEWServer" The connection op


Username\Password form -
Hi, I'd like to create a form where the user chooses a username\password to login and store the data until the next login etc. There are no security issues here and when the login button is clicked just a form will be displayed. Should I make it from a new form or use the Login te


Login Security -
In my last thread post I asked how to make a login screen. In this post I ask if someone can help me with login security. So.... The login procedure should finally work like this: Somebody logs in, passw and name are checked, if allright, the procedure continues. There must b


Website Security Certificates -
Hi, I know some websites require security certificates to allow authorization to a site. My question is does uninstalling a browser delete the security certificates? The reason I am asking this is because this site: https://moodle.tafesait.org/login/index.php doesn't work properly


[2005] using thumbmark as security -
using vb.net, can i use the thumb mark as a security login? how?


Login and Security -
Hello to anyone, I just started to design some small project using VB. I got some problems. One of them is to design a login form which would allow the right user to access my program. I used the access to build a table which contained two data fields: user name and password. And


Security Levels -
I have written in some security stuff for my prog. Currently my login screen looks to a databsae and verifies the username and password. What I am trying to do is set security levels for each individual user also. I am including the code I currently have written. Please let me know


RDS + Security -
Help! I've written a rds business object to return a disconected recordset. Wehn I run my client, it creates the object ok, but when I try to call the method that retunrs the recordse, I get Internet Server Error. If I try to run it locally on my machine, I get 'Login Failed for U


ASP IIS and SQL Security -
Hi All, Ok this is driving me mad... we are setting up some ASP code that access a SQL DB. However all the examples we have seen shows the ASP pages accessing SQL via the SA login and a plain text passowrd... Erm this dosent appear to be a sane way of asscessing SQL ! How can it be


VB & Access97 Security -
I have posted this in the database section as well.. sorry, but I really need an answer to this one. Here's the scenario, I have a VB front end that accesses the security workgroup file (MDW) of a database. The VB front end requires the users to login, this then open a connectio


Security login Freeze -
Hey i have made my own security login on windows its all done starts on startup and stuff but now i have al little problem i dont want them be able to click it away or open any other programs. i mean when you have windows xp and you click shutdown ( on my computer and on all other c


Security in SQL Server, using the Connection object. -
This is just as such a question about SQL Server as it is a question about ADO . . . I want to be able to keep my database and program secure by passing username and password in the connection's Open method. The Connection object is connecting to a SQL Server database using a DSN.


Login and security error -
Hi Everybody! I hope you can help me. I have my application logging into my SQL server 7.0 for user security. I can log in to my login screen, but the application seems to not hold on to the username and password when I try to open other forms in the application. It gives me th


Vb.net App - SQL Database Login -
I have a vb.net app connecting to a sql database. When I run the app on the PC running Sql Server it logins ok. When I try and run the app on a different PC, I get the following error System.Data.SqlClient.SqlException: Login failed for user 'BM-PC\Guest'. I am using the foll


Security LoginUrl -
I took an example from microsoft to protect my sit. At least trying out this security... I got in the Web.config something like this: <authentication mode="Forms"> <forms name="Login" loginURL="Login.aspx" prot


Difference between New login and New db User -
wat is the diff between New login and new db user in sql sever ? how come when i create a new login ,del it and recreate it again ..i got this error: 21008: SQL-DMO Login xxxx already exists.


Login Script for Windows ME -
Hi Guys, I am running Windows ME, however I have heard that you cannot have a login script for it? I would like to know if this is true, and if not, how could I sort out a login script for windows ME as a simple security measure? Regards, Ben


Login Page - Resolved -
When you create an asp page that query a database, do you build the connection string of the ADO as Window Authentication or a SQL Account. Doing it with window authentication, I am able to get it to work on my computer but when I test on another computer, it gave me an error of "


login error -
On my own pc i m trying to run a report...and I keep getting a login error some reports work fine..but this report keeps saying: login failed: 28880: [Microsoft] [ODB SQL Server Driver][SQL Server] Login failed for user Blah\username I hate crystal...so much Jon


Error with Integrated Security & SQL -
Hi I'm an ASP.NET newbie and am having a few problems connecting to our SQL Database. I have got a really basic ASP.NET page that is connecting to a database and returning a list of users. The IIS is on my PC and I'm trying to connect to one of our SQL Servers on another box. I'


Assemblies Should Declare MinimumSecurity -
Dear reader, I have checked my program with Microsoft FxCop. Fxcope gave me this error. CriticalError, Certainty 95, for AssembliesShouldDeclareMinimumSecurity { Target : login.exe (IntrospectionTargetModule) Resolution : "No valid permission requests we


Request.QueryString/Request[""] and Security -
I have been trying to completely avoid using the querystring because depending on the levels of security you code into your site it can be used to insert invalid data/scripts and so depending on what your site uses in the way of dynamic page creation/layout and so on. My question is


vb.net access DB on server without login -
Hello all, I have an SQL database on a server that I need to access. But, because of security reasons beyond my control no one is allowed to log on to the server directly or remotely. Is there a way to connect to an SQL database on a server without actually logging into that server


Force a user to logoff -
Hi all, I got a login 'Jeff' with is password being "Hello" in the Security Logins from SQL Server. Let's say Jeff is currently logged in via an application in a random DB... I want to delete Jeffs login for XYZ reasons but the sp_droplogin procedure WILL fail because J


ASP.Net Security Settings -
Hi all, I have a website in which I tried to implement security features. Actually I have 1. unset my IIS security settings so as not to allow Anonymous Login. 2. Checked Windows Authentication 3. Set <authentication mode="Windows"> in Web.Config 4. Defined a li


Use security in ASP.NET DB for win app -
Hello all, I have a ASP.NET 2.0 website that uses the built in tables added from the aspnet_regsql.exe tool. I am creating a windows based app for my end users and I just wanna use the same SQL DB for security that the website uses. Of course the password is encrypted. How can I


security error in win98 -
I'm trying to run my app in win98, it gives me security error when I try to select some files. It also gives me another kind of security error when I try to show a "folder browser" dialog, which someone gave me on this forum... this works fine with not errors in win xp


login failed to database [B][B] -
Resolved Dim oSQLConn As SqlConnection = New SqlConnection oSQLConn.ConnectionString = "Data Source=(local);" & _ "Initial Catalog=Con_Test;" & _ "Integrated Security=S


Security for database -
How to set the level of security for ach user in access 2002 and applied it in VB? my program got login page when it start, then how i set the user as admin that can do all the stuff? and normal user that only can view and update and add records? help plz...thank


Login For Program -
I'd like to make a login screen for a network admin program. Can anyone tell me how to place a login screen where you normally login for windows? I would like it so that they can login to windows normally but instead of going to windows, it will load up my login screen and then it w


Webbrowser.Navigate success check -
My first post - I am using Webbrowser.Navigate to push some data to a secured website from my Access application (VBA). I have a NavigateError event set to trap return codes in case of an error during the transfer that seems to be working OK. Here is my dilemma: Since this is