How do I add an AS400 system as a Linked server?

I have been reading for 2 hours and testing different way to create a linked
server and I am just not placing the right data in the correct fields... any
recommendations on what to read or where to find resources
What error are you getting?
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"WANNABE" <breichenbach AT istate DOT com> wrote in message
news:OXue2r9FHHA.1804@.TK2MSFTNGP02.phx.gbl...
>I have been reading for 2 hours and testing different way to create a
>linked server and I am just not placing the right data in the correct
>fields... any recommendations on what to read or where to find resources
>

How do I add an AS400 system as a Linked server?

I have been reading for 2 hours and testing different way to create a linked
server and I am just not placing the right data in the correct fields... any
recommendations on what to read or where to find resourcesWhat error are you getting?
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"WANNABE" <breichenbach AT istate DOT com> wrote in message
news:OXue2r9FHHA.1804@.TK2MSFTNGP02.phx.gbl...
>I have been reading for 2 hours and testing different way to create a
>linked server and I am just not placing the right data in the correct
>fields... any recommendations on what to read or where to find resources
>

How do I add an AS400 system as a Linked server?

I have been reading for 2 hours and testing different way to create a linked
server and I am just not placing the right data in the correct fields... any
recommendations on what to read or where to find resourcesWhat error are you getting?
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"WANNABE" <breichenbach AT istate DOT com> wrote in message
news:OXue2r9FHHA.1804@.TK2MSFTNGP02.phx.gbl...
>I have been reading for 2 hours and testing different way to create a
>linked server and I am just not placing the right data in the correct
>fields... any recommendations on what to read or where to find resources
>sql

how create linked server to informix

I want to create a linked server to Informix through OLEDB.
I tried to use sp_addlinkedserver but with wanted parameters
name!!!
Bellow settings are my odbc connection that can help you to advise me ,how
to setup parameter to values
working odbc
Servername=bronz
Host Name=192.168.19.184
service=bronz
protocol=onsoctcp
database name=development
userid=user
password=pass
client locale=cs_CZ.852
database locale = cs.CZ.852
thanksTarvirdi wrote:
> I want to create a linked server to Informix through OLEDB.
> I tried to use sp_addlinkedserver but with wanted parameters
> name!!!
> Bellow settings are my odbc connection that can help you to advise me ,how
> to setup parameter to values
> working odbc
> Servername=bronz
> Host Name=192.168.19.184
> service=bronz
> protocol=onsoctcp
> database name=development
> userid=user
> password=pass
> client locale=cs_CZ.852
> database locale = cs.CZ.852
Haven't tried a linked server, but we did install Informix drivers on
SQL Server and then utilized a DTS package to regularly pull data from
an Informix source into SQL Server so we could operate on that data.
Maybe that would meet your needs?
gorf

How create Excel linked server without Security Admin

I need to import excel data to mssql, i am creating linked server and then
selecting from it
Is there a why to create linked server without security admin role or some
other way to import data from excel spreadsheet to MsSQL 2000. It is not
very good security policy to have 10 users with Security administrator
server role :)
--
MusonDTS?
"Muson" <nu@.nu.nu> wrote in message
news:ufic8sc8GHA.788@.TK2MSFTNGP05.phx.gbl...
>I need to import excel data to mssql, i am creating linked server and then
>selecting from it
> Is there a why to create linked server without security admin role or some
> other way to import data from excel spreadsheet to MsSQL 2000. It is not
> very good security policy to have 10 users with Security administrator
> server role :)
> --
> Muson
>|||In SQL Server 2005, you can grant ALTER ANY LINKED SERVER permission, which allow to execute
sp_addlinkedserver. See below BOL URL:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/fed3adb0-4c15-4a1a-8acd-1b184aff558f.htm
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Muson" <nu@.nu.nu> wrote in message news:ufic8sc8GHA.788@.TK2MSFTNGP05.phx.gbl...
>I need to import excel data to mssql, i am creating linked server and then selecting from it
> Is there a why to create linked server without security admin role or some other way to import
> data from excel spreadsheet to MsSQL 2000. It is not very good security policy to have 10 users
> with Security administrator server role :)
> --
> Muson
>

How create Excel linked server without Security Admin

I need to import excel data to mssql, i am creating linked server and then
selecting from it
Is there a why to create linked server without security admin role or some
other way to import data from excel spreadsheet to MsSQL 2000. It is not
very good security policy to have 10 users with Security administrator
server role
MusonDTS?
"Muson" <nu@.nu.nu> wrote in message
news:ufic8sc8GHA.788@.TK2MSFTNGP05.phx.gbl...
>I need to import excel data to mssql, i am creating linked server and then
>selecting from it
> Is there a why to create linked server without security admin role or some
> other way to import data from excel spreadsheet to MsSQL 2000. It is not
> very good security policy to have 10 users with Security administrator
> server role
> --
> Muson
>|||In SQL Server 2005, you can grant ALTER ANY LINKED SERVER permission, which
allow to execute
sp_addlinkedserver. See below BOL URL:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/fed3adb0-4c15-4a1a-8acd-
1b184aff558f.htm
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Muson" <nu@.nu.nu> wrote in message news:ufic8sc8GHA.788@.TK2MSFTNGP05.phx.gbl...een">
>I need to import excel data to mssql, i am creating linked server and then
selecting from it
> Is there a why to create linked server without security admin role or some
other way to import
> data from excel spreadsheet to MsSQL 2000. It is not very good security po
licy to have 10 users
> with Security administrator server role
> --
> Muson
>

How create Excel linked server without Security Admin

I need to import excel data to mssql, i am creating linked server and then
selecting from it
Is there a why to create linked server without security admin role or some
other way to import data from excel spreadsheet to MsSQL 2000. It is not
very good security policy to have 10 users with Security administrator
server role
Muson
DTS?
"Muson" <nu@.nu.nu> wrote in message
news:ufic8sc8GHA.788@.TK2MSFTNGP05.phx.gbl...
>I need to import excel data to mssql, i am creating linked server and then
>selecting from it
> Is there a why to create linked server without security admin role or some
> other way to import data from excel spreadsheet to MsSQL 2000. It is not
> very good security policy to have 10 users with Security administrator
> server role
> --
> Muson
>
|||In SQL Server 2005, you can grant ALTER ANY LINKED SERVER permission, which allow to execute
sp_addlinkedserver. See below BOL URL:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/fed3adb0-4c15-4a1a-8acd-1b184aff558f.htm
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Muson" <nu@.nu.nu> wrote in message news:ufic8sc8GHA.788@.TK2MSFTNGP05.phx.gbl...
>I need to import excel data to mssql, i am creating linked server and then selecting from it
> Is there a why to create linked server without security admin role or some other way to import
> data from excel spreadsheet to MsSQL 2000. It is not very good security policy to have 10 users
> with Security administrator server role
> --
> Muson
>
sql