Visual Basic

27-Jul-05 5:45

Hello!

I don't know how to connect to SqlServer when this server is not in the localmachine.
I'm using VB.Net and the server can only be joined on the internet.

My connect string looks this :

Cnx.ConnectionString = "Integrated Security=SSPI;Initial Catalog=name_of_my_base; Data Source=name_of_my_machine"

The computer where the server is running can be reached by a domaine name

Thank you for your help (and sorry for my bad english)

SeLoRBIS

toxcct27-Jul-05 6:07

toxcct

27-Jul-05 6:07

did you try directly with the IP Address of the SQL Server into the connection string ?

moreover, isn't the sql server based on a machine hidden on a sub-network (private IP) without any NAT server ?

SeLoRBIS wrote:
sorry for my bad english

no problem, as we still understand you... Poke tongue | ;-P

and welcome on CodeProject (the best programming site ever) Mr Selorbis :-> Cool | :cool:

TOXCCT >>> GEII power
[toxcct][VisualCalc]

SeLoRBIS27-Jul-05 6:25

27-Jul-05 6:25

I've tried this ! and it doesn't work !

the machine is directly connected to the internet , a DNS server resolves the IP !

SeLoRBIS

toxcct27-Jul-05 20:28

toxcct

27-Jul-05 20:28

maybe you could ask this on the SQL forum[^] if no one knows here...

TOXCCT >>> GEII power
[toxcct][VisualCalc]

SeLoRBIS28-Jul-05 1:19

28-Jul-05 1:19

toxcct wrote:
maybe you could ask this on the SQL forum[^] if no one knows here...

Thank you Toxcct I'm going to this forum for ask my question !

SeLoRBIS

Rizwan Bashir27-Jul-05 21:50

Rizwan Bashir

27-Jul-05 21:50

Hye
Use this connection string.
"user id=sa;password=xyz;initial catalog=Mydata;data source=Server_IP_Address;Connect Timeout=5"

I hope this will work. Second thing go to command prompt and confirm the server availability by ping command. once you started pinging the server you will get connected.

Regards
Rizwan Bashir

SeLoRBIS27-Jul-05 22:27

27-Jul-05 22:27

That's what i did but i didn't put "Connect Timeout=5".
can you explain a bit more what this adds ?

Thank You Wink | ;)

SeLoRBIS

Rizwan Bashir28-Jul-05 1:19

Rizwan Bashir

28-Jul-05 1:19

check this site... in dot net section connection over IP

http://www.connectionstrings.com/[^]

SeLoRBIS28-Jul-05 4:00

Re: Validating XML in VB.NET

28-Jul-05 4:00

I think , your URL is what i needed but i don't understand that :

SQLServer / SqlConnection (.NET) / Connect via an IP address:

"Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"
(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))

Could you explain me what is it exactly ?

Thank you

So it isn't running better but thank you for the link .
I think , the probleme come from my sql server install

SeLoRBIS

Validating XML in VB.NET

Anonymous27-Jul-05 4:17

Anonymous

27-Jul-05 4:17

Hi all,

Is there a way to validate an XML file in VB.NET. For instance, a user can import a file into my application. And my application will read the XML and perform some action on it. How can I make sure that the selected XML file is valid (contains valid elements)? Is there some way to compare a DTD in code?

Any guidance would be appreciated.

Thanks!

Briga27-Jul-05 4:36

Re: Validating XML in VB.NET

27-Jul-05 4:36

try to have a look at the XMLValidatingReader class in the .net framework. it does what you need

HiH
Briga

Anonymous27-Jul-05 5:15

Anonymous

27-Jul-05 5:15

Thanks!

fail to save new ATL ActiveX control on VB6 form page

Amos.A27-Jul-05 3:51

Amos.A

27-Jul-05 3:51

I have build an activeX controller in ATL VC++ that uses a window and shows camera captured frames, it works well in VisualC environment.
In Visual Basic 6, however, When I tried to integrate the control into a project, it was loaded ok but when I tried to save or run the project, I got a system Error
&H80004005 (-2147467259).

When I tried the same under .net environment, this problem didn't appear.

DO you have any idea what can be the problem or how can I debug it ?

Thanks
Amos.A

Strange IO.Directory.Move behavior

Brad Fackrell27-Jul-05 3:44

Brad Fackrell

27-Jul-05 3:44

Can anybody tell me why the code below would execute IO.Directory.Move and then re-create the original folder name?

