|
Hi DD!
Management studio is a separate download. Go here[^]
Hope this helps.
[Mod]
But see discussion below before deciding.
[/Mod] Last modified: 2hrs 27mins after originally posted --
Honi soit qui mal y pongs - Evil to he who thinks it stinks
|
|
|
|
|
That's the wrong version of SQL Server. Dalek Dave has SQL Server 2008 express. If he uses that then there will be features he cannot use because the tools don't match the database engine. Also, there are issues with mismatched tools and installation order.
|
|
|
|
|
Thanks for that. I wasn't aware of any issues re installation order.
It is the Management Studio that I use and it seems to work OK with SQLExpress 2005 and SQLExpress 2008. As to missing features, I cannot comment as this is the first version of the manager that I have used in earnest, although I had the manager for 2005 installed previously.
When I downloaded it I chose that one because it did not have a version number in the name, i.e. it was not labelled SQLExpress Manager 2005, or whatever.
When I installed it it complained because I had 2005 Manager installed, so I uninstalled 2005 version and it installed OK. As I said earlier it looks to me as though it works fine, although I am no expert, as you can probably tell.
Honi soit qui mal y pongs - Evil to he who thinks it stinks
|
|
|
|
|
Henry Minute wrote: It is the Management Studio that I use and it seems to work OK with SQLExpress 2005 and SQLExpress 2008.
If it is already installed it will do up to a point. The Enterprise Manager (from SQL Server 2000) will also work (up to a lesser point), however you don't get the benefit of any new features or improvements. The biggest improvement is Management Studio 2008 supports Intellisense. But there are improvements to do with additional features of the database engine, e.g. Spatial Query support
The main issue with installation order is that two versions of Management studio clash. Especially if you have the version of SQL Server 2005 Express that came with Visual Studio 2008 because not many people realised it silently installed it if you just went with the default install. That particular version seems to cause endless problems if it comes into contact with SQL Server 2008 express (or even the developer edition)
|
|
|
|
|
OK.
You are quite right, as was your original post, which I have now read with more care.
I guess that I got over-excited at the thought that I could actually help somebody.
Sorry! Won't do it again. Honest.
Honi soit qui mal y pongs - Evil to he who thinks it stinks
|
|
|
|
|
Henry Minute wrote: Won't do it again
I little over exuberance never hurt.
|
|
|
|
|
Further looking around and reading is due over the next few days!
------------------------------------
"The greatest tragedy in mankind's entire history may be the hijacking of morality by religion"
Arthur C Clarke
|
|
|
|
|
im really stuck , i want to get the cover art of current song playing in itunes and simply display the image. using the itunes lib dll.
i been able to get the current track name and info like that(text) ...so my references are correct ect but i can get the cover image.
i have found this vb 6 script that doesnt work just gives errors
iTunes play event
Private Sub iTunes_OnPlayerPlayEvent(ByVal iTrack As Variant)
‘Find the current track
Set Track = iTunes.CurrentTrack
Dim Art1 As iTunesLib.IITArtworkCollection
Dim Art2 As iTunesLib.IITArtwork
Set Art1 = Track.Artwork
If Art1.Count > 0 Then
Set Art2 = Art1.Item(1)
Art2.SaveArtworkToFile ("C:\art\" & Track.Artist & " - " & Track.Album & ".jpg")
Open "C:\art\config.txt" For Output As #5
Print #5, Track.Artist & " - " & Track.Album
Close #5
End If
End Sub
has anyone got this working , all i need is a simple example to help me get on . Any help would be great .
thanks
luke
|
|
|
|
|
did you get this working? i'd like to see how you accomplished this!
|
|
|
|
|
hi I need help I am very need the source code to generate barcode by any font in (vb6)
thanks for any body can help me
|
|
|
|
|
|
Im suppose to have an app where it will compare two folders, Folder A and Folder B. It will check whether files in folder A are in folder B. If the file in folder A are not in folder B, it will display the name of the files that are not in folder B. This is the coding that i manage to do.. But nothing happen when i click the button check.. PLsss sumbody help me..
Private Sub btncheck_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btncheck.Click
Dim di1 As DirectoryInfo = New DirectoryInfo(txtdir1.Text) ' Folder A
Dim di2 As DirectoryInfo = New DirectoryInfo(txtdir2.Text) ' Folder B
Try
Dim dirs1 As FileSystemInfo() = di1.GetDirectories
Dim dirs2 As FileSystemInfo() = di2.GetDirectories
Dim d1, d2 As DirectoryInfo
Dim i As Integer
For i = 0 To dirs1.Length - 1
For Each d1 In dirs1
Dim f1 As FileInfo() = d1.GetFiles()
For Each d2 In dirs2
Dim f2 As FileInfo() = d2.GetFiles()
If d1.Name = d2.Name Then
Else
Console.WriteLine(d1.Name)
End If
Next
Next
Next
Catch ex As Exception
End Try
End Sub
Private Sub btndirectory_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btndirectory.Click
Dim folderopen As New FolderBrowserDialog
With folderopen
.RootFolder = Environment.SpecialFolder.Desktop
.SelectedPath = "C:\DOCUMENT"
.Description = "Select the source directory"
If .ShowDialog = Windows.Forms.DialogResult.OK Then
' Display the selected folder if the user clicked on the OK button.
MessageBox.Show(.SelectedPath)
txtdir1.Text = .SelectedPath
End If
End With
End Sub
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
lbldate.Text = Now.ToLongDateString
End Sub
Private Sub btndirectory2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim folderopen As New FolderBrowserDialog
With folderopen
.RootFolder = Environment.SpecialFolder.Desktop
.SelectedPath = "C:\DOCUMENT"
.Description = "Select the source directory"
If .ShowDialog = Windows.Forms.DialogResult.OK Then
' Display the selected folder if the user clicked on the OK button.
MessageBox.Show(.SelectedPath)
txtdir2.Text = .SelectedPath
End If
End With
End Sub
|
|
|
|
|
zaimah wrote: Catch ex As Exception
End Try
Great. First you throw away all available information about possible exceptions, and then
you ask the CP community what goes wrong in your program.
NEVER ignore exceptions the way you did. Log them, print them to the console, count them, whatever
but don't let them go unnoticed.
|
|
|
|
|
shame on me iv just put MsgBox(ex.Message) between Catch ex As Exception and End Try.. but still nothing happen.. i know my question sound a bit stupid.. im new in this.. and thanks a lot for the reply
|
|
|
|
|
OK, now start debugging, i.e. either add some output statements so you can see what is going on,
or use single-stepping and watch the values.
how many entries are in dirs1 and dirs2?
you are aware you are comparing two folders assuming they contain just 1 level of subfolders and no
files at the toplevel?
strange code:
Why is there a for i loop?
what is the use of f1 and f2? you assign a value to them but never use them? all you do is compare the names of the subfolders!
modified on Saturday, January 3, 2009 8:03 AM
|
|
|
|
|
actually i have to compare lots of folder.. like this, there are 280 folder under customers id.. each of the customers folder, there are files .. we have to compare source folder with the folder in portal.. with this prgm, to make sure that we know which r the files in the source have not been copied.. so i will choose one customer's folder the source and the portal... the folder only hv 1 level subfolder.. i hv tried to put sum outpt statements.. when i put console.write"Hello" after Try, it doesnt display "Hello", but if i put MsgBox("Hello") after Try the msg box came out. When i put msgbox inside For Each d1 in dirs1, nothing come out.. so it must be sum thing wrong with my For Each statements.. and one more thing, why console.write doesn't work? and the i loop is actually i want it to compare with all the files in the source folder.. lets say the source have 14 files and the portal only got 10.. it must check all 14 between all 10 files in portal.. when i test it with the output staments, i put out the i loop.. bcoz im afraid it will effect the output.. iv just notice about the unused f1 and f2.. thanks
|
|
|
|
|
Hi,
as I said before, your code does not make much sense: i, f1 and f2 are assigned a value but never used.
zaimah wrote: When i put msgbox inside For Each d1 in dirs1, nothing come out
maybe dirs1 is empty so the foreach gets skipped.
|
|
|
|
|
i have throw the i, f1 and f2.. the possibility for the folder is empty is there, but i tried with folder level 1,2 and 3.. still nothing come out... if f1 n f2 is not there anymore, logically if i put
For Each d1 In dirs
MsgBox("Hello") <-- at least it will execute this command to display the word. but nothing come out.
if i, f1 and f2 is out of the coding, what is the possibility of error in my coding? is there sum thing wrong with the coding? or is there sum thing wrong with me?
|
|
|
|
|
Hi,
I suggest you add Console.WriteLine statements to watch intermediate values, or you single-step in the
debugger and watch how things evolve.
|
|
|
|
|
I manage to correct my coding... but there's another problems appear... two main directories that is dirA and dirB.. dirA have 3 folders and it is the main source.. must compare with dirB.. where if in dirA hv folder name ASB01,BP001 and CP001. And each of the folder hv files. I have to compare dirA with dirB where it suppose to display which folder and files in dirA are not in dirB. But when i did this coding, it only compare the first folder, and display the files that are not in dirB. When it comes to the next folder, it didnt compare, it display all the files in dirA. Example if dirA have folder ASB01 with files C4001, C4002 and folder BP001. Meanwhile dirB have folder ASB01 with files C4001 only. It will display ASB001/C4002, and all the files and other folder than ASB001. Iv been trying to find the problems..
Try
Dim dA1, dB1 As DirectoryInfo
Dim dirA2 As FileSystemInfo() = dirA1.GetDirectories
Dim dirB2 As FileSystemInfo() = dirB1.GetDirectories
For Each dA1 In dirA2
For Each dB1 In dirB2
If dA1.Name = dB1.Name Then
Dim dA2, dB2 As FileSystemInfo
Dim dirA3 As FileSystemInfo() = dA1.GetFileSystemInfos
Dim dirB3 As FileSystemInfo() = dB1.GetFileSystemInfos
For Each dA2 In dirA3
For Each dB2 In dirB3
If dA2.Name = dB2.Name Then
Else
ListBox1.Items.Add(dA2.FullName)
End If
Next dB2
Next dA2
Else
ListBox1.Items.Add(dA2.FullName)
End If
Next dB1
Next dA1
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub
|
|
|
|
|
Hi,
there are many mistakes, I'll name a few:
1.
zaimah wrote: MsgBox(ex.Message)
IMO it is a bad idea to ignore all but the message of an exception;
ex.ToString() offers the mesage, the stack traceback and extra information such as the file name in case a file I/O problem occurs. That should be interesting.
2.
zaimah wrote: For Each dA2 In dirA3
For Each dB2 In dirB3
If dA2.Name = dB2.Name Then
Else
The else will execute many times, say dirA3 contains X+Y+Z and dirB3 contains K+L+M+N,
then each file in dirA3 will be shown 4 times just because there are 4 items in dirB3.
That cannot be what you want.
3.
What you seem to be trying is some kind of backup utility, finding files that exist in dirA but not
in dirB. To do so, you don't need to enumerate the files in dirB, all it takes is enumerate the files
in dirA and check existence of the corresponding file in dirB, hence come up with the fullname
the file would have in dirB and test File.Exists().
That will cost you the calculation of the fullnames, and it saves you the nested for loops
(and the multiple firing of the else problem, see 2).
Two more comments:
A. the general solution needs recursion, that would be able to cope with an arbitrary hierarchy of
files and folders.
B. you can ask GetFiles/GetFolder/... to work recursively for you, hiding all the nested-folder stuff,
with one caveat: it then returns many more items (always as full path names) all at once, possibly leading to out-of-memory (or memory low) problems. It could be fine for a small part of a disk or partition,
but it would NOT be the way to go for backing up an entire disk (which could hold millions of files)!
|
|
|
|
|
Thanks for the explaination.. It really helps me understand the problems. iv got a few helps from friends and this are the new coding that i did. but still it keeps on repeating the name of the files..
Dim folderALocation As String = txtdir1.Text
Dim folderBLocation As String = txtdir2.Text
'Get all files in Folder A including those found in sub directories
Dim folderAFiles() As String = System.IO.Directory.GetFiles
(folderALocation, "*.*", IO.SearchOption.AllDirectories)
'Enumerate through the string array and determine if each file exists within Folder B
For Each fileName As String In folderAFiles
If System.IO.File.Exists(fileName.Replace(folderALocation,
folderBLocation)) = False Then
ListBox1.Items.Add(fileName)
End If
Next
|
|
|
|
|
Hi,
I see you made real progress.
I ran your code and it works fine under ideal conditions, i.e. when:
- both textboxes contain absolute paths
- both paths end on backslash, or none of them do
- both paths point to local partitions
Otherwise things will or may go wrong. You should program more defensively, i.e. either reject or fix bad input.
Minor remarks:
1. string.Replace replaces all occurences so it could happen that your destination gets damaged,
assume textbox1="a" and textbox2="b", now all characters a will get replaced in filenames and extensions. The better approach is to compute filename2 as folderBlocation followed by the
tail of filename (all but the first N chars where N=folderAlocation.Length)
2. it still may go wrong when you enter the path in a way that is valid but not the standard way,
e.g. when there are aliases (could happen with networked drives) or double dots (..\folder) since GetFiles would return a so-called canonical path, not necessarily the way you specified it.
3. I would replace "...Exists = false ..." by "Not Exists..."
4. I would use "*" as a filter instead of "*.*" (non-Windows file systems don't enforce a dot when there
is no extension, so you would never see those files)
|
|
|
|
|
This is my folder.. dirA and dirB is on my desktop. I will click folder FTP and PORTAL for txtdir1.Text and txtdir2.Text
\FTP
\ASB01
C4201
C4432
\BP001
C4186
C4187
C4190
C4191
\BRT01
C4192
C4209
C4212
\PORTAL
\ASB01
C4201
\BP001
C4186
C4187
And the output comeout is
C:\Documents and Settings\Desktop\FTP\ASB01\C4432
C:\Documents and Settings\Desktop\FTP\BP001\C4186
C:\Documents and Settings\Desktop\FTP\BP001\C4187
C:\Documents and Settings\Desktop\FTP\BP001\C4187
C:\Documents and Settings\Desktop\FTP\BP001\C4190
C:\Documents and Settings\Desktop\FTP\BP001\C4191
C:\Documents and Settings\Desktop\FTP\BP001\C4191
C:\Documents and Settings\Desktop\FTP\BRT01\C4192
C:\Documents and Settings\Desktop\FTP\BRT01\C4209
C:\Documents and Settings\Desktop\FTP\BRT01\C4212
C:\Documents and Settings\Desktop\FTP\BP001\C4187
C:\Documents and Settings\Desktop\FTP\BP001\C4191
C:\Documents and Settings\Desktop\FTP\ASB01\C4432
1. and i dont understand ur remarks number 1. Can u pls explain details?
Maybe bcoz im new in this programming, thats why i dont fully
understand ur explaination.
2. Remarks number 3, does it means change ".Exists = false" to
".Exists = true" ?
3. I have change "*.*" with "*" but still nothing happen..
Sorry for my stupid question
|
|
|
|
|
Hi,
1.
if File.Exists(file)=False then can/should be written as if NOT File.Exists(file) then , that is what I meant, this is not a mistake just a comment on style.
2.
I guess you are using relative paths, your text boxes just contain FTP and PORTAL, instead of
C:\Documents and Settings\Desktop\FTP and C:\Documents and Settings\Desktop\PORTAL
Now assume one of your files inside FTP is ...\FTP\FTP1.DAT , then String.Replace("FTP", "PORTAL") would turn that into ...\PORTAL\PORTAL1.DAT which is not what you intend;
Replace does not care about folders and filenames, it just eagerly replaces.
That is way I suggested not using Replace, but performing a string concatenation; this only
works if the paths are absolute, i.e. the thing to be replaced starts at the first character
(replace C:\Documents and Settings\Desktop\FTP by C:\Documents and Settings\Desktop\PORTAL)
3.
a general debugging rule:
as long as your code does not behave the way you want, split a more complex line in multiple lines and
watch the intermediate values, like so:
...
dim filename2 as string=filename.Replace(AFolder,BFolder)
Console.WriteLine("--- Going to look if this exists: "&filename2)
if not File.Exists(filename2) then
...
That way you will see whether or not you are checking the right filenames, or are having some
trouble with paths and/or replace issues.
Of course you can use myListBox.Add() or whatever you prefer to see intermediate values...
listing them to a console or listbox is much easier than watching them through debug commands
or through MessageBox.Show statements (they get irritating pretty soon).
4.
your code ran fine with me when the textboxes contained "H:\someFolder\" and "H:\someFolderCopy\";
it discovered 2 files missing out of several thousand.
|
|
|
|
|