In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.
Solved
I get an error message when connecting to an access database
Posted on 2016-07-18
In vb.net, 2015- when I connect to an access database, with the following code:
Dim StnStr() As String
StnStr = "Data Source=servername; Initial Catalog=databasename; User ID=userid; Password=password"
StnStr = "Provider=MSDataShape;Data
StnStr = StnStr & "Jet OLEDB:System database=" & My.Application.Info.Direct
StnStr = StnStr & "Password=PW;User ID=USERNAME;"
StnStr = StnStr & "Data Source=" & My.Application.Info.Direct
StnStr = StnStr & "Persist Security Info=False"
Dim CON As New OleDb.OleDbConnection(StnS
CON.Open()
I receive the following error message in the output window:
The program '[3660] UpdateCrgs.vshost.exe' has exited with code -1073741819 (0xc0000005) 'Access violation'.
What can this mean?
In other projects it seems fine, why in this project am I getting this message?
Dim StnStr() As String
StnStr = "Data Source=servername; Initial Catalog=databasename; User ID=userid; Password=password"
StnStr = "Provider=MSDataShape;Data
StnStr = StnStr & "Jet OLEDB:System database=" & My.Application.Info.Direct
StnStr = StnStr & "Password=PW;User ID=USERNAME;"
StnStr = StnStr & "Data Source=" & My.Application.Info.Direct
StnStr = StnStr & "Persist Security Info=False"
Dim CON As New OleDb.OleDbConnection(StnS
CON.Open()
I receive the following error message in the output window:
The program '[3660] UpdateCrgs.vshost.exe' has exited with code -1073741819 (0xc0000005) 'Access violation'.
What can this mean?
In other projects it seems fine, why in this project am I getting this message?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
3 Comments
I'm a thinkin' this is a little hatched
StnStr = "Provider=MSDataShape;Data Provider=Microsoft.Jet.OLE
https://msdn.microsoft.com/en-us/library/ms254500(v=vs.110).aspx
Are you sure that the MSDataShape provider is in use with an .mdb data source?
And are you sure you want to carry on with that, as it seems that MS is deprecating it?
https://msdn.microsoft.com/en-us/library/ms676105(v=vs.85).aspx
StnStr = "Provider=MSDataShape;Data Provider=Microsoft.Jet.OLE
https://msdn.microsoft.com/en-us/library/ms254500(v=vs.110).aspx
Are you sure that the MSDataShape provider is in use with an .mdb data source?
And are you sure you want to carry on with that, as it seems that MS is deprecating it?
https://msdn.microsoft.com/en-us/library/ms676105(v=vs.85).aspx
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
- Microsoft Applications
- Windows OS
- Fonts Typography
- Web Browsers
- Microsoft Word
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Suggested Courses
Course of the Month10 days, 1 hour left to enroll
722 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.