?
Solved

Oracle Lite & Coldfusion

Posted on 2006-03-30
5
Medium Priority
?
1,195 Views
Last Modified: 2013-12-16
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

0
Comment
Question by:camarotta
  • 2
3 Comments
 
LVL 4

Accepted Solution

by:
marper earned 2000 total points
ID: 16338800
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
 

Author Comment

by:camarotta
ID: 16342578
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
 
LVL 4

Expert Comment

by:marper
ID: 16342921
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

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to recover a database from a user managed backup
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question