Results for the 2147217843Security 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. Authentication Failed **RESOLVED** - I am using ADO to connect to an access 97 database. Does anyone know what causes RTE -2147217843 "Authentication failed" on opening the ADO connection object? "Authentication failed" error trapping - In a project I'm working on, in my Sub Main process, I do a check for a Jet provider. I get the following error: -2147217843 ' "Authentification Failed" . I've tried all "standard" error traps for this error, but so far, no luck. I've tried "on error goto Database Connectivity problem - Hi all, I have give a passwor for my database. So how can open the database having password? It is giving me run-time error 2147217843(8004e4d) Can anyone tell me what is the wrong with the code? If i don't give the passwod for my database then there is no problem with the connecti runtime error *RESOLVED* - Hi folks, i'm back. I have finished the application on my workstation and it works fine. (windows 2000 server) I put the data under an IIS Directory , because it has to be accesible for the website. Te program exists of a single standard application and an activeX dll. The web Access2K password from VB using ADO - Hi, I'm connecting to a password protected Access2K database from within my VB app. I'm using ADO and the connect string is as follows: goDb.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\something.mdb;Password=blablabla" Howev OCX and ODBC error - I've created a program that uses an ODBC connection to a SQL 7 database. Running the program on my computer (Windows NT) is no problem. However, when I move the .exe to another computer (Windows 2000) I get the error "MSDATLST.OCX or one of it's dependencies not correctly regist 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 URGENT: Connection to SQL Database - I've searched the site but cannot find a solution to my SQL Connection problem. I am trying to connect to an SQL Database located on a NT4 Server (i'm no expert on SQL databases). The database is using SQL + NT Authentication, and I am supplying the Administrator username and passwo Database connection error! - Hi, I am trying to connct to my MS Access Databse with the follwoing code Code: Dim cnn As New ADODB.Connection Dim rst As New ADODB.Recordset Dim fld As ADODB.Field cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" _ & "Data S not a valid accountname or password - i am connecting to access-2003 from VB6 with .mdw file for security. .mdw file resides in the application path. my connection string is like this... '............................................. sub open cnn() dim pathway,sysway as string ' databse and .mdw file path dim cnn_string a MsAccess DB - Password - Hai! How to Access the secured Database from VB, thru ADODB. i.e. I secure my Access DataBase with password, and I am using ADODB Connectivity in my VB Form. Whilst initializing the connection, my code is 1) Con.Provider = "Microsoft.jet.oledb.4.0" Con.Con Login HELP! - 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 e 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 MS-Access Connection Problem - hi In my MS-Access2000 Database i gave the password protection in exclusive mode. But I unable to Open the databse my code is Code: con.provider="Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Admin.mdb;Persist Security Info=False; Password= ***RESOVED***VB 6 Connect to a Secured Access DB, Workgroup file not found. - Hello out there I am connection to a Secured Access Database using VB6 and I always get the following error (err.number = -2147217843), err.Description "Cannot start your applocation. The workgroup information file is missing or opened exclusively by another user". Not Connection String vs Password - Hi guys Below is my current connection string code VB Code: Set db = New ADODB.Connection db.CursorLocation = adUseClient db.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\SPCPD_DATA\SPCPD.mdb;Persist Security Info=False" I cannot access Error login in SQL server. - I have a problem when accessing a SQL server from my VB application. Everything works fine on my test environment but when I was installing the application on the target environment I get the following error: Error #-2147217843 Login failed for user 'UserName'. NativeError: 18456 Access password gets deleted - I'm fairly sure that Microsoft hates me. Why else would I have this silly little problem that is giving me so many headaches? I use the following code (i found this example here on these boards) to compact an Access 2000 database. But it DELETES THE M.F*ING PASSWORD ! I have t (SOLVED)Trapping Errors in a loop... - Hi guys... I have a simple question to you... I have the following code: VB Code: For x= 1 To Combo.ListCount - 2 On Error GoTo ErrSec If Not NotErrcnxBTE Then Set DataBTE = New ADODB.Connection Else & |