|
Why do you think so? That connection string is not for SQL Server, it's for Access.
---
b { font-weight: normal; }
|
|
|
|
|
i have tried it b4 and it's really not for access, in the first place setting password to an access database does not require username..and if u use the password with the username, it will juz prompt an invalid password.. it's alright, thanks anyway : )
|
|
|
|
|
Try this for your connection string:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\path\myDB.mdb;Jet OLEDB:Database Password=myPassword"
If the database is located in the application folder, you could use:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "\myDB.mdb;Jet OLEDB:Database Password=myPassword"
Steve
|
|
|
|
|
I always put my database inside the bin or in a folder inside the bin..
i'll try your connection string, thanks!
-Kai
|
|
|
|
|
If your DB is in the bin folder you could use:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "\bin\myDB.mdb;Jet OLEDB:Database Password=myPassword"
This will be ok during development but when you deploy your app this connection string will not work unless you install your DB to a bin folder under your app folder. Most likely you will need to change it at the deployment stage to:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "\myDB.mdb;Jet OLEDB:Database Password=myPassword"
...if the DB is installed to the app folder. Otherwise you will have to change the 'Data Source=' to point to the actual folder that contains your back-end DB.
Steve
|
|
|
|
|
Steve! i've tried your connection string and it worked! Thanks a lot man! now i dont have to worry about my database being vulnerable..!
Thanks for the help!
-Kai
|
|
|
|
|
Great! Pleased to help.
Be aware that Access databases are not that secure. A utility available on the Internet for about $45.00 can break the pasword protection.
Access DB's are great for doing a lot of things but if security is a real issue, you would be better to choose SQL Server or another more secure database model.
Steve
|
|
|
|
|
Hello
I am trying to bind a Date Time Picker to a "Date/Time" field in an Access database.
1st of all I tried to bind the DateTimePicker with the "Value" property and that didn't work so I tried to bind the date to a text box and that didn't work.
The error I keep getting is:-
System.ArgumentException
Cannot Bind to property or column TheDate on DataSource.
Any Ideas
Many Thanks
The FOZ
|
|
|
|
|
hi all
this is what i plan to impliment. create a media server with some videos. develop an application to select the file and view it. i would be implimenting it on my college network. i do not plan to use media streaming.
i would need help on the following:
1. how do i get the media player up and running? does it have the functions to connect to the database and fetch the file?
2. whats the best way to impliment the database. should i keep an index in a databse like SQL or access?
regards
Vineet
|
|
|
|
|
media files are big, so I wouldn't use a database to store the files, just store paths to the files on the file system. Then, your media player can connect to the actual files over the networ, all you need to do is tell it where to look.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Hello, I'm using VB.NET 2005, I am trying to use the Internet Transfer Control to load a web page source into a rich text box and then index all the words into a SQL database, but when I tell the Internet Transfer Control to open a URL it gives the following error
Exception from HRESULT: 0x800A8BA8
The URL comes from a text box, when I press a button.
I would be very grateful for any help
Thanks
Aaron
|
|
|
|
|
I have a multi-threaded webserver core written in VB.NET. I have gotten it to parse headers, send HTML Documents, etc...
But whenever i send images they show as an X or corrupted...i was thinking i wasnt sending or reading in the right mode...but i read in binary to a byte array and i send as a byte array so im very confused...
You can view my current source code here:
http://prdownloads.sourceforge.net/caedo/CaedoHTTPd.rar?download
it would greatly appreciate help, so i can finish porting my webserver to .net and further advance the possibilities.
If you can help, please reply asap!
|
|
|
|
|
hellow to all
i am drawing a graphics object on a picture box , when i click a button , i see the shapes , but after i move to other form the shapes fade away ,
is there any way to solve this problem ? , i think i am missing a line of command , that save the image ,
thx for anyhelp ..
|
|
|
|
|
You can't just draw things on the screen, and expect them to get magically attached to the control that happens to be at the location where you draw. You have to catch the draw event of the control and use that to draw the graphics.
---
b { font-weight: normal; }
|
|
|
|
|
|
Inherit from the control and override the OnPaint method, or make an event delegate and add to the Paint event.
---
b { font-weight: normal; }
|
|
|
|
|
can u provide me with link how to apply this method ?
|
|
|
|
|
I build a web based aplication useing shdocview (axwebBrowserobj1 -- internet explorer control). using mshtml class (mshtml.tlb) i can manipulate my html page,..
but then i have difficulties about how to make VB.NET cature HTML event (like some button (input type button) onclick event ,.. to execute my vb.net procedure.
any body have idea,... plz help,..
|
|
|
|
|
I'm working on a project that needs to search a database - one particular field of the database actually and find the record that contains the searched text in that field. If not found display a message box that states that then go load another form to add the record that isn't there. I don't want to use classes if possible. Is this possible with VB6?
Steve Smith
|
|
|
|
|
oh yea, this database table has an index as well - I never did figure out how to utilize that index. I'm familiar with clipper but haven't done anything with a database in vb6 yet.
Thanks again
Steve
|
|
|
|
|
Hi there. I have the following problem:
I need to make a control that has an irregular shape. So far so good - I have no problem drawing it using something like this:
Private Sub TabPage4_Paint(ByVal sender As Object, ByVal e As System.Windows.Forms.PaintEventArgs)
Handles TabPage4.Paint
Dim myPointArray As Point() = {New Point(50, 50), New Point(100, 120), New Point(140, 100)}
Dim MyGraphics As Graphics = e.Graphics
Dim MyPen As New Pen(Color.Azure, 2)
Dim mySolidBrush As New SolidBrush(Color.Aqua)
myGraphics.DrawClosedCurve(myPen, myPointArray)
MyGraphics.FillClosedCurve(mySolidBrush, myPointArray)
End Sub
So now I have drawn part of the control. The problem comes when I try to raise an event regarding the irregular shape I've drawn, not the ractangle containing it.
Can anyone help me with an idea, or maybe a hole new different approach to make such a control?
|
|
|
|
|
I need to build a program that does inventory. Then a form to subtract that inventory from what is on hand noting a account number or a name. can anyone help me. If it isnt one thing it is something else. I am new to VB.net, so i am still learning.
thanks!
steve
|
|
|
|
|
Hi. Everyone is still learning If you need to make an inventory program, you will almost certainly need to make a database. The first thing is to choose your DBMS (DataBase Management System) and take it from there. After you're done with the database, it's not so difficult to make that form. I could send you some samples if you like.
Best regards.
|
|
|
|
|
So i guess i need to create the tables in access and go from there? I want it to subtract the inventory once i put the account number that it goes with. Is that possible. I am using visual Basic .net
|
|
|
|
|
Just start from build the database then you'll find out what you gonna do next.
|
|
|
|