Connecting Tech Pros Worldwide Help | Site Map
 
 
LinkBack Thread Tools Search this Thread
  #1  
Old November 12th, 2005, 10:45 AM
Mauro Miotello
Guest
 
Posts: n/a
Default db2app.dll

I've to create a webapp with VS.Studio.NET 2003 and DB2 Enterprise.
I've create a webform and put this code on PageLoad event:

1 Dim strConnection As String
2 strConnection =
ConfigurationSettings.AppSettings("DB2Connection.C onnectionString")
3 Dim DB2Conn = New IBM.Data.DB2.DB2Connection(strConnection)

4 Dim qry As String = "SELECT Codice, Ragionesoc as [Ragione
Sociale], Localita, Paiv AS [Partita Iva] FROM(Clifo)WHERE (Codice = @src OR
RagioneSoc like '%' + @src+ '%' OR Paiv = @src OR Tel like '%' + @src+ '%')
AND (Tipo = 'C' OR Tipo = 'P')"
5 Dim cmdCC As New IBM.Data.DB2.DB2Command(qry, DB2Conn)
6 cmdCC.Parameters.Add("@src", IBM.Data.DB2.DB2Type.VarChar,
100).Value = TBox.Text
7 Dim daGetClienti As New IBM.Data.DB2.DB2DataAdapter(cmdCC)
8 Dim dsClienti As New DataSet
9 daGetClienti.Fill(dsClienti, "ClientiTrovati")


running, on row 3 VS.Studio stop with this error: .. unable to load DLL
'db2app.dll' ....
someone have found same problem ?
someone have a solution ?

thanks

mauro


  #2  
Old November 12th, 2005, 10:45 AM
Jean-Marc Blaise
Guest
 
Posts: n/a
Default Re: db2app.dll

"Mauro Miotello" <sviluppo@ashnet.it> a écrit dans le message de
news:d5imi9$u1h$1@news.ngi.it...[color=blue]
> I've to create a webapp with VS.Studio.NET 2003 and DB2 Enterprise.
> I've create a webform and put this code on PageLoad event:
>
> 1 Dim strConnection As String
> 2 strConnection =
> ConfigurationSettings.AppSettings("DB2Connection.C onnectionString")
> 3 Dim DB2Conn = New IBM.Data.DB2.DB2Connection(strConnection)
>
> 4 Dim qry As String = "SELECT Codice, Ragionesoc as [Ragione
> Sociale], Localita, Paiv AS [Partita Iva] FROM(Clifo)WHERE (Codice = @src[/color]
OR[color=blue]
> RagioneSoc like '%' + @src+ '%' OR Paiv = @src OR Tel like '%' + @src+[/color]
'%')[color=blue]
> AND (Tipo = 'C' OR Tipo = 'P')"
> 5 Dim cmdCC As New IBM.Data.DB2.DB2Command(qry, DB2Conn)
> 6 cmdCC.Parameters.Add("@src", IBM.Data.DB2.DB2Type.VarChar,
> 100).Value = TBox.Text
> 7 Dim daGetClienti As New IBM.Data.DB2.DB2DataAdapter(cmdCC)
> 8 Dim dsClienti As New DataSet
> 9 daGetClienti.Fill(dsClienti, "ClientiTrovati")
>
>
> running, on row 3 VS.Studio stop with this error: .. unable to load DLL
> 'db2app.dll' ....
> someone have found same problem ?
> someone have a solution ?
>
> thanks
>
> mauro
>[/color]

I think you need to register the dll yourself, as described in

http://www-1.ibm.com/support/docview...=UTF-8&lang=en

HTH,

Jean-Marc


  #3  
Old November 12th, 2005, 10:45 AM
Mauro Miotello
Guest
 
Posts: n/a
Default Re: db2app.dll

Thanks for your info, i've tried to register this dll with utility found in
your IBM link and it was registered correctly
I've verified on my registry

but the program does'nt run

the strange thing is if i create connection, dataadapter and dataset at
design time, all it's ok
i don't understand..

bye

thanks

mauro

