Format of the initialization string does not conform to specification starting at index 0.
Original thread here. I was able to get the connection to work within VWD connecting to the remote database, now I get the error bolded above.
Current .aspx page:
Current master page
web.config
There is nothing but the default data in the code behinds.
Target framework is set to .net 2.0 in VWD
SQL server 2005 database
Server 2003 with .net 2.0 (which is where the sql database is located)
I am able to connect to the database through VWD, and view the contents, but I get nothing when I 'View in Browser' or load on any page.
Help?
Original thread here. I was able to get the connection to work within VWD connecting to the remote database, now I get the error bolded above.
Current .aspx page:
Code:
<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="CLA.aspx.cs" Inherits="CLA" %>
<asp:Content ID="Content1" ContentPlaceHolderID="title" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="sitebrand" Runat="Server">
<h1>Commercial Lending</h1>
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="FormList" Runat="Server">
[B]<asp:SqlDataSource id="srcForms" SelectCommand="SELECT * From CLAdb" connectionString="LendingFormsDB" Runat="server" />
<asp:BulletedList ID="BulletedList1" runat="server"
DataSourceID="srcForms"
DataTextField="FormName"
DataValueField="FormURL"
DisplayMode="HyperLink">
</asp:BulletedList>
</asp:Content>[/B]
Current master page
Code:
<%@ Master Language="C#" AutoEventWireup="true" CodeFile="Site.master.cs" Inherits="Site" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<style type= "text/css">
/*CSS for Rollover Information*/
.popup a{position:relative;}/* set stacking context*/
.popup a span{
visibility:hidden;/* hide message initially*/
position:absolute;
top:-100px;
left:0px;
width:250px;
padding:5px;
background:#B0AE67;
color:#000;
border:2px inset #848113;
text-decoration: none;
}
.popup a:hover{visibility:visible}/* ie bug needed to make span show*/
.popup a:hover span{visibility:visible;}/* reveal image*/
/* --End of Rollover CSS -- */
</style>
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>
<asp:ContentPlaceHolder id="title" runat="server">
</asp:ContentPlaceHolder></title>
<link href="StyleSheet.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<div id="header">
<div id="sitebranding">
<asp:ContentPlaceHolder id="sitebrand" runat="server">
</asp:ContentPlaceHolder>
</div>
<div id="tagline">
<p>Pre-Closing Customer Contact Forms</p>
<div id="taglinelinks">
<a href="mailto:[email protected]">E-Mail here with Questions/Concerns</a>
</div>
</div>
</div><!--End of Header Div -->
<div id="navigation">
<ul>
<p><li><a href="ResourceCLA.html">Pre-Closing Customer Contact Forms</a></li></p>
<p><li><a href="ResourceCLB.html">Pre-Closing Backroom Forms</a></li></p>
<p><li><a href="ResourceCLC.html">Closing Documents</a></li></p>
<p><li><a href="ResourceCLD.html">Post-Closing Documents</a></li></p>
<p><li><a href="ResourceCLE.html">Form Letters</a></li></p>
<p><li><a href="ResourceCLF.html">Title and Related Documents</a></li></p>
<p><li><a href="ResourceCLG.html">Appraisals</a></li></p>
<p><li><a href="ResourceCLH.html">Repossession Kit</a></li></p>
<p><li><a href="http://intranet/BusinessConnect/eBCM.asp?filterKey=8&pageKey=9">Back to Commercial Banking Intranet</a></li></p>
</ul>
</div> <!-- end of navigation div -->
<div id="bodycontent">
<h2>Pre-Closing Customer Contact Forms</h2>
<div id="forms">
[B] <asp:ContentPlaceHolder id="FormList" runat="server">
</asp:ContentPlaceHolder>[/B]
</div><!-- End of bodycontent div -->
</form>
</body>
</html>
web.config
Code:
<?xml version="1.0"?>
<!--
Note: As an alternative to hand editing this file you can use the
web admin tool to configure settings for your application. Use
the Website->Asp.Net Configuration option in Visual Studio.
A full list of settings and comments can be found in
machine.config.comments usually located in
\Windows\Microsoft.Net\Framework\v2.x\Config
-->
<configuration>
<appSettings/>
[B]<connectionStrings>
<add name="LendingFormsDB" connectionString="Data Source=intranetdb;DataBase=LendingForms;uid=sa;pwd=123;" providerName="System.Data.SqlClient"/>
</connectionStrings>[/B]
<system.web>
<!--
Set compilation debug="true" to insert debugging
symbols into the compiled page. Because this
affects performance, set this value to true only
during development.
-->
<compilation debug="false">
</compilation>
<!--
The <authentication> section enables configuration
of the security authentication mode used by
ASP.NET to identify an incoming user.
-->
<authentication mode="Windows" />
<!--
The <customErrors> section enables configuration
of what to do if/when an unhandled error occurs
during the execution of a request. Specifically,
it enables developers to configure html error pages
to be displayed in place of a error stack trace.
<customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
<error statusCode="403" redirect="NoAccess.htm" />
<error statusCode="404" redirect="FileNotFound.htm" />
</customErrors>
-->
</system.web>
</configuration>
There is nothing but the default data in the code behinds.
Target framework is set to .net 2.0 in VWD
SQL server 2005 database
Server 2003 with .net 2.0 (which is where the sql database is located)
I am able to connect to the database through VWD, and view the contents, but I get nothing when I 'View in Browser' or load on any page.
Help?