473,242 Members | 1,312 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,242 software developers and data experts.

URGENT | VB.Net | Access DB connectivity

Hey,

I'm facing a very strange problem.
We have a windows application being maintained in CVS (not VSS!!!! and i
hate it! but nevertheless....)
Within this application, we are connecting to an MS Access database, using
the connection string:
PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath & ";Password=" &
strDBPassword
where strDBPath and strDBPassword are being picked up from the config file.
Now the project builds alright on all the machines, save for one, where
we're getting the following error:
"No Error Information Available : VB.NET DB_SEC_E_AUTH_FAILED(0x80040E4D)"
This is pretty strange, as due to this error, no form is opening up in the
design mode.

Has anyone faced a similar problem???
Tried searching on Google, but there again, it generally comes in when ppl
have used very large excessive connection strings, and merely changing the
connection string to the version that I am using has rectified the problem in
almmost all cases that i browsed through.
Any pointers gladly appreciated

Cheers!
Nick
Aug 10 '05 #1
2 3092
On Wed, 10 Aug 2005 00:56:04 -0700, "Nick" <Ni**@discussions.microsoft.com> wrote:

Hey,

I'm facing a very strange problem.
We have a windows application being maintained in CVS (not VSS!!!! and i
hate it! but nevertheless....)
Within this application, we are connecting to an MS Access database, using
the connection string:
PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath & ";Password=" &
strDBPassword
where strDBPath and strDBPassword are being picked up from the config file.
Now the project builds alright on all the machines, save for one, where
we're getting the following error:
"No Error Information Available : VB.NET DB_SEC_E_AUTH_FAILED(0x80040E4D)"
This is pretty strange, as due to this error, no form is opening up in the
design mode.

Has anyone faced a similar problem???
Tried searching on Google, but there again, it generally comes in when ppl
have used very large excessive connection strings, and merely changing the
connection string to the version that I am using has rectified the problem in
almmost all cases that i browsed through.
Any pointers gladly appreciated

If that is your actual connection string then the syntax is incorrect when using a database
password:

http://www.carlprothman.net/Default....orMicrosoftJet
Paul
~~~~
Microsoft MVP (Visual Basic)
Aug 10 '05 #2
Gee thanks Paul for pointing that out!
I was as yet using a DB without a password and that conn string was working
fine.
When i tried using it with a password enabled DB, it couldn't connect. Used
one of the connection strings in that link.

Cheers!
Nick

"Paul Clement" wrote:
On Wed, 10 Aug 2005 00:56:04 -0700, "Nick" <Ni**@discussions.microsoft.com> wrote:

¤ Hey,
¤
¤ I'm facing a very strange problem.
¤ We have a windows application being maintained in CVS (not VSS!!!! and i
¤ hate it! but nevertheless....)
¤ Within this application, we are connecting to an MS Access database, using
¤ the connection string:
¤ PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath & ";Password=" &
¤ strDBPassword
¤ where strDBPath and strDBPassword are being picked up from the config file.
¤ Now the project builds alright on all the machines, save for one, where
¤ we're getting the following error:
¤ "No Error Information Available : VB.NET DB_SEC_E_AUTH_FAILED(0x80040E4D)"
¤ This is pretty strange, as due to this error, no form is opening up in the
¤ design mode.
¤
¤ Has anyone faced a similar problem???
¤ Tried searching on Google, but there again, it generally comes in when ppl
¤ have used very large excessive connection strings, and merely changing the
¤ connection string to the version that I am using has rectified the problem in
¤ almmost all cases that i browsed through.
¤ Any pointers gladly appreciated

If that is your actual connection string then the syntax is incorrect when using a database
password:

http://www.carlprothman.net/Default....orMicrosoftJet
Paul
~~~~
Microsoft MVP (Visual Basic)

Aug 10 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

15
by: uphid | last post by:
I've been tossing around an idea here in the shop for a while, and I am curious if anyone else out there would be interested. I am thinking of creating a server implementation for Access MDBs....
9
by: Tony Lee | last post by:
Some time a ago, on this newsgroup the following comments were made in recommending good references for Access (2003) >I used to recommend Dr. Rick Dobson's, "Programming Access <version>" for...
10
by: Preston Crawford | last post by:
I'm looking to learn ASP.NET better and thinking about helping my church put together a website in order to do this. They need the help, I'd like the training, so I'm thinking of going this route...
2
by: Nick | last post by:
Hey, I'm facing a very strange problem. We have a windows application being maintained in CVS (not VSS!!!! and i hate it! but nevertheless....) Within this application, we are connecting to an...
4
by: VB Programmer | last post by:
When I run my ASP.NET 2.0 web app on my dev machine it works perfect. When I precomile it to my web deployment project and then copy the debug files to my web server I get this problem when trying...
5
by: Nathan Given | last post by:
Hello All, I've been struggling on and off for 3 months trying to connect to an DB2 database running on an IBM iSeries machine. I FINALLY figured out how to connect with Coldfusion (see...
1
by: mai wurd | last post by:
Client has three workstations on a workgroup P2P w/folders shared to provide Access DB connectivity. One workstation needs to be RO and the others update the data throughout the day. I set up users...
0
by: raylopez99 | last post by:
10 years ago, the below was written (see very end, after my signature RL). What, if anything, has changed? I have Access 2003 and soon Access 2007 on a Windows XP Professional or Windows...
0
by: justSteve | last post by:
I'm working with a .sln that has 2 projects...one has db connectivity, the other is intended to call methods of the db-connected project. This isn't a formal 'DAL' situation but it's along those...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, youll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.