471,120 Members | 1,356 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,120 software developers and data experts.

adding the vc express bundled sql server to odbc

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?

Thanks in advance, Carlos

Feb 19 '07 #1
1 1421
Chuck (ca*************@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Feb 19 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by Iain | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.