Re: Oracle Connection with SQLDataSource will fail
Jun 18, 2010 12:40 PM|nareshguree23@gmail.com|LINK
did you test your connection string in sqldatasource.
you can use like
Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=Hera)(PORT=1525))) (CONNECT_DATA=(SERVER=SHARED)(SERVICE_NAME=BRB)));User Id=aaaa;Password=pwd;
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:
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:
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
bladepit
Contributor
7260 Points
1902 Posts
Re: Oracle Connection with SQLDataSource will fail
Jun 18, 2010 12:40 PM|nareshguree23@gmail.com|LINK
did you test your connection string in sqldatasource.
you can use like
Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=Hera)(PORT=1525))) (CONNECT_DATA=(SERVER=SHARED)(SERVICE_NAME=BRB)));User Id=aaaa;Password=pwd;
check your tnsnames.ora file
happy coding
None
0 Points
9 Posts
Re: Oracle Connection with SQLDataSource will fail
Jun 18, 2010 03:24 PM|bladepit|LINK
Hello,
i dont unterstand you. In my first post i have use this connection string.
the data source in my tnsnames work cause in my c# code i use this.