-
Connecting to Oracle 9i with ASP
I am trying to connect to an Oracle 9i database with ASP. I'm just learning ASP, so I'm not very good yet.
This is what my ASP code looks like:
Dim objConn, objRS, strQuery
Dim strConnection
Set objConn = Server.CreateObject("ADODB.Connection")
strConnection = "Driver={Microsoft ODBC for Oracle};Server=Webtank;"
strConnection = strConnection & "Uid=****;Pwd=****;"
ObjConn.Open strConnection
strQuery = "SELECT Productname, UnitPrice FROM Products "
strQuery = strQuery & "ORDER BY Productname"
Set objRS = objConn.Execute(strQuery)
the "****" are my username and pass....
when I try to load the page...I get this error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
/asp/listing13-1.asp, line 10
I'm not quite sure what to do, so if anyone could please help it would be much appreciated.
Thanks
trinkus
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|