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

camarottaAsked:
Who is Participating?
 
marperCommented:
Microsoft’s Open Database Connectivity (ODBC) standard is an application programming interface (API) for database access. It is designed to use specific ODBC API calls, which a driver will translate into the native API language for that database, to allow connectivity and to execute Structured Query Language (SQL) against the database. This allows the programmer to use any front end application that is ODBC enabled (meaning that the application allows an odbc driver to connect). Examples of these types of front end applications are: Microsoft Access, Microsoft Visual Basic, Microsoft Visual C++, Crystal Reports, Cold Fusion, etc. Oracle Lite provides three odbc drivers to connect to the Oracle Lite database and for use with Brand Office using the ODBC API standard from Microsoft.

How to configure a Data Source Name (DSN) on Windows 32
Instructions:

Click on Start  

Select Settings, and then select Control Panel.  

Double Click on the Data Sources (ODBC) icon.  

Click on the ‘Add..’ button.  

Click on the Oracle Lite 40 ODBC Driver (3.51), and then click on the ‘Finish’ button.  

Now an Oracle9i Lite ODBC 3.51 Setup screen will appear.  

In the Setup screen fill in the following fields:  

Data Source Name:  
Enter the Name you want to use for this example it will be called ABC  
Data Description:  
This is only a description for the user. It has no effect on the actual connection.  
Database Directory:  
If the connection is being made to the default Oracle Lite database, it resides here: <drive>:\Oracle_Home\Mobile\Sdk\OLDB40  
Database:  
This is the file name of the Oracle Lite database for the default database it would be POLITE.odb  
Default Isolation Level:  
This is used to specify the Isolation level for that ODBC DSN. For now, leave it at the default value of Read Committed.  
Autocommit:  
This is used to specify whether the connection with that DSN will automatically commit the SQL being used. For now, leave it at the default value of Off.  
Default Cursor Type:  
This is used to specify the cursor type being used by the ODBC DSN. For now, leave it at the default value of Forward Only.  
After the fields of the DSN have been filled in, click on the ‘OK’ button. The DSN will now be created.


0
 
camarottaAuthor Commented:
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
0
 
marperCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.