"Jean-Marc Blaise" <nobody@nowhere.com> ha scritto nel messaggio
news:427d2d5a$0$3134$8fcfb975@news.wanadoo.fr...[color=blue]
> "Mauro Miotello" <sviluppo@ashnet.it> a écrit dans le message de
> news:d5imi9$u1h$1@news.ngi.it...[color=green]
>> I've to create a webapp with VS.Studio.NET 2003 and DB2 Enterprise.
>> I've create a webform and put this code on PageLoad event:
>>
>> 1 Dim strConnection As String
>> 2 strConnection =
>> ConfigurationSettings.AppSettings("DB2Connection.C onnectionString")
>> 3 Dim DB2Conn = New IBM.Data.DB2.DB2Connection(strConnection)
>>
>> 4 Dim qry As String = "SELECT Codice, Ragionesoc as [Ragione
>> Sociale], Localita, Paiv AS [Partita Iva] FROM(Clifo)WHERE (Codice = @src[/color]
> OR[color=green]
>> RagioneSoc like '%' + @src+ '%' OR Paiv = @src OR Tel like '%' + @src+[/color]
> '%')[color=green]
>> AND (Tipo = 'C' OR Tipo = 'P')"
>> 5 Dim cmdCC As New IBM.Data.DB2.DB2Command(qry, DB2Conn)
>> 6 cmdCC.Parameters.Add("@src", IBM.Data.DB2.DB2Type.VarChar,
>> 100).Value = TBox.Text
>> 7 Dim daGetClienti As New IBM.Data.DB2.DB2DataAdapter(cmdCC)
>> 8 Dim dsClienti As New DataSet
>> 9 daGetClienti.Fill(dsClienti, "ClientiTrovati")
>>
>>
>> running, on row 3 VS.Studio stop with this error: .. unable to load DLL
>> 'db2app.dll' ....
>> someone have found same problem ?
>> someone have a solution ?
>>
>> thanks
>>
>> mauro
>>[/color]
>
> I think you need to register the dll yourself, as described in
>
> http://www-1.ibm.com/support/docview...=UTF-8&lang=en
>
> HTH,
>
> Jean-Marc
>
>[/color]


  #4  
Old November 12th, 2005, 10:45 AM
Mark Yudkin
Guest
 
Posts: n/a
Default Re: db2app.dll

Is the containing directory on your _system_ PATH?

"Mauro Miotello" <sviluppo@ashnet.it> wrote in message
news:d5jh8j$7r1$1@news.ngi.it...[color=blue]
> Thanks for your info, i've tried to register this dll with utility found
> in your IBM link and it was registered correctly
> I've verified on my registry
>
> but the program does'nt run
>
> the strange thing is if i create connection, dataadapter and dataset at
> design time, all it's ok
> i don't understand..
>
> bye
>
> thanks
>
> mauro
>
> "Jean-Marc Blaise" <nobody@nowhere.com> ha scritto nel messaggio
> news:427d2d5a$0$3134$8fcfb975@news.wanadoo.fr...[color=green]
>> "Mauro Miotello" <sviluppo@ashnet.it> a écrit dans le message de
>> news:d5imi9$u1h$1@news.ngi.it...[color=darkred]
>>> I've to create a webapp with VS.Studio.NET 2003 and DB2 Enterprise.
>>> I've create a webform and put this code on PageLoad event:
>>>
>>> 1 Dim strConnection As String
>>> 2 strConnection =
>>> ConfigurationSettings.AppSettings("DB2Connection.C onnectionString")
>>> 3 Dim DB2Conn = New IBM.Data.DB2.DB2Connection(strConnection)
>>>
>>> 4 Dim qry As String = "SELECT Codice, Ragionesoc as [Ragione
>>> Sociale], Localita, Paiv AS [Partita Iva] FROM(Clifo)WHERE (Codice =
>>> @src[/color]
>> OR[color=darkred]
>>> RagioneSoc like '%' + @src+ '%' OR Paiv = @src OR Tel like '%' + @src+[/color]
>> '%')[color=darkred]
>>> AND (Tipo = 'C' OR Tipo = 'P')"
>>> 5 Dim cmdCC As New IBM.Data.DB2.DB2Command(qry, DB2Conn)
>>> 6 cmdCC.Parameters.Add("@src", IBM.Data.DB2.DB2Type.VarChar,
>>> 100).Value = TBox.Text
>>> 7 Dim daGetClienti As New IBM.Data.DB2.DB2DataAdapter(cmdCC)
>>> 8 Dim dsClienti As New DataSet
>>> 9 daGetClienti.Fill(dsClienti, "ClientiTrovati")
>>>
>>>
>>> running, on row 3 VS.Studio stop with this error: .. unable to load DLL
>>> 'db2app.dll' ....
>>> someone have found same problem ?
>>> someone have a solution ?
>>>
>>> thanks
>>>
>>> mauro
>>>[/color]
>>
>> I think you need to register the dll yourself, as described in
>>
>> http://www-1.ibm.com/support/docview...=UTF-8&lang=en
>>
>> HTH,
>>
>> Jean-Marc
>>
>>[/color]
>
>[/color]


  #5  
