| Author |
BizTalk and MS Access
|
|
| Souatif 2005-07-27, 7:50 am |
| Hi everybody,
For my current job, I have to build a model using BizTalk to allow one
updtate in a database to be spread to other databases.
Using SQL Adapters, it was easy to connect SQL Server databases and
make them communicate, but the next step is to connect MS Access
databases.
I've been looking for a solution for a long time now  and I don't
think we can use SQL Adapters anymore !
Is someone able to help me please ?
Thanks for your help.
Fred
| |
| Souatif 2005-07-27, 5:52 pm |
|
PS : I'm using BizTalk Server 2003...
| |
| Walker Texas Ranger 2005-07-27, 5:52 pm |
|
You should try to RTFM !
Oups I've forgotten it was about biztalk...
Good luck
(I think that you should try to look how to connect BiwTalk and Oracle,
and then to adapt the connection string.)
| |
| Souatif 2005-07-28, 2:48 am |
| thank you my little jacket !! :p
but which f****** manual ?
Walker Texas Ranger a =E9crit :
> You should try to RTFM !
>
> Oups I've forgotten it was about biztalk...
>
> Good luck
>
> (I think that you should try to look how to connect BiwTalk and Oracle,
> and then to adapt the connection string.)
| |
|
| do you need to monitor an Access db for changes or just make updates to
Access? If you just need to make updates then create your own AIC that
exectues the necessary SQL code to update the db. It's pretty straight
foward if you're comfortable with xml and data classes in .net.
|
|
|
|