DaniWeb Forum Index > Software Development > C++

C++ RSS

Run time error on my SQL database

Please support our C++ advertiser: Intel Parallel Studio Home

•

Join Date: Sep 2007

Posts: 185

Reputation: eranga262154 is an unknown quantity at this point

Solved Threads: 2

eranga262154 eranga262154 is offline

Offline

Junior Poster

Run time error on my SQL database

Oct 24th, 2007

Hi all,

I create a database on SQL 2005 Express edition and link it to a C++/MFC application as follows. It wont gives any compile time errors. But at run time, it gives an error. Here are details.

Link the database in OnInitDialog()

here is the code

 Help with Code Tags 
 c++ Syntax (Toggle Plain Text) 
BOOL CSRFDBDlg::OnInitDialog()
{
CDatabase srfDB ;
CString srfNAME ;
 
srfNAME = "ODBC; DSN=.SQLEXPRESS; UID=sa; PWD=sa123; DATABASE=srfdb.mdf" ;
srfDB.Open(srfNAME) ;
if(srfDB.IsOpen())
{
AfxMessageBox("ok") ;
}
 
srfDB.Close() ;
}
BOOL CSRFDBDlg::OnInitDialog()
{
CDatabase srfDB ;
CString srfNAME ;

srfNAME = "ODBC; DSN=.SQLEXPRESS; UID=sa; PWD=sa123; DATABASE=srfdb.mdf" ;
srfDB.Open(srfNAME) ;
if(srfDB.IsOpen())
{
AfxMessageBox("ok") ;
}

srfDB.Close() ;
}

Gives the following runtime error

Help with Code Tags

C++ Syntax (Toggle Plain Text)

Data source name not found and no default driver specified

Can you guys tell me where I'm going wrong....

“victory breeds hatred, the defeated live in pain; happily the peaceful live giving up victory and defeat” - Gautama Buddha

•

Join Date: Oct 2006

Posts: 2,833

Reputation: niek_e has a reputation beyond repute

Solved Threads: 297

niek_e

Offline

Roasting Maven

Re: Run time error on my SQL database

Oct 24th, 2007

hmm, are you calling that ' open' function the right way?

source: http://msdn2.microsoft.com/en-us/lib...dw(VS.80).aspx

try calling it like:

 Help with Code Tags 
 C++ Syntax (Toggle Plain Text) 
 
CDatabase srfDB ;
srfDB.Open( _T( ".SQLEXPRESS" ), FALSE,  FALSE, _T( "UID=sa; PWD=sa123; DATABASE=srfdb.mdf" ));
 
CDatabase srfDB ;
srfDB.Open( _T( ".SQLEXPRESS" ), FALSE,  FALSE, _T( "UID=sa; PWD=sa123; DATABASE=srfdb.mdf" ));

regards Niek

•

Join Date: Sep 2007

Posts: 185

Reputation: eranga262154 is an unknown quantity at this point

Solved Threads: 2

eranga262154 eranga262154 is offline

Offline

Junior Poster

Re: Run time error on my SQL database

Oct 24th, 2007

Thanks, but I got the same error on that code as well.

“victory breeds hatred, the defeated live in pain; happily the peaceful live giving up victory and defeat” - Gautama Buddha

•

Join Date: Oct 2006

Posts: 2,833

Reputation: niek_e has a reputation beyond repute

Solved Threads: 297

niek_e

Offline

Roasting Maven

Re: Run time error on my SQL database

Oct 24th, 2007

And you're sure you got the DB and DNS set up correctly?

Here's a usefull link

Regards Niek

•

Join Date: Sep 2007

Posts: 185

Reputation: eranga262154 is an unknown quantity at this point

Solved Threads: 2

eranga262154 eranga262154 is offline

Offline

Junior Poster

Re: Run time error on my SQL database

Oct 24th, 2007

Yep, I'm sure that the DNS setup is correct. At the time I've tried the SQLOLEDB.1 connection. I think it can be easy to work on OLEDB, do you have any suggestion on that?

I'm really appreciate your comments....

“victory breeds hatred, the defeated live in pain; happily the peaceful live giving up victory and defeat” - Gautama Buddha