ERRORS on Insert/Update DB2 from SQL Enterprise Manager (linked server)

I've set up an AS400/DB2 as a linked server, all standard configs (V4R5) on a SQL server 2000 machine and can select all day long. When I go to update or insert it throws an error referencing my driver. I'm using the HIS/OLEDB2 driver. Any ideas? Someone mentioned turning on Journaling on the 400?

Anything at this point would helpRE:
Q1 I'm using the HIS/OLEDB2 driver and can select all day long. When I go to update or insert it throws an error referencing my driver. Any ideas? Anything at this point would help

A1 Perhaps DB2 Connect provides a better odbc driver? Per IBM, DB2 Connect: "Provides extensive application programming tools for developing client-server and web applications using industry standard APIs such as ODBC, ADO, OLE DB, JDBC, SQLJ, DB2 CLI and Embedded SQL."

See: http://www-3.ibm.com/software/data/db2/db2connect/|||I found an answer that worked from a colleague. Thanks.

errors in ssis package execution

i have sql server 2005 standard edition(9.0.3054) with sp2, My ssis packages
were initially working fine,After installing sql server 2008 ctp, all ssis
packages stopped executing and giving error "Could not create DTS.Application
because of error 0x80040154", also import export wizard in sql 2005 is not
working.
After that i uninstalled sql server 2008 ctp and integration
service of sql 2005, and again installed integrtaion service of sql 2005 but
still i am getting error in ssis package execution.Please suggest me a
solution asap , as it is on a production server.
Thanks
Rupesh Mondal.
I had already removed and reinstalled "ssis" but it didnt worked ok,and i
already had sp2 installed on my database server.
Thanks and Regards,
Rupesh Mondal.
"John Bell" wrote:

> "Rupesh Mondal" <RupeshMondal@.discussions.microsoft.com> wrote in message
> news:CF99A5D6-B6C6-4484-9BD2-B6237A1A3D05@.microsoft.com...
> Hi Rupesh
> Error Code 0x80040154 relates to class not registered, therefore it looks
> like a SSIS component has been corrupted. The easiest solution may be to
> remove and re-install SSIS or SQL Server. If you are not on SP2 then you may
> just get away with installing that.
> John
>
>

errors in ssis package execution

i have sql server 2005 standard edition(9.0.3054) with sp2, My ssis packages
were initially working fine,After installing sql server 2008 ctp, all ssis
packages stopped executing and giving error "Could not create DTS.Application
because of error 0x80040154", also import export wizard in sql 2005 is not
working.
After that i uninstalled sql server 2008 ctp and integration
service of sql 2005, and again installed integrtaion service of sql 2005 but
still i am getting error in ssis package execution.Please suggest me a
solution asap , as it is on a production server.
Thanks
Rupesh Mondal."Rupesh Mondal" <RupeshMondal@.discussions.microsoft.com> wrote in message
news:CF99A5D6-B6C6-4484-9BD2-B6237A1A3D05@.microsoft.com...
>i have sql server 2005 standard edition(9.0.3054) with sp2, My ssis
>packages
> were initially working fine,After installing sql server 2008 ctp, all ssis
> packages stopped executing and giving error "Could not create
> DTS.Application
> because of error 0x80040154", also import export wizard in sql 2005 is not
> working.
> After that i uninstalled sql server 2008 ctp and integration
> service of sql 2005, and again installed integrtaion service of sql 2005
> but
> still i am getting error in ssis package execution.Please suggest me a
> solution asap , as it is on a production server.
> Thanks
> Rupesh Mondal.
Hi Rupesh
Error Code 0x80040154 relates to class not registered, therefore it looks
like a SSIS component has been corrupted. The easiest solution may be to
remove and re-install SSIS or SQL Server. If you are not on SP2 then you may
just get away with installing that.
John|||I had already removed and reinstalled "ssis" but it didnt worked ok,and i
already had sp2 installed on my database server.
Thanks and Regards,
Rupesh Mondal.
"John Bell" wrote:
> "Rupesh Mondal" <RupeshMondal@.discussions.microsoft.com> wrote in message
> news:CF99A5D6-B6C6-4484-9BD2-B6237A1A3D05@.microsoft.com...
> >i have sql server 2005 standard edition(9.0.3054) with sp2, My ssis
> >packages
> > were initially working fine,After installing sql server 2008 ctp, all ssis
> > packages stopped executing and giving error "Could not create
> > DTS.Application
> > because of error 0x80040154", also import export wizard in sql 2005 is not
> > working.
> > After that i uninstalled sql server 2008 ctp and integration
> > service of sql 2005, and again installed integrtaion service of sql 2005
> > but
> > still i am getting error in ssis package execution.Please suggest me a
> > solution asap , as it is on a production server.
> >
> > Thanks
> > Rupesh Mondal.
> Hi Rupesh
> Error Code 0x80040154 relates to class not registered, therefore it looks
> like a SSIS component has been corrupted. The easiest solution may be to
> remove and re-install SSIS or SQL Server. If you are not on SP2 then you may
> just get away with installing that.
> John
>
>|||Hi
Have you re-installed .NET? Otherwise I would re-install from scratch.
Hopefully this is not a production server!
John
"Rupesh Mondal" <RupeshMondal@.discussions.microsoft.com> wrote in message
news:81A467AD-B56B-44FC-92C9-D4FA96019C87@.microsoft.com...
>I had already removed and reinstalled "ssis" but it didnt worked ok,and i
> already had sp2 installed on my database server.
> Thanks and Regards,
> Rupesh Mondal.
> "John Bell" wrote:
>> "Rupesh Mondal" <RupeshMondal@.discussions.microsoft.com> wrote in message
>> news:CF99A5D6-B6C6-4484-9BD2-B6237A1A3D05@.microsoft.com...
>> >i have sql server 2005 standard edition(9.0.3054) with sp2, My ssis
>> >packages
>> > were initially working fine,After installing sql server 2008 ctp, all
>> > ssis
>> > packages stopped executing and giving error "Could not create
>> > DTS.Application
>> > because of error 0x80040154", also import export wizard in sql 2005 is
>> > not
>> > working.
>> > After that i uninstalled sql server 2008 ctp and
>> > integration
>> > service of sql 2005, and again installed integrtaion service of sql
>> > 2005
>> > but
>> > still i am getting error in ssis package execution.Please suggest me a
>> > solution asap , as it is on a production server.
>> >
>> > Thanks
>> > Rupesh Mondal.
>> Hi Rupesh
>> Error Code 0x80040154 relates to class not registered, therefore it looks
>> like a SSIS component has been corrupted. The easiest solution may be to
>> remove and re-install SSIS or SQL Server. If you are not on SP2 then you
>> may
>> just get away with installing that.
>> John
>>

Error:40

I'm using VS2005 Standard Edition with SQL 2000 and get the following error message:

Whenconnecting to SQL Server 2005, this failure may be caused by the factthat under the default settings SQL Server does not allow remoteconnections. (provider: Named Pipes Provider, error: 40 - Could notopen a connection to SQL Server)

I've seen lots of people talking about SQL2005 Express but I'm not even using that version?? I know it gets installed by default when you install VS2005 but I've never used it. I've checked the connection properties to make sure that "using local and remote connections" is checked etc, but still I get the error can any one please help?

Hey,

You can configure that through the SQL Server Surface Area Configuration tool for SQL 2005; I'm assuming that you may be doing something that created the ASPNETDB.mdf file that contains membership/role/profile/other information in it by default... You can tell if you refresh the App_Data folder...

|||Hi,

It did create the ASPNETDB.mdf file and asked me if I wanted to put it somewhere....
I'd been through the surface area tool and made sure that everything is 'enabled' i.e. IP/TCP

I've used sql express before with VWD Express and I never had any problems, but now using a full version of VS2005 it all falls apart! Should I delete the ASPNETDB.mdf file as I'm not using sql express?

This whole problem is driving me up the wall!!|||

Hey,

You don't have to use the ASPNETDB.mdf file, but if you don't use a custom provider, and you access a feature that uses membership/personalization, or if you use the ASP.NET configuration tool, then it will create it for you. Be aware of that...

So you setup under View by Instance > Database Engine> Remote Connections, and made it local and remote connections?

|||Sorry, what program should I be using to do: So you setup under View by Instance > Database Engine> Remote Connections, and made it local and remote connections ?

Many thanks,
James|||Sorry, what program should I be using to do: So you setup under View byInstance > Database Engine> Remote Connections, and made it localand remote connections ?

Many thanks,
James|||Oh, sorry, the SQL Server Surface Area Configuration tool. Then click the first option link (view by ... forget the exact text)|||I have configured as you advised, Remote Connections > Local And Remote Connections
but the sub option I chose was "Using TCP/IP Only", is this correct or should I have chosen the
"Using both TCP/IP and named pipes" option?

Many thanks|||

Hey,

Try TCP/IP only; if that still gives you an error, try named pipes as well. If both don't correct the problem, we know it isn't related to that...

|||I've tried both and it's still the same error.
All I'm trying to do is click on a hyperlink within a gridviewand it passes to another page with a querystring object. The gridview itself populates fine from a remote database which makes me think maybe its something else too!

I'm in the process of migrating an application I created from asp 1.1 (vs2003) to 2.0 (vs2005)
Ihave a datagrid with a hyperlink with a querystring column that whenclicked takes you to another page with parameter "id={0}". However, thedatagrid property builder in vs2003 makes me use three items:
textfield (column name from sql database)
URLField (StudentId - the primary key from sql table)
URLFormatString (updateStudent.aspx?id={0} - this is the page i'm navigating to along with my param)

but in vs2005 the gridview has different options (DataNavigateURL .....etc)
Are you please able to tell me what data needs to go in what property box on the GridView ?

Many thanks
James|||

Hey,

Yeah, DataNavigateUrl is the name of the field that is the ID value in the querystring. DataNavigateUrlFormatString is where you put the page name and the querystring text, such as "otherpage.aspx?id={0}" when the code runs, {0} gets replaced with the value in the field specified by DataNavigateUrl. You can also specify DataTextField to dynamically get the text value and the DataTextFieldFormatString to format that text as well, or just use Text to render static text for the link.

|||

jimmy_fingers:

I'm using VS2005 Standard Edition with SQL 2000 and get the following error message:

When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I've seen lots of people talking about SQL2005 Express but I'm not even using that version?? I know it gets installed by default when you install VS2005 but I've never used it. I've checked the connection properties to make sure that "using local and remote connections" is checked etc, but still I get the error can any one please help?

In Enterprise Manager at the top right click and go to server properties then Network Configurations make sure both TCP/IP and Named Pipes is enabled. Then go to VS2005 at the top click on the Data Link Property to connect. Hope this helps.

|||I appear to have all three properties set up correctly:
DataNavigateUrlField - studentId (primary key for the table in question)
DataNavigateUrlFormatString - updateStudents.aspx?id={0}
DataTextField - StudentName (table column being displayed)

but I'm still getting the same error??|||I'm so very sorry I feel such an idiot!!! I'd made a mistake with my connection string in web.config file.
Although I had done the auto connection I had also hard coded a connection string myself and made a spelling mistake - ROOKIE ERROR! lol

Many thanks though for your help,
James|||

Hey,

No problem. I do it all the time.