470,833 Members | 1,477 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,833 developers. It's quick & easy.

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");

SCDATA is the ODBC data source name.

Thanks for any help.
Aug 11 '08 #1
3 2902
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.

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;
  3. $Conn = $Server->CreateObject("ADODB.Connection");
  4. $Conn->Open("DSN=SCDATA;UID=tcm;PWD=tcm");
  6. $sql = "select distinct initials, lastname || ', ' || firstname lastname from nurses order by lastname"; 
  7. $Rs = $Conn->Execute($sql);
  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
  16. $Rs->Close;
Aug 11 '08 #3
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.

Aug 11 '08 #4

Post your reply

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

Similar topics

2 posts views Thread by Hari Om | last post: by
4 posts views Thread by Ellen K. | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.