Opendatasource

I'm trying to use OPENDATASOURCE in t-sql to update data on our AS/400 from MSSQL but don't know the property value for provider_name. Please help!!!"Control Panel"\"Administrative Tools"\"Data Sources(ODBC)"
Select a tab "File DSN", click "Add..", select server and click "Advanced".
Now you see sub-driver for ODBC (MSDASQL)

For MS SQL Server in MS SQL Server
select *
from OpenRowset('MSDASQL', 'Driver={SQL Server};Server=MyServer;User=MyUser','select * from sysobjects')

I do not have A/400 driver installed, that is why I cannot test this for A/400.

Good luck !|||my diagnosis is the your transactional properties of your neural defilibrator is going to require that you just replace the AS400 with SQL Server.

you better get to work.sql

online book "script error-object doesn't support this property or

When I click some link of book online, then an "Internet explorer Script
Error" comes out:
Line 1
char 1
Error: Object doesn't support this property or method
code 0
URL: ..
It works fine before. I don't know why this error show.vollen,
Can you reapply the latest Internet Explorer service pack? This should
fix it.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
vollen wrote:
> When I click some link of book online, then an "Internet explorer Script
> Error" comes out:
> Line 1
> char 1
> Error: Object doesn't support this property or method
> code 0
> URL: ..
>
> It works fine before. I don't know why this error show.