[dba-SQLServer] File extensions

Thanks Jim. There won't be any code to look at I'm sure. This is commercial
software. I just want to establish if I can extract data from it or link to
it. Thanks for the ODBC tip.

-- 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 Jim Lawrence (AccessD)
> Sent: 14 September 2004 13:49
> To: dba-sqlserver at databaseadvisors.com
> Subject: RE: [dba-SQLServer] File extensions
> 
> 
> Hi Andy:
> 
> At a station, you either check the ODBC file list. If one is 
> directed toward a MS SQL server, you probably have a SQL 
> server running. Then just scan the Access code to see how the 
> FE connects. If their app is bound, through an ODBC 
> connections, the tables and queries icons will appear quite 
> different otherwise scan the code for the word ADO.
> 
> HTH
> Jim
> 
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf 
> Of Andy Lacey
> Sent: Monday, September 13, 2004 11:49 PM
> To: dba-sqlserver at databaseadvisors.com
> Subject: [dba-SQLServer] File extensions
> 
> 
> Sent this hours ago but hasn't appeared, hence trying again  
> -  so apologies in advance when the original turns up.
> 
> Hello good people on this wet and windy Autumn evening in the UK
> 
> Simple question from a simple soul. I keep a weather eye on 
> the SQL server list but never having actually developed a SQL 
> system my question is: if I go to look at a client's existing 
> system how can I tell if it is SQL (which I think it is)? 
> Would file suffixes tell me, or can a developer call a 
> database anything he/she likes? And if the file suffixes are 
> the answer what are the magic three letters? Going on from 
> there, if I was offered the opportunity to take the data away 
> to have a look at it can I just zip up a file or two, and if 
> so what would I need in order to be able to read the data in 
> Access when I got back home?
> 
> -- 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
> 
> 
>