Posted by Erland Sommarskog on 02/19/07 23:07

Chuck (carlos.crosetti@gmail.com) writes:
> Hi, I have installed a trial version of VC++ Express 2005 with the
> budled SQL Server. After creating a C++ Forms prototype, with some
> tables into a database file named Test1.mdb, now I want to make ODBC
> available this local database.
>
> What are the steps required to add and ODBC entry so any ODBC-capable
> program may access my prototype?
>
> I know in advance the location of the database file and log file, know
> it is local (so the server is localhost or just (local) ) and also the
> driver name and the port number.
>
> What is unknown to me is the user id and password as the installlation
> was done to auth with OS credentials.
> Could be "sa" without password?

Why can't use Windows authentication? Why would the ODBC application
log in as sa?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]