Please Help with access database read only exception!!

Question

0.00/5 (No votes)

See more:

I have a fairly simple but large access database but once I load it to my project it either crashes Visual studio.net or errors when the adapter is added.

The error is connectionstring is read only?

I have tried everything and looked every where to find out how to change the connection string so that it is not read only but have come up with nothing but frustration and dead ends

wont anyone please help?

I have tried to add a sql database but I get a error which reads something about the database is not compatible up to server 2008 or something even after installing visual net 2008 and the sp1 update.

Im completely out of ideas

the line my adapter adds to the load event is

VB

Me.MD5_Virus_DatabaseTableAdapter.Fill(Me.Virus_Signature_Database_beDataSet.MD5_Virus_Database)

and the line that it errors on is:

VB

Settings3.Virus_Signature_Database_beConnectionString = resources.GetString("Settings3.Virus_Signature_Database_beConnectionString")

and:

VB

Settings4.Virus_Signature_Database_beConnectionString = resources.GetString("Settings4.Virus_Signature_Database_beConnectionString")

thank you very much if your able to point out my errors
:)

Posted 29-Jan-12 1:28am

Dale 2012

Updated 29-Jan-12 1:39am

Amir Mahfoozi

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sander Rossel · Accepted Answer · 2012-01-29T02:06:00

Solution 1

Kind of hard to tell If we don't know what Settings3 and 4 is. However, if you hover over Settings3/4.Virus_Signature_Database_beConnectionString, right click and in the context menu click 'Go to definition' you'll probably find something that looks like this:

VB

Public ReadOnly Property Virus_Signature_Database_beConnectionString As String
   Get
      Return _someVar
      ' possibly Return _someConnection.ConnectionString
   End Get
End Property

As you can see this Property has no Setter, this means you can not change the value of _someVar outside your Class (unless there is some other Property or Method that alters it).
You should either change the Property so that it can be set (deleting the ReadOnly keyword and adding the Setter), or find another method that can change it.
Perhaps you should look for something like: Settings3.Connection.ConnectionString.

Good luck and I hope it helps!

Posted 29-Jan-12 2:06am

Sander Rossel

Comments

Dale 2012 29-Jan-12 17:59pm

You are bang on the money with this but once I fix the section you say I get a new error white message:

Resource was of type 'Microsoft.VSDesigner.VSDesignerPackage.SerializableConnectionString' instead of String - call GetObject instead.

Please Help Im pulling my hair out over this thing.

thank you if you can and if you cant please let me know what else I can tell you to solve this issue.

Sander Rossel 29-Jan-12 18:14pm

Are you sure your property is of type String?
Perhaps you would need something like:
Public Property Virus_Signature_Database_beConnectionString As Microsoft.VSDesigner.VSDesignerPackage.SerializableConnectionString

Don't know if that makes any sense, because I have no idea what it's talking about... :s

Dale 2012 29-Jan-12 19:13pm

Maybe this might give you some insight as to the problem im having

<global.system.configuration.applicationscopedsettingattribute(), _
="" global.system.diagnostics.debuggernonusercodeattribute(),="" global.system.configuration.specialsettingattribute(global.system.configuration.specialsetting.connectionstring)=""> _
Public Property Virus_Signature_Database_be___CopyConnectionString() As String
Get
Return CType(Me("Virus_Signature_Database_be___CopyConnectionString"), String)
End Get
Set(value As String)

End Set
End Property

Sander Rossel 29-Jan-12 19:17pm

This code looks very weird an unreadable... Sorry to tell you this, but you really need to use some more readable names. What does Me(stringParam) do? And why are you casting the result to a String? And what do you need the Attribute for? Why haven't you implemented the setter?...

Dale 2012 29-Jan-12 19:23pm

This is all form generated code not anything I have done. the code is in my settings designer and was generated when I added my access database to my project. sounds lame to ask but what is the setter?

Sander Rossel 29-Jan-12 19:26pm

Set(value As String)

End Set
That's the setter... And if it is empty you can assign values to your property all you want, but nothing will happen. Furthermore if it is designer generated it will be foolish to edit it since the next time you generate whatever it is you are generating all your edits will be gone.
I suggest you get a book or read an article and learn the basics of VB... Working with Properties and implementing them properly is such a basic skill that I, nor anyone, could help you with your problem until you understand what it is you're doing...

Dale 2012 29-Jan-12 19:41pm

ok so besides going back to the drawing board once more and reading for hours more is there any other advise you may give?

Dale 2012 29-Jan-12 19:41pm

I know your right but it seems to be such a simple error holding me back at this point

Sander Rossel 30-Jan-12 2:38am

If you know how to work with your tools then probably the error is very simple indeed. It might be as simple as setting another Property or setting a Property of a Property. However, as you seem to have no idea how Properties work, let alone how the tool you work with works, there is no way for me to even begin telling you what to do.
I wish you good luck however, and if you have any problems don't hesitate to ask.

Dale 2012 30-Jan-12 7:12am

Hey thanks I figured out that error and now face this one lol

The ConnectionString property has not been initialized.

and the line of code is

Me.CRC32_Virus_DatabaseTableAdapter.Fill(Me._Virus_Signature_Database_be___CopyDataSet.CRC32_Virus_Database)

and also:

Me.MD5_Virus_DatabaseTableAdapter.Fill(Me._Virus_Signature_Database_be___CopyDataSet.MD5_Virus_Database)

The CRC32 is a table adapter and so is the MD5 virus database. I know the error is because I need to open the connection but I do not know how. I am a very visual learner and even though I want nothing more than to learn I understand somewhat of the terms but grasp it better for the long term if I can see it and also do it for myself. Long story short how can I open my database connection for access database? thanks in advance

Sander Rossel 30-Jan-12 13:46pm

Me.CRC32_Virus_DatabaseTableAdapter.Connection.Open?

Dale 2012 29-Jan-12 19:14pm

Im not sure this helps but if it does im waiting patiently to hear your response

thank you so much for what you have contributed thus far