Private Sub renameFolder()
   Dim Prompt As String
   Dim oldFolderName As String
   Dim folderName As String
   Dim selectedPath As String
   Dim newPath As String

   selectedPath = TreeView1.SelectedNode.FullPath ' get the full path of the selected node
   oldFolderName = TreeView1.SelectedNode.Text ' get the name of the selectd node
   Prompt = "Enter the new name for: " & oldFolderName ' ask for the new folder name
   folderName = InputBox(Prompt, "Rename Folder", oldFolderName) ' load the name into the variable 'folderName'
   newPath = selectedPath.Replace(oldFolderName, folderName) ' build the new path by replacing the old name with the new
   IO.Directory.Move(selectedPath, newPath) ' remove the old directory
   TreeView1.SelectedNode.Parent.Nodes.Add(folderName) ' add the new folder to the treeView
   TreeView1.SelectedNode.Remove() ' remove the old node from the tree
End Sub

Let me explain what is happening; When I step through this code with the debugger it seems to execute perfectly. After IO.Directory.Move(selectedPath, newPath) executes, the old folder is gone and the and the new folder is present.

The problem is that as the debugger exits Private Sub renameFolder() the old folder re-appears. At this point the new folder and the old folder are present.

Thanks
Brad

pcmcia card insertion detection

Briga27-Jul-05 3:30

Re: pcmcia card insertion detection

27-Jul-05 3:30

Hi,
i'm wondering how to "catch" when a pcmcia card (specifically a GSM modem) is inserted. I couldn't find anything in the .net framework documentation.
Any clue on how to do it?

Thanks
Briga

Briga27-Jul-05 4:28

Transparency within MDI application

27-Jul-05 4:28

after days of search (but few minutes from this post) I managed to get to it.
Just override the wndproc and filter the WM_DEVICECHANGE message.

Smile | :)

oakleaf27-Jul-05 3:19

oakleaf

27-Jul-05 3:19

I am having a problem building a menu bar. My mdi parent loads a child form anchored to the left and top within the form load. This is to be my menu bar. Originally the client wanted the buttons on the menu bar (total of 6 buttons) to produce a submenu under the last button in the menu. The submenu would of course have options for whatever main menu button was clicked.

Now the client (now being several stages into development) would like the submenu (6 seperate panel controls populated with link controls) to appear to the right of the main menu item that was clicked.

Not a problem I thought... I had to extend the width of the menu bar to accomodate the width of the submenu and move them around a bit.

BUT now if there are other child windows open when the submenu appears, they are covered by the background of the main menu.

I tried making the bg of the mainmenu transparent, but then the desktop, not the MDI parent bg is visible.

So I created a transparent .gif, made that the backgroundimage for the mainmenu and got the same result as above.

Do I have to repaint the MDI Parent BG?

Has anyone ran into something similar?

All I want is the submenu to appear without the BG accompanying it.

Sorry for the long post, but it is about as best as I can explain it.

Re: Transparency within MDI application

oakleaf27-Jul-05 5:00

oakleaf

27-Jul-05 5:00

Beginning to think that this is not possible.

If I apply transparency to a MDI child, the same region within the parent form also becomes transparent (desktop visible).

Re: Transparency within MDI application

oakleaf27-Jul-05 7:30

oakleaf

27-Jul-05 7:30

OK so here was my way around it. Just never mind about transparency...

Used an owned form instead. Unsure | :~

At the form level:
Public WithEvents subnav As New System.Windows.Forms.Form

and within the load event of my main menu:

<br />
'add the owned form to the MDI parent<br />
F1.AddOwnedForm(subnav)<br />
'a little config<br />
        subnav.FormBorderStyle = FormBorderStyle.None<br />
        subnav.Text = ""<br />
        subnav.Width = 150<br />
        subnav.Height = 100<br />
'moves it to the extreme right of the main menu<br />
        subnav.Left = nav.Panel1.Width<br />
<br />
        subnav.Top = 100<br />
        subnav.BackColor = Color.AliceBlue<br />

And in the main menu buttons:

<br />
'Adds the existing panel from the main menu.<br />
'This kept me from having to move code and controls etc...<br />
        subnav.Controls.Add(nav.Panel2)<br />
<br />
        subnav.Controls.Item(0).Visible = True<br />
        subnav.Controls.Item(0).Left = 0<br />
        subnav.Controls.Item(0).Top = 0<br />
        subnav.Show()<br />

There are probly better ways to do this, but....
It works. And the link control events within the added panels still behave as they should. Again, without rewriting or copying and pasting...

help on event handling

bspro27-Jul-05 3:15

bspro

27-Jul-05 3:15

i need urgent help on my project.. i need to browse for an exe and add a new menu item. i want to run that exe by clicking that menuitem... pls help... i cant find a way to handle the event..iam not able to pass arguments to the event handler.. pls help me.....!!! thanks

Re: help on event handling

Briga27-Jul-05 3:42