Visual Basic

10-Mar-06 1:37

I'm using VB.Net 2003.

I want to connect my client app to a SQL Server over the internet.
How do I send my connection request through the local proxy server?

The setup:

SQL Server --> Firewall -->>>>Internet<<<<-- Proxy Server <-- Client App

The neccesary port forwarding has already been set up.
It's not a HTTP request that I'm looking for.

Dave Kreskowiak10-Mar-06 4:28

10-Mar-06 4:28

That depends entirely on your Proxy server, what it supports, and what it requires you to do. You're first step would be to dig up the documentation on your Proxy server. You might be looking for Socks support, if nothing else.

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

MatthysDT13-Mar-06 20:00

13-Mar-06 20:00

The documentation merely specifies the setup and installation - nothing as technical as how to formulated a SQL request.

I think it may be neccesary to wrap the SQL within a HTTP request but I have absolutely no idea on how to do that. If anyone maybe knows about a site with alot of info on HTTP requests it could help me a great deal.

Dave Kreskowiak14-Mar-06 1:12

14-Mar-06 1:12

You're not looking for anything about formulating an SQL Request. You're looking for how to connect to an outside host by specifying an IP Address and port number.

You can't wrap an SQL in an HTTP blanket unless the SQL Server supports it. If not, you're wassting your time because the server will never respond since it wasn't listening on port 80, or any other port, for a web request.

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

MatthysDT14-Mar-06 1:41

14-Mar-06 1:41

Dave Kreskowiak wrote:
You're not looking for anything about formulating an SQL Request. You're looking for how to connect to an outside host by specifying an IP Address and port number.

I know how to specify the IP and port to connect to but I have to connect to the proxy first because I can't connect directly to the remote IP, the proxy blocks it. How do I inform the proxy, after connecting to it, what my remote IP:PORT is?

In other words how do you specify multiple IP's and port numbers.
Because I have to connect to the proxy via IP:PORT but also to the remote SQL Server's
static-IP:PORT, my current connection settings only has provisions for one host address.

Dave Kreskowiak14-Mar-06 2:19

Remove duplicates from an arraylist

14-Mar-06 2:19

Some proxies require the IP and port to be specified, along with a username and password, in a special format! Some require client software to be installed on your machine. That's why you have to dig up anything you can on your proxy server. There are "standards" to these formats, about 7 or 8 of them (IIRC), but not every proxy supports every format. Without the docs on your proxy, you're pretty much screwed. How about visiting the website of the manufacturer for your proxy for more information on it???????

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

-- modified at 8:19 Tuesday 14th March, 2006

Mincy George9-Mar-06 23:15

Mincy George

9-Mar-06 23:15

Hi,
Can anyone give me a sample code to remove duplicates from an arraylist?
I have an arraylist with duplicate entry and want the distinct values from that.
Thanks in Advance

Re: Remove duplicates from an arraylist

The Man from U.N.C.L.E.9-Mar-06 23:53

The Man from U.N.C.L.E.

9-Mar-06 23:53

Private Sub RemoveDuplicates(ByRef source As System.Collections.ArrayList)
	Dim destination As New System.Collections.ArrayList
	For Each item As Object In source
		If Not destination.Contains(item) Then
			destination.Add(item)
		End If
	Next
	source = destination
End Sub

It would however be move efficient to perform the contains test on the original arraylist before inserting the items in the first place.

If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)

How to use Remote access with Sql Parameters in .net

dokhung9-Mar-06 23:12

dokhung

9-Mar-06 23:12

I have a project using remote access but program was wrong and not compile when i use an sql parameter as a variable to take data.
But i use string as variable thn program run.
help me

quang

Re: How to use Remote access with Sql Parameters in .net

Colin Angus Mackay9-Mar-06 23:47

Colin Angus Mackay

9-Mar-06 23:47

dokhung wrote:
I have a project using remote access

What do you mean by "remote access"?

dokhung wrote:
but program was wrong and not compile

What is the error message the compiler is giving?

dokhung wrote:
when i use an sql parameter as a variable to take data.
But i use string as variable thn program run.

Can you supply us with that section of code?

Your request was very vague. In order to get help you need to give us more information.

ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?

How to use mscomm1

areon259-Mar-06 22:28

areon25

9-Mar-06 22:28

hi everybody.. I have a question.. i have a problem how to communicate vb with my hardware using serial port.. can somebody help me solve my problem..

areon25

Re: How to use mscomm1

Briga10-Mar-06 0:43

Briga

10-Mar-06 0:43

You have at least two options depending which version of VS are you running:

VS2005: Use My.Computer.Ports class to access and use COMx
VS2003: You can use MSCOMM object or one of the available classes (also on this site)

With VS2005 look in the official MSDN documentation for code samples
With MSCOMM it's easier to find sample code (tons) with google
With User classes (there are at least three around) sample code is provided with them.

Briga

deleting old files

svanlier9-Mar-06 21:52

svanlier

9-Mar-06 21:52

Hello all,

I want to write a program in VB.NET that deletes all files and subdirectories, in a directory, that are 7 or more days old, I don't know how to go about it though. Does anyone know how to do this?

Thanks in advance for any advice.

Re: deleting old files

alien viper9-Mar-06 22:02

alien viper

9-Mar-06 22:02

Hi.

Use following class.

System.IO.DirectoryInfo
System.IO.FileInfo

!alien!

Re: deleting old files

Steve Pullan10-Mar-06 0:51

Steve Pullan

10-Mar-06 0:51

I am assuming that you have a non-destructive purpose for this question? (i.e. you are not trying to delete anyone else's files are you? Smile | :)

)

Before you reinvent the wheel... there are many free utilities out on the net that can do this and more. Just Google for them.

If you REALLY want to write it in code, first of all read all you can about the classes "alien viper" has already posted and understand the NTFS (or FAT32) directory structure and how it operates. There are plenty of articles on The Code Project and elsewhere on the net.

...Steve

1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once Smile | :)

(Translation: I'll show you the way, but not write the code for you.)

How do you resize the app window?

MatthysDT9-Mar-06 20:56

Send a Value in to a Parameter field from Formula fields?(Crystal report)

9-Mar-06 20:56

I'm working on an MS Access app.

The client use this app with their monitor resolution set to 800 x 600.
Whenever I edit a form I need to set my screen resolution to 800 x 600 to make sure the form is within bounds.

I wan't a fast way to set the Main Access Window's size too 800 x 600 pixels.

Application.DoCmd.MoveSize(,,800,600) is supposed to work but I get a syntax error.

Any ideas?

superdragon9-Mar-06 19:56

superdragon

9-Mar-06 19:56

Now, i have a formula, after solving some expression i want to assign a new value to a Parameter fields.
But i dont know how to do it.
Please help me!

superdragon

creating multiple webcharts based upon query ID

uglyeyes9-Mar-06 17:00

uglyeyes

9-Mar-06 17:00

Hi All,

In response to my post below, I got feedback from dave which was

FEEDBACK
**********

Performance will suffer each time you have to go back to the database to get the records you need.
Your best shot is to use a DataView on your DataTable so it returns all the records with at ID.
It's a different View of the table. DataViews can be reconfigured quickly so...

What you'd probably do is retrieve a small table with all the UNIQUE (hint, hint) ID's you're going to use,
then retrieve all the records that contain all the ID's you want in a seperate table.

Now, you'll iterate through the first table, with the ID's, and use each, one at a time,
to build a DataView on the second table that will return only the records with that ID.
You can then use the data in that DataView to bind to your control.

Dim dv As New DataView(dataTable)With dv
.AllowDelete = False
.AllowEdit = False
.AllowNew = False
.RowFilter = String.Format("ID='{0}'", idToFind)
.Sort = "CompanyName DESC"End With' Bind you control to this DataView

**********

MY POST
-------

I am using a webchart tool called Mycos ( A web control)
I create a single chart with following code:

MycosChartWeb1.DataSource = CreateData()
MycosChartWeb1.DataBind()

creating single chart is not a big deal if i have a standard query with no parameter called ID.

if createData() is of type:

Private Function CreateData() As DataSet

Dim id As String
objConn = New SqlConnection(dbPath)

cmd = New SqlCommand("select period,scorecard,actual,target from ShirePlan where measureID='2.1.1.1' and period like '%2003%' ", objConn)

'cmd = New SqlCommand("select period,scorecard,actual,target from ShirePlan where measureID='" & ID & "'", objConn)

Dim da As New SqlDataAdapter(cmd)
Dim ds As New DataSet

da.Fill(ds)
Return ds

End Function

but in my case i have ID which ranges from zero to N records.
I need to create dataset for each ID like for measureID 2.1.1.1 i need to create new dataset and bind it to mycos
again for new measureID i have to do same.
Some one told me to use Dataview and someone said something i really dont know how to achieve this

------

I actually wanted a list of datasets for each ID which i want to bind to a webcontrols. i think from what dave suggested is i will only get one
get one whole set of record

eg.

dataset1 to datasetN for ID 1 to N

where N is a number from 1 to 20

dynamically.

hope its clear and hope you will make clear how to achieve this.

thanks

Re: creating multiple webcharts based upon query ID

Dave Kreskowiak10-Mar-06 3:28