Changing the datasource

[Aakash]

hey,

Once I specify the database location in the datasource connectivity wizard
for a new form.How can i modify the path if i would like to move the database
to some other location?

 

[ural]

i dont know is there any direct way to do it. but i have done it this way

1. Say File>Extract From Files
2. Goto manifest.xsf file at the extracted location.
3. Find the connection string there and replace it with whatever you want.
4. open xsf file and republish as xsn

Hope this helps!!
Ural

 

[John]

Alex,
Are you really at Microsoft? Are you serious about your response?

Is there a fix planned? Or must we follow this hack to move code into
production?

Good Luck back at ya'!!!
John

 

[Brian Teutsch [MSFT]]

Just as a matter of policy, and to not get anyone's hopes up too much, we
don't comment on future product directions. Alex's statement about changing
the datasource is correct, that currently is the best way to move from a
test to a production environment.

Brian

Alex,
Are you really at Microsoft? Are you serious about your response?

Is there a fix planned? Or must we follow this hack to move code into
production?

Good Luck back at ya'!!!
John

Aakash,

Here is one way to do this:
- extract form files (Open the form in design mode -> File -> Extract
Form Files)
- open manifest.xsf file from the location where you extracted the
files. Use notepad to edit this file.
- inside the manifest.xsf, there is a section that looks like this:
<xsf:adoAdapter connectionString="... ">
Modify the path that is specified in the connectionString to point to
the new location.
- save the manifest.xsf and close notepad
- right-click on manifest.xsf and select "design". The form will open in
InfoPath Design Mode.
- Save the form. It will be saved as a single file (.xsn).

Good luck!
Alex @ Microsoft

-----Original Message-----
From: Aakash [mailto:[email protected]]
Posted At: Tuesday, May 03, 2005 6:33 AM
Posted To: microsoft.public.infopath
Conversation: Changing the datasource
Subject: Changing the datasource

hey,

Once I specify the database location in the datasource connectivity
wizard
for a new form.How can i modify the path if i would like to move the
database
to some other location?

 

[Aakash]

hey all,
Thanks a lot for the help..it worked..but i have a doubt:
I would like to put the form and database on a web server.Now when i try to
specify a database which is on the webserver, it says that it accepts only
access and sql databases .It is actually an access database , i donno why it
is giving me this error.

--
Best Regards,
Aakash Munjal

Just as a matter of policy, and to not get anyone's hopes up too much, we
don't comment on future product directions. Alex's statement about changing
the datasource is correct, that currently is the best way to move from a
test to a production environment.

Brian

Alex,
Are you really at Microsoft? Are you serious about your response?

Is there a fix planned? Or must we follow this hack to move code into
production?

Good Luck back at ya'!!!
John

Aakash,

Here is one way to do this:
- extract form files (Open the form in design mode -> File -> Extract
Form Files)
- open manifest.xsf file from the location where you extracted the
files. Use notepad to edit this file.
- inside the manifest.xsf, there is a section that looks like this:
<xsf:adoAdapter connectionString="... ">
Modify the path that is specified in the connectionString to point to
the new location.
- save the manifest.xsf and close notepad
- right-click on manifest.xsf and select "design". The form will open in
InfoPath Design Mode.
- Save the form. It will be saved as a single file (.xsn).

Good luck!
Alex @ Microsoft

-----Original Message-----
From: Aakash [mailto:[email protected]]
Posted At: Tuesday, May 03, 2005 6:33 AM
Posted To: microsoft.public.infopath
Conversation: Changing the datasource
Subject: Changing the datasource

hey,

Once I specify the database location in the datasource connectivity
wizard
for a new form.How can i modify the path if i would like to move the
database
to some other location?

 

[Scott L. Heim [MSFT]]

Hi all,

Just to clarify this for everyone: if you are talking about modifying the
location of "secondary" data sources, then yes - this is currently the only
way to accomplish this. However, if you are referring to the "main" data
source then as long as you have SP1 installed you can choose the "Convert
Main Datasource" option from the Tools menu - this will allow you to point
to a different database, server, etc.

Thanks,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.