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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER
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