You need to use either SQLREDIS.EXE which I think ships with SQL Server, or
you can use the ubiquitous MDAC.
You can get MDAC 2.6 from the microsoft data web site -
www.microsoft.com/data. MDAC_TYP.EXE supports switches (/Q for example)
which enable a silent install. Note with MDAC you get SQL Server/Oracle and
other ODBC drivers/OLE DB providers, as well as ADO data access layer. It
may be overkill, in which case SQLREDIS might be better (if it includes SQL
driver).
Alastair
> Thanks... I figured that portion of it out.
> The question I have now is how to install the SQL Driver itself if it is
not
> currenlty on the system at runtime.
> The problem I have is I have client license for 500 pc but I only want to
> install the ODBC driver so I can create my DSN's. I want be able to run a
> batch job on the client that will run during off hours to update all
clients
> to have the driver as well as the DSN.
> Thanks for anyhelp
> Angie Shinkle
> Aspen Medical Group
> > SQLConfigDataSource(NULL,ODBC_ADD_SYS_DSN, _T("SQL Server"),
_T("DSN=MyDb\0SERVER=(MyServer)\0Database=MyDb\0Trusted_Connection=yes\0\0"
)
> > );
> > and dont forget to include the odbc32.lib and odbccp32.lib in your
project
> > > I need to be able to do the following and am not sure how to go about
> it.
> > > Any help would be great.
> > > I need to install without any prompting on the users part a DSN to a
> SQL
> > > 7.0 Server.
> > > I do not know where to find the components for the ODBC SQL Server
> Driver
> > > either.
> > > The Sql Driver is not installed on the client.
> > > I want to:
> > > 1. Install SQL Server Driver
> > > 2. Create DSN
> > > DSN Name: mydsn
> > > Driver: SQL Server
> > > Server MYSQLSERVER
> > > Database MYDB
> > > Authentication: NT Authentication
> > > Thanks
> > > Angie Shinkle
> > > Aspen Medical Group
by