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 ...
12th May 2009, 04:05 PM #1
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.
13th May 2009, 12:07 PM #2
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.
14th May 2009, 09:40 AM #3
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!
By SpecialAgent in forum Educational IT Jobs
Last Post: 11th May 2009, 04:16 PM
By RobFuller in forum Office Software
Last Post: 22nd January 2009, 02:00 PM
By tom_newton in forum Windows
Last Post: 23rd January 2008, 05:10 PM
Last Post: 28th September 2007, 11:23 AM
By Quackers in forum Web Development
Last Post: 10th January 2007, 08:38 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)