Old November 12th, 2005, 10:45 AM
Mauro Miotello
Guest
 
Posts: n/a
Default Re: db2app.dll

Yes i've c:\programmi\IBM\SQLLIB\BIN on my system path !

"Mark Yudkin" <myudkinATcompuserveDOTcom@boing.org> ha scritto nel messaggio
news:427dc2d3$0$1163$5402220f@news.sunrise.ch...[color=blue]
> Is the containing directory on your _system_ PATH?
>
> "Mauro Miotello" <sviluppo@ashnet.it> wrote in message
> news:d5jh8j$7r1$1@news.ngi.it...[color=green]
>> Thanks for your info, i've tried to register this dll with utility found
>> in your IBM link and it was registered correctly
>> I've verified on my registry
>>
>> but the program does'nt run
>>
>> the strange thing is if i create connection, dataadapter and dataset at
>> design time, all it's ok
>> i don't understand..
>>
>> bye
>>
>> thanks
>>
>> mauro
>>
>> "Jean-Marc Blaise" <nobody@nowhere.com> ha scritto nel messaggio
>> news:427d2d5a$0$3134$8fcfb975@news.wanadoo.fr...[color=darkred]
>>> "Mauro Miotello" <sviluppo@ashnet.it> a écrit dans le message de
>>> news:d5imi9$u1h$1@news.ngi.it...
>>>> I've to create a webapp with VS.Studio.NET 2003 and DB2 Enterprise.
>>>> I've create a webform and put this code on PageLoad event:
>>>>
>>>> 1 Dim strConnection As String
>>>> 2 strConnection =
>>>> ConfigurationSettings.AppSettings("DB2Connection.C onnectionString")
>>>> 3 Dim DB2Conn = New IBM.Data.DB2.DB2Connection(strConnection)
>>>>
>>>> 4 Dim qry As String = "SELECT Codice, Ragionesoc as [Ragione
>>>> Sociale], Localita, Paiv AS [Partita Iva] FROM(Clifo)WHERE (Codice =
>>>> @src
>>> OR
>>>> RagioneSoc like '%' + @src+ '%' OR Paiv = @src OR Tel like '%' + @src+
>>> '%')
>>>> AND (Tipo = 'C' OR Tipo = 'P')"
>>>> 5 Dim cmdCC As New IBM.Data.DB2.DB2Command(qry, DB2Conn)
>>>> 6 cmdCC.Parameters.Add("@src", IBM.Data.DB2.DB2Type.VarChar,
>>>> 100).Value = TBox.Text
>>>> 7 Dim daGetClienti As New IBM.Data.DB2.DB2DataAdapter(cmdCC)
>>>> 8 Dim dsClienti As New DataSet
>>>> 9 daGetClienti.Fill(dsClienti, "ClientiTrovati")
>>>>
>>>>
>>>> running, on row 3 VS.Studio stop with this error: .. unable to load DLL
>>>> 'db2app.dll' ....
>>>> someone have found same problem ?
>>>> someone have a solution ?
>>>>
>>>> thanks
>>>>
>>>> mauro
>>>>
>>>
>>> I think you need to register the dll yourself, as described in
>>>
>>> http://www-1.ibm.com/support/docview...=UTF-8&lang=en
>>>
>>> HTH,
>>>
>>> Jean-Marc
>>>
>>>[/color]
>>
>>[/color]
>
>[/color]


  #6  
