I have Oracle 10g installed in my laptop. I have currently inserted a Gridview and in this Gridview when i choose "Oracle Database" as my Data Source, I come across a form where I have to fill out the server name, username, and password. I do not know what
to give for the server name as oracle 10g is installed in my machine. I have tried putting in so many names in the server name textbox but none of them are working. If I did not give the server name but only inserted the username and password, and when i
click on Test Connection, it says "Test Connection succeeded". I cannot leave the server name field blank as the OK button won't activate unless I enter something in the field.
Please guide me on what to give for the server name. Thanks
check this link on how to create connection string for oracle.
http://www.connectionstrings.com/oracle
I just checked this link and usually I leave the data source blank and the code works for insert, update and delete command. But this doesn't solve my current problem of connecting the grid view to the oracle database. I am struggling to understand what
the server name is. When I click on Advanced, the Data Source field is blank and whatever I enter in that field is the name that is enter in the server field. Appreciate your help on this. Thanks
None
0 Points
10 Posts
Connecting Gridview to Oracle database
Jul 18, 2010 04:35 AM|nsharish16|LINK
Hi,
I have Oracle 10g installed in my laptop. I have currently inserted a Gridview and in this Gridview when i choose "Oracle Database" as my Data Source, I come across a form where I have to fill out the server name, username, and password. I do not know what to give for the server name as oracle 10g is installed in my machine. I have tried putting in so many names in the server name textbox but none of them are working. If I did not give the server name but only inserted the username and password, and when i click on Test Connection, it says "Test Connection succeeded". I cannot leave the server name field blank as the OK button won't activate unless I enter something in the field.
Please guide me on what to give for the server name. Thanks
All-Star
17775 Points
3957 Posts
Re: Connecting Gridview to Oracle database
Jul 18, 2010 05:18 AM|vik20000in|LINK
check this link on how to create connection string for oracle.
http://www.connectionstrings.com/oracle
www.vikramlakhotia.com
Please mark the answer if it helped you
Contributor
6865 Points
1752 Posts
Re: Connecting Gridview to Oracle database
Jul 18, 2010 06:06 AM|SSA|LINK
Then it should be 'localhost' if thats not accepted than edit your hostfile (etc/drivers/hosts) and add one line
127.0.0.1 localhost
None
0 Points
10 Posts
Re: Connecting Gridview to Oracle database
Jul 18, 2010 01:22 PM|nsharish16|LINK
I went into my hostfile and I found out that there are two lines already:
127.0.0.1 localhost
127.0.0.1 .host
So what should I do now?
None
0 Points
10 Posts
Re: Connecting Gridview to Oracle database
Jul 18, 2010 01:32 PM|nsharish16|LINK
I just checked this link and usually I leave the data source blank and the code works for insert, update and delete command. But this doesn't solve my current problem of connecting the grid view to the oracle database. I am struggling to understand what the server name is. When I click on Advanced, the Data Source field is blank and whatever I enter in that field is the name that is enter in the server field. Appreciate your help on this. Thanks
Contributor
6865 Points
1752 Posts
Re: Connecting Gridview to Oracle database
Jul 18, 2010 01:48 PM|SSA|LINK
Then you have to configure a listner http://download.oracle.com/docs/cd/B13789_01/network.101/b10775/listenercfg.htm
Open orale enterprise manager, and add a listner. you can see steps on above link.
Member
8 Points
96 Posts
Re: Connecting Gridview to Oracle database
Jul 23, 2010 05:29 PM|phrozengorilla06|LINK
Hi,
I've had this issue before, and I can't remember how I found it the first time. But I just did a search and came across this:
select global_name from global_name;
When I put it my SQL*PLUS I got:
GLOBAL_NAME
----------------------------------------
MYDREAMH.REGRESS.RDBMS.DEV.US.ORACLE.COM
My server name is mydreamh. The user name and password is what you ususally use to log into SQL*PLUS.
Hope this helps
None
0 Points
5 Posts
Re: Connecting Gridview to Oracle database
Jul 26, 2010 06:34 AM|martin.angler|LINK
Hi nsharish16,
Did you try to insert "localhost", along with the correct port in the server name field?
Best regards,
Martin
oracle gridview