Microsoft KB Archive/820928

= You receive an &quot;SQL Server does not exist or access denied&quot; error message when you browse an ASP.NET Web page =

Article ID: 820928

Article Last Modified on 1/6/2006

-

APPLIES TO


 * Microsoft Office FrontPage 2003

-





SYMPTOMS
When you use your browser to view a database on a Web page that you created in FrontPage 2003, you receive the following error message:

Error: SQL Server does not exist or access denied.



CAUSE
This problem may occur if you use Microsoft ASP.NET version 1.0 to connect to a Data Source Name (DSN) connection to your database when you create your Web page in FrontPage 2003. DSN uses the OdbcDataAdapter to connect to a database. ASP.NET version1.0 uses the OleDbDataAdapter to connect to a database. ASP.NET version 1.0 does not support the use of the OdbcDataAdapter.



RESOLUTION
To resolve this problem, download and install ASP.NET version 1.1 on the computer that hosts the Web page, and then edit the Fpdbnet.cs file to change the database connection. ASP.NET version 1.1 includes support for the OdbcDataAdapter. To download ASP.NET version 1.1, visit the following ASP.NET Web page:

http://www.asp.net/Default.aspx?tabindex=0&tabid=1

To edit the Fpdbnet.cs file and make the required changes, follow these steps:
 * 1) Click Start, right-click My Computer, and then click Explore.
 * 2) Expand My Documents/My Web Sites/ _fpclass.
 * 3) Right-click Fpdbnet.cs, and then click Open.
 * 4) If the file does not open, in the Windows dialog box, click Select the program from a list, and then click OK.

In the Programs list, click Notepad, and then click OK.
 * 1) Click Edit, and then click Replace.
 * 2) In the Find what box, type Oledb, and in the Replace with box, type Odbc.
 * 3) Click Replace all, and then close the Replace dialog box.
 * 4) Find the three lines that say DataTable literalInfo, and then type a ; (semicolon) at the beginning of each line to prevent these lines from processing.
 * 5) In Microsoft Windows Explorer, expand My Documents/My Web Sites/ _vti_cnf, right-click the Global.asa file, and then click Edit.
 * 6) Find the appropriate database connection and copy the connection string (for example, DSN=SQLDSN;Driver={SQL Driver}).
 * 7) Click Fpdbnet.cs and find the line that says _dbConn = new OdbcConnection(strConnStr.ToString).
 * 8) Paste the database connection string that you copied from the Global.asa file in the brackets of this line so that the line now reads _dbConn = new OdbcConnection.
 * 9) Save and close Fpdbnet.cs, close Global.asa, and then quit Windows Explorer.
 * 10) Open your Web page in your browser.

You can now view the database.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Keywords: kberrmsg kbdatabase kbprb kbasp KB820928

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.