+ Post New Thread
Results 1 to 3 of 3
Office Software Thread, Infopath to sql data connections in Technical; Trying to set a data connection between sql 2005 and infopath have created it and designed the foem but when ...
  1. #1

    Join Date
    May 2008
    Thank Post
    Thanked 49 Times in 46 Posts
    Rep Power

    Infopath to sql data connections

    Trying to set a data connection between sql 2005 and infopath
    have created it and designed the foem but when i publish it i get
    An error occurred accessing a data source.

    An entry has been added to the Windows event log of the server.
    Log ID:6932

  2. #2
    FABEnterprises's Avatar
    Join Date
    Apr 2009
    Thank Post
    Thanked 4 Times in 3 Posts
    Rep Power
    I'm not familiar with Infopath but usually this is permission problem communicating with the database either your user credentials are not correct, you don't have right client software on the webserver or the webserver is not allowed/restricted from accessing the DB server, make sure all relevant ports are open on your servers.

    You might also want to look at this article, might be similar to what you are experiencing.

    Good Luck

  3. #3

    Join Date
    May 2009
    Thank Post
    Thanked 40 Times in 30 Posts
    Rep Power
    Might be worth checking the log entry on the server to see what it says! Also see if there's anything in the server's access/audit/security logs too.

    I'll bet money it's one of these though:

    - wrong user/password
    - wrong database instance
    - no access for the particular machine/ip you're using
    - no access on a particular network interface (less likely but you never know)

    If there's an entry in the server's log, then it's unlikely to be a firewall or server hostname/ip problem, but just check the database really is where you think it is!

+ Post New Thread

Similar Threads

  1. MIS/Data Manager (cmis/sql) Leeds £27,573K to £29,714K
    By SpecialAgent in forum Educational IT Jobs
    Replies: 0
    Last Post: 11th May 2009, 05:16 PM
  2. [MS Office - 2007] InfoPath - Workflow - SharePoint Services 3.0
    By RobFuller in forum Office Software
    Replies: 5
    Last Post: 22nd January 2009, 03:00 PM
  3. MS SQL 2005 - Dump SQL
    By tom_newton in forum Windows
    Replies: 7
    Last Post: 23rd January 2008, 06:10 PM
  4. Infopath: Embedding template in form
    By m2d2 in forum Windows
    Replies: 0
    Last Post: 28th September 2007, 12:23 PM
  5. Want somthing like Infopath.
    By Quackers in forum Web Development
    Replies: 3
    Last Post: 10th January 2007, 09:38 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts