How do Creating a Call center form with sql (Problem)

[Andre]

I am trying to create my own form with info path and it is connecting my
local (on my pc) SQL database, VIA sharepoint (on a different server).

1. I have created a database with two tables( these reside on my computer)
2. I have created the form with infopath.
3. I have connected them to the database (No errors) except one.
when I try to bind a text box,date picker,dropdown etc. I get this error

(you have chosen to bind a non-repeating control to a repeating field or
group.this control will be bound to the first item in the repeating field or
group. Do you want to continue?) I say yes.

4. I publish it to Sharepoint I then try to put in some test data and I
can't do anything. It is like it is in read only format.

 

[NewIdiot]

first, I would set up the database and then move that file to a folder on the
server where all your users have access (example if that is on your pc, what
happens when your pc is turned off???). set up a shared folder on the
server. move your database to that folder on the server. then design your
forms to point to that database on that server. store the template forms
either in the same folder on that server (giving others access via sharepoint
or shortcuts thru your network connections).

I will tell you I did the same thing (set up database on my pc) then
designed the initial testing forms. then moved the database to another
shared folder and had problems when I tried to reset the main database
connection on my forms. I got the same error messages. I ended up coping
the forms and restarting from scratch.

 

[Andre]

Thanks Problem Solved.

first, I would set up the database and then move that file to a folder on the
server where all your users have access (example if that is on your pc, what
happens when your pc is turned off???). set up a shared folder on the
server. move your database to that folder on the server. then design your
forms to point to that database on that server. store the template forms
either in the same folder on that server (giving others access via sharepoint
or shortcuts thru your network connections).

I will tell you I did the same thing (set up database on my pc) then
designed the initial testing forms. then moved the database to another
shared folder and had problems when I tried to reset the main database
connection on my forms. I got the same error messages. I ended up coping
the forms and restarting from scratch.