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
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
32 Win XP
I don't know this post help:
https://forums.oracle.com/message/10585274
David Hervieux