• Content count

  • Joined

  • Last visited

About sms

  • Rank
    Forum Newbie
  1. That worked! Thanks very much for the help.
  2. 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;
  3. 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
  4. 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.