asp_databases thread: accesing sql from components in asp...through mts.
Message #1 by "sushma roopa kadambari" <sushmark1@r...> on 12 Oct 2001 07:27:54 -0000
|
|
hello,=0D=0A=0D=0A in my application i used asp as frontend ,mts as middlew
are..and sql as database server..(backend)=0D=0A=0D=0A i used vb to make d
lls and registered them in mts..=0D=0Ai am using them to retieve data from
sql..=0D=0A=0D=0Ait is giving me errors..=0D=0A because (probably)of improp
er configuration between mts and sql server=0D=0A..=0D=0Ai used=0D=0A iis4.
0=0D=0A mts 2.0=0D=0A vb6=0D=0A sql7.0=0D=0Awindows nt4.0=0D=0A eagerly
waiting for reply=0D=0A thanks=0D=0Ai installed sql before i installed
mts=0D=0A =0A
Message #2 by "Iyappan P" <iyappan_p@h...> on Fri, 12 Oct 2001 21:44:05
|
|
If you can give us the error description, it will be helpful for us to
analyse.
Whenever you ask something make sure that you are giving all the necessary
info.
Regards,
Iyappan
>From: "sushma roopa kadambari" <sushmark1@r...>
>Reply-To: "ASP Databases" <asp_databases@p...>
>To: "ASP Databases" <asp_databases@p...>
>Subject: [asp_databases] accesing sql from components in asp...through mts.
>Date: 12 Oct 2001 07:27:54 -0000
>
>
>hello,
>
> in my application i used asp as frontend ,mts as middleware..and sql as
>database server..(backend)
>
> i used vb to make dlls and registered them in mts..
>i am using them to retieve data from sql..
>
>it is giving me errors..
> because (probably)of improper configuration between mts and sql server
>..
>i used
> iis4.0
> mts 2.0
> vb6
> sql7.0
>windows nt4.0
> eagerly waiting for reply
> thanks
>i installed sql before i installed mts
>
Message #3 by "sushma roopa kadambari" <sushmark1@r...> on 13 Oct 2001 15:29:09 -0000
|
|
hi thahks for reply..
actually the error is
type mismatch error. error number..800a000d
i tried the following to find the choking point...
1) to check parameters problem... i wrote a simple
code and made it dll and regisered in mts and passed
values from asp's vb script.. it is fine...
(no database connection...)
2)so i tried o call sql directly
from asp's script.. no problem... but this case
3)wrote a simple
sql qurey in vb made it dll and registered in mts and tried to call
it from asp's vbscript.. then it showed me the error... so what i
am thinking is some problem with mts to sql..configuration so
please help me in this regard..
awaiting your reply...
Message #4 by "Iyappan P" <iyappan_p@h...> on Sun, 14 Oct 2001 16:29:23
|
|
In vbscript everything is variant, but in vb it is not so. and also when you
pass something by referrence from vbscript make sure that u r declaring that
as variant in vb. for example when u pass a adodb connection object from
asp, u have to declare that connection object as variant in ur vb code. and
also when u r passing integers and string from asp to vb make sure that u r
passing it by value. that way u reduce the overhead of marshalling.
if u can send us the vbcode and asp code it would be helpful for us to tell
u what went wrong. i hope the following may be the cause.
if u declare a parameter as integer in ur vb dll and if u don't convert that
parameter from variant to integer before passing that to ur vb dll, u will
get this error. it will fit for all the value type parameters like int,
string, long etc.
Please send us ur code, we can tell u exactly what went wrong.
Regards,
Iyappan
>From: "sushma roopa kadambari" <sushmark1@r...>
>Reply-To: "ASP Databases" <asp_databases@p...>
>To: "ASP Databases" <asp_databases@p...>
>Subject: [asp_databases] Re: accesing sql from components in asp...through
>mts.
>Date: 13 Oct 2001 15:29:09 -0000
>
> hi thahks for reply..
> actually the error is
>type mismatch error. error number..800a000d
> i tried the following to find the choking point...
>
>1) to check parameters problem... i wrote a simple
>code and made it dll and regisered in mts and passed
>values from asp's vb script.. it is fine...
>(no database connection...)
>
>2)so i tried o call sql directly
>from asp's script.. no problem... but this case
>
>3)wrote a simple
>sql qurey in vb made it dll and registered in mts and tried to call
>it from asp's vbscript.. then it showed me the error... so what i
>am thinking is some problem with mts to sql..configuration so
>please help me in this regard..
>
>awaiting your reply...
>
>
Message #5 by Vijay Saste <vijay_saste@y...> on Sun, 14 Oct 2001 21:33:36 -0700 (PDT)
|
|
can u send me the code itself and its function in
brief so that I will make try to make it work at my
end. provided u r using win 2000 server and COM+ since
this what I am using at me end.
Regards
Vijay
--- sushma roopa kadambari <sushmark1@r...>
wrote:
> hi thahks for reply..
> actually the error is
> type mismatch error. error number..800a000d
> i tried the following to find the choking point...
>
> 1) to check parameters problem... i wrote a simple
> code and made it dll and regisered in mts and passed
> values from asp's vb script.. it is fine...
> (no database connection...)
>
> 2)so i tried o call sql directly
> from asp's script.. no problem... but this case
>
> 3)wrote a simple
> sql qurey in vb made it dll and registered in mts
> and tried to call
> it from asp's vbscript.. then it showed me the
> error... so what i
> am thinking is some problem with mts to
> sql..configuration so
> please help me in this regard..
>
> awaiting your reply...
>
|
View Cart
