creating new database session

creating new database session

avatar

I am attempting to create a new session(Database) to access an oracle database (version 10g). By default the data source is Microsoft SQL Server and the data provider is .NET Framework Data Provider for SQL Server . I select the elipsys (...) next to connection string. A connection Properties window is displayed. I select Change by data source and from the list I select Oracle Database and the provider I choose is .NET Framework for OLE DB. This returns me to the connection properties window which now has Oracle Database (OLE DB) selected as a datasource. I enter the IP address of my Oracle server in the Server name field. In the log on to database section I enter the user name and password I have used to log into the database from other programs (dbvisualizer/Oracle SQL developer). Again I enter the IP address of the Oracle server in Server Name and enter the username/password.


If I click on Test Connection it responds with ORA-12504: TNS:listener was not given the Service_name in Connect_Data
If I click on ADVANCED a window appears with the following information

Advanced
Extended Properties NO VALUE
Locale Identifier 1033
Named ConnectionString
File Name NO VALUE
Pooling
OLE DB Services Default
Security
Password ******
Persist Security Info True
User ID <my oracle user ID>
Source
Data Source <my oracle IP address>
Provider MSDAORA

Below this is a field that contains what appears to be a connection string
Provider=MSDAORA;Data Source=<my oracle IP>;Persist Security Info=True;User ID=<my user id>

I am sorry for being so verbose but I thought too much detail would be better than "HELP MEEZ, ITS BROKE" lol

All Comments (3)

avatar

Hi,
Just a quick question. Do you use RDM 32 bit or 64 bit. Perhaps the 64 bit Oracle provider is not provided by Microsoft

David Hervieux

avatar

32 Win XP

avatar

I don't know this post help:

https://forums.oracle.com/message/10585274

David Hervieux