Visual Basic Question

Can anyone help?

[giggle]

Hi

We use a serviced office and connect to the internet via the service company's 512 ADSL connection. In our office we have a VPN and have 5 pc's connected via a switching hub to our server.

The problem is that when my VB processes run and access the SQL database (hosted in the UK - we're in Thailand!) it gobbles up their band-width and they're getting angry!

I tried putting the two processes that access the SQL database onto a machine that is connected to the VPN but also has a dial-up connection to the internet, thinking that, once connected via dial-up the processes would connect to SQL via the dial-up and therefore not use up any of the service companies band width.

Didn't work! Even though the pc is 'dialled-up' it still connected via the server!

The code I'm using to connect is:

Dim objConnection As New ADODB.Connection
Dim objRS As New ADODB.Recordset

strSQL = "SELECT * FROM newemails...."

objRS.LockType = 3
objRS.Open strSQL, "Provider=SQLOLEDB.1;Password=?;Persist Security Info=True;User ID=?;Initial Catalog=?;Data Source=?.?.?.?"

My question is (finally I hear you say), how can I force my VB to use the dial up connection?

Any ideas GREATLY appreciated.

[davester28]

Hmmm, I know Windows 2000 Server and newer has something called ... hmm... i think it's "Bandwidth throttling".. you might want to google that, and see if it may work for you.

Another thought is to modify the router table on the PC (the PC you're trying to use for Dial-up). The internal network could have routing entries only for the internal network, and therefore it would use the dial up connection for any outside web stuff.

Hope this might help a bit.
==========
Davester28