[dba-SQLServer] Browsing tool?

Andy Lacey andy at minstersystems.co.uk
Thu Oct 7 12:42:04 CDT 2004


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
> 
> 
> 




More information about the dba-SQLServer mailing list