Oracle and ASP connection

hi all,
i am trying to connect to oracle thru an ASP page ... for this i
write a code as below
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "dsn=OracleDSN;uid=userid;pwd=password;"

after this i am trying to display the rows of a table in the database

The problem is when i tried to run the ASP page on my comp which has
IIS 5.0 on it it gave me an error saying Oracle Client required but i
have Oracle Client on my system.
on second time onwards i didnot get this error at all neither i could
see something on the page (which actually should display rows) i am
getting wht is problem and wht is solution for this .

Plz help .........

Re: Oracle and ASP connection

"asp_ora" wrote in message
news:5295a58c.0502160232.22426abd@posting.google.com...
> hi all,
> i am trying to connect to oracle thru an ASP page ... for this i
> write a code as below
> Set objConn = Server.CreateObject("ADODB.Connection")
> objConn.Open "dsn=OracleDSN;uid=userid;pwd=password;"
>
> after this i am trying to display the rows of a table in the database
>
> The problem is when i tried to run the ASP page on my comp which has
> IIS 5.0 on it it gave me an error saying Oracle Client required but i
> have Oracle Client on my system.
> on second time onwards i didnot get this error at all neither i could
> see something on the page (which actually should display rows) i am
> getting wht is problem and wht is solution for this .
>
> Plz help .........

I suspect that:

objConn.Open "dsn=OracleDSN;uid=userid;pwd=password;"

should be changed to:

