Asp and access problems

I have an asp page in which i get recordsets from a access db ,
when i do a query from the asp page i get EOF (no rs),but then i make the
same Query inside access, and i get the data, then i return again to my asp
page and for some reasone it gives me some data back, and allways after i do
the query inside access will it return my data inside my asp page?

Re: Asp and access problems

What code are you using?

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

"polilop" wrote in message
news:uXcFdvx0GHA.720@TK2MSFTNGP02.phx.gbl...
> I have an asp page in which i get recordsets from a access db ,
> when i do a query from the asp page i get EOF (no rs),but then i make the
> same Query inside access, and i get the data, then i return again to my
asp
> page and for some reasone it gives me some data back, and allways after i
do
> the query inside access will it return my data inside my asp page?
>
>

Re: Asp and access problems

Set RsGiN = Server.CreateObject("ADODB.Recordset")
RsGiN.ActiveConnection = MM_Connection_STRING
RsGiN.Source = "SELECT NUM_SIFRA_VALUTE, TXT_SIFRA_VALUTE, IZNOS_KN_KUP,
IZNOS_VAL_KUP, IZNOS_KN_PROD, IZNOS_VAL_PROD, IME, ZBROJ.BR_POSLOVNICE,
SIFRA FROM MjenjaciPojedinacno WHERE OZNAKA_PLACANJA='G' AND
OZNAKA_REZIDENTNOSTI='N' AND SIFRA='"& StrSifra&"' AND
DATUMIZVJESCA='"&StrDatum&"' ORDER BY NUM_SIFRA_VALUTE ASC"
RsGiN.CursorType = 0
RsGiN.CursorLocation = 2
RsGiN.LockType = 1
RsGiN.Open()
RsGiN_numRows = 0

The problem is that this worked fine, until few days ago, the only change i
have to make is to put my application on port 5555
as i have another that responds to port 80, but after that it still woked
OK. I'm wondering if access is the problem

"Steven Burn" wrote in message
news:uFP$E8y0GHA.1040@TK2MSFTNGP06.phx.gbl...
> What code are you using?
>
> --
> Regards
>
> Steven Burn
> Ur I.T. Mate Group
> www.it-mate.co.uk
>
> Keeping it FREE!
>
> "polilop" wrote in message
> news:uXcFdvx0GHA.720@TK2MSFTNGP02.phx.gbl...
>> I have an asp page in which i get recordsets from a access db ,
>> when i do a query from the asp page i get EOF (no rs),but then i make the
>> same Query inside access, and i get the data, then i return again to my
> asp
>> page and for some reasone it gives me some data back, and allways after i
> do
>> the query inside access will it return my data inside my asp page?
>>
>>
>
>

Re: Asp and access problems

Resolved my problem, i had a query that used another query to return a
value, this query was altered, so every time i went into access and run the
sub query( some call it parametrized query) somehow when the asp query run
afterwords it could get the data, although it was altered..
sorry if i did not explain this wery well :(
"polilop" wrote in message
news:ON93lSz0GHA.3656@TK2MSFTNGP04.phx.gbl...
> Set RsGiN = Server.CreateObject("ADODB.Recordset")
> RsGiN.ActiveConnection = MM_Connection_STRING
> RsGiN.Source = "SELECT NUM_SIFRA_VALUTE, TXT_SIFRA_VALUTE, IZNOS_KN_KUP,
> IZNOS_VAL_KUP, IZNOS_KN_PROD, IZNOS_VAL_PROD, IME, ZBROJ.BR_POSLOVNICE,
> SIFRA FROM MjenjaciPojedinacno WHERE OZNAKA_PLACANJA='G' AND
> OZNAKA_REZIDENTNOSTI='N' AND SIFRA='"& StrSifra&"' AND
> DATUMIZVJESCA='"&StrDatum&"' ORDER BY NUM_SIFRA_VALUTE ASC"
> RsGiN.CursorType = 0
> RsGiN.CursorLocation = 2
> RsGiN.LockType = 1
> RsGiN.Open()
> RsGiN_numRows = 0
>
> The problem is that this worked fine, until few days ago, the only change
> i have to make is to put my application on port 5555
> as i have another that responds to port 80, but after that it still woked
> OK. I'm wondering if access is the problem
>
> "Steven Burn" wrote in message
> news:uFP$E8y0GHA.1040@TK2MSFTNGP06.phx.gbl...
>> What code are you using?
>>
>> --
>> Regards
>>
>> Steven Burn
>> Ur I.T. Mate Group
>> www.it-mate.co.uk
>>
>> Keeping it FREE!
>>
>> "polilop" wrote in message
>> news:uXcFdvx0GHA.720@TK2MSFTNGP02.phx.gbl...
>>> I have an asp page in which i get recordsets from a access db ,
>>> when i do a query from the asp page i get EOF (no rs),but then i make
>>> the
>>> same Query inside access, and i get the data, then i return again to my
>> asp
>>> page and for some reasone it gives me some data back, and allways after
>>> i
>> do
>>> the query inside access will it return my data inside my asp page?
>>>
>>>
>>
>>
>
>