Old November 12th, 2005, 10:45 AM
Mauro Miotello
Guest
 
Posts: n/a
Default Re: db2app.dll

I've found other people with same problem here:
http://www.webservertalk.com/archive...4-1008001.html

bye

Mauro

"Mauro Miotello" <sviluppo@ashnet.it> ha scritto nel messaggio
news:d5nseh$qrb$1@news.ngi.it...[color=blue]
> Yes i've c:\programmi\IBM\SQLLIB\BIN on my system path !
>
> "Mark Yudkin" <myudkinATcompuserveDOTcom@boing.org> ha scritto nel
> messaggio news:427dc2d3$0$1163$5402220f@news.sunrise.ch...[color=green]
>> Is the containing directory on your _system_ PATH?
>>
>> "Mauro Miotello" <sviluppo@ashnet.it> wrote in message
>> news:d5jh8j$7r1$1@news.ngi.it...[color=darkred]
>>> Thanks for your info, i've tried to register this dll with utility found
>>> in your IBM link and it was registered correctly
>>> I've verified on my registry
>>>
>>> but the program does'nt run
>>>
>>> the strange thing is if i create connection, dataadapter and dataset at
>>> design time, all it's ok
>>> i don't understand..
>>>
>>> bye
>>>
>>> thanks
>>>
>>> mauro
>>>
>>> "Jean-Marc Blaise" <nobody@nowhere.com> ha scritto nel messaggio
>>> news:427d2d5a$0$3134$8fcfb975@news.wanadoo.fr...
>>>> "Mauro Miotello" <sviluppo@ashnet.it> a écrit dans le message de
>>>> news:d5imi9$u1h$1@news.ngi.it...
>>>>> I've to create a webapp with VS.Studio.NET 2003 and DB2 Enterprise.
>>>>> I've create a webform and put this code on PageLoad event:
>>>>>
>>>>> 1 Dim strConnection As String
>>>>> 2 strConnection =
>>>>> ConfigurationSettings.AppSettings("DB2Connection.C onnectionString")
>>>>> 3 Dim DB2Conn = New IBM.Data.DB2.DB2Connection(strConnection)
>>>>>
>>>>> 4 Dim qry As String = "SELECT Codice, Ragionesoc as [Ragione
>>>>> Sociale], Localita, Paiv AS [Partita Iva] FROM(Clifo)WHERE (Codice =
>>>>> @src
>>>> OR
>>>>> RagioneSoc like '%' + @src+ '%' OR Paiv = @src OR Tel like '%' + @src+
>>>> '%')
>>>>> AND (Tipo = 'C' OR Tipo = 'P')"
>>>>> 5 Dim cmdCC As New IBM.Data.DB2.DB2Command(qry, DB2Conn)
>>>>> 6 cmdCC.Parameters.Add("@src", IBM.Data.DB2.DB2Type.VarChar,
>>>>> 100).Value = TBox.Text
>>>>> 7 Dim daGetClienti As New IBM.Data.DB2.DB2DataAdapter(cmdCC)
>>>>> 8 Dim dsClienti As New DataSet
>>>>> 9 daGetClienti.Fill(dsClienti, "ClientiTrovati")
>>>>>
>>>>>
>>>>> running, on row 3 VS.Studio stop with this error: .. unable to load
>>>>> DLL
>>>>> 'db2app.dll' ....
>>>>> someone have found same problem ?
>>>>> someone have a solution ?
>>>>>
>>>>> thanks
>>>>>
>>>>> mauro
>>>>>
>>>>
>>>> I think you need to register the dll yourself, as described in
>>>>
>>>> http://www-1.ibm.com/support/docview...=UTF-8&lang=en
>>>>
>>>> HTH,
>>>>
>>>> Jean-Marc
>>>>
>>>>
>>>
>>>[/color]
>>
>>[/color]
>
>[/color]


  #7  
Old November 12th, 2005, 10:46 AM
Mark Yudkin
Guest
 
Posts: n/a
Default Re: db2app.dll

