I was able to successfully create a linked server to AS400 box without
any problem. But now, due to some reason the following query does not
return any data (0 rows)
Select * from openQuery(CWBIS800, 'select * from lib.tb where cmln =
10001001')
whereas the following query does return the correct record.
Select * from openQuery(CWBIS800, 'select * from lib.tb') where cmln =
10001001
I dont like the later query as this basically fetches all the records
from as400 (network traffic) and then applies the where clause on SQL
server side. Any idea how to fix the previous query ? please help
Sandeep Khandelwal
KeyBank
What is the data type for cmln? Did you try the first query
- exactly what is in between the single quotes - using
Client Access or on the AS400 itself?
-Sue
On 17 Sep 2004 12:47:53 -0700, Sandeep.khandelwal@.gmail.com
(Sandeep) wrote:
>I was able to successfully create a linked server to AS400 box without
>any problem. But now, due to some reason the following query does not
>return any data (0 rows)
>Select * from openQuery(CWBIS800, 'select * from lib.tb where cmln =
>10001001')
>whereas the following query does return the correct record.
>Select * from openQuery(CWBIS800, 'select * from lib.tb') where cmln =
>10001001
>I dont like the later query as this basically fetches all the records
>from as400 (network traffic) and then applies the where clause on SQL
>server side. Any idea how to fix the previous query ? please help
>
>Sandeep Khandelwal
>KeyBank
Showing posts with label linked. Show all posts
Showing posts with label linked. Show all posts
Sunday, March 11, 2012
AS2K5. Linked Measure Group. Why schould I include all measures?
If I Link a measure group I can don't include all measures. The Visual Studo notify no error either during editing or during deploiment. But during processing I get fully unqulified error message such as following
Errors in the OLAP storage engine: The metadata for the statically linked measure group, with the name of 'Verkauf', cannot be verified against the source object.
What a behaviour? Is this by design?
This doesnt look like by design behavior. Sounds more like a defect in the product.
Please go ahead and file it using feedback site: http://connect.microsoft.com/SQLServer/feedback/
Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Hi Edward.
The feedback site is a mess. There is not filtering by category (SSAS). I schoul use full text search.
Thursday, March 8, 2012
AS/400 Linked Server Error
Hello,
I have installed IBM AS/400 Client Access on my machine and then added a new
ODBC Data Source.
I have been working with this ODBC connection on several DTS packages and
everything has worked just fine.
Right now, I need to access some information on my AS/400 server from
several stored procedures on my SQL Server. I already configured a Linked
Server to the AS/400 server using the Microsoft OLE DB Provider for ODBC
Driver.
When I click the Tables folder under the new linked server, I can browse
through all the tables on the 400 Database. But when I execute any query
(using OPENQUERY or 4-part names in a normal query) I get the following error:
*******************************************+++
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [IBM][Client Access Express ODBC Driver
(32 bits)] Driver not capable.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows returned
0x80004005: ].
******************************************
Why is this happening? What is the error? Is there anything I am doing
wrong? I have been "fighting" with this problem for several hours.
Thanks a lot, in advance, for all the help you can give me.
is your ib client access the most updated version?
"Gabriel Giraldo" wrote:
> Hello,
> I have installed IBM AS/400 Client Access on my machine and then added a new
> ODBC Data Source.
> I have been working with this ODBC connection on several DTS packages and
> everything has worked just fine.
> Right now, I need to access some information on my AS/400 server from
> several stored procedures on my SQL Server. I already configured a Linked
> Server to the AS/400 server using the Microsoft OLE DB Provider for ODBC
> Driver.
> When I click the Tables folder under the new linked server, I can browse
> through all the tables on the 400 Database. But when I execute any query
> (using OPENQUERY or 4-part names in a normal query) I get the following error:
> *******************************************+++
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDASQL' reported an error.
> [OLE/DB provider returned message: [IBM][Client Access Express ODBC Driver
> (32 bits)] Driver not capable.]
> OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows returned
> 0x80004005: ].
> ******************************************
> Why is this happening? What is the error? Is there anything I am doing
> wrong? I have been "fighting" with this problem for several hours.
> Thanks a lot, in advance, for all the help you can give me.
>
|||Hi,
0x80004005 usually has something to do with permission issues. You might
want to check that out first.
Regards,
Steve
"Gabriel Giraldo" <GabrielGiraldo@.discussions.microsoft.com> wrote in
message news:C84D15C4-6087-4377-B66B-1F4C3EDEF7C2@.microsoft.com...
> Hello,
> I have installed IBM AS/400 Client Access on my machine and then added a
> new
> ODBC Data Source.
> I have been working with this ODBC connection on several DTS packages and
> everything has worked just fine.
> Right now, I need to access some information on my AS/400 server from
> several stored procedures on my SQL Server. I already configured a Linked
> Server to the AS/400 server using the Microsoft OLE DB Provider for ODBC
> Driver.
> When I click the Tables folder under the new linked server, I can browse
> through all the tables on the 400 Database. But when I execute any query
> (using OPENQUERY or 4-part names in a normal query) I get the following
> error:
> *******************************************+++
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDASQL' reported an error.
> [OLE/DB provider returned message: [IBM][Client Access Express ODBC Driver
> (32 bits)] Driver not capable.]
> OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows
> returned
> 0x80004005: ].
> ******************************************
> Why is this happening? What is the error? Is there anything I am doing
> wrong? I have been "fighting" with this problem for several hours.
> Thanks a lot, in advance, for all the help you can give me.
>
I have installed IBM AS/400 Client Access on my machine and then added a new
ODBC Data Source.
I have been working with this ODBC connection on several DTS packages and
everything has worked just fine.
Right now, I need to access some information on my AS/400 server from
several stored procedures on my SQL Server. I already configured a Linked
Server to the AS/400 server using the Microsoft OLE DB Provider for ODBC
Driver.
When I click the Tables folder under the new linked server, I can browse
through all the tables on the 400 Database. But when I execute any query
(using OPENQUERY or 4-part names in a normal query) I get the following error:
*******************************************+++
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [IBM][Client Access Express ODBC Driver
(32 bits)] Driver not capable.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows returned
0x80004005: ].
******************************************
Why is this happening? What is the error? Is there anything I am doing
wrong? I have been "fighting" with this problem for several hours.
Thanks a lot, in advance, for all the help you can give me.
is your ib client access the most updated version?
"Gabriel Giraldo" wrote:
> Hello,
> I have installed IBM AS/400 Client Access on my machine and then added a new
> ODBC Data Source.
> I have been working with this ODBC connection on several DTS packages and
> everything has worked just fine.
> Right now, I need to access some information on my AS/400 server from
> several stored procedures on my SQL Server. I already configured a Linked
> Server to the AS/400 server using the Microsoft OLE DB Provider for ODBC
> Driver.
> When I click the Tables folder under the new linked server, I can browse
> through all the tables on the 400 Database. But when I execute any query
> (using OPENQUERY or 4-part names in a normal query) I get the following error:
> *******************************************+++
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDASQL' reported an error.
> [OLE/DB provider returned message: [IBM][Client Access Express ODBC Driver
> (32 bits)] Driver not capable.]
> OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows returned
> 0x80004005: ].
> ******************************************
> Why is this happening? What is the error? Is there anything I am doing
> wrong? I have been "fighting" with this problem for several hours.
> Thanks a lot, in advance, for all the help you can give me.
>
|||Hi,
0x80004005 usually has something to do with permission issues. You might
want to check that out first.
Regards,
Steve
"Gabriel Giraldo" <GabrielGiraldo@.discussions.microsoft.com> wrote in
message news:C84D15C4-6087-4377-B66B-1F4C3EDEF7C2@.microsoft.com...
> Hello,
> I have installed IBM AS/400 Client Access on my machine and then added a
> new
> ODBC Data Source.
> I have been working with this ODBC connection on several DTS packages and
> everything has worked just fine.
> Right now, I need to access some information on my AS/400 server from
> several stored procedures on my SQL Server. I already configured a Linked
> Server to the AS/400 server using the Microsoft OLE DB Provider for ODBC
> Driver.
> When I click the Tables folder under the new linked server, I can browse
> through all the tables on the 400 Database. But when I execute any query
> (using OPENQUERY or 4-part names in a normal query) I get the following
> error:
> *******************************************+++
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDASQL' reported an error.
> [OLE/DB provider returned message: [IBM][Client Access Express ODBC Driver
> (32 bits)] Driver not capable.]
> OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows
> returned
> 0x80004005: ].
> ******************************************
> Why is this happening? What is the error? Is there anything I am doing
> wrong? I have been "fighting" with this problem for several hours.
> Thanks a lot, in advance, for all the help you can give me.
>
AS/400 Linked Server Error
Hello,
I have installed IBM AS/400 Client Access on my machine and then added a new
ODBC Data Source.
I have been working with this ODBC connection on several DTS packages and
everything has worked just fine.
Right now, I need to access some information on my AS/400 server from
several stored procedures on my SQL Server. I already configured a Linked
Server to the AS/400 server using the Microsoft OLE DB Provider for ODBC
Driver.
When I click the Tables folder under the new linked server, I can browse
through all the tables on the 400 Database. But when I execute any query
(using OPENQUERY or 4-part names in a normal query) I get the following erro
r:
****************************************
***+++
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [IBM][Client Access Express O
DBC Driver
(32 bits)] Driver not capable.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows retur
ned
0x80004005: ].
****************************************
**
Why is this happening? What is the error? Is there anything I am doing
wrong? I have been "fighting" with this problem for several hours.
Thanks a lot, in advance, for all the help you can give me.is your ib client access the most updated version?
"Gabriel Giraldo" wrote:
> Hello,
> I have installed IBM AS/400 Client Access on my machine and then added a n
ew
> ODBC Data Source.
> I have been working with this ODBC connection on several DTS packages and
> everything has worked just fine.
> Right now, I need to access some information on my AS/400 server from
> several stored procedures on my SQL Server. I already configured a Linked
> Server to the AS/400 server using the Microsoft OLE DB Provider for ODBC
> Driver.
> When I click the Tables folder under the new linked server, I can browse
> through all the tables on the 400 Database. But when I execute any query
> (using OPENQUERY or 4-part names in a normal query) I get the following er
ror:
> ****************************************
***+++
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDASQL' reported an error.
> [OLE/DB provider returned message: [IBM][Client Access Express
ODBC Driver
> (32 bits)] Driver not capable.]
> OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows ret
urned
> 0x80004005: ].
> ****************************************
**
> Why is this happening? What is the error? Is there anything I am doing
> wrong? I have been "fighting" with this problem for several hours.
> Thanks a lot, in advance, for all the help you can give me.
>|||Hi,
0x80004005 usually has something to do with permission issues. You might
want to check that out first.
Regards,
Steve
"Gabriel Giraldo" <GabrielGiraldo@.discussions.microsoft.com> wrote in
message news:C84D15C4-6087-4377-B66B-1F4C3EDEF7C2@.microsoft.com...
> Hello,
> I have installed IBM AS/400 Client Access on my machine and then added a
> new
> ODBC Data Source.
> I have been working with this ODBC connection on several DTS packages and
> everything has worked just fine.
> Right now, I need to access some information on my AS/400 server from
> several stored procedures on my SQL Server. I already configured a Linked
> Server to the AS/400 server using the Microsoft OLE DB Provider for ODBC
> Driver.
> When I click the Tables folder under the new linked server, I can browse
> through all the tables on the 400 Database. But when I execute any query
> (using OPENQUERY or 4-part names in a normal query) I get the following
> error:
> ****************************************
***+++
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDASQL' reported an error.
> [OLE/DB provider returned message: [IBM][Client Access Express
ODBC Driver
> (32 bits)] Driver not capable.]
> OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows
> returned
> 0x80004005: ].
> ****************************************
**
> Why is this happening? What is the error? Is there anything I am doing
> wrong? I have been "fighting" with this problem for several hours.
> Thanks a lot, in advance, for all the help you can give me.
>
I have installed IBM AS/400 Client Access on my machine and then added a new
ODBC Data Source.
I have been working with this ODBC connection on several DTS packages and
everything has worked just fine.
Right now, I need to access some information on my AS/400 server from
several stored procedures on my SQL Server. I already configured a Linked
Server to the AS/400 server using the Microsoft OLE DB Provider for ODBC
Driver.
When I click the Tables folder under the new linked server, I can browse
through all the tables on the 400 Database. But when I execute any query
(using OPENQUERY or 4-part names in a normal query) I get the following erro
r:
****************************************
***+++
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [IBM][Client Access Express O
DBC Driver
(32 bits)] Driver not capable.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows retur
ned
0x80004005: ].
****************************************
**
Why is this happening? What is the error? Is there anything I am doing
wrong? I have been "fighting" with this problem for several hours.
Thanks a lot, in advance, for all the help you can give me.is your ib client access the most updated version?
"Gabriel Giraldo" wrote:
> Hello,
> I have installed IBM AS/400 Client Access on my machine and then added a n
ew
> ODBC Data Source.
> I have been working with this ODBC connection on several DTS packages and
> everything has worked just fine.
> Right now, I need to access some information on my AS/400 server from
> several stored procedures on my SQL Server. I already configured a Linked
> Server to the AS/400 server using the Microsoft OLE DB Provider for ODBC
> Driver.
> When I click the Tables folder under the new linked server, I can browse
> through all the tables on the 400 Database. But when I execute any query
> (using OPENQUERY or 4-part names in a normal query) I get the following er
ror:
> ****************************************
***+++
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDASQL' reported an error.
> [OLE/DB provider returned message: [IBM][Client Access Express
ODBC Driver
> (32 bits)] Driver not capable.]
> OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows ret
urned
> 0x80004005: ].
> ****************************************
**
> Why is this happening? What is the error? Is there anything I am doing
> wrong? I have been "fighting" with this problem for several hours.
> Thanks a lot, in advance, for all the help you can give me.
>|||Hi,
0x80004005 usually has something to do with permission issues. You might
want to check that out first.
Regards,
Steve
"Gabriel Giraldo" <GabrielGiraldo@.discussions.microsoft.com> wrote in
message news:C84D15C4-6087-4377-B66B-1F4C3EDEF7C2@.microsoft.com...
> Hello,
> I have installed IBM AS/400 Client Access on my machine and then added a
> new
> ODBC Data Source.
> I have been working with this ODBC connection on several DTS packages and
> everything has worked just fine.
> Right now, I need to access some information on my AS/400 server from
> several stored procedures on my SQL Server. I already configured a Linked
> Server to the AS/400 server using the Microsoft OLE DB Provider for ODBC
> Driver.
> When I click the Tables folder under the new linked server, I can browse
> through all the tables on the 400 Database. But when I execute any query
> (using OPENQUERY or 4-part names in a normal query) I get the following
> error:
> ****************************************
***+++
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDASQL' reported an error.
> [OLE/DB provider returned message: [IBM][Client Access Express
ODBC Driver
> (32 bits)] Driver not capable.]
> OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows
> returned
> 0x80004005: ].
> ****************************************
**
> Why is this happening? What is the error? Is there anything I am doing
> wrong? I have been "fighting" with this problem for several hours.
> Thanks a lot, in advance, for all the help you can give me.
>
Wednesday, March 7, 2012
AS/400 Linked Server Error
Hello,
I have installed IBM AS/400 Client Access on my machine and then added a new
ODBC Data Source.
I have been working with this ODBC connection on several DTS packages and
everything has worked just fine.
Right now, I need to access some information on my AS/400 server from
several stored procedures on my SQL Server. I already configured a Linked
Server to the AS/400 server using the Microsoft OLE DB Provider for ODBC
Driver.
When I click the Tables folder under the new linked server, I can browse
through all the tables on the 400 Database. But when I execute any query
(using OPENQUERY or 4-part names in a normal query) I get the following error:
*******************************************+++
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [IBM][Client Access Express ODBC Driver
(32 bits)] Driver not capable.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows returned
0x80004005: ].
******************************************
Why is this happening? What is the error? Is there anything I am doing
wrong? I have been "fighting" with this problem for several hours.
Thanks a lot, in advance, for all the help you can give me.is your ib client access the most updated version?
"Gabriel Giraldo" wrote:
> Hello,
> I have installed IBM AS/400 Client Access on my machine and then added a new
> ODBC Data Source.
> I have been working with this ODBC connection on several DTS packages and
> everything has worked just fine.
> Right now, I need to access some information on my AS/400 server from
> several stored procedures on my SQL Server. I already configured a Linked
> Server to the AS/400 server using the Microsoft OLE DB Provider for ODBC
> Driver.
> When I click the Tables folder under the new linked server, I can browse
> through all the tables on the 400 Database. But when I execute any query
> (using OPENQUERY or 4-part names in a normal query) I get the following error:
> *******************************************+++
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDASQL' reported an error.
> [OLE/DB provider returned message: [IBM][Client Access Express ODBC Driver
> (32 bits)] Driver not capable.]
> OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows returned
> 0x80004005: ].
> ******************************************
> Why is this happening? What is the error? Is there anything I am doing
> wrong? I have been "fighting" with this problem for several hours.
> Thanks a lot, in advance, for all the help you can give me.
>|||Hi,
0x80004005 usually has something to do with permission issues. You might
want to check that out first.
Regards,
Steve
"Gabriel Giraldo" <GabrielGiraldo@.discussions.microsoft.com> wrote in
message news:C84D15C4-6087-4377-B66B-1F4C3EDEF7C2@.microsoft.com...
> Hello,
> I have installed IBM AS/400 Client Access on my machine and then added a
> new
> ODBC Data Source.
> I have been working with this ODBC connection on several DTS packages and
> everything has worked just fine.
> Right now, I need to access some information on my AS/400 server from
> several stored procedures on my SQL Server. I already configured a Linked
> Server to the AS/400 server using the Microsoft OLE DB Provider for ODBC
> Driver.
> When I click the Tables folder under the new linked server, I can browse
> through all the tables on the 400 Database. But when I execute any query
> (using OPENQUERY or 4-part names in a normal query) I get the following
> error:
> *******************************************+++
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDASQL' reported an error.
> [OLE/DB provider returned message: [IBM][Client Access Express ODBC Driver
> (32 bits)] Driver not capable.]
> OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows
> returned
> 0x80004005: ].
> ******************************************
> Why is this happening? What is the error? Is there anything I am doing
> wrong? I have been "fighting" with this problem for several hours.
> Thanks a lot, in advance, for all the help you can give me.
>
I have installed IBM AS/400 Client Access on my machine and then added a new
ODBC Data Source.
I have been working with this ODBC connection on several DTS packages and
everything has worked just fine.
Right now, I need to access some information on my AS/400 server from
several stored procedures on my SQL Server. I already configured a Linked
Server to the AS/400 server using the Microsoft OLE DB Provider for ODBC
Driver.
When I click the Tables folder under the new linked server, I can browse
through all the tables on the 400 Database. But when I execute any query
(using OPENQUERY or 4-part names in a normal query) I get the following error:
*******************************************+++
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [IBM][Client Access Express ODBC Driver
(32 bits)] Driver not capable.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows returned
0x80004005: ].
******************************************
Why is this happening? What is the error? Is there anything I am doing
wrong? I have been "fighting" with this problem for several hours.
Thanks a lot, in advance, for all the help you can give me.is your ib client access the most updated version?
"Gabriel Giraldo" wrote:
> Hello,
> I have installed IBM AS/400 Client Access on my machine and then added a new
> ODBC Data Source.
> I have been working with this ODBC connection on several DTS packages and
> everything has worked just fine.
> Right now, I need to access some information on my AS/400 server from
> several stored procedures on my SQL Server. I already configured a Linked
> Server to the AS/400 server using the Microsoft OLE DB Provider for ODBC
> Driver.
> When I click the Tables folder under the new linked server, I can browse
> through all the tables on the 400 Database. But when I execute any query
> (using OPENQUERY or 4-part names in a normal query) I get the following error:
> *******************************************+++
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDASQL' reported an error.
> [OLE/DB provider returned message: [IBM][Client Access Express ODBC Driver
> (32 bits)] Driver not capable.]
> OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows returned
> 0x80004005: ].
> ******************************************
> Why is this happening? What is the error? Is there anything I am doing
> wrong? I have been "fighting" with this problem for several hours.
> Thanks a lot, in advance, for all the help you can give me.
>|||Hi,
0x80004005 usually has something to do with permission issues. You might
want to check that out first.
Regards,
Steve
"Gabriel Giraldo" <GabrielGiraldo@.discussions.microsoft.com> wrote in
message news:C84D15C4-6087-4377-B66B-1F4C3EDEF7C2@.microsoft.com...
> Hello,
> I have installed IBM AS/400 Client Access on my machine and then added a
> new
> ODBC Data Source.
> I have been working with this ODBC connection on several DTS packages and
> everything has worked just fine.
> Right now, I need to access some information on my AS/400 server from
> several stored procedures on my SQL Server. I already configured a Linked
> Server to the AS/400 server using the Microsoft OLE DB Provider for ODBC
> Driver.
> When I click the Tables folder under the new linked server, I can browse
> through all the tables on the 400 Database. But when I execute any query
> (using OPENQUERY or 4-part names in a normal query) I get the following
> error:
> *******************************************+++
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDASQL' reported an error.
> [OLE/DB provider returned message: [IBM][Client Access Express ODBC Driver
> (32 bits)] Driver not capable.]
> OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows
> returned
> 0x80004005: ].
> ******************************************
> Why is this happening? What is the error? Is there anything I am doing
> wrong? I have been "fighting" with this problem for several hours.
> Thanks a lot, in advance, for all the help you can give me.
>
AS/400 Linked Server
Hello. Anyone know how what's needed to connect to an
AS/400 from SQL Server via a Linked Server? Any special
Provider softwre need to be in place? Any references on
this would help. THanks a lot... BruceBruce,
Try the MS Host Integration Server Administration Client .What you should be
installing is Microsoft ODBC Driver for DB2.
Refer
INF: Configuring Data Sources for the Microsoft OLE DB Provider for AS/400
and VSAM
http://support.microsoft.com/?id=219077
INF: Configuring Data Sources for the Microsoft OLE DB Provider for DB2
http://support.microsoft.com/?id=218590
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Bruce de Freitas" <bruce@.defreitas.com> wrote in message
news:016701c35218$f63188c0$a501280a@.phx.gbl...
> Hello. Anyone know how what's needed to connect to an
> AS/400 from SQL Server via a Linked Server? Any special
> Provider softwre need to be in place? Any references on
> this would help. THanks a lot... Bruce|||Excellent info Dinesh. I'll check it out... THanks, Bruce
>--Original Message--
>Bruce,
>Try the MS Host Integration Server Administration
Client .What you should be
>installing is Microsoft ODBC Driver for DB2.
>Refer
>INF: Configuring Data Sources for the Microsoft OLE DB
Provider for AS/400
>and VSAM
>http://support.microsoft.com/?id=219077
>INF: Configuring Data Sources for the Microsoft OLE DB
Provider for DB2
>http://support.microsoft.com/?id=218590
>
>--
>Dinesh.
>SQL Server FAQ at
>http://www.tkdinesh.com
>"Bruce de Freitas" <bruce@.defreitas.com> wrote in message
>news:016701c35218$f63188c0$a501280a@.phx.gbl...
>> Hello. Anyone know how what's needed to connect to an
>> AS/400 from SQL Server via a Linked Server? Any special
>> Provider softwre need to be in place? Any references on
>> this would help. THanks a lot... Bruce
>
>.
>
AS/400 from SQL Server via a Linked Server? Any special
Provider softwre need to be in place? Any references on
this would help. THanks a lot... BruceBruce,
Try the MS Host Integration Server Administration Client .What you should be
installing is Microsoft ODBC Driver for DB2.
Refer
INF: Configuring Data Sources for the Microsoft OLE DB Provider for AS/400
and VSAM
http://support.microsoft.com/?id=219077
INF: Configuring Data Sources for the Microsoft OLE DB Provider for DB2
http://support.microsoft.com/?id=218590
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Bruce de Freitas" <bruce@.defreitas.com> wrote in message
news:016701c35218$f63188c0$a501280a@.phx.gbl...
> Hello. Anyone know how what's needed to connect to an
> AS/400 from SQL Server via a Linked Server? Any special
> Provider softwre need to be in place? Any references on
> this would help. THanks a lot... Bruce|||Excellent info Dinesh. I'll check it out... THanks, Bruce
>--Original Message--
>Bruce,
>Try the MS Host Integration Server Administration
Client .What you should be
>installing is Microsoft ODBC Driver for DB2.
>Refer
>INF: Configuring Data Sources for the Microsoft OLE DB
Provider for AS/400
>and VSAM
>http://support.microsoft.com/?id=219077
>INF: Configuring Data Sources for the Microsoft OLE DB
Provider for DB2
>http://support.microsoft.com/?id=218590
>
>--
>Dinesh.
>SQL Server FAQ at
>http://www.tkdinesh.com
>"Bruce de Freitas" <bruce@.defreitas.com> wrote in message
>news:016701c35218$f63188c0$a501280a@.phx.gbl...
>> Hello. Anyone know how what's needed to connect to an
>> AS/400 from SQL Server via a Linked Server? Any special
>> Provider softwre need to be in place? Any references on
>> this would help. THanks a lot... Bruce
>
>.
>
as/400 linked server
Hi everybody,
I have a problem in SQL Server 2000. I need to connect as a linked server
the AS400 database (V5R3).
I read in the SQL documentation about the SP_ADDLINKEDSERVER stored
procedure and the linked server from SQL Manager but I'm not to be able to
have success using its.
The book's online of SQL Server sp3 is not very clear for me.
server name : s112233a
library : sales
object/file : order
member(optional) : orderFY05
Could you help me, please?
Thanks, Francesco.First you need to have the drivers, providers for the AS400
installed on the SQL Server box.
If you install Client Access on the server, it will install
and configure the drivers and providers for the AS400 on the
SQL Server box so that you can use linked servers. You
should also make sure you have the client updated with what
whatever service pack level based on updates to the AS400.
For data source, use the IP address of the AS400. For
provider string, you need to include the library you are
using, connect timeout setting and code page. There is some
documentation for the settings in the Client Access
help files. You'd set the provider string somewhat like:
InitCat=YourLibrary;CCSID=37;PCCodePage=
1252;
Data Source=xxx.xxx.xxx.xxx
Settings will depend on how your AS400 is configured. Again,
the Client Access help files have information on the
necessary connection string settings.
The logical or physical file you are accessing is what you
would reference as the table in your query against the
linked server.
-Sue
On Mon, 28 Feb 2005 21:38:36 GMT, "Francesco Trigiante"
<ftrigiante@.libero.it> wrote:
>Hi everybody,
>I have a problem in SQL Server 2000. I need to connect as a linked server
>the AS400 database (V5R3).
>I read in the SQL documentation about the SP_ADDLINKEDSERVER stored
>procedure and the linked server from SQL Manager but I'm not to be able to
>have success using its.
>The book's online of SQL Server sp3 is not very clear for me.
>server name : s112233a
>library : sales
>object/file : order
>member(optional) : orderFY05
>Could you help me, please?
>Thanks, Francesco.
>
>|||On the machine I have installed Win 2003 server, Sql 2k and CA V5R3 with
recent updates.
I would to use the "IBMDA400 iSeries provider for DB2 UDB" odbc but when i
set-up the linked server with the SP_ADDLINKEDSERVER or in Enterprise
Manager i select Linked Server in Security option of the database I receive
a error like "7303 - Sql can't initialize the database provider".
Probably I made mistake in the provider string but I don't have esperience
in SQL Server.
Francesco.|||I'm not sure what else to tell you.
As I already posted, for data source, use the IP address of
the AS400. For provider string, you need to include the
library you are using, connect timeout setting and code
page. You'd set the provider string somewhat like:
InitCat=YourLibrary;CCSID=37;PCCodePage=
1252;
Data Source=xxx.xxx.xxx.xxx
Settings will depend on how your AS400 is configured
There is some information on the provider string in the CA
help files. Make sure you can connect just using Client
Access as well.
-Sue
On Fri, 04 Mar 2005 21:38:43 GMT, "Francesco Trigiante"
<ftrigiante@.libero.it> wrote:
>On the machine I have installed Win 2003 server, Sql 2k and CA V5R3 with
>recent updates.
>I would to use the "IBMDA400 iSeries provider for DB2 UDB" odbc but when i
>set-up the linked server with the SP_ADDLINKEDSERVER or in Enterprise
>Manager i select Linked Server in Security option of the database I receive
>a error like "7303 - Sql can't initialize the database provider".
>Probably I made mistake in the provider string but I don't have esperience
>in SQL Server.
>
>Francesco.
>
I have a problem in SQL Server 2000. I need to connect as a linked server
the AS400 database (V5R3).
I read in the SQL documentation about the SP_ADDLINKEDSERVER stored
procedure and the linked server from SQL Manager but I'm not to be able to
have success using its.
The book's online of SQL Server sp3 is not very clear for me.
server name : s112233a
library : sales
object/file : order
member(optional) : orderFY05
Could you help me, please?
Thanks, Francesco.First you need to have the drivers, providers for the AS400
installed on the SQL Server box.
If you install Client Access on the server, it will install
and configure the drivers and providers for the AS400 on the
SQL Server box so that you can use linked servers. You
should also make sure you have the client updated with what
whatever service pack level based on updates to the AS400.
For data source, use the IP address of the AS400. For
provider string, you need to include the library you are
using, connect timeout setting and code page. There is some
documentation for the settings in the Client Access
help files. You'd set the provider string somewhat like:
InitCat=YourLibrary;CCSID=37;PCCodePage=
1252;
Data Source=xxx.xxx.xxx.xxx
Settings will depend on how your AS400 is configured. Again,
the Client Access help files have information on the
necessary connection string settings.
The logical or physical file you are accessing is what you
would reference as the table in your query against the
linked server.
-Sue
On Mon, 28 Feb 2005 21:38:36 GMT, "Francesco Trigiante"
<ftrigiante@.libero.it> wrote:
>Hi everybody,
>I have a problem in SQL Server 2000. I need to connect as a linked server
>the AS400 database (V5R3).
>I read in the SQL documentation about the SP_ADDLINKEDSERVER stored
>procedure and the linked server from SQL Manager but I'm not to be able to
>have success using its.
>The book's online of SQL Server sp3 is not very clear for me.
>server name : s112233a
>library : sales
>object/file : order
>member(optional) : orderFY05
>Could you help me, please?
>Thanks, Francesco.
>
>|||On the machine I have installed Win 2003 server, Sql 2k and CA V5R3 with
recent updates.
I would to use the "IBMDA400 iSeries provider for DB2 UDB" odbc but when i
set-up the linked server with the SP_ADDLINKEDSERVER or in Enterprise
Manager i select Linked Server in Security option of the database I receive
a error like "7303 - Sql can't initialize the database provider".
Probably I made mistake in the provider string but I don't have esperience
in SQL Server.
Francesco.|||I'm not sure what else to tell you.
As I already posted, for data source, use the IP address of
the AS400. For provider string, you need to include the
library you are using, connect timeout setting and code
page. You'd set the provider string somewhat like:
InitCat=YourLibrary;CCSID=37;PCCodePage=
1252;
Data Source=xxx.xxx.xxx.xxx
Settings will depend on how your AS400 is configured
There is some information on the provider string in the CA
help files. Make sure you can connect just using Client
Access as well.
-Sue
On Fri, 04 Mar 2005 21:38:43 GMT, "Francesco Trigiante"
<ftrigiante@.libero.it> wrote:
>On the machine I have installed Win 2003 server, Sql 2k and CA V5R3 with
>recent updates.
>I would to use the "IBMDA400 iSeries provider for DB2 UDB" odbc but when i
>set-up the linked server with the SP_ADDLINKEDSERVER or in Enterprise
>Manager i select Linked Server in Security option of the database I receive
>a error like "7303 - Sql can't initialize the database provider".
>Probably I made mistake in the provider string but I don't have esperience
>in SQL Server.
>
>Francesco.
>
as/400 linked server
Hi everybody,
I have a problem in SQL Server 2000. I need to connect as a linked server
the AS400 database (V5R3).
I read in the SQL documentation about the SP_ADDLINKEDSERVER stored
procedure and the linked server from SQL Manager but I'm not to be able to
have success using its.
The book's online of SQL Server sp3 is not very clear for me.
server name : s112233a
library : sales
object/file : order
member(optional) : orderFY05
Could you help me, please?
Thanks, Francesco.
First you need to have the drivers, providers for the AS400
installed on the SQL Server box.
If you install Client Access on the server, it will install
and configure the drivers and providers for the AS400 on the
SQL Server box so that you can use linked servers. You
should also make sure you have the client updated with what
whatever service pack level based on updates to the AS400.
For data source, use the IP address of the AS400. For
provider string, you need to include the library you are
using, connect timeout setting and code page. There is some
documentation for the settings in the Client Access
help files. You'd set the provider string somewhat like:
InitCat=YourLibrary;CCSID=37;PCCodePage=1252;
Data Source=xxx.xxx.xxx.xxx
Settings will depend on how your AS400 is configured. Again,
the Client Access help files have information on the
necessary connection string settings.
The logical or physical file you are accessing is what you
would reference as the table in your query against the
linked server.
-Sue
On Mon, 28 Feb 2005 21:38:36 GMT, "Francesco Trigiante"
<ftrigiante@.libero.it> wrote:
>Hi everybody,
>I have a problem in SQL Server 2000. I need to connect as a linked server
>the AS400 database (V5R3).
>I read in the SQL documentation about the SP_ADDLINKEDSERVER stored
>procedure and the linked server from SQL Manager but I'm not to be able to
>have success using its.
>The book's online of SQL Server sp3 is not very clear for me.
>server name : s112233a
>library : sales
>object/file : order
>member(optional) : orderFY05
>Could you help me, please?
>Thanks, Francesco.
>
>
|||On the machine I have installed Win 2003 server, Sql 2k and CA V5R3 with
recent updates.
I would to use the "IBMDA400 iSeries provider for DB2 UDB" odbc but when i
set-up the linked server with the SP_ADDLINKEDSERVER or in Enterprise
Manager i select Linked Server in Security option of the database I receive
a error like "7303 - Sql can't initialize the database provider".
Probably I made mistake in the provider string but I don't have esperience
in SQL Server.
Francesco.
|||I'm not sure what else to tell you.
As I already posted, for data source, use the IP address of
the AS400. For provider string, you need to include the
library you are using, connect timeout setting and code
page. You'd set the provider string somewhat like:
InitCat=YourLibrary;CCSID=37;PCCodePage=1252;
Data Source=xxx.xxx.xxx.xxx
Settings will depend on how your AS400 is configured
There is some information on the provider string in the CA
help files. Make sure you can connect just using Client
Access as well.
-Sue
On Fri, 04 Mar 2005 21:38:43 GMT, "Francesco Trigiante"
<ftrigiante@.libero.it> wrote:
>On the machine I have installed Win 2003 server, Sql 2k and CA V5R3 with
>recent updates.
>I would to use the "IBMDA400 iSeries provider for DB2 UDB" odbc but when i
>set-up the linked server with the SP_ADDLINKEDSERVER or in Enterprise
>Manager i select Linked Server in Security option of the database I receive
>a error like "7303 - Sql can't initialize the database provider".
>Probably I made mistake in the provider string but I don't have esperience
>in SQL Server.
>
>Francesco.
>
I have a problem in SQL Server 2000. I need to connect as a linked server
the AS400 database (V5R3).
I read in the SQL documentation about the SP_ADDLINKEDSERVER stored
procedure and the linked server from SQL Manager but I'm not to be able to
have success using its.
The book's online of SQL Server sp3 is not very clear for me.
server name : s112233a
library : sales
object/file : order
member(optional) : orderFY05
Could you help me, please?
Thanks, Francesco.
First you need to have the drivers, providers for the AS400
installed on the SQL Server box.
If you install Client Access on the server, it will install
and configure the drivers and providers for the AS400 on the
SQL Server box so that you can use linked servers. You
should also make sure you have the client updated with what
whatever service pack level based on updates to the AS400.
For data source, use the IP address of the AS400. For
provider string, you need to include the library you are
using, connect timeout setting and code page. There is some
documentation for the settings in the Client Access
help files. You'd set the provider string somewhat like:
InitCat=YourLibrary;CCSID=37;PCCodePage=1252;
Data Source=xxx.xxx.xxx.xxx
Settings will depend on how your AS400 is configured. Again,
the Client Access help files have information on the
necessary connection string settings.
The logical or physical file you are accessing is what you
would reference as the table in your query against the
linked server.
-Sue
On Mon, 28 Feb 2005 21:38:36 GMT, "Francesco Trigiante"
<ftrigiante@.libero.it> wrote:
>Hi everybody,
>I have a problem in SQL Server 2000. I need to connect as a linked server
>the AS400 database (V5R3).
>I read in the SQL documentation about the SP_ADDLINKEDSERVER stored
>procedure and the linked server from SQL Manager but I'm not to be able to
>have success using its.
>The book's online of SQL Server sp3 is not very clear for me.
>server name : s112233a
>library : sales
>object/file : order
>member(optional) : orderFY05
>Could you help me, please?
>Thanks, Francesco.
>
>
|||On the machine I have installed Win 2003 server, Sql 2k and CA V5R3 with
recent updates.
I would to use the "IBMDA400 iSeries provider for DB2 UDB" odbc but when i
set-up the linked server with the SP_ADDLINKEDSERVER or in Enterprise
Manager i select Linked Server in Security option of the database I receive
a error like "7303 - Sql can't initialize the database provider".
Probably I made mistake in the provider string but I don't have esperience
in SQL Server.
Francesco.
|||I'm not sure what else to tell you.
As I already posted, for data source, use the IP address of
the AS400. For provider string, you need to include the
library you are using, connect timeout setting and code
page. You'd set the provider string somewhat like:
InitCat=YourLibrary;CCSID=37;PCCodePage=1252;
Data Source=xxx.xxx.xxx.xxx
Settings will depend on how your AS400 is configured
There is some information on the provider string in the CA
help files. Make sure you can connect just using Client
Access as well.
-Sue
On Fri, 04 Mar 2005 21:38:43 GMT, "Francesco Trigiante"
<ftrigiante@.libero.it> wrote:
>On the machine I have installed Win 2003 server, Sql 2k and CA V5R3 with
>recent updates.
>I would to use the "IBMDA400 iSeries provider for DB2 UDB" odbc but when i
>set-up the linked server with the SP_ADDLINKEDSERVER or in Enterprise
>Manager i select Linked Server in Security option of the database I receive
>a error like "7303 - Sql can't initialize the database provider".
>Probably I made mistake in the provider string but I don't have esperience
>in SQL Server.
>
>Francesco.
>
AS/400 DB2 Driver
Hi,
I tried the way of adding a Linked Server.But DB2OLEDB provider is not listing on the
Provider Name combo box when i go to add it.Waht should I do?
In the Provider String there are two attributes call
Package Collection=MyPkgCol;
Default Schema=Schema;
What does it mean?
This is SQL I used.
EXEC sp_addlinkedserver
@.server = '10.1.0.7',
@.provider = 'DB2OLEDB',
@.srvproduct = '',
@.provstr = 'Provider=DB2OLEDB;Network Transport Library=TCPIP;Network
Address=100.1.0.27;Initial Catalog=Depani;User ID=gift;Password=gift;'
Any coding related to Please send me.
Thanks.
Pubudu
If you have any issue with DB2OLEDB provider then you can use the following Driver.
Note: Your Server need to have the DRIVER/PROVIDER. If it is not available you can get it from IBM-DB2 site.
Driver={IBM DB2 ODBC DRIVER};Database=myDataBase;Hostname=myServerAddress;Port=1234;Protocol=TCPIP;Uid=myUsername;Pwd=myPassword;
|||I have installed the AS400 DB2 client and Im having a provider call IBM AS400
OLEDB Provider.
I have used in this way
'Driver={IBM AS400 OLEDB Provider};Database=upul;Hostname=10.1.0.4;Port=23;Protocol=TCPIP;Uid=upul;Pwd=upul02;'
Please help me.
Thanks,
Pubudu
|||Are you able to connect the server.
If not use the IBM's oledb provider..
Provider=IBMDADB2;Database=myDataBase;Hostname=myServerAddress;Protocol=TCPIP;Port=50000;Uid=myUsername;Pwd=myPassword;
AS/400 DB2 and SQL Server..
Hi Guys,
We are using Linked server to access DB2 on AS/400 from SQL Server. Well, things are fine when we test with SELECT statement. When we use update etc... a strange error comes up. Cannot open File 'C:\Program Files\DataDirect\ODBC41\Drivers\.'. Well, on the first time I did an update it seemed like it worked. But I had given the wrong Criteria so nothing got updated. But going forward, I am always getting this error. Can somebody please help me.
Thanks in advance
AshokIt is ok now guys. It turned out we had not set up the journal properly on the AS/400. It works great now.
We are using Linked server to access DB2 on AS/400 from SQL Server. Well, things are fine when we test with SELECT statement. When we use update etc... a strange error comes up. Cannot open File 'C:\Program Files\DataDirect\ODBC41\Drivers\.'. Well, on the first time I did an update it seemed like it worked. But I had given the wrong Criteria so nothing got updated. But going forward, I am always getting this error. Can somebody please help me.
Thanks in advance
AshokIt is ok now guys. It turned out we had not set up the journal properly on the AS/400. It works great now.
AS/400 DB2 Access through SQL Server 2000
Hi,
I tried the way of adding a Linked Server.But DB2OLEDB provider is not listing on the
Provider Name combo box when i go to add it.Waht should I do?
In the Provider String there are two attributes call
Package Collection=MyPkgCol;
Default Schema=Schema;
What does it mean?
This is SQL I used.
EXEC sp_addlinkedserver
@.server = '10.1.0.7',
@.provider = 'DB2OLEDB',
@.srvproduct = '',
@.provstr = 'Provider=DB2OLEDB;Network Transport Library=TCPIP;Network
Address=100.1.0.27;Initial Catalog=Depani;User ID=gift;Password=gift;'
Any coding related to Please send me.
Thanks.
Pubudu
If you have any issue with DB2OLEDB provider then you can use the following Driver.
Note: Your Server need to have the DRIVER/PROVIDER. If it is not available you can get it from IBM-DB2 site.
Driver={IBM DB2 ODBC DRIVER};Database=myDataBase;Hostname=myServerAddress;Port=1234;Protocol=TCPIP;Uid=myUsername;Pwd=myPassword;
|||I have installed the AS400 DB2 client and Im having a provider call IBM AS400
OLEDB Provider.
I have used in this way
'Driver={IBM AS400 OLEDB Provider};Database=upul;Hostname=10.1.0.4;Port=23;Protocol=TCPIP;Uid=upul;Pwd=upul02;'
Please help me.
Thanks,
Pubudu
|||Are you able to connect the server.
If not use the IBM's oledb provider..
Provider=IBMDADB2;Database=myDataBase;Hostname=myServerAddress;Protocol=TCPIP;Port=50000;Uid=myUsername;Pwd=myPassword;
Friday, February 24, 2012
Arrrggh - Linked Server issue
Help! I can't seem to get the permissions right on my linked server. I keep getting this error:
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSOLAP.3" for linked server "DW" reported an error. Access denied.
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "MSOLAP.3" for linked server "DW".
Here you go: http://support.microsoft.com/kb/925869
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
|||
Thank you. That helped. Now when i query using a SQL Server user (non-windows) I get this response:
OLE DB provider "MSOLAP" for linked server "DW" returned message "An error was encountered in the transport layer.".
OLE DB provider "MSOLAP" for linked server "DW" returned message "The peer prematurely closed the connection.".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "DW".
I noticed in the profiler that the user who is connecting is anonymous logon and I turned the required auth on AS off, but I have no idea what permissions are needed to allow this to work.
Subscribe to:
Posts (Atom)