Visual Basic

Re: Problem with ADO, ADO.NET and VB.NET

12-Jul-04 13:57

No, not out-of-the-box. There may be a 3rd party addin, but I can't find one.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Steven Campbell12-Jul-04 8:11

Steven Campbell

12-Jul-04 8:11

Perhaps you should post this in the "Article Requests" forum.

my blog

MSDE and VB.NET Standard Edition

ellisonc12-Jul-04 7:25

ellisonc

12-Jul-04 7:25

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.

Steven Campbell12-Jul-04 7:35

Steven Campbell

12-Jul-04 7:35

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 ]

Carl Mercier12-Jul-04 7:51

Carl Mercier

12-Jul-04 7:51

Or download SQL Server 2000 trial and install ONLY the tools (not the server engine). The tools don't expire...

ellisonc12-Jul-04 9:39

ellisonc

12-Jul-04 9:39

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?

Steven Campbell12-Jul-04 9:56

Steven Campbell

12-Jul-04 9:56

Did you try a username of "sa" and a blank password? Works in 90% of cases Suspicious | :suss:

my blog

Accessing a network drive letter???

ellisonc12-Jul-04 11:25

ellisonc

12-Jul-04 11:25

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

Britnt712-Jul-04 5:50

Britnt7

12-Jul-04 5:50

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 Smile | :)

Dave Kreskowiak12-Jul-04 6:08

12-Jul-04 6:08

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

Britnt712-Jul-04 7:06

Britnt7

12-Jul-04 7:06

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

Britnt712-Jul-04 7:22

Britnt7

12-Jul-04 7:22

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 Smile | :)

Dave Kreskowiak12-Jul-04 10:29

System.OutOfMemoryException

12-Jul-04 10:29

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

Brad Fackrell12-Jul-04 4:44

12-Jul-04 4:44

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

Dave Kreskowiak12-Jul-04 6:04

12-Jul-04 6:04

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

Brad Fackrell12-Jul-04 6:17

12-Jul-04 6:17

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

Brad Fackrell12-Jul-04 6:56

12-Jul-04 6:56

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. Unsure | :~

Brad

beowulfagate12-Jul-04 13:46

beowulfagate

12-Jul-04 13:46

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.

Brad Fackrell13-Jul-04 7:58

OpenFileDialog and StartUpPath of Windows Service?

13-Jul-04 7:58

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... Eek! | :eek:

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... Unsure | :~

Thanks again!
Brad

Web browser credentials

wizard_nz12-Jul-04 0:09

wizard_nz

12-Jul-04 0:09

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

mythinky11-Jul-04 23:37

mythinky

11-Jul-04 23:37

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 and StartUpPath of Windows Service?

Syed Abdul Khader11-Jul-04 23:55

Syed Abdul Khader

11-Jul-04 23:55

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

Re: OpenFileDialog and StartUpPath of Windows Service?

Dave Kreskowiak12-Jul-04 6:49