Sending Company File using Email


T

tiagaw

Hi Jesper,
What will be the needed data to be attached so that the recepient
can open the company file that I'll be sending using email? Is it
the .sbc file alone? Thanks..
Best regards,
Lenito
 
Ad

Advertisements

S

sorenf

Yes - assuming you've setup remote access correctly all you need to do is
send the sbc file to users who have OA client installed on their machine.
 
T

tiagaw

Yes - assuming you've setup remote access correctly all you need to do is
send the sbc file to users who have OA client installed on their machine.
--
sorenf





- Show quoted text -
Hi Soren,

Yes, it looks like I remembered that I met an error about allowing
remote connections for a particular file. Here's the scenario:

I copied all accounting data(.sbc, .sbd, .sbl, .sbb) to another unit.
When I tried opening the file i.e. buildup.sbc in the unit (the one
that data was transferred), the following error occurred:
"The company could not be opened. Please ensure that SQL server
exists, the service is running, and that access has been granted." (I
have no idea about this error.)

So what I did is restore the backup for that company if it will work.
In the process of restoring the company, the following error
occurred:
"An error has occurred while establishing a connection to the
server. When connecting to SQL Server 2005, this failure may be caused
by the fact that under the default settings SQL Server does not allow
remote connections. (provider: TCP Provider, error: 0 - A connection
attempt failed because the connected party did not properly respond
after a period of time, or established connection failed because
connected host has failed to respond.)"

Can you give me the process to set-up remote connections correctly?
And also, what does the error above (error 1 i.e. Please ensure that
SQL server exists...) mean? Thanks.

Respectfully yours,
Lenito A. Alarde
 
J

Jesper [MS]

Hi Lenito

You basically have two different scenarios mixed up here and the error you
mention is a result of that.

The first scenario is how to transfer your data from one machine to
another - i.e. from your work machine to your home machine.
The second one is how to connect to the same company from two different
machine that are connected in a network.

Your solution depends on which scenario your are aiming for.

As for the work-to-home scenario then that is used when the machines are not
connected directly.
In this case you can take a backup at work and transport the backup file to
your home computer where you then restore it. Then you can work on it at
home and bring another backup to work the day after and repeat the process.
In this scenario you can only work on the company data in one location at a
time since each restore will overwrite any data that was entered in the
company you restore it over.

The second scenario is when you have two or more machines connected in a
network i.e. in a larger office.
In this scenario you create the company on one machine and then enable
multi-user access from that machine. You can then simply copy the sbc-file
to any other machine in the network or just make it available in a shared
location, and the other machines can now connect to the remote company. In
this scenario everyone can work on the same company at the same time and you
don't transport any data around manually.


As for the error then what happened was that when you restored a backup you
selected an existing sbc-file. The sbc-file is just a shortcut which points
to a specific computer and company. So when you copied an sbc-file from
another computer and selected it during the restore, it was unable to access
the computer that the shortcut was pointing to.
The way to restore in this case would be to enter a new name instead of
selecting an existing one and this will then create a new sbc-file that you
can use. Alternately you can select an sbc-file which points to a local
computer (btw. try to open the sbc-file in Notepad and you will see what I
mean about the shortcut).


To me it sounds like you are trying to perform scenario one described above
and that you simply want to take a backup at work and copy that one backup
file (don't copy any sbc-files) to your home computer. Then you can restore
the backup file at home while creating a new sbc-file. In future
backup/restore operations you can then select the sbc-file that was created
locally which will overwrite the company data rather than freate a new one
every time.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


Yes - assuming you've setup remote access correctly all you need to do is
send the sbc file to users who have OA client installed on their machine.
--
sorenf





- Show quoted text -
Hi Soren,

Yes, it looks like I remembered that I met an error about allowing
remote connections for a particular file. Here's the scenario:

I copied all accounting data(.sbc, .sbd, .sbl, .sbb) to another unit.
When I tried opening the file i.e. buildup.sbc in the unit (the one
that data was transferred), the following error occurred:
"The company could not be opened. Please ensure that SQL server
exists, the service is running, and that access has been granted." (I
have no idea about this error.)

So what I did is restore the backup for that company if it will work.
In the process of restoring the company, the following error
occurred:
"An error has occurred while establishing a connection to the
server. When connecting to SQL Server 2005, this failure may be caused
by the fact that under the default settings SQL Server does not allow
remote connections. (provider: TCP Provider, error: 0 - A connection
attempt failed because the connected party did not properly respond
after a period of time, or established connection failed because
connected host has failed to respond.)"

Can you give me the process to set-up remote connections correctly?
And also, what does the error above (error 1 i.e. Please ensure that
SQL server exists...) mean? Thanks.

Respectfully yours,
Lenito A. Alarde
 
T

tiagaw

Hi Jesper,
Thank you so much. I can now open all company data by restoring all
backups. I have a question though. How can I set-up a remote access
for me to send a company file using email? Because I have to transfer
company files here (Philippines) to the US. Soren said I can and I
only need to attach an .sbc file. But I have no idea to do it.
Thanks..
Respectfully yours,
Lenito A. Alarde
 
T

tiagaw

Hi Jesper,
Thank you so much. I can now open all company data by restoring all
backups. I have a question though. How can I set-up a remote access
for me to send a company file using email? Because I have to transfer
company files here (Philippines) to the US. Soren said I can and I
only need to attach an .sbc file. But I have no idea to do it.
Thanks..
Respectfully yours,
Lenito A. Alarde
 
Ad

Advertisements

J

Jesper [MS]

In your scenario it is not sufficient to send the sbc-file. Remote access
only works if all computers are on the same network and it doesn't sound
like yours are. It might be possible to set up a VPN connection for this but
you would need a network expert for that.
In your scenario you should probably be sending the backup file back and
forth between your locations and restore it in each place as described
previously.
 
Ad

Advertisements

T

tiagaw

In your scenario it is not sufficient to send the sbc-file. Remote access
only works if all computers are on the same network and it doesn't sound
like yours are. It might be possible to set up a VPN connection for this but
you would need a network expert for that.
In your scenario you should probably be sending the backup file back and
forth between your locations and restore it in each place as described
previously.

--
Thanks
Jesperhttp://blogs.msdn.com/jesperbirkolsen/







- Show quoted text -
Hi Jesper, Hi Soren,
Ok, thank you for all the support. I think this discussion will end
here. One thing I have to say - You two are genius! :eek:). Good job
guys!
Respectfully yours,
Lenito A. Alarde
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top