Search results for query: *

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.cmmrfrds Thanks for your suggestion,I check the table found it lost primary key.I put it there.It's fixed. Thanks lot Hu

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...

Hi,Link9 & Turkbear Thanks for your suggestion,I've already fixed my problem as what you suggested. Thanks alot!

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...

Hey jack & Paul Thanks for your clear explaination.

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,paul Just wnat to confirm Does IIs autometically running connection pool ? we don't need to set up anything for it? Thanks for your tips!

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,everyone I put session.abandon in global.asa session_onend,but it doesn't help.any idea about it? Any help will be greatly appreciated!

Thank you dbrom your reply is clear.

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?