Their problem was a configuration problem on their systems. But if your
problem has the same cause, fine.

"Mauro Miotello" <sviluppo@ashnet.it> wrote in message
news:d5nupk$rni$1@news.ngi.it...[color=blue]
> I've found other people with same problem here:
> http://www.webservertalk.com/archive...4-1008001.html
>
> bye
>
> Mauro
>
> "Mauro Miotello" <sviluppo@ashnet.it> ha scritto nel messaggio
> news:d5nseh$qrb$1@news.ngi.it...[color=green]
>> Yes i've c:\programmi\IBM\SQLLIB\BIN on my system path !
>>
>> "Mark Yudkin" <myudkinATcompuserveDOTcom@boing.org> ha scritto nel
>> messaggio news:427dc2d3$0$1163$5402220f@news.sunrise.ch...[color=darkred]
>>> Is the containing directory on your _system_ PATH?
>>>
>>> "Mauro Miotello" <sviluppo@ashnet.it> wrote in message
>>> news:d5jh8j$7r1$1@news.ngi.it...
>>>> Thanks for your info, i've tried to register this dll with utility
>>>> found in your IBM link and it was registered correctly
>>>> I've verified on my registry
>>>>
>>>> but the program does'nt run
>>>>
>>>> the strange thing is if i create connection, dataadapter and dataset at
>>>> design time, all it's ok
>>>> i don't understand..
>>>>
>>>> bye
>>>>
>>>> thanks
>>>>
>>>> mauro
>>>>
>>>> "Jean-Marc Blaise" <nobody@nowhere.com> ha scritto nel messaggio
>>>> news:427d2d5a$0$3134$8fcfb975@news.wanadoo.fr...
>>>>> "Mauro Miotello" <sviluppo@ashnet.it> a écrit dans le message de
>>>>> news:d5imi9$u1h$1@news.ngi.it...
>>>>>> I've to create a webapp with VS.Studio.NET 2003 and DB2 Enterprise.
>>>>>> I've create a webform and put this code on PageLoad event:
>>>>>>
>>>>>> 1 Dim strConnection As String
>>>>>> 2 strConnection =
>>>>>> ConfigurationSettings.AppSettings("DB2Connection.C onnectionString")
>>>>>> 3 Dim DB2Conn = New IBM.Data.DB2.DB2Connection(strConnection)
>>>>>>
>>>>>> 4 Dim qry As String = "SELECT Codice, Ragionesoc as [Ragione
>>>>>> Sociale], Localita, Paiv AS [Partita Iva] FROM(Clifo)WHERE (Codice =
>>>>>> @src
>>>>> OR
>>>>>> RagioneSoc like '%' + @src+ '%' OR Paiv = @src OR Tel like '%' +
>>>>>> @src+
>>>>> '%')
>>>>>> AND (Tipo = 'C' OR Tipo = 'P')"
>>>>>> 5 Dim cmdCC As New IBM.Data.DB2.DB2Command(qry, DB2Conn)
>>>>>> 6 cmdCC.Parameters.Add("@src", IBM.Data.DB2.DB2Type.VarChar,
>>>>>> 100).Value = TBox.Text
>>>>>> 7 Dim daGetClienti As New IBM.Data.DB2.DB2DataAdapter(cmdCC)
>>>>>> 8 Dim dsClienti As New DataSet
>>>>>> 9 daGetClienti.Fill(dsClienti, "ClientiTrovati")
>>>>>>
>>>>>>
>>>>>> running, on row 3 VS.Studio stop with this error: .. unable to load
>>>>>> DLL
>>>>>> 'db2app.dll' ....
>>>>>> someone have found same problem ?
>>>>>> someone have a solution ?
>>>>>>
>>>>>> thanks
>>>>>>
>>>>>> mauro
>>>>>>
>>>>>
>>>>> I think you need to register the dll yourself, as described in
>>>>>
>>>>> http://www-1.ibm.com/support/docview...=UTF-8&lang=en
>>>>>
>>>>> HTH,
>>>>>
>>>>> Jean-Marc
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>[/color]
>>
>>[/color]
>
>[/color]


 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 205,174 network members.