By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,852 Members | 2,259 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,852 IT Pros & Developers. It's quick & easy.

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

P: 4
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
Share this Question
Share on Google+
3 Replies


eWish
Expert 100+
P: 971
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

P: 4
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
Expert 100+
P: 971
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

Post your reply

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