Setup ODBC problem using SQL Express
I have install Microsoft Visual C# Express Editon 2005 from MSDN site. I have follow this step
. | Uninstall beta versions Before installing, youmustuninstall any previous versions of SQL Server 2005, Visual Studio 2005, and the .NET Framework 2.0. |
2. | Download and install Download and install Visual C# 2005 Express Edition!! Note: Having network issues or need to burn a CD for offline installation? Follow themanual installation instructions. |
3. | Register Why register? You’ll need to get your registration key. Additionally, you’ll get a lot of free stuff including royalty-free images from Corbis, online training from Microsoft Learning, E-books from Microsoft Press and more. Learn more aboutregistration benefits. |
before that i also insatl IIS from windows service pack 2
My problem starting when I'm trying to enable connection to the database with setup the ODBC my step
1.Start>>Control Panel>>Administrative Tools>>Data Sources(ODBC)
2.System DSN>>Add
3.Select>>SQL Server>>Finish
4.Put Name:>>>Choose Server:>>>Next
5.Select>>>With SQL Server authenticationusing a ID and password enter by user>>>Connect to SQL Server>>>put Login ID:sa>>>Next
6. Test Data Source
7.Error
Connection failed:
SQL State:'01000'
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect( )).
Connection faild:
SQL State:'08001'
SQL Server Error: 7
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.
Please help me step by step. I'm using C# to build application that can pullout data from card using chip like smartcard or chip based card. The data then save to database in SQL. Using Macromedia I'm build a website that can publish the data to web site. My mission to set up my CPU as Server using SQL Server. I'm build all my project in the same CPU with the server.
tq.