objConn.Open Driver={Microsoft ODBC for
Oracle;Server=OracleServer.world;uid=userid;pwd=password;"

http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNL ess.htm#ODBCDriv
erForOracleFromMicrosoft

Re: Oracle and ASP connection

Thnx for help sir,

but unfortunately even this also is not working.


suyog

Re: Oracle and ASP connection

Thnx for help sir,

but unfortunately even this also is not working.


suyog

RE: Oracle and ASP connection

The first thing I would do is make sure your connection object is actually
open. After the objConn.Open add:
Response.Write objConn.State
Response.End

You should see a "1" if the connection was succesful.

If that works, then move on to troubleshooting the data retrieval part of
your code.
If not, you need to verify your connection string properties. You might
also want to veryify that you can retrieve data using this DSN via some other
tool such as Excel.
You might also check out: http://gpoulose.home.att.net/ He has a free query
tool that works with most any ODNC driver. If you can connect to Oracle
using your ODBC connection with his tool, you should be able to connect
within IIS.





"asp_ora" wrote:

> hi all,
> i am trying to connect to oracle thru an ASP page ... for this i
> write a code as below
> Set objConn = Server.CreateObject("ADODB.Connection")
> objConn.Open "dsn=OracleDSN;uid=userid;pwd=password;"
>
> after this i am trying to display the rows of a table in the database
>
> The problem is when i tried to run the ASP page on my comp which has
> IIS 5.0 on it it gave me an error saying Oracle Client required but i
> have Oracle Client on my system.
> on second time onwards i didnot get this error at all neither i could
> see something on the page (which actually should display rows) i am
> getting wht is problem and wht is solution for this .
>
> Plz help .........
>

Re: Oracle and ASP connection

hello sir,

i tried your options but unfortunatley again nothing comes on screen
even tht
Response.Write objConn.State
Response.End
does not print anything on the screen.

suyog

Re: Oracle and ASP connection

Can you post the entire contents of the page in question?



"suyog_linux" wrote:

> hello sir,
>
> i tried your options but unfortunatley again nothing comes on screen
> even tht
> Response.Write objConn.State
> Response.End
> does not print anything on the screen.
>
> suyog
>
>

Re: Oracle and ASP connection

<%@ Language=VBScript %>
<% Option Explicit %>














<%

Dim oConnect
Dim oMap
Dim bInitSuccess
Dim oLayers
Dim xMin, yMin
Dim xMax, yMax
Dim mapClickX, mapClickY
Dim IDx, IDy, sIDx, sIDy
Dim sMapAction
Dim oExtent
Dim sMapURL, sLegURL
Dim oDBConn, oRecSet, bConnOpen
Dim sExtFeatures
Dim sIDAttributes
Dim sDBID, sActionTemp, sZoomToID
Dim sUser, bLoggedIn
Dim bCreateNewMap

bConnOpen = False ' DB connection not open yet
bCreateNewMap = True ' Make new map unless turn off
sMapAction = Request.Form("mapAction")

' Server & Map connection
Set oConnect = CreateObject("aims.ArcIMSConnector")
oConnect.ServerName = MAPSERVER
oConnect.ServerPort = CLng(MAPPORT)
Set oMap = CreateObject("aims.Map")
oMap.MapDraw = False
oMap.Legend.Display = False
oMap.Legend.Height = MAPHEIGHT
oMap.Legend.Title = " "
oMap.Legend.Width = 130
oMap.Legend.Autoextent = True
bInitSuccess = oMap.InitMap(oConnect, MAPSERVICE)
If (Not bInitSuccess) Then
Response.Write ""
Response.End
End If
oMap.Width = CLng(MAPWIDTH)
oMap.Height = CLng(MAPHEIGHT)
Set oLayers = oMap.Layers

'iNumLayers = oLayers.Count

If sMapAction = "" Then
' Just starting up -- get info
xMin = oMap.Extent.xMin
xMax = oMap.Extent.xMax
yMin = oMap.Extent.yMin
yMax = oMap.Extent.yMax

sMapAction = "zoomin" ' default action on startup
Session("LoggedIn") = "False"
Else

xMin = Request.Form("mapXMin")
yMin = Request.Form("mapYMin")
xMax = Request.Form("mapXMax")
yMax = Request.Form("mapYMax")
mapClickX = Request.Form("mapClickX")
mapClickY = Request.Form("mapClickY")
sIDAttributes = Request.Form("idAttributes") ' preserve attribute list
sDBID = Request.Form("dbID")
sZoomToID = Request.Form("zoomToID")
bLoggedIn = Session("LoggedIn")
sUser = Request.Form("uinfo")

' Set the map envelope to the current extent
Set oExtent = Server.CreateObject("aims.Envelope")
oExtent.xMin = xMin
oExtent.xMax = xMax
oExtent.yMin = yMin
oExtent.yMax = yMax

oMap.DoZoomToExtent oExtent

If sDBID <> "" Then
sActionTemp = sMapAction
If sZoomToID = "True" Then sMapAction = "zoomToID" Else sMapAction =
"ShowByID"
End If

Select Case sMapAction

Case "fullextent"
oMap.DoZoomToFullExtent

Case "zoomin"
oMap.CenterAt mapClickX, mapClickY
oMap.DoZoom 5

Case "zoomout"
oMap.CenterAt mapClickX, mapClickY
oMap.DoZoom -5

Case "pan"
oMap.CenterAt mapClickX, mapClickY

Case "identify"
sIDAttributes = DBIdentify(oDBConn, mapClickX, mapClickY, oMap,
oExtent)

Case "ShowByID"
sIDAttributes = DBIdentifyID(oDBConn, sDBID, oMap, False)
sMapAction = sActionTemp ' Restore map action to current tool

Case "zoomToID" ' Zoom to DB Feature by its ID
sIDAttributes = DBIdentifyID(oDBConn, sDBID, oMap, True)
sMapAction = sActionTemp

Case "login"
sUser = Request.Form("uInfo")
bLoggedIn = CheckUserInfo(oDBConn, sUser)
bCreateNewMap = False ' Don't need new map
sExtFeatures = Request.Form("extFeatures") ' (but preserve extent
feature list)

End Select

End If

Set oExtent = oMap.Extent

If bCreateNewMap Then
sExtFeatures = AddDBPoints(oDBConn, oMap, oExtent)

