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