db2app.dll

[Mauro Miotello]

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

[Jean-Marc Blaise]

"Mauro Miotello" <sv******@ashnet.it> a écrit dans le message de
news:d5**********@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

[Mauro Miotello]

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" <no****@nowhere.com> ha scritto nel messaggio
news:42**********************@news.wanadoo.fr...

"Mauro Miotello" <sv******@ashnet.it> a écrit dans le message de
news:d5**********@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

[Mark Yudkin]

Is the containing directory on your _system_ PATH?

"Mauro Miotello" <sv******@ashnet.it> wrote in message
news:d5**********@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" <no****@nowhere.com> ha scritto nel messaggio
news:42**********************@news.wanadoo.fr...

"Mauro Miotello" <sv******@ashnet.it> a écrit dans le message de
news:d5**********@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

[Mauro Miotello]

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

"Mark Yudkin" <my***********************@boing.org> ha scritto nel messaggio
news:42**********************@news.sunrise.ch...

Is the containing directory on your _system_ PATH?

"Mauro Miotello" <sv******@ashnet.it> wrote in message
news:d5**********@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" <no****@nowhere.com> ha scritto nel messaggio
news:42**********************@news.wanadoo.fr...

"Mauro Miotello" <sv******@ashnet.it> a écrit dans le message de
news:d5**********@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

[Mauro Miotello]

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

bye

Mauro

"Mauro Miotello" <sv******@ashnet.it> ha scritto nel messaggio
news:d5**********@news.ngi.it...

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

"Mark Yudkin" <my***********************@boing.org> ha scritto nel
messaggio news:42**********************@news.sunrise.ch...

Is the containing directory on your _system_ PATH?

"Mauro Miotello" <sv******@ashnet.it> wrote in message
news:d5**********@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" <no****@nowhere.com> ha scritto nel messaggio
news:42**********************@news.wanadoo.fr...
"Mauro Miotello" <sv******@ashnet.it> a écrit dans le message de
news:d5**********@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

[Mark Yudkin]

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

"Mauro Miotello" <sv******@ashnet.it> wrote in message
news:d5**********@news.ngi.it...

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

bye

Mauro

"Mauro Miotello" <sv******@ashnet.it> ha scritto nel messaggio
news:d5**********@news.ngi.it...

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

"Mark Yudkin" <my***********************@boing.org> ha scritto nel
messaggio news:42**********************@news.sunrise.ch...

Is the containing directory on your _system_ PATH?

"Mauro Miotello" <sv******@ashnet.it> wrote in message
news:d5**********@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" <no****@nowhere.com> ha scritto nel messaggio
news:42**********************@news.wanadoo.fr...
> "Mauro Miotello" <sv******@ashnet.it> a écrit dans le message de
> news:d5**********@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
>
>