Andy Lacey
andy at minstersystems.co.uk
Thu Oct 7 12:04:09 CDT 2004
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 > > >