+ 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
    Location
    York
    Posts
    515
    Thank Post
    22
    Thanked 48 Times in 45 Posts
    Rep Power
    24

    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
    Location
    Hastings
    Posts
    12
    Thank Post
    0
    Thanked 4 Times in 3 Posts
    Rep Power
    11
    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
    Location
    Sheffield
    Posts
    242
    Thank Post
    21
    Thanked 35 Times in 26 Posts
    Rep Power
    20
    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!

SHARE:
+ 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, 04: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, 02:00 PM
  3. MS SQL 2005 - Dump SQL
    By tom_newton in forum Windows
    Replies: 7
    Last Post: 23rd January 2008, 05:10 PM
  4. Infopath: Embedding template in form
    By m2d2 in forum Windows
    Replies: 0
    Last Post: 28th September 2007, 11:23 AM
  5. Want somthing like Infopath.
    By Quackers in forum Web Development
    Replies: 3
    Last Post: 10th January 2007, 08: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
  •