|
Hi all, ok, as the subject stated, I am trying to make my form link up to a Ms Access file that is password protected. I tried linking using oledbdataadaper1 on a un-protected MS Access file and it works fine, I can access the inside DB and all. But when I put a password into that Access File, I cannot get my form to link up to it.
It came out a message saying 'Test connection failed because of an error initializing provider'. I put the username as Admin and the password I put in for the Access file, but still this error... Anyone have any idea where I went wrong.? Thanz..
|
|
|
|
|
In the connection string, you have to supply a User Id, Password, and possibly the System Database path that holds the workgroup security information. I really can't tell you for sure because I stopped using Access for all of my database work years ago.
Just a little sample:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyDb.mdb;Jet OLEDB:System Database=C:\MySystemDB.mdw"
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hmm, didn't really help there since I am using the oledbdataadapter wizard to link to my MS Access file.. Anyone else who got any idea to my situation..? Thanz anyway, Dave.
P.S :- You mentioned that u are not using Access years ago... What are you using now to keep your data and all.. Can it be password protected? If so, I might want to look into it...
|
|
|
|
|
icowa wrote:
What are you using now to keep your data and all
He might be using SQL Server.
icowa wrote:
Can it be password protected?
You can use a combination of user name and password to access the data.
<italic>Work hard, Work effectively.
|
|
|
|
|
If your using the Wizard to generate the OleDb code, then I think you're out of luck using a password protected Access database. I found the code the Wizards generated to much of a pain to maintain, so I would HIGHLY recommend writing the code by hand. It's much easier to maintain, by FAR, much easier to ask questions about in the forums, much easier to debug, and it gives you much greater control over how your code runs.
I use MSDE and SQL Server. Both of which has security FAR better than anything you'll find in Access.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
mmm, I was afraid you'll say that. The part about vb.net not being able to access a password protected Access file. Yea, I read a lot of PDF files on this sql but not a one of them is very intuitive on how you go and create a SQL Db and accessing it and providing it with password and all. Thats what made me go and figure out on Access on the first place.
Since I search throughout the net before and not having much luck, do you know of any sites or maybe you have any PDF files that is good in teaching u on SQL. Preferably with good DIY step by step instructions... Thanz
|
|
|
|
|
icowa wrote:
The part about vb.net not being able to access a password protected Access file.
I didn't say it couldn't access a password protected Access file. I said it wasn't supportable in the forums because the Wizard is completely visual. It's FAR easier to deal with code that is hand written then it is to deal with the stuff that the Wizard generates.
icowa wrote:
Since I search throughout the net before and not having much luck, do you know of any sites or maybe you have any PDF files that is good in teaching u on SQL. Preferably with good DIY step by step instructions
I don't have anything. I taught myself SQL Server straight out of the Administrators manuals.
There's no such thing as adding a single password to an SQL Server database. Each SQL Server can maintain it's own users and groups. You can give each user/group rights to specific databases, tables, procedures, ... Right down to even who can execute which procedures and who can can cannot read/write whatever tables in the databases.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
|
No, you learn how to write the code yourself instead of having a Wizard mess it up for you.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Is there no one who can help me on this area?
|
|
|
|
|
You said the database is password protected. How is it protected?
In Access there are 2 ways to protect a database. 1 is by setting the database password (this will simply prompt for a password when you try to open the db), the other is by setting up users and using a workgroup database to store this info.
How you access the DB in code will depend on which method used.
Jon
|
|
|
|
|
My password protection for the MS Access file is the one you have to key in whenever u open the file..
|
|
|
|
|
icowa wrote:
Is there no one who can help me on this area?
Have patience. You got an initial reply in 4 hours and you posted this after 8 hours. That isn't too bad considering how much this service is costing you (i.e. nothing). Everyone who responds here are volunteers. If you need a fast solution to your problem then you can always open a support incident with Microsoft.
Anyway, to your problem. First, try not to use the wizards - if you feel you must, at least look at the code they generate. You can look at the code the wizard generates and modify the connection string. Dave already suggested one. You can find more examples at http://www.connectionstrings.com/[^]
My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
|
|
|
|
|
 I completely forgot about that site!
Thanks Colin!
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
How do I take a string that a user typed into my app and run it as code or use it to call a function within the form (like a scripting engine). Im trying to make a 3D Turtle Graphics Engine from scratch. The code will be calls to functions like "forward(10)" and needs to pass the variables. I have everything except for the string-->code part...
Thanks in advance!
|
|
|
|
|
Since the .NET Framework doesn't know anything about the Turtle graphics language, you don't have anyting to compile. You'll have to write the virtual machine and interpreter to understand your Turtle language. You have to interpret the statements and maintain your virtual machines state as you step through the program.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
im going to use a bitmap as the back, and just make a group of functions to control it. i want the string>script to call functions and pass variables.
|
|
|
|
|
What you really want is to parse the code entered, and run your internal code in response to it.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Like Christian said, that's the biggest part of the virtual machine you're going to have to write.
You need two things, really. You need a parser to translate the written code into soemthing that your virtual machine can run, otherwise known as a compiler. And, you need to write a virtual machine that will take this compiled code, and execute it, on instruction at a time. This virtual machine will maintain its own "memory", call stack, and display.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I have a lot of objects to create and I am wondering if I can build them with a parameter.
I set 2 examples below with my Account and a Contact object's Data property. Can I have a parameter passed in during object instantiation that is the object type use this boiler plate for all of my classes?
I don't know if there is such a thing as a class Template or Class Macro or Parameritized Class animal that I can use.
Thanks for taking the time to look at the code.
William
'' Get the object with this ID. If it does not exist yet, try to load it
Default Public ReadOnly Property Data(ByVal id As Integer) As Account
Get
Dim obj As Account = Nothing
SyncLock Me
If (m_odict.Contains(id)) Then
obj = CType(m_odict(id), Account)
m_olastaccessed(id) = DateTime.Now
Else
obj = New Account
obj.ID = id
If (obj.Load()) Then
m_odict.Add(obj.ID, obj)
m_olastaccessed.Add(obj.ID, DateTime.Now)
Else
obj = Nothing
m_odict.Add(id, Nothing)
m_olastaccessed.Add(id, DateTime.Now)
End If
End If
End SyncLock
Data = obj
End Get
End Property
'' Get the object with this ID. If it does not exist yet, try to load it
Default Public ReadOnly Property Data(ByVal id As Integer) As Contact
Get
Dim obj As Contact = Nothing
SyncLock Me
If (m_odict.Contains(id)) Then
obj = CType(m_odict(id), Contact)
m_olastaccessed(id) = DateTime.Now
Else
obj = New Contact
obj.ID = id
If (obj.Load()) Then
m_odict.Add(obj.ID, obj)
m_olastaccessed.Add(obj.ID, DateTime.Now)
Else
obj = Nothing
m_odict.Add(id, Nothing)
m_olastaccessed.Add(id, DateTime.Now)
End If
End If
End SyncLock
Data = obj
End Get
End Property
|
|
|
|
|
Templates are a new C# feature in VS.Net 2005. I honestly don't know if they will be in VB.NET
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Hey guys, having a brain fart today.... need to set a double click event on a panel object.
HELP!!!
|
|
|
|
|
Nevermind.......
|
|
|
|
|
I am creating an Inventory Management Application, and am having some trouble with DataRows...
Scenario:
There are 3 possible types of "inventory" items that can be created; blank, finished, and coated. A blank produces a finished, which in turn can produce a coated item.
When the items are being created, they are created blank, then finished, then coated. As they are created, I save the information from the form using a Datarow, which is created by calling the inventory tables .NewRow function. So, in 1 possible scenario, I create a blank, a finished, and then 1 coated item.
My problem is that for some reason, the datarow created for the blank is being corrupted when I call .NewRow to create the datarow for the coated item. The blank row seems to "shadow" the newly created coated row; the blank row's data is all set to DBNull, and then when I setup the data for the new coated item, the blank item gets that data as well.
After I create the new rows, I'm storing the data in a structure for each type of item that has a datarow member and a long member.
What's really weird, is the fact that the blank row is created first, but it is corrupted by a .NewRow call for a COATED item, however the Finished Item is always fine. Furthermore, if I create 3 coated items, then the blank, and all coated items get reset by each successive call to create a new coated item.
I guess my question is how could a .NewRow call affect another DataRow?
Please help. I need to find out a possible cause for the .NewRow affecting other rows, I'm not concerned with someone looking at my code, I just really need to know if anyone has run accross anything similar, what their problem was, so I can try and understand, and possibly look for the same problem in my code.
Thanks in advance for any help!
Thanks,
Jake
|
|
|
|
|
I’m reading several lines from a txt file into an array then loading that array into a comboBox. It appears that somewhere along the way a special character is being inserted where ever there was a carriage return in the txt file. Doses anybody know anything about this?
I seem to remember seeing somewhere that this was a glitch in Split function.
Thanks
Brad
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
