|
Home > Archive > BizTalk Server General > March 2005 > Remote access database error
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Remote access database error
|
|
| yu guo qiang 2005-03-16, 2:48 am |
| I install the Biztalk server 2004 , the sql server 2000 and another any
required software in my PC.
Now i want to use the sql adapter to access another sql server 2000
database.
there are not any BizTalk components in that computer.
Could i access the remote database through the sql adapter(e.g. another sql
server 2000 )?
if can ,how to do?
Thanks. Yugq
| |
| BizWorld 2005-03-16, 2:48 am |
| Yes you can access other SQL Server by using SQL Adapter in BizTalk 2004.
1. Right Click your Project in VS2003 solution explorer.
2. Click Add Generated Items..............
3. Select SQL Adapter.
4. Connection settings
5. Select your required Operation "Insert/update/delete/storedproc" and do
further steps
6. Finish
7. You will see this adapter now in Transport Type Property of your Port
8. Just select SQL Transport type.............................
This way you can get or send data to any SQL Server.
Hope this will help you.
Regards,
BizWorld
"yu guo qiang" <yugq@gillion.com.cn> wrote in message
news:O9ZvsZfKFHA.3336@TK2MSFTNGP09.phx.gbl...
> I install the Biztalk server 2004 , the sql server 2000 and another any
> required software in my PC.
> Now i want to use the sql adapter to access another sql server 2000
> database.
>
> there are not any BizTalk components in that computer.
> Could i access the remote database through the sql adapter(e.g. another
sql
> server 2000 )?
>
> if can ,how to do?
>
> Thanks. Yugq
>
>
| |
| yu guo qiang 2005-03-17, 3:04 am |
| Thanks very much£¬BizWorld.
According to your steps,I get a error :
Failed to execute SQL Statement.please ensure that the supplied syntax is
correct.A error occurs when register in the distributed
transaction.(the last sentence is a translation of the chinese,hope you can
understand my poor english)
My steps is as follows:
> 1. Right Click My Project in VS2003 solution explorer.
> 2. Click Add Generated Items..............
> 3. Select SQL Adapter.
> 4. Connection settings
User name: sa password:*** select Allow saving password
select the database on the server: Northwind
And Test Connection Succeeded
> 5. Target Name space: http://Gillion
Receive port
the name of the root element: Root
> 6. select sentence
> 7. sql script: select * from orders for xml auto
then I click the next button
I get the error:
Failed to execute SQL Statement.please ensure that the supplied syntax is
correct.A error occurs when register in the distributed
transaction.(the last sentence is a translation of the chinese,hope you can
understand my poor english)
My computer's DTC has been open .
And the other computer's DTC has been open.
what's the means of the error ?
what can i do for solving the problem?
tell me ,please.
My OS is windows 2003 server.
and the other computer'OS is windows 2003 server too.
Thanks,have a good time.
Yugq.
"BizWorld" <BizWorld@BizWorld.com> wrote in message
news:OvIHwzfKFHA.1136@TK2MSFTNGP10.phx.gbl...
> Yes you can access other SQL Server by using SQL Adapter in BizTalk 2004.
>
> 1. Right Click your Project in VS2003 solution explorer.
> 2. Click Add Generated Items..............
> 3. Select SQL Adapter.
> 4. Connection settings
> 5. Select your required Operation "Insert/update/delete/storedproc" and do
> further steps
> 6. Finish
> 7. You will see this adapter now in Transport Type Property of your Port
> 8. Just select SQL Transport type.............................
>
> This way you can get or send data to any SQL Server.
>
> Hope this will help you.
>
> Regards,
>
> BizWorld
>
>
> "yu guo qiang" <yugq@gillion.com.cn> wrote in message
> news:O9ZvsZfKFHA.3336@TK2MSFTNGP09.phx.gbl...
> sql
>
>
| |
|
|
"yu guo qiang" <yugq@gillion.com.cn> wrote in message news:...
> Thanks very much£¬BizWorld.
> According to your steps,I get a error :
> Failed to execute SQL Statement.please ensure that the supplied syntax is
> correct.A error occurs when register in the distributed
> transaction.(the last sentence is a translation of the chinese,hope you
can
> understand my poor english)
> My steps is as follows:
> User name: sa password:*** select Allow saving password
> select the database on the server: Northwind
> And Test Connection Succeeded
> Receive port
> the name of the root element: Root
> then I click the next button
> I get the error:
> Failed to execute SQL Statement.please ensure that the supplied syntax is
> correct.A error occurs when register in the distributed
> transaction.(the last sentence is a translation of the chinese,hope you
can
> understand my poor english)
>
> My computer's DTC has been open .
> And the other computer's DTC has been open.
> what's the means of the error ?
> what can i do for solving the problem?
> tell me ,please.
>
> My OS is windows 2003 server.
> and the other computer'OS is windows 2003 server too.
>
>
> Thanks,have a good time.
> Yugq.
>
>
>
>
> "BizWorld" <BizWorld@BizWorld.com> wrote in message
> news:OvIHwzfKFHA.1136@TK2MSFTNGP10.phx.gbl...
2004.[vbcol=seagreen]
do[vbcol=seagreen]
any[vbcol=seagreen]
another[vbcol=seagreen]
>
>
|
|
|
|
|