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