|
|
Posted by Erland Sommarskog on 04/01/07 18:45
raylopez99 (raylopez99@yahoo.com) writes:
> Thanks Erland--right now another problem that's sprung up is
> connecting to a simple database (the same one, this time the database
> 'works' fine, but accessing it from outside the SQL language via a
> console C++ program is the problem). See thread here:
> http://tinyurl.com/3e2nz8
You have a connection string that goes:
connection->ConnectionString = "User ID=sa; Password=;"
"Data Source=(local); Initial Catalog=DCV_DB;";
But didn't you say you were using SQL Express? By default, SQL Express is
installed as a named instance with the name SQLEXPRESS, in which case the
Data Source should be: (local)\SQLEXPRESS.
Did the User ID and Password come from that book? If you want your app
to run with Integrated Security, you should use
Integrated Security=SSPI;
instead. Having sa with a blank password is extremely bad practice, and
outright dangerous if the server is exposed on the Internet.
--
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
Navigation:
[Reply to this message]
|