Blog

Oracle Connection with SQLDataSource will failRSS

2 replies

Last post Jun 18, 2010 03:24 PM by bladepit

‹ Previous Thread|Next Thread ›

Shortcuts

bladepit

None

0 Points

9 Posts

Oracle Connection with SQLDataSource will fail

Jun 18, 2010 11:43 AM|bladepit|LINK

Hello to everybody,

i dont know why i always beacme the error: NO SUCH HOST KNOWN.

This is my cide with the SQLDataSource and the GridView which use the SQLDataSource:

<asp:SqlDataSource ID="ProductsDataSource" runat="server"
   	 	ConnectionString="Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=xe)));User Id=HTS;Password=bhcweb;"
    	SelectCommand="SELECT * FROM TEST">
	</asp:SqlDataSource>
        

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
    DataKeyNames="CT" DataSourceID="ProductsDataSource"
    EnableViewState="False">
    <Columns>
        <asp:BoundField DataField="CT" HeaderText="CT"
            InsertVisible="False" ReadOnly="True" SortExpression="CT" />
    </Columns>
</asp:GridView>

I have posted my datas with because i think there is a problem.

In my program i use the tnsname connection but if i try this:

	<asp:SqlDataSource ID="ProductsDataSource" runat="server"
   	 	ConnectionString="Data Source=BHCDATA;User Id=HTS;Password=bhcweb;"
    	SelectCommand="SELECT * FROM TEST">
	</asp:SqlDataSource>
        
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
    DataKeyNames="CT" DataSourceID="ProductsDataSource"
    EnableViewState="False">
    <Columns>
        <asp:BoundField DataField="CT" HeaderText="CT"
            InsertVisible="False" ReadOnly="True" SortExpression="CT" />
    </Columns>
</asp:GridView>

I become this same error. I have tried my ip address and my hostname but nothing worked.

The Oralce Database is on my local machine and i am using google chrome as browser.

Have you an idea what is wrong with my connection string?

Greetz