Asp and access problems

[polilop]

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?

 

[Steven Burn]

What code are you using?

--
Regards

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

Keeping it FREE!

 

[polilop]

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

 

[polilop]

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