472,954 Members | 2,044 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,954 software developers and data experts.

Can not connect to Oracle 10g XE from ASP perscript web page on IIS 6

I Can not connect to Oracle 10g XE from ASP perscript web page on IIS 6 running on server 2003. I have set up the database and the ODBC connections. The ODBC connection is workinh and I can connect to it via the ODBC test. I have the same ASP application running on a VISTA workstation and it connects fine.

Here is the connection string that works fine on the VISTA PC put I can not get it to work on the server 2003 system.


$Conn = $Server->CreateObject("ADODB.Connection");
$Conn->Open("DSN=SCDATA;UID=tcm;PWD=tcm");

SCDATA is the ODBC data source name.

Thanks for any help.
Aug 11 '08 #1
3 2985
eWish
971 Expert 512MB
This does not look like perl code to me. Would you please post a bit more of the code where it involves perl. Are you using the DBD::ODBC driver? This connection string does not look correct if you are.

--Kevin
Aug 11 '08 #2
I am not using DBD I use ADODB.Connection. Here is some more of the PERL code. This works on other servers. NT, VISTA, server 2000. Not sure if it is a permission issue in IIS or what. Thanks again for any help

Expand|Select|Wrap|Line Numbers
  1. use Win32::ASP;
  2.  
  3. $Conn = $Server->CreateObject("ADODB.Connection");
  4. $Conn->Open("DSN=SCDATA;UID=tcm;PWD=tcm");
  5.  
  6. $sql = "select distinct initials, lastname || ', ' || firstname lastname from nurses order by lastname"; 
  7. $Rs = $Conn->Execute($sql);
  8.  
  9. while (! $Rs->EOF) {
  10.     $empl = $Rs->Fields('initials')->value;
  11.     $nme = $Rs->Fields('lastname')->value;
  12.     print "<option value=$empl>$nme</option>";
  13.     $Rs->MoveNext;
  14. } # while
  15.  
  16. $Rs->Close;
Aug 11 '08 #3
eWish
971 Expert 512MB
I am not familiar with an IIS server, therefore, not sure how the permissions work for them. I would suggest that you ask if it could be a permission issue in the IIS forum. As far as the perl code it looks correct.

--Kevin
Aug 11 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Hari Om | last post by:
Cannot connect as Internal Hello, I am using IBM AIX 5.1L box for Oracle 9.2.0.1. I cannot connect as internal to my DB INstance - wonder why? Here is what is do:...
1
by: DAVID | last post by:
Hello, With regards to the Connect dialog on Oracle forms 6i via which we can connect to Oracle database, should we use the same functionality on forms run time again? I mean, I want to make a...
4
by: Ellen K. | last post by:
Hi all, Being that so far I didn't get an answer to my below problem on the Oracle newsgroup, I figured it couldn't hurt to try here. While at my current job I've been working with mostly SQL...
5
by: jrefactors | last post by:
My machine is Windows XP with Oracle 9.2 Home; IIS and Oracle are in the same box. I have tried both Oracle OLEDB Provider and Microsoft ODBC For Oracle, but both not working. For Microsoft...
8
by: danbredy | last post by:
Hi, I'm attempting to connect to an Oracle database using SQL Server 2005 Express (OS is Windows XP Professional) and having absolutely no luck. Here is the information SQL Plus gives me about...
4
by: RLN | last post by:
I have an Access2002 database that needs to connect to an Oracle Database. I connected to my Oracle DB in a simple VB6 app using no ODBC data source. How do I do the same thing using VBA in...
7
by: D. Patrick | last post by:
I need to connect to an Oracle database. I've never done it before. I see that with framework 1.1 you had to download ODP.NET from Oracle's site in order for the framework classes to even work....
9
by: D. Patrick | last post by:
I need to connect to an Oracle database. I've never done it before. I see that with framework 1.1 you had to download ODP.NET from Oracle's site in order for the framework classes to even work....
2
by: mallz | last post by:
hi, im new to programming in jsp and i need to connect to oracle db. i could connect to ms access using the following code ...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
1
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.