SQL Server Express with Visual C++ (visual studio 2005)

• DarthCake

  Valued Member

  Points: 69

  More actions

  December 1, 2007 at 10:59 am

  #377278

  I have set up a SQL DB in SQL Server Express which come with Visual Studio 2005, then I've set up a DSN for this DB.

  Now I try to connect to this DB in C++ with the SQL ODBC SQLConnect() command.

  This function always returns -1 (=> SQL Error).

  I have used the example code found @ http://www.codeproject.com/database/sqlconnect.asp.

  But also the example code you can find in the Visual Studio Help while performing a search for Connecting with SQLConnect.

  I'm able to connect to the DB in Visual Studio Server Explorer while using Microsoft ODBC Data Source (ODBC), also the data source name is shown in the drop down menu.

  Does someone knows what could be the problem here? Where do I have to search?

  Anything else you should need to know to help me solve this problem?