How do i connect to database

[sim133]

i have an asp written a simple asp code to connect to the database in order to generate some reports. my question would be do i need to fulfil some kind of pre-requiernments for me to pull those data from the databse. eg. do i need to set up ODBC driver ? DNS name....

 

[steven290]

here is another driver

Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider = MSDAORA;User ID=myuser;Password=mypwd;Data Source=myserver;DATABASE=mydb;"
Set rs = conn.Execute("SELECT * FROM tblname")

try this see if it works, just replace server,database, username , password

 

[bslintx]

sim

help us here;-)

1. what IS the name of your server?
2. what is the name of your db?
3. is the database in same directory as the asp files?

 

[Sheco]

He isn't using a file-based database driver so #3 doesn't really matter.

 

[steven290]

also try this (odbc)

Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=Username;Pwd=asdasd;Database=datasebasename;"
Set rs = conn.Execute("SELECT * FROM tblname")

 

[bslintx]

sim...are you getting an error code when trying to connect?

 

[Sheco]

good question!

 

[bslintx]

Stevens 1st connection statement seems to be the current driver for an oracle9i database.
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider = MSDAORA;User ID=myuser;Password=mypwd;Data Source=myserver;DATABASE=mydb;"
Set rs = conn.Execute("SELECT * FROM tblname")
%>

 

[sim133]

Here is the error msg i got.

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

/vendor.asp, line 3

here is my code
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=xyz;Pwd=xyz;Database=tplp;"
Set rs = conn.Execute("SELECT * FROM vendor")

%>
<table border="1" align="center">
<tr>
<% for each oField in testRS.Fields %>
<td><b><%= oField.Name %></b></td>
<%next%>
</tr>
<%do while not testRS.EOF %>
<tr>
<% for each oField in testRS.Fields %>
<td>
<% If IsNull(oField) then
response.write "what is up"
else
response.write oField.Value
end if%>
</td>

<%next
testRS.movenext%>
</tr>
<%loop%>
</table>
<%
testRS.close
set testRS = nothing

%>

 

[steven290]

try theses connection strings

<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider = MSDAORA;User ID=myuser;Password=mypwd;Data Source=myserver;DATABASE=mydb;"
Set rs = conn.Execute("SELECT * FROM tblname")
%>

if it doesn't work try this
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=MSDASQL;DRIVER={Microsoft ODBC for ORACLE};UID=User;PWD=Password;Server=Your_TNSNames_Alias;DATABASE=mydb;"
Set rs = conn.Execute("SELECT * FROM tblname")
%>

 

[bslintx]

it's possible not all the oracle components are updated..at least from the error code provided and this link...try to read through and ensure all is up-to-date

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q255084&LN=EN-US#toc

 

[bslintx]

here is origianl link w/ someone having same error

http://forums.oracle.com/forums/thread.jsp?forum=41&thread=215722&tstart=0&trange=15

 

[sim133]

Guys thank you for the help but i am still not connected to database. It seems a very straight forward process for some reason it is not working for me. I probably,look for someone server admn to take a look at it.
thank you and i appreciate your prompt response and priceless ideas.