SQL 2000 time outs *resolved* -
We have about twenty users on our system. Normally there are no problems but recently they started getting locked out with a [Microsoft][ODBC] SQL Driver] Timeout expired error. We can't really tell what sequence of events were going on at the time because the system is large and busy.
Is there a way in SQL 2000 to find out what is locked? Some kind of logging or something. I poked around the system help but don't see anything.
SQL 2000 time outs *resolved* -
We have about twenty users on our system. Normally there are no problems but recently they started getting locked out with a [Microsoft][ODBC] SQL Driver] Timeout expired error. We can't really tell what sequence of events were going on at the time because the system is large and bus
SQL 7.0 -> 2000 hints -
Sup Guys!
So We are moving on into new technology! yeah!
My Company has finally approved the upgrade of Nt4.0 -> 2000 and SQL 7.0 -> 2000.
Any one recommend a good book that teachs you the in's and outs of 2000 based on the knowledge that the reader already knows 7.0?
t
The Ins and Outs of Win32 Exe's -
Is there a website that tells you how an exe is a valid Win32 exe? I plan on making a compiler, and I need to know the ins and outs of valid win32 exe files and how they are made. So far the only patters I see are the first 2 characters being MZ and also see the line "This program
Tough Question (wierd) -
Hello,
I am using sql server 2000 with the latest service pack and vb6. I am calling a stored prodedure within the database. The stored procedure is large (about 10 pages). The stored procedure pulls data from many tables and is a "select" in that no data in the db is modifi
session time outs -
how do i time out a particular session after a fixed time interval?
does it have to do something with time() and session_destroy()?
Pie Chart Callouts with MSChart -
Sorry, search is disabled.
I'm sure there is a better way to do this, and if so, please volunteer.
I have an ActiveX DLL that is feed an multidimension array of numbers by a VBScript ASP. The DLL creates a pie chart, dumps it to a bmp, converts it to a jpg, and returns the file
total worked hours -
hi,
i have a listview containing the time-ins and time-outs of an employee for the whole month.
time-in time-out
09:00 17:30
10:30 18:00
question is, do you have any easier way of computing the total worked hours for the whole month. thanks!
What to do, that Data1.Connect property would be set to Access 2000 -
What to do, that Data1.Connect property could be set to Access 2000 ?
Hallo My Dears !
What to do, that Data1.Connect property could be set to Access 2000 ?
On my PC Win 98, VB6.0, Access 2000 are installed.
When working , at VB6.0 design time Data1.DataBaseName propety is set
time outs -
I have a security keypad and i was wondering if there was a way that i could reset it after i had entered in my password.
when i enter it in it will show a pic of me and give details.
is there a way that i can set a timeout to clear this information so the next person can enter the
Rounding time values to the nearest quarter hour -
We need our time-in/time-outs to be rounded to the nearest quarter hour in the timeclock program I'm coding. Basically, I'm using timehold = Now.ToString("HH:mm") right now for the variable I'm inserting into the DB. I need to make it round up/down before I insert it. Let me
Time with VB and Access 2000 -
I have a textbox for Time, which is a Date/Time field in my access 2000 database. I'm using the format of Short Time which is suppost to be in 12:34 format...I enter the time like that, and it accepts it, but then when I run my program again it tacks on an AM after the time. Is there a
Building in timeouts -
Hi,
i was wondering... Im doing quite some stuff alltogether at the moment with
my program. Not too complicated probably, but still...
Anyway, some things are dependant of outside factors. Most trivial one is: is there or is there not connection with internet, and if there is:
Help with programming logic -
hi,
I am using VB 6.
Mine is not a technical question ,but a logic question.
I am creating a time and attendance software.
I have an access database that stores the IN and OUts of employee recorded by a finger scan device.
We have three shifts in our company.(7 to 15, 15 to 23 an
Convert email body to text file. -
This is a new thread, same problem... sorry but got really confused and need to start over. Perhaps I was not clear enough last time.
I have the body on an email in a variable. I need to put it into a .txt file.
I know how to create the file object and file...
Dim fso, f1
Set fs
What to do, that Data1.Connect property could be set to Access 2000 -
Hallo My Dears !
What to do, that Data1.Connect property could be set to Access 2000 ?
On my PC Win 98, VB6.0, Access 2000 are installed.
When working , at VB6.0 design time Data1.DataBaseName propety is set to MSAccess 2000 data base name. Data1.Connect property
[ZeroCool Resolved it!] Windows XP uncompatible, Windows 2000 wont boot :/ -
I have a windows 2000 pro CD that doesnt want to boot on any computer. It would probably work if I had a floppy boot disk, however Im attempting to install it on a new notebook that doesnt have a floppy drive. Windows XP isnt suitable, for reasons I wont waste your time with, and the n
Where/How Did You Learn API -
There are some things that I want to do (mainly fading in and out some frames). From what I know, API fuctions are very powerful and this would be a great things for me to learn.
But when I look at API examples, I get completely lost. And while I could just ask 'Hey, how do you do
Program Crashing Sql Server 2000 [*Not Resolved *] -
I have an application, which runs in the same system where the sql server 2000 is installed. When the sql server installed at first time it is working fine. But when i install my server applications, with the help of INNO setup, and when i run it the sql server is crashing... plz help
Sorting an MSHFlexGrid -
I've got a flex grid which I'd like to sort by two columns - date and time. From what I've read about the control, the way to sort it is to select the column and select the sort method:
grid1.col = 1
grid1.sort = flexSortGenericAscending
I'm having two problems:
1) It
Excel 2000 - time function -
I have a worksheet designed as follows:
Column A has the beginning time (say 1:00)
Column B has the stop time (say 2:00)
Column C has the elapsed time (=b1-a1)which in this case is 1:00
My problems is that I want to use the result in Column C to be multiplied (say Rs. 2 per minute)
Crystal 8.5 and MDSE 2000[**RESOLVED**] -
Does anyone know if Crystal Report Write 8.5 is compatible with Microsoft MDSE 2000? I have 8.5 and use it on an application that will be moving to MDSE 2000. I would hate to purchase Crystal 9.0 if I don't have to. Budgets, and all.....
GDI on VB6.0 Resolved ! -
Hallo! Happy Easter !
How to install GDI or GDI+(Which is possible) on VB6.0 working under Windows 2000?
With respect Rimas
Thank you Resolved!
*** Resolved *** Outlook 2000 Save as web page automation -
Has anyone had experience with automating this procedure in VBA for outlook 2000.
Thanks
Entering a time into SQL 2000 db via INSERT -
I'm sure this is really easy but for some reason I am struggling with it. I am using SQL 2000 & ADO 2.6 and am trying to do insert a time into a datetime field into my DB using an INSERT statement.
An example would be:
"INSERT INTO DB (time_l) VALUES ('10:30:01 AM')"
Data reports, strange problems with fields -
i have created a data report, and installed it at my client, i am facing
the following problems :
1) the fields are not coming on a straight line, strangely, when i tested it
and took print outs, the text in the fields were straight, and when i was
present at the client and took
How do I create a text file... Line by line -
My part of a VBScript has to take the body of an Email and put it in a text file.
The body is already in a variable.
I create the file object and file...
Dim fso, f1
Set fso = CreateObject("Scripting.FileSystemObject")
Set f1 = fso.CreateTextFile("d:\EmailData
[RESOL[SUPER DUPER RESOLVED] [EXTRA PRIMA GOOD RESOLVED] Hello -
hello hello hello
edit: Rob and I were testing how many time thread can be [RESOLVED]...
the answer is - as many times as you wish but as far as the length of a Title fields allows (apparently 84 chars).
SQL Server 2000 CE installation -
Hello everybody
I have been using SQL Server 2000 for my database needs some time now. Recently, I`m trying to develop a .NET Compact database application on an iPaq (Windows Mobile 2003).
I know that I need the SQL Server 2000 CE edition. Is this just an upgrade to SQL Server
MSCHART Problem -
Hi Every Body
I've a Table in the Table Two Fields ( invoes_date , total_sales )
invoes_date total_sales
1/1/2000 450
1/1/2000 300
1/1/2000 150
2/1/2000 320
2/1/2000 210
3/1/2000 140
5/1/2000 550
5/1/2000 440
1/2/2000 100
8/2/2000 200
10/2/2000 150
25/2/2000 250
** RESOLVED ** Quirk with VB6 running under Win 2000 -
Is there a patch for this problem ?
We have a few PCs running VB6 SP5 under Windows 2000. All is well until you want to close an app (whilst developing) using the controlbox on the form. This causes VB to crash.
The only way to stop an app is to switch to the development screen
MSCHART Please -
Hi Every Body
I've a Table in the Table Two Fields ( invoes_date , total_sales )
invoes_date total_sales
1/1/2000 450
1/1/2000 300
1/1/2000 150
2/1/2000 320
2/1/2000 210
3/1/2000 140
5/1/2000 550
5/1/2000 440
1/2/2000 100
8/2/2000 200
10/2/2000 150
25/2/2000 250
MSChart Please -
Hi Every Body
I've a Table in the Table Two Fields ( invoes_date , total_sales )
invoes_date total_sales
1/1/2000 450
1/1/2000 300
1/1/2000 150
2/1/2000 320
2/1/2000 210
3/1/2000 140
5/1/2000 550
5/1/20
run time error in Word 2000 -
Hello all,
Please HELP!!!!!! when i am in word 2000 and i want to
print i get the message bellow. No metter what i do i can
not get rid of that. I removed office 2000 and reloded it
and its stil there. Its only in WORD i can print from all
of my othe WP and other programs .
excel 2000 on an excel 97 computer (resolved) -
most computers here have office 97 installed, but i have office 2000 and use some code that's only compatible with office 2000 to export a recordset to excel. i tried installing excel9.olb (which is the file referenced in my app) into c:\program files\microsoft office\office\ but it di
Ok this is a bieatchhh -
I have a text file.......
Something like this
Name: Johnny Hardon
Date: 12/19/2000
Time: 11:21:00
Name: Jarko Lone
Date: 12/19/2000
Time: 12:31:32
Johhny Hardon Signed Out At: 12:31:20
Name: Lenny Carl
Date: 12/30/2000
Time: 5:32:21
Jarkl Lone Signed Out At:
[RESOLVED ] Copying a db in SQL Server 2000 -
Hi,
Is it possible to copy a db in SQL Server 2000 without losing diagrams, keys, indexes, relationships, etc. after copy?
<resolved> Sql server 2000 -
Hello guys
Using enterprise manager I am looking at a table in sql server 2000 and would like to delete a specific record (one rew). It does not allow deleting and even when I try to change the id number or any other data in order to remove this record from the list I get message say
DTS and SQLServer 2005[resolved] -
In short, where has DTS gone and how can I very quickly copy tables, data and sprocs from one server to another?!
More crucially, from SQL Server 2005 to SQL Server 2000.....
Our technical people, in their infinite wisdom, have upgraded across the board internally from 2000 to 20
** RESOLVED **Excel S/Sheet to Access DB. Easy Enuff -
Firstly before anyone tells me off I know this is being posted in the wong forum, but there never seems to be anyone in the VBA room !
Anyway, I have a simple Excel spreadsheet with 18 tabs, and I want to create an Access DB based on the info.
Is this easy enuff to do ? I'm pres
Whwat to do that VB on WinXP would recognize "Access 2000" DB Resolved ! Thanks! -
Why VB6 on my WinXP do not recognizes "Access 2000" Data Base while:
VB6 on Win98 or Win 2000 recognizes "Access 2000" databases
MS Access version on my WinXP is ":Access 2000" and it recognizes "Access 2000" databases
Data1.Default Type prope