oMap.MapDraw = True
oMap.Legend.Display = True
oMap.Refresh
sMapURL = oMap.GetImageAsURL
sLegURL = oMap.Legend.URL
End If
%>

Re: Oracle and ASP connection

OK. You're going to have to do a little digging here. If you truly got no
response from that code, then the code is not being executed. You will need
to climb backwards in the code until you find out why that piece of code is
not running.

I would start by adding a response.write line as the first line in the
function.
For example:

Function AddDBPoints(mConn, mMap, mExtent)
RESPONSE.WRITE "Function AddDbPoints" & "
"
RESPONSE.END

You should get a line that says "Function AddDbPoints" and then the
processing should stop. If you get this, then move down the code within the
function, testing until it breaks. If not, then the function is not beling
called and you need to move backwards from there.

HTH,

JOHN







"suyog_linux" wrote:

> <%@ Language=VBScript %>
> <% Option Explicit %>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> <%
>
> Dim oConnect
> Dim oMap
> Dim bInitSuccess
> Dim oLayers
> Dim xMin, yMin
> Dim xMax, yMax
> Dim mapClickX, mapClickY
> Dim IDx, IDy, sIDx, sIDy
> Dim sMapAction
> Dim oExtent
> Dim sMapURL, sLegURL
> Dim oDBConn, oRecSet, bConnOpen
> Dim sExtFeatures
> Dim sIDAttributes
> Dim sDBID, sActionTemp, sZoomToID
> Dim sUser, bLoggedIn
> Dim bCreateNewMap
>
> bConnOpen = False ' DB connection not open yet
> bCreateNewMap = True ' Make new map unless turn off
> sMapAction = Request.Form("mapAction")
>
> ' Server & Map connection
> Set oConnect = CreateObject("aims.ArcIMSConnector")
> oConnect.ServerName = MAPSERVER
> oConnect.ServerPort = CLng(MAPPORT)
> Set oMap = CreateObject("aims.Map")
> oMap.MapDraw = False
> oMap.Legend.Display = False
> oMap.Legend.Height = MAPHEIGHT
> oMap.Legend.Title = " "
> oMap.Legend.Width = 130
> oMap.Legend.Autoextent = True
> bInitSuccess = oMap.InitMap(oConnect, MAPSERVICE)
> If (Not bInitSuccess) Then
> Response.Write ""
> Response.End
> End If
> oMap.Width = CLng(MAPWIDTH)
> oMap.Height = CLng(MAPHEIGHT)
> Set oLayers = oMap.Layers
>
> 'iNumLayers = oLayers.Count
>
> If sMapAction = "" Then
> ' Just starting up -- get info
> xMin = oMap.Extent.xMin
> xMax = oMap.Extent.xMax
> yMin = oMap.Extent.yMin
> yMax = oMap.Extent.yMax
>
> sMapAction = "zoomin" ' default action on startup
> Session("LoggedIn") = "False"
> Else
>
> xMin = Request.Form("mapXMin")
> yMin = Request.Form("mapYMin")
> xMax = Request.Form("mapXMax")
> yMax = Request.Form("mapYMax")
> mapClickX = Request.Form("mapClickX")
> mapClickY = Request.Form("mapClickY")
> sIDAttributes = Request.Form("idAttributes") ' preserve attribute list
> sDBID = Request.Form("dbID")
> sZoomToID = Request.Form("zoomToID")
> bLoggedIn = Session("LoggedIn")
> sUser = Request.Form("uinfo")
>
> ' Set the map envelope to the current extent
> Set oExtent = Server.CreateObject("aims.Envelope")
> oExtent.xMin = xMin
> oExtent.xMax = xMax
> oExtent.yMin = yMin
> oExtent.yMax = yMax
>
> oMap.DoZoomToExtent oExtent
>
> If sDBID <> "" Then
> sActionTemp = sMapAction
> If sZoomToID = "True" Then sMapAction = "zoomToID" Else sMapAction =
> "ShowByID"
> End If
>
> Select Case sMapAction
>
> Case "fullextent"
> oMap.DoZoomToFullExtent
>
> Case "zoomin"
> oMap.CenterAt mapClickX, mapClickY
> oMap.DoZoom 5
>
> Case "zoomout"
> oMap.CenterAt mapClickX, mapClickY
> oMap.DoZoom -5
>
> Case "pan"
> oMap.CenterAt mapClickX, mapClickY
>
> Case "identify"
> sIDAttributes = DBIdentify(oDBConn, mapClickX, mapClickY, oMap,
> oExtent)
>
> Case "ShowByID"
> sIDAttributes = DBIdentifyID(oDBConn, sDBID, oMap, False)
> sMapAction = sActionTemp ' Restore map action to current tool
>
> Case "zoomToID" ' Zoom to DB Feature by its ID
> sIDAttributes = DBIdentifyID(oDBConn, sDBID, oMap, True)
> sMapAction = sActionTemp
>
> Case "login"
> sUser = Request.Form("uInfo")
> bLoggedIn = CheckUserInfo(oDBConn, sUser)
> bCreateNewMap = False ' Don't need new map
> sExtFeatures = Request.Form("extFeatures") ' (but preserve extent
> feature list)
>
> End Select
>
> End If
>
> Set oExtent = oMap.Extent
>
> If bCreateNewMap Then
> sExtFeatures = AddDBPoints(oDBConn, oMap, oExtent)
>
> oMap.MapDraw = True
> oMap.Legend.Display = True
> oMap.Refresh
> sMapURL = oMap.GetImageAsURL
> sLegURL = oMap.Legend.URL
> End If
> %>
>
>

