Visual Basic

Dave Kreskowiak19-Sep-06 13:20

19-Sep-06 13:20

It works perfectly under XP, even if the machine hasn't been patched up in the last 6 months.

Dave Kreskowiak
Microsoft MVP - Visual Basic

K ^edar V19-Sep-06 22:34

19-Sep-06 22:34

Thanks dave to giving me the replies.
Well, The code u've given i'have paste it in new .net project and it worked fine...
But the same code if i'm using with my-application-code .. It just annoying me by giving that error "Unhandled Exception blah blah blah...."
Chk this class out.... Its working perfactly ok in test application as yours.. But when it has to work real.. it denies with that ERROR...
What could be the possible problem? that on the same platform same code behaves unbelivably? I've checked all references and i'm perfact.. the version of system.management.dll obviously thats too ok... THEN WHAT COULD IT BE ?
If this wont work atall(I'm still trying) Do i have any option to use this code eg. making a dll(for jst a little talk?)

I really thank you for the replies you are posting and taking the problem as if its urs... thanks again - kedar
Oh !! well check the code....
Public Class Win32_Printer
Public Overloads Shared Function GetPrinterList() As String()
' Local machine.
Return BuildPrinterList(Nothing)
End Function 'GetPrinterList
Public Overloads Shared Function GetPrinterList(ByVal machineName As String, ByVal userName As String, ByVal userPassword As String) As String()
Dim options As New ConnectionOptions
options.Username = userName
options.Password = userPassword
Dim path As New ManagementPath
path.Server = machineName
Dim scope As New ManagementScope(path)
scope.Options = options
' Remote machine
Return BuildPrinterList(scope)

End Function 'GetPrinterList
Private Shared Function BuildPrinterList(ByVal scope As ManagementScope)
Dim searcher As New ManagementObjectSearcher("Select * from Win32_PrintJob")
If Not scope Is Nothing Then
searcher.Scope = scope
End If
Dim list As New ArrayList
For Each obj As ManagementObject In searcher.Get()
list.Add(obj("Name").ToString())
Next obj
Return list.ToArray(GetType(String))
End Function 'BuildPrinterList
End Class

"You can do any thing you set to your mind" - theGhost_k8

Dave Kreskowiak20-Sep-06 1:57

20-Sep-06 1:57

The code works, at least on an XP machine that has SP2 on it and is patched up to about 6 months ago.

If the machine that is filling the WMI request is patched up to current levels, complete with the latest service packs, this code should work just fine on any 2000, XP, or 2003 Server machine.

Dave Kreskowiak
Microsoft MVP - Visual Basic

K ^edar V20-Sep-06 2:00

20-Sep-06 2:00

i've tried out with dll ... i mean doing the same thing in a dll
and then calling from our proj..
even that gives the error.... I'm getting hiper now...
well thanks for recognising the code....

"You can do any thing you set to your mind" - theGhost_k8

Dave Kreskowiak20-Sep-06 2:06

20-Sep-06 2:06

I doesn't matter what you put this code in, Form, DLL, library, ...

If the machine is not patched up properly, it just plain won't work. This is a known problem with Windows 2000 and XP. I already posted the links to the KB articles about it.

Dave Kreskowiak
Microsoft MVP - Visual Basic

K ^edar V20-Sep-06 2:13

20-Sep-06 2:13

yes !!! but i'm trying my luck..
as same code, same pgm ... giving diff. o/p on same machine..

"You can do any thing you set to your mind" - theGhost_k8

Dave Kreskowiak20-Sep-06 4:49

not the solution but i've got problem(possible)

20-Sep-06 4:49

I tired your code on an XP box with SP2 and it worked perfectly. It tried it on a 2003 box, and it still worked.

Your code is making some assumptions, though, which may be screwing it up. Specify the full namespace to use, don't use the defaults. Always supply a scope, don't rely on the default scope, and call Connect on it before you pass it into an ObjectSearcher and call Get on that.

Dave Kreskowiak
Microsoft MVP - Visual Basic

K ^edar V20-Sep-06 23:36

how get the last modified date of the files

20-Sep-06 23:36

Hay dave !
i've got a possible problem that might be causing the error "Unhandled exception in .....System.managent.dll"
i'm using pdf-printer to print document...
It has few events to be handled through the code in which i call save dialogbox to select the path etc..
I can give different names to that printer but events they fire are same...
This events are written in both applications and hence they both get fired when i select any of the printer to print pdf.
now what i've thought of doing is,
find printer-name and job-id combination using WMI
compare if its printer of App1 or App2
Exit App1 if its printer of App2 and vice versa

Now i've to insert this "Printer Check Code" in events that are generated from that printer only
and THAT CAUSES A PROBLEM... [i think so]
If I'm trying to get printer-job name combination to compare from printer_event then its giving ERROR
Hence i think i gotta finish it off now and just start looking at APIs for solution..
I think API can only be at my rescue.. well thanks dude u've been there always for help
well so what about API ?? (jst kiddin i'll try it .. )

"You can do any thing you set to your mind" - theGhost_k8

flickr like TAGS

navish0118-Sep-06 0:13

navish01

18-Sep-06 0:13

Hello

I would like to have TAGS option,(i.e : like they have in flickr).

i want then when submiting a document to the aplliction there the user will have to select tags, and i need to have the ability to search documents by tags and to have statisics such as most popular tags and so on.

is there a sample code or some information about how to that ?

thanks

Nav

Re: flickr like TAGS

Christian Graus18-Sep-06 0:37

Christian Graus

18-Sep-06 0:37

I'd imagine you do this by setting up your database to store tags and link them to a document in your file store.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Amit Agarrwal17-Sep-06 23:43

Amit Agarrwal

17-Sep-06 23:43

i'm getting a files from directory.
i also want to get the last modified date of the files
how can i do it.
thanx

me_vb_man17-Sep-06 23:47

17-Sep-06 23:47

Dim di As DirectoryInfo = New DirectoryInfo("C:\*.*")
Dim aFiles As Array = di.GetFiles("*.ord")

the aFiles should have all the information you need

Amit Agarrwal17-Sep-06 23:52

Amit Agarrwal

17-Sep-06 23:52

thanks for the reply
i did it..
and i'm displaying the file name in the listbox and i want to show the last modified date of the file plz tell me how can i show it along with the file name.
tahnx

me_vb_man17-Sep-06 23:55

17-Sep-06 23:55

use ListView instead of listbox so you can diaplay like windows explorer

Amit Agarrwal18-Sep-06 0:04

Amit Agarrwal

18-Sep-06 0:04

i can use only checkedlistbox control only

me_vb_man18-Sep-06 0:08

Urgent Code needed for remote database connection

18-Sep-06 0:08

Ohhh you need to customize the control to have two columns , there are a lots of custom controls on this site you have to search for it

GabrielVarun17-Sep-06 23:30

Re: Urgent Code needed for remote database connection

17-Sep-06 23:30

i am in need of a Remote database connection coding in vb.net 2003. Can Anybody help.When i tried the given coding i got error.

"Provider=sqloledb; Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs; User ID=sa; Password=asdasd;"

Error.
Cry | :((

(An unhandled exception of type "System.Data.Odbc.OdbcException" Occured in System.Data.dll

I tried with spaces removed in between(Like "UserID=sa;").But code gave the same error. So that doesnt effect much.

Please try to tell me how to connect to a remote database.

me_vb_man17-Sep-06 23:33

Re: Urgent Code needed for remote database connection

17-Sep-06 23:33

I am guessing 190.190.200.100 is the ip address and 1433 this is the port number the format should be 190.190.200.100:433

GabrielVarun17-Sep-06 23:50

Re: Urgent Code needed for remote database connection

17-Sep-06 23:50

But the server address or ip is just as i gave.

me_vb_man17-Sep-06 23:53

Re: Urgent Code needed for remote database connection

17-Sep-06 23:53

Can you post the code you are using please?

GabrielVarun18-Sep-06 0:13

Re: Urgent Code needed for remote database connection

18-Sep-06 0:13

Imports System.Data
Imports System.Data.SqlClient

Public Class Form1
Inherits System.Windows.Forms.Form

Private Sub btn1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn1.Click
Dim conn As New Odbc.OdbcConnection("Provider=MSDASQL.1;Persist Security Info=False;User ID=sa;Extended Properties=DSN=11045-flo1;UID=sa;DATABASE=callcenter11;Network Library=dbmssocn;Initial Catalog=callcenter11")
Dim datacmd As New Odbc.OdbcCommand("select fname,lname,phone from customertracking", conn)
conn.Open()
datacmd.ExecuteNonQuery()
Dim dr As Odbc.OdbcDataReader
txt1.Text = dr.Item("fname")
txt2.Text = dr.Item("lname")
txt3.Text = dr.Item("phone")
dr.Close()
End Sub
End Class
This is my complete coding in vb.net 2003.

Colin Angus Mackay18-Sep-06 0:44

Colin Angus Mackay

18-Sep-06 0:44

Is there any particular reason you are using an OdbcConnection to connect to a SQL Server? Why not use the more specific SqlConnection?

Upcoming Scottish Developers events:
* UK Security Evangelists On Tour (2nd November, Edinburgh)
* Developer Day Scotland: are you interested in speaking or attending?
My: Website | Blog

Re: Urgent Code needed for remote database connection

GabrielVarun18-Sep-06 0:58

18-Sep-06 0:58

Can you modify my code to use with sqlconnections

SOAP attachments

me_vb_man17-Sep-06 23:17