Hi, there
Recently ,I have a problem about using ASP to contact SQL server(2000).
my SQL server use NT authentication,but I can not connect it through ASP,the error message saying"login fail for user /Iuser...." I use DSN "weborder" .in my asp page,code is like:
conn.open...
hi ,there
In my access database , I have two linked table. T1 linked with another access database,T2 linked with SQL database.
T1 is fine ,I can insert or update data.but I can't modify data in T2.I have no idea why T2 is read only? I check T2's permission in SQL,public user hava full permission...
Hi, there
I have a file in our network, i'm author of this file.but recently when i open this file , a message pop up saying this file is editing by myself,it's a read only file. Actually none editing this file at this monent.I was courious why this file is lock by myself? if any one has...
Thanks,Turkber
the followings are code:
......
set cnn = server.createobject("adodb.connection")
cnn.open "WEBORDER"
sql5= "select Inquery.ID,Inquery.Section, Inquery.Length, Inquery.Qty, Inquery.RequiredDate from inquery where jobnum='"&job &"' order by...
hi, there
I have some problem in my asp page the error message like this:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
a couple of weeks ago , I use the same asp page,it's fine.
but now it doesn't work. Could...
Hi,there
I'm new in SQL, I have a question about SQL.
I create a datebase in Query Analyzer,and sp_help show me as owner of this database.then I try to create a new tabale in enterprise manager,but the error message pop up saying i'm not valid user for this database. the owner is not the valid...
Hi,there
I'm interested in Asp.net. I'm trying to learn it and rewrite all my ASP page to Asp.net.but I'm not sure what kind of web server is required for asp.net? IIS4 or IIS5?
Thanks in advance.
Hi,james
thank you for your suggestion.right now it works. but I still hava a small problem,every time when this task is running,a MSTask window pop up,Do you know how to make it dasappear?my setting is like:
RUN:C:\WINNT\system32\cscript.exe backuptest.vbs
start in C:(backuptest is in c drive)...
Hi,there
I have a vbscript file I want it run every 50 minutes from 9:00 am
in windows command prompt I type in
at 9:00 am /every:50 cscript.exe c:\test.vbs
but it only run once ,I try to modify the property of it in scheduled task,without success.
could some one tell me how to set schedule...
Hi,all
In my case all the pages related to one database. It's still in testing phrase.before publishing it to web site I want suggestion from experienced people which method is better in my case.(set up connection in session or in every page?)Right now I put the connection in session,but it...
Hi,everyone
Thanks for your reply. The discussion is interseting and helpful.
As Paul suggested "Best practice is to not set objects (in general) to have session scope....".but I'm not sure about the performance if we create a ADO connection,and then close it and set it =nothing in...
Hi,everyone
this is updated message
I did some test and found if I set the session.timeout=15
the database connection will destoried 15 minutes after I close the browser,IF I set timeout=1 the connection will destoried 1 minute after I close the browser.That means after I close the browser the...
Hi,all
I uae the same database connection,same sql,if I use "set rs=conn.execute(sql)" to get recordset,rs.recordcount return value=-1.if I use "rs.Open sql, conn, adOpenStatic " ,rs.recordcount return correct value.Could some know the reason for it?
Thanks
Hi,gsc1ugs
I'm trying to use this method but I don't know where to put "session.abandon". Since I have no idea when the client finish their job ,I don't know which page is the last one.I can't put it in asp pages .Do you mean to put it in Glabol.asa session_onend?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.