[dba-SQLServer] Browsing tool?

Andy Lacey andy at minstersystems.co.uk
Thu Oct 7 13:25:21 CDT 2004


Received and tried. Works like a charm. That's really useful Chris. Thanks
so much.

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com 
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf 
> Of Mackin, Christopher
> Sent: 07 October 2004 18:58
> To: dba-sqlserver at databaseadvisors.com
> Subject: RE: [dba-SQLServer] Browsing tool?
> 
> 
> Are you using Windows 2000 or after?  I'll send you a file 
> off-line of what the .udl should look like.
> 
> -Chris Mackin
> 
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf 
> Of Andy Lacey
> Sent: Thursday, October 07, 2004 11:42 AM
> To: dba-sqlserver at databaseadvisors.com
> Subject: RE: [dba-SQLServer] Browsing tool?
> 
> 
> Well I said I was a novice. What should the contents of this 
> .udl look like? I tried putting what I think is a valid 
> connection string, but if I double-click on it to open it I 
> get the message "File cannot be opened. Ensure it is a valid 
> data link file".
> 
> -- Andy Lacey
> http://www.minstersystems.co.uk 
> 
> > -----Original Message-----
> > From: dba-sqlserver-bounces at databaseadvisors.com
> > [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf 
> > Of Mackin, Christopher
> > Sent: 07 October 2004 18:17
> > To: dba-sqlserver at databaseadvisors.com
> > Subject: RE: [dba-SQLServer] Browsing tool?
> > 
> > 
> > It's just a file that stores a connection string.  All you do
> > is create a text file, then change the file extension from 
> > .txt to .udl. Open it up and you'll see how you do it, it's 
> > self-explanatory.
> > 
> > In ADO you can use the .udl file as the connction string as
> > an easy way to get the connection out in the filesystem so 
> > you can change it externally.  If you open the .udl in 
> > Notepad it will give you a Connection String you can use, but 
> > for what you want to do just open and test the connection and 
> > it will give you what you want.
> > 
> > -Chris
> > 
> > -----Original Message-----
> > From: dba-sqlserver-bounces at databaseadvisors.com
> > [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf
> > Of Andy Lacey
> > Sent: Thursday, October 07, 2004 11:04 AM
> > To: dba-sqlserver at databaseadvisors.com
> > Subject: RE: [dba-SQLServer] Browsing tool?
> > 
> > 
> > I'm sorry Chris but I'm a SQL Server novice and I don't
> > understand what you're suggesting. I don't know what a UDL 
> > is. And what would I test the connection with, and how?
> > 
> > -- Andy Lacey
> > http://www.minstersystems.co.uk
> > 
> > > -----Original Message-----
> > > From: dba-sqlserver-bounces at databaseadvisors.com
> > > [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf
> > > Of Mackin, Christopher
> > > Sent: 07 October 2004 14:29
> > > To: dba-sqlserver at databaseadvisors.com
> > > Subject: RE: [dba-SQLServer] Browsing tool?
> > > 
> > > 
> > > Andy,
> > > 
> > > The .udl will allow you to test the connection and will 
> let you know 
> > > if the username and password you provide (or Windows
> > > Authentication) are valid ways of connecting.
> > > 
> > > -Chris Mackin
> > > 
> > > -----Original Message-----
> > > From: dba-sqlserver-bounces at databaseadvisors.com
> > > [mailto:dba-sqlserver-bounces at databaseadvisors.com]On 
> Behalf Of Andy 
> > > Lacey
> > > Sent: Thursday, October 07, 2004 12:39 AM
> > > To: dba-sqlserver at databaseadvisors.com
> > > Subject: RE: [dba-SQLServer] Browsing tool?
> > > 
> > > 
> > > Thanks Francisco
> > > That'll help ascertain if it's Sql Server, but presumably the 
> > > database can be secured and prevent me linking to it. So I was 
> > > looking for a "browsing tool" to check whether that is 
> the case or 
> > > if I can freely get at the data.
> > > 
> > > -- Andy Lacey
> > > http://www.minstersystems.co.uk
> > > 
> > > > -----Original Message-----
> > > > From: dba-sqlserver-bounces at databaseadvisors.com
> > > > [mailto:dba-sqlserver-bounces at databaseadvisors.com] On 
> Behalf Of 
> > > > Francisco Tapia
> > > > Sent: 06 October 2004 22:36
> > > > To: dba-sqlserver at databaseadvisors.com
> > > > Subject: Re: [dba-SQLServer] Browsing tool?
> > > > 
> > > > 
> > > > Additionally the Machine that is said to have the Sql
> > Server on it,
> > > > look for a service running named: MSSQLSERVER, where the
> > executable
> > > > file name is sqlservr.exe
> > > > 
> > > > 
> > > > 
> > > > On Wed, 6 Oct 2004 14:08:24 -0600, Mackin, Christopher
> > > > <cmackin at quiznos.com> wrote:
> > > > > One simple way is to just create a text file and then
> > rename it to
> > > > > .udl.  Once you open it you can set up a connection to it
> > > using the
> > > > > avaialble Providers.
> > > > > 
> > > > > -Chris Mackin
> > > > > 
> > > > > 
> > > > > 
> > > > > -----Original Message-----
> > > > > From: dba-sqlserver-bounces at databaseadvisors.com
> > > > > [mailto:dba-sqlserver-bounces at databaseadvisors.com]On
> > > > Behalf Of Andy
> > > > > Lacey
> > > > > Sent: Wednesday, October 06, 2004 1:53 PM
> > > > > To: dba-sqlserver at databaseadvisors.com
> > > > > Subject: [dba-SQLServer] Browsing tool?
> > > > > 
> > > > > Hi folks
> > > > > 
> > > > > Next week I'm going to see a potential client (hurrah!). He
> > > > has a 3rd
> > > > > party package specific to companies in the printing
> > industry, and
> > > > > wants a simple contact management system which will link to
> > > > the client
> > > > > data in this package. I suspect (but am not sure) that
> > the package
> > > > > uses a SQL Server database. If I'm correct (and I've
> > > > already asked how
> > > > > best to see if it's SQL Server d/b, thanks for help on
> > > > that) and it is
> > > > > SQL Server then I'd like to see if I can link to it
> > > > successfully. So,
> > > > > if I start from the worst case scenario that they won't
> > have any
> > > > > software capable of linking to SQL Server does anyone have
> > > > or know of
> > > > > any free utility which will fit on a CD that I could use
> > > > just to look
> > > > > at a database, whatever the OS and whatever the SQL vintage?
> > > > > 
> > > > > -- Andy Lacey
> > > > > http://www.minstersystems.co.uk
> > > > > 
> > > > > _______________________________________________
> > > > > dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com
> > > > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > > > > http://www.databaseadvisors.com
> > > > > 
> > > > > 
> > > > > 
> > > > > _______________________________________________
> > > > > dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com
> > > > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > > > > http://www.databaseadvisors.com
> > > > > 
> > > > > 
> > > > 
> > > > 
> > > > --
> > > > -Francisco
> > > > <a href="http://pcthis.blogspot.com">Pc This! pc news 
> with out the 
> > > > jargon</a> _______________________________________________
> > > > dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com
> > > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > > > http://www.databaseadvisors.com
> > > > 
> > > > 
> > > > 
> > > 
> > > _______________________________________________
> > > dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > > http://www.databaseadvisors.com
> > > 
> > > _______________________________________________
> > > dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > > http://www.databaseadvisors.com
> > > 
> > > 
> > > 
> > 
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> > 
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> > 
> > 
> > 
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 
> 




More information about the dba-SQLServer mailing list