sms

Members
 View Profile  See their activity

  • Content count

    4

  • Joined

  • Last visited

Everything posted by sms

  1. Hi - I have the Oracle client installed and can connect to Oracle databases via DataWebParts, but when I use the Fusion wizard it says its unable to connect to the database. When I look int he logs it shows ORA-12154: TNS:could not resolve the connect identifier specified. Our config uses LDAP for lookups - could that be causing a problem? Also, what is the direction of this product? I'm curious what I'm allowed to do with the beta version and how much the production version will cost. Thanks.
  2. That worked! Thanks very much for the help.
  3. That didn't work - same errors. This is the connect string I use via designer. Can you tell me how your wizard translates to these fields? ProviderName="System.Data.OracleClient" ConnectionString="Data Source=(Description=(Address_list=(Address=(Protocol=TCP)(HOST=hostname)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=servicename)(INSTANCE_NAME=instance)));User ID=xxxxx;Password=xxxxxxx;
  4. The wizard only asks for the server name, user & pass. We run multiple instances on our server. I can TNS Ping the instance and I can also connect using a data source in sharepoint designer. Now I'm reciving this error: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA