[dba-VB] How I'm approaching the problem

I have code that can query a database for its tables and the fields in those
tables (SQL server-specific).

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Thursday, July 19, 2007 12:33 PM
To: dba-vb at databaseadvisors.com
Subject: Re: [dba-VB] How I'm approaching the problem

I have found code to do that.  How it works I haven't a clue but once I get
it working I will show what it is.  In my case it has to be local.  Servers
out on the internet are not usable in my business.

John W. Colby
Colby Consulting
www.ColbyConsulting.com
-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Thursday, July 19, 2007 3:10 PM
To: dba-vb at databaseadvisors.com
Subject: Re: [dba-VB] How I'm approaching the problem

Hi John

How would you build a list of available server instances? 
These could in theory be spread all over the Internet not only at the
default port 1433.

If you could limit the address range and assume port 1433, you would still
need a port scanner routine to look up all on-line instances.

/gustav

>>> jwcolby at colbyconsulting.com 19-07-2007 20:42 >>>
I have a form.  On the form I have:

1) A control to specify the path to the database files.
2) A control to select a server instance.
3) A control to select a database.
4) A control to select a table.

5) A control to specify a path to the DATA files to be imported.


#2 above needs code (and a combo as the control) to select the server.

#3 above needs code and a combo as the control to select a database within
that server

#4 above needs code and a combo to select a table within that database

1 and 5 already have controls and code to select a directory.




_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com

_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.10.9/907 - Release Date: 7/18/2007
3:30 PM