|
I am having trouble using MSDE with VB.NET Standard. I’m trying to study the book ADO.NET Step by Step, but it’s practice file installation instructions assume I have VB Studio, which includes a servers node. The Standard edition does not include a servers node and I can’t figure out how to access the database without it.
The Standard edition does not include MSDE, so I downloaded it separately. I believe I installed it correctly, creating the VSDOTNET instance, but I have no way to check and see if it’s setup properly. If I need to add the connection manually in VB, I’m not sure what the name of my server is, or my user name and password.
I can’t be the first person who’s run into this problem. Can anyone tell me what to do? Thanks.
|
|
|
|
|
Unfortunately, MSDE does not include any tools to actually access the database. All is not lost though -- you can try either:
* .NET Enterprise Manager (web based)
* download the new MSDE (beta) which does include tools
my blog
[EDIT: the new beta does not include tools at this time, although later versions will ]
|
|
|
|
|
Or download SQL Server 2000 trial and install ONLY the tools (not the server engine). The tools don't expire...
|
|
|
|
|
I tried ASP.NET Enterprise manager, but it asked me for a user ID and password and I don't know what these are. Any ideas?
|
|
|
|
|
Did you try a username of "sa" and a blank password? Works in 90% of cases
my blog
|
|
|
|
|
Didn't work. I got some help from Kelly Martens using VNC. She was referred to me by the author of ADO.NET Step by Step, Rebecca Riordan. She configured my system properly. Hopefully it will stay fixed. I just finished a grueling VNC session with her and I'm beat. Don't think I want to risk breaking things right now. Thanks for you help anyway.
Ellison
|
|
|
|
|
This is my code in VB.Net:
Dim dirDate As Date = Now()
dirStrDate = String.Format("D:\test\{0}", dirDate.ToString("MMyy"))
If System.IO.Directory.Exists(dirStrDate) Then
Textbox1.Text = "Directory Found!"
End If Everything works on my local drive, but how do I search a network drive? If I use
dirStrDate = String.Format("K:\test\{0}", dirDate.ToString("MMyy")), it doesn't fail but nothing ever returns, even if the directory does exist on that drive.
Any help aprecciated. Thanks
|
|
|
|
|
What happens exactly and on what line. The line you have
dirStrDate = String.Format("K:\test\{0}", dirDate.ToString("MMyy"))
will return no matter what. Are you saying that your app hangs on the following line:
If System.IO.Directory.Exists(dirStrDate) Then
????
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
It looks for directory 0704 in K:\test\. Nothing ever hangs but it never finds the directory. There is an 0704 directory in K:\test\. It should find it as it does on my local drive. If I use D:\test\, then it finds the 0704 and says directory found. It acts as if I need to provide maybe my login information? I have run out of ideas.
Thanks
|
|
|
|
|
Sorry,
It does find it in VB.Net. I wrote the small app in VB.Net and it worked. The problem I am having is when I apply it to my VB.Net and ASP.Net project, it doesn't work. It never sees the network. I guess when it goes out and comes back, I somehow need it to see my network. Any suggestions??
Thanks
|
|
|
|
|
You never mentioned anything about ASP.NET. It won't work because the account that the ASP.NET process is running under doesn't have any rights to the network, nor does it even get drive mappings. You need to use an account that has rights to the network shares your trying to get to.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Is anybody familiar with this error?
An unhandled exception of type 'System.OutOfMemoryException' occurred in system.drawing.dll
I have two applications that contain the following code:
imgThumbNail = Image.FromFile(strFiles(intCounter))
One applications works perfectly but the other generates the error above.
Does anybody have any idea what is causing this?
Thanks
Brad
|
|
|
|
|
Without seeing the rest of your code, it's impossible to say. Since your loading Icon files, you may be ownerdrawing something? The first thing I'd check for is making sure you're explicitly disposing an Graphics objects that your using.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Here is the sub that I'm using:
Public Sub AddThumbnails()<br />
<br />
Dim strFiles() As String<br />
Dim intCounter As Integer = 0<br />
Dim intTotalFiles As Integer = 0<br />
Dim imgThumbNail As Image<br />
<br />
Dim imgcallback As Image.GetThumbnailImageAbort = New Image.GetThumbnailImageAbort(AddressOf ThumbCallback)<br />
<br />
strFiles = System.IO.Directory.GetFiles("C:\Test1")<br />
intTotalFiles = strFiles.GetLength(0)<br />
<br />
If intTotalFiles = 0 Then<br />
Exit Sub<br />
End If<br />
<br />
Me.lvPics.LargeImageList = ilPicts<br />
Me.ilPicts.ImageSize = New Size(96, 96)<br />
<br />
ilPicts.Images.Clear()<br />
lvPics.Items.Clear()<br />
<br />
Do Until intCounter = intTotalFiles<br />
imgThumbNail = Image.FromFile(strFiles(intCounter))<br />
ilPicts.Images.Add(imgThumbNail.GetThumbnailImage(96, 96, imgcallback, System.IntPtr.Zero))<br />
lvPics.Items.Add(strFiles(intCounter), intCounter)<br />
intCounter = intCounter + 1<br />
<br />
Loop<br />
<br />
End Sub
I’m clearing my controls. Do I need to do more?
Thanks
Brad
|
|
|
|
|
I’ve added imgThumbNail = Nothing at the end of my loop and still no luck.
The error is being generated in the first loop so I guess that clearing the image won't matter anyway.
Brad
|
|
|
|
|
From MSDN:
If the file does not have a valid image format or if GDI+ does not support the pixel format of the file, this method throws an OutOfMemoryException exception.
|
|
|
|
|
Thanks.
I discovered that the images in the directory that I was trying to read were link files (image.jpg.lnk).
I'm trying to solve the problem by trimming off the lnk...
newFileName = file.Name.Replace(".lnk", "")
...and rewrite my path string to go to the file location where the actual jpg lives...
newFilePath = filePath.Replace("Original String", "New String")
I'm still working on that second part... It is complicated by the fact that the Original String is never the same and part of it is used to create the New String . But I think I can figure it out...
Thanks again!
Brad
|
|
|
|
|
Hi,
I am trying to open a web page from my desktop application.
There is any way to pass login credentials (user,password,domain) to the web browser object, so the user don't have to type each time this details?
Thanks,
Wizard_NZ
|
|
|
|
|
1. i am having an openfiledialog. I want the openfiledialog function as opening some file. The file name is abc.vb. We can't open any other file anymore. The filename is already fixed. How to check whether the file I open is abc.vb? Before I am exit the openfiledialog, check will be done to ensure the filename is abc.vb. I have used the filter and filename, but we still can open other files. I don't want it to open other files. Please help me.
2. How to get the startup directory of the windows service? I have used the Environment.Directory, it doesn't work. It will return C:\Windows\System32\.
I try to use Application.StartupPath(), it doesn't work for windows service, it only work for windows application. How to solve it?
Thanks for your idea. Your idea is highly appreciated.
Information is for sharing. Human's idea should be highly appreciated.
|
|
|
|
|
Re:OpenFileDialog
What s the problem in using as follows
Private Sub OpenFileDialog1_FileOk(ByVal sender As System.Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles OpenFileDialog1.FileOk
If Not Me.OpenFileDialog1.FileName.ToLower.EndsWith("abc.vb") Then
MessageBox.Show("You cannot open this file")
e.Cancel = True
End If
End Sub
|
|
|
|
|
mythinky wrote:
2. How to get the startup directory of the windows service? I have used the Environment.Directory, it doesn't work. It will return C:\Windows\System32\.
Try Application.ExecutablePath . This will give you the complete path to the .EXE that started your app. Just remove the filename from the end of what's returned.
Imports System.IO
.
.
.
Dim path As String
path = Application.ExecutablePath()
path = path.SubString(1, path.LastIndexOf(Path.DirectorySeparatorChar))
This should return the complete path to the executable (not including the filename) appended with the path seperator character ( \ ).
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I am trying to develop a simple Hello world program for PocketPC when i test it in PocketPC Emulator it works just fine but when i try tu Run it on my PocketPC - the real one, it fails!
Am I doing something wrong is there anything that I should know?????
soni_xiao
|
|
|
|
|
This question really belongs in the Embedded/Mobil Forum.
But, did you install the .NET Compact Framework (same version as your dev environment) on the Pocket PC?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I think that when I press run (F5) in visual studio dev env it automatically deploys .net CF to PocketPC. at least it does so in emulator.
Thanks anyway
|
|
|
|
|
Hi. I am working on a project which involves one server and many remote apps accessing its features.(A cyber classroom). I have a problem that when i receive a picture from the sever through remoting, i am unable to display it due to some serialization problem. Secondly i am stuck in remoting events. I want a remote event which is broadcasted to all subscribers when fired. If someone could help me, i would be greatley thankful.
|
|
|
|