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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development Software

From novice to tech pro — start learning today.