ODBC connection "tony wong" <x34[ at ]netvigator.com> 28.10.2005 11:02:56 i have setup a Access application with MsSQL server. Now i have to setup ODBC connection at each XP workstations. any better method to setup this connection at once rather than do it at each workstations? Thanks a lot. tony

Re: ODBC connection "tony wong" <x34[ at ]netvigator.com> 28.10.2005 11:50:23 i find this method in Ms KM http://support.microsoft.com/default.aspx?scid=kb;en-us;892490 any pros and cons on both methods? Thx "tony wong" <x34[ at ]netvigator.com> ¼¶¼g©ó¶l¥ó·s»D:e0w5h862FHA.268[ at ]TK2MSFTNGP10.phx.gbl... [Quoted Text] >i have setup a Access application with MsSQL server. > > Now i have to setup ODBC connection at each XP workstations. > > any better method to setup this connection at once rather than do it at > each workstations? > > Thanks a lot. > > tony >

Re: ODBC connection "tony wong" <x34[ at ]netvigator.com> 28.10.2005 12:05:52 i also have concerns about the normal user can do it (not a power user under XP rights). thx. "tony wong" <x34[ at ]netvigator.com> ¼¶¼g©ó¶l¥ó·s»D:ew1DCX72FHA.3188[ at ]TK2MSFTNGP12.phx.gbl... [Quoted Text] >i find this method in Ms KM > http://support.microsoft.com/default.aspx?scid=kb;en-us;892490 > > any pros and cons on both methods? Thx > > > "tony wong" <x34[ at ]netvigator.com> ¼¶¼g©ó¶l¥ó·s»D:e0w5h862FHA.268[ at ]TK2MSFTNGP10.phx.gbl... >>i have setup a Access application with MsSQL server. >> >> Now i have to setup ODBC connection at each XP workstations. >> >> any better method to setup this connection at once rather than do it at >> each workstations? >> >> Thanks a lot. >> >> tony >> > >

Re: ODBC connection "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 28.10.2005 22:29:15 Consider going DSN-less. Take a look at http://www.accessmvp.com/DJSteele/DSNLessLinks.html for one way to do this. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "tony wong" <x34[ at ]netvigator.com> wrote in message news:e0w5h862FHA.268[ at ]TK2MSFTNGP10.phx.gbl... [Quoted Text] >i have setup a Access application with MsSQL server. > > Now i have to setup ODBC connection at each XP workstations. > > any better method to setup this connection at once rather than do it at > each workstations? > > Thanks a lot. > > tony >

Re: ODBC connection Roland <roland[ at ]none> 30.10.2005 08:40:51 File DSNs might be just the right solution for your problem. A DSN (Data Source Name) describes the ODBC connection string. There are 3 types of DSNs: 1. System DSN (DSN may be used by all users, you need administrator priviliges to create it, DSN is stored in "all users" registry hive) 2. User DSN (DSN may only be used by current user, you only need user rights to create it, DSN is stored in "current user" registry hive) 3. File DSN (DSN may be used by all users who have access to the file, DSN is stored in a file on local disk or network share, not in registry) So if you use file DSNs, you simply copy your dsn-file into a directory on a windows share which is common to all XP workstations and reference this file in your ODBC connection string (e.g. x:\config\myapp.dsn) Of course the drive mapping for x: must be the same on all workstations. Here you will find a short description how to do this http://www.kamath.com/tutorials/tut005_filedsn.asp Hope this helps, Roland tony wong wrote: [Quoted Text] > i have setup a Access application with MsSQL server. > > Now i have to setup ODBC connection at each XP workstations. > > any better method to setup this connection at once rather than do it at each > workstations? > > Thanks a lot. > > tony > >