I haven't done this myself, but from other posts made here...
As I understand it, Windows 7 has a 32bit widgit and a 64bit widgit for ODBC. Others have found that you need to be sure to use the 32bit ODBC widgit for this.
Thanks for the tip - I can well believe that there're 32 bit and 64 bit widgets. Any idea where I might find them and be sure I'm using the right one?
Incidentally, I forgot to mention earlier that when I go to the ODBC Data Source Administrator via the control panel, and try to add a new System DNS, I'm only being offered SQL Server and SQL Server Native Client in the driver list.
I am going by a far from perfect memory, but I think the ODBC Data Source Adminstrator is the widgit that comes in 32 and 64 bit forms. I haven't done this myself so I could easily be wrong and don't know how you pull up the two different versions...
I managed to find the odbcad32.exe in the SysWOW64 folder which let me create a System DNS.
I haven't succeeded, though, in establishing a connection - probably because I don't have the connection string right. I'm not sure what format it's supposed to be in.
Also, I'm not sure that I've managed to properly share the database - it's still not showing up in the list of "Currently Open Files" on the ODBC dialog box even though it's clearly open.
Thanks for the help, though - much appreciated.