Re: Oracle and ASP connection

thank you sir

i will try and let you know

Re: Oracle and ASP connection

sir i started to debug this code the next error tht i have got is

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified
/sss/Data.asp, line 216

Re: Oracle and ASP connection

sir i have started to debug the code line by line and following is the
error that i got on mconn.open line

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified
/sss/Data.asp, line

Re: Oracle and ASP connection

That tells me that either you have an error in your connection string, or
your DSN is not configured correctly.

Can you access the db using any other application via this DSN?


"suyog_linux" wrote:

> sir i started to debug this code the next error tht i have got is
>
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC Driver Manager] Data source name not found and no
> default driver specified
> /sss/Data.asp, line 216
>
>

Re: Oracle and ASP connection

What version of the Oracle Network Client are you using?

I have seen comments that the error you mention is caused by the IUSR
account not having permissions on the Oracle directory where the client
software is stored.

If you are using Oracle 9 or 10 client software it is also possible that the
Microsoft ODBC for Oracle driver needs updating. Earlier versions did not
support past Oracle 8. I think the latest version does but I have had
variable results. You may want to switch to the Oracle OleDB provider.
Install it and change the connection string to:

Provider=OraOLEDB.Oracle;Data Source=;User Id= name here>;Password=

--
--Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com


"asp_ora" wrote in message
news:5295a58c.0502160232.22426abd@posting.google.com...
> hi all,
> i am trying to connect to oracle thru an ASP page ... for this i
> write a code as below
> Set objConn = Server.CreateObject("ADODB.Connection")
> objConn.Open "dsn=OracleDSN;uid=userid;pwd=password;"
>
> after this i am trying to display the rows of a table in the database
>
> The problem is when i tried to run the ASP page on my comp which has
> IIS 5.0 on it it gave me an error saying Oracle Client required but i
> have Oracle Client on my system.
> on second time onwards i didnot get this error at all neither i could
> see something on the page (which actually should display rows) i am
> getting wht is problem and wht is solution for this .
>
> Plz help .........

Re: Oracle and ASP connection

i am using oracle 9i client .

and i dont knwo how to give priviledge to IUSR for oracle directory plz
explain .


suyog