Data Connections

Re: Connection to database JET DB intilization problem HELP!

gillrajb — Thu, 14 Jun 2007 13:15:47 GMT

Will I need access to the overall sharepoint site? Because I only have access to the directory Safety and Training http://207.245.47.37/sites/Safety_and_Training/ Also, I cannot find the IIS on my computer obviously so I take it I will have to get admin rights for the whole site?

Re: Connection to database JET DB intilization problem HELP!

Matt Faus — Thu, 14 Jun 2007 13:09:23 GMT

Information from this site might be helpful: http://blog.crowe.co.nz/archive/2006/03/18/603.aspx

Re: Connection to database JET DB intilization problem HELP!

gillrajb — Thu, 14 Jun 2007 12:47:26 GMT

But can how can I make it so that the shared folder can be accessed from any computer anywhere? I forget how to do this, can you link me to a tutorial on making it available anywhere?

Re: Connection to database JET DB intilization problem HELP!

Matt Faus — Thu, 14 Jun 2007 08:50:44 GMT

Hi gillrajb,

Instead of uploading to a doc library in SharePoint, have you tried storing on a shared network folder? I think this might be a little easier for InfoPath to understand.

Connection to database JET DB intilization problem HELP!

gillrajb — Sat, 09 Jun 2007 01:31:01 GMT

Hi guys. Im having alot of trouble with this. I have created a simple access database, uploaded to a doc library on a sharepoint site. Then I made a infopath form based on this by using the url: //207.245.47.37/sites/Safety_and_Training/ai/db2.mdb

I succeeded in creating the form. I then published it onto the sharepoint site. Now, when I try to fill out the form so the database can be filled in, I hit submit and it opens up a ADO warning telling me that the website is using my identity to connect to the datasource, I hit ok and then I get another window saying "Please enter MS JET OLE DB Initialization." In the fields it has 1) Datasource is \\207.245.47.37\sites\Safety_and_Training\ai\db2.mdb, the 2)username is Admin, 3)password is blank, 4)provider string is blank and the 5)open mode is on DB_Mode_Readwrite.

1. One thing I tried is in the username and password I give my administrator login as Corpdynatec\RGill, and then the password I always use to login onto the site. It then gives me:

InfoPath cannot connect to the data source.
Not a valid account name or password.

2. Next thing I try is just leaving the username as admin and password blank but then I get the message:

InfoPath cannot connect to the data source.
The Microsoft Jet database engine cannot open the file '\\207.245.47.37\sites\Safety_and_Training\ai\db2.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

Please let me know what im doing wrong and how to fix this.