Link to home
Start Free TrialLog in
Avatar of camarotta
camarotta

asked on

Oracle Lite & Coldfusion

Hi, I'm having yet another crisis, about the 10th today.  To make a long story short, I installed Oracle 10 lite on my machine. I ran some sql stuff to set up the default db that gets installed with that.  Now I need to run this with Coldfusion MX 7.  However, I can't set up the datasource in the coldfusion administrator.

This is the error I get when I try to use ODBC sockets:

# Connection verification failed for data source: Polite
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver]TCP/IP error, connection reset by peer.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver]TCP/IP error, connection reset by peer.

I set it up using ODBC this way:

DSN  - Polite, SID name - Polite, Server (servername), username system, password master

I'm not really sure what the SID name is supposed to be.  I've tried a few things already.

This is the error I get when I try to use ODBC:

Connection verification failed for data source: Polite
java.sql.SQLException: [Macromedia][Oracle JDBC Driver]Error establishing socket. Connection refused: connect
The root cause was that: java.sql.SQLException: [Macromedia][Oracle JDBC Driver]Error establishing socket. Connection refused: connect

Now, I don't know oracle at all.  I know enough to run someone else's scripts.  I would really appreciate any help at all.

Thanks!
Carol

ASKER CERTIFIED SOLUTION
Avatar of marper
marper
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of camarotta
camarotta

ASKER

Thank you so much, I think we're making progress.  In Coldfusion now I'm getting:

Connection verification failed for data source: Polite
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][POL-5150] access violation
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][POL-5150] access violation

But it could be that the db isn't set up correctly.  I've never tried to set up Oracle before, so it could be that I did something else incorrectly.

Carol
It could be.
You have to read some documents how to set up a basic database under Oracle.
Read these documents and you will get some idea

http://www.orafaq.com/faqdba.htm
http://www.adp-gmbh.ch/ora/admin/creatingdbmanually.html