Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    Visual Basic




Auto Reconnect To DB After SQL Server Restarted


Dear All,

I'm coding an application to check for specific record on a table in every 15 seconds.

How can I:
1. check for server/db disconnection (e.g. SQL Server restarted or network disconnected) and
2. auto reconnect to DB

I've seen many error handling codes on the internet, but that's not enough for my case.

My platform:
OS: Windows 2000 Server SP4
DBMS: SQL Server 2000 SP3a
Tool: VB6 SP5 & ADO

Super Thanks.

Fergus



Edited by - ferguscham on 11/19/2003 12:19:51 AM




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
Auto Reconnect Onto Internet
I was just wondering how I would go about coding a program that reconnects automatically onto the internet on the same account I was using, as soon as I get disconnected.

I have a dailup 56kmodem, get disconnected every 2hrs, so that's why

SQL Server Reconnect
I'm currently creating a VB application which requires connection to an SQL server database. I need a code which will keep my application running (keep updating, inserting, etc.) in case the server is down. It's sort of like a temporary buffer thingy which will in turn push the records entered once the server is running again. Can anyone please help...

Winsock Help - When Server Reboots/lan Down How To Reconnect
Hi - right now my project starts up with the PC and sends data, but then might not need to send data until the end of the day, but it is possible it will send data quite often throughout the day...

So right now the connection is made at program startup and used when needed, which is fine - however, if the server is rebooted, or if the lan goes down for a second or something, the client/server loose their connection - so what is the best way to have the winsock control:

either:
1. Determine that the connection is down and re-establish it
2. Only make the connection when needed???? (tried it this way and having trouble)

Any other ideas?

Thanks guys

Chris

App Restarted After Unloading
pls can somebody tell me why my app restarted after unloading and exiting the program in IDE

Does The Timer Automatically Reset (how Long Its Been Going For) When Restarted?
if u use timer.enabled = false,then enable it again, does it restart? (that is, in an interval of 60000, and its restarted - enabled = false/true 20 seconds in, will it run the code 40 seconds after or 60?)

How To Count No. Of Times System Restarted Or Shut Downed
hi all,

how i can find out my system has shut downed/restarted this much time(from this date to this date). how can i start to code this issue

saj

Help With Resetting Desktop/screen, When A Docked Bar Crashes And Is Restarted
My program is a docking program however if it is crased and is reopened, it cant properly allocate the space it used to have beucase there is a gap there of where the app used to be.

is there anyway to reset the desktop so the program can properly allocate the space for itself?

Problem With Winsock Listening When Program Has Closed And Computer Has Restarted.
for some reason a bunch of ports are listening on my computer which is a huge pain in the *** because one of them is port 80 which i need to run my webserver. i dont know why they are running and i have windows XP so it shows me all the applications and proccesses on my computer that are running. so i need help on this one guys. also how come i get a bunch of errors when ever i load this webpage?

Auto ID In SQL Server....
I am inserting into a SQL table with "INSERT INTO...." and the table has an auto-increment ID field.

Is there any way that I can return that value within the INSERT call to the DB? Or do i have to do my INSERT and then a SELECT?

Thanks,
Kevin

SQL Server Auto-detection.
Hello all,

To my understand, to connect to a SQL server, you must have a DSN or Server name in the ConnectionString among other things. Is there anywhere where I could auto-detect any SQL Server connected to the client PC?

Auto Shutting Down MS SQL Server (Help Me)
Plz Help me.

       Auto shutting down of my sql service manager. what i will start it, but the server is shutdown after 30 seconds. that is why i can't used any services. Please to help me, what about to start of my sql service manager and matained of sql server 2000 (enterprice)? Please answer and good thing.

Plz faster and faster moment.

Thank of all and member.
Saw Oo(Myanmar)

edit: moved to an appropriate forum. It was posted in the forum News...





Edited by - dries_neyrinck on 4/21/2005 5:39:11 AM

Reconnect?
I have a program in client side use winsock to make connection
with a streaming server. However, somtimes it will disconnect.
So, is there any method to check that if the connection is
close and reconnect to server immediately? Thanks!

Reconnect, Reconnect, Reconnect
Would anyone know how to avoid getting the below terminating error without having to keep reconnecting to Oracle? The subroutine where this is occurring I have two connections, one to an Oracle database, and one to an Access database. The goal of the subroutine is to transfer all of my Access records unto a table in Oracle. Aslong as I keep reconnecting, I'm fine. What kind of memory issues am I running into that forces me to keep reconnecting?

Error I'm getting:
The instruction at "0x1f....." referenced memory at "0x04.....". The memory could not be "written".

This is my reconnecting subroutine:

Public Sub ConnectToOracle()

If Conn2.State = adStateOpen Then
Conn2.Close
Set Conn2 = Nothing
End If
rs2.CursorLocation = adUseServer
Conn2.ConnectionTimeout = 3600
Conn2.Open "Driver={Microsoft ODBC for Oracle};Server=USTRQD51;Uid=mi_load;Pwd=info$load#;" ' QA database
Set Cmd2.ActiveConnection = Conn2
Cmd2.CommandTimeout = 1800
End Sub

Thanks!

Reconnect
Hi Pros., I have a application that connect to a SQL Server for retrieve the new data in every 5 minutes. But sometimes the SQL Server is disconnected. If I want to make my application retry the connection while the connection is downed and make it resume when the connection is back again, what should I do? Many thanks.


SQL Server 7, Auto Incrament And ADO Recordsets
I am using SQL Server 7 and I am trying to get the value of an auto incrament field after I have performed a .addnew and .update using an ADO recordset. This at the moment is returning <NULL>. Unfortunately I do not have much option as to using the recordset to .addnew and .update as there is a lot of code working like this which I am currently using.

So having done a .addnew I want to know what is the best way of getting the auto incrament field from SQL Server?

Auto-sense Server Connection
I am currently developing a POS system. Before it saves data into the server, it must SENSE first if it (client machine) has connection to the server. I do it that way so that if the connection is cut as transaction is going on, the client is going to save temporarily the data to the local database. My problem now is how to SENSE if there is a connection between the Server and the client. Please help...

(The DETECTION of the connection must be FAST).

Tnx in advance.

Auto Number Generation In SQL Server
Hi Gurus,

I post this topic already, i didn't get yet what i want .that's y i posted it again.

the above post is here
click here

I am using vb6 with SQL Server 2000.

I am having a form and in this number should be autoincremented...

Auto generated Number is like Fin/cc/ss/2002-2003/01003550

----- Here i stuck in generating [2002-2003] the year.

I have to check 1st april to 31st March..If 31st march 12.59 then the year has to be changed like 2003-2004 and for coming years too.

I want to increment my number like

01003550------>01 mentions the january month...... It automatically display the month according to current month

Pls anyone help me.

Auto Delete Mail On Server?
Hello,

Here is my current situation...

I've configured my current host's SpamAssasin to TAG e-mails (with ***SPAM*** in the subject line) on the server so that my e-mail client can then filter it when it gets fetched.

But unfortunately this still causes me to filter the messages on the way back to my client.

What I need is a program that can log in at regular intervals, check the messages, and automatically delete anything with ***SPAM*** in the subject line. (Yes, I am willing to possibly delete a false positive). (This program would run on my home PC), basically cleaning my account(s) at a preset interval.

The reason for this is that, I often check my mail remotely (webmail), and having to sort through all the cr@p is a pain (until I get home and fetch it with my e-mail client which has a spam filter to filter the tagged messages).

I've changed my settings recently on my webmail, so that it deletes all the messages having ***SPAM*** in the subject line, but unfortunatly it only performs this operation WHEN I LOGIN using webmail. So if I don't login using webmail, I have to use my e-mail client to fetch the messages.

I've looked everywhere for a premade solution to this, but have come up empty. Hence I thought I'd visit here and see if anyone has some example code, and I could write my own.

If you happen to know of software (premade) that does this (I am sure it exists somewhere!!), or have similar source code, please let me know.

Thanks again,
Powerfinger




Edited by - powerfinger on 1/28/2005 9:42:32 AM

Disconnect - Reconnect
Why is it always that when i disconnect and try to reconnect to my client / server app, it doenst connect anymore. The first time i have no problems but when i press disconnect on the client side en press on connect again it doenst connect anymore, how do i fix this problem.

Reconnect On Winsock...
guys,

 i'm developing a chat program. i'm currently using an array of sockets on my server.. testing was ok,, but problem emerged when somebody accidentally shut down the pc. the problem is that he cannot reconnect to the server and an error message appeared... the point is, i needed a mechanism to automatically reconnect to each other regardless of which session (client or server) was experiencing the network problem, and to do so without user intervention.

guys, i need your help... please..

Auto Update Problem On Client/server (need Help)
I am developing client server system on VB 6.0. Consist 2 module:
Client & server
Database is on server.

Client act as interface login remote on client machine.
Once login success database add record on time in, IP, machine name, user name automatic.
Work fine.

But, time out not working...
Suppose client logout, it send data to server to update time out before connection close.
Coding has no error msg. I really dont know how?

Any idea, solution.. I think this program similar as visual cyber cafe or auto cyber cafe..
Please reply me. I really tried many possible solutions I can think.

Reconnect Attempt Loop
I'm using winsock and a timer loop to try to reconnect every x ms. On my computer reconnecting every 80ms uses very little bandwidth, however on other computers it is such a bandwidth hog that it can simulate a DoS attack on the computer it's running and effectively cause their internet connection to drop. Does anyone know why this phenomena happens?

Winsock Reconnect Error
I have another problem with winsock.

After i close the connection (Winsock1.close on both sides, server and client application) with the other application, and try to connect again i get an error. But if i close both applications, reopen them and try to connect again everything works fine.

Winsock Reconnect Question
If I have a winsock control on a client that has sent data to a server but for some unknown reason the winsock has closed before receiving a response or all of the expected data back from the server how can I reconnect the winsock and resend the data?
When winsock.close occurs there is a timer enabled and that timer starts to parse apart the data received so far. It checks for the end of string (</p3Gram, if this is not there it throws the error I am seeing - incomplete message.

Here is code from the timer1

Code:
Private Sub Timer1_Timer()
Dim MyPos As Long, MyPos2 As Long
Dim getData As String, strData As String

Timer1.Enabled = False

If Len(globstrData) < 1 Then
globstrData = ConCat.GenerateCurrentString
End If

'If Len(globstrData) < 1 Then
' globstrData = datastr
MyPos = InStr(globstrData, "</P3GRAM")
If MyPos > 0 Then
globstrData = Left(globstrData, MyPos - 1)
End If
'End If

MyPos = InStr(DataStr, "</P3GRAM")
MyPos2 = InStr(MyPos + 1, DataStr, ">")
If MyPos2 < MyPos Then
m_ResponseCode = 86
m_ResponseInfo = msgClient_086 + " EID=993"
TextResponseCode.Text = Str(m_ResponseCode)
TextResponseInfo.Text = m_ResponseInfo
Call CauseCompletion
Exit Sub
End If
End Sub

And the winsock close event

Code:
Private Sub Winsock32_Close()

If i_Mode <> 1 Then
Winsock32.Close
End If
Timer1.Enabled = True

End Sub


What I would like to do is just start over with reconnecting the winsock and send the original request back to the server with an additional string. The odd thing I have seen is if the original request (usually a sql statement) is a certain length it fails. If I send the same sql statement with another statement appended on the end then it works. It seems to me the winsock control is dividing things up incorrectly or is losing them. Losing packets I though was not possible with TCP, which this winsock is using.

Thanks for anyone who looked at this long post, but this problem has been bugging me for a long time and I would like to get it resolved. Talked to Microsoft and all they could tell me was to recompile with service pack 6, and check for the connection is active before calling senddata. But it looks like to me that the connection is cut off in the middle.

Thanks,
mojo

Automatically Reconnect After Error
In an Access project connected with a SQL Server database, users must reconnect using File/Connection after the connection is broken when a network error occured.

How can I do this automatically, using VBA and the settings on the Data Link Properties dialog box ?

UDP Client Reconnect Problem
I have scoured the net for solutions to this before posting here but there isn't much help out there. I am writing a UDP Client program to talk to a UDP Server (written in VB 6 using Winsock). The problem is that I can communicate with the server fine and do many send and receives to and from it. The problem is that when I close my app and re-run it, the first time I send a datagram to the server, it appears that the program not only sends the string that is programmed, but also a single 1 byte empty string. The Server responds to the first correct line but the packet is never received by my client. Therefore the client hangs as the receive line stops the program as it waits for the response. The onlyt way to get the program to work again I have to restart the server program.

I am assuming the client is causing the problem as I can't see how/why it sends this blank string. I am thinking its becuase for whatever reason, the second time the program runs the socket is dead or already connected. I do however close the socket and set the object to nothing...

Does anyone have any ideas? Thanks

Monitor Server By Auto Pinging? Reinventing Wheel?
I need to monitor a server's uptime. I think i can write a small script that will ping the server every few seconds and when unsuccessful somehow log the error to a file and also text message my cell phone.

Should i be considering a ready made monitoring software that possibly fullfills this function and more or am i reinventing the wheel.

Please help

Thnx

Force Netword Drive To Reconnect
Hi

I have a mapped network drive that can only reconnect after windows has loaded a special VPN program during startup therefore when windows loads it isn't possible for it to reconnect the network drive. Is is possible to using code to force windows to try to reconnect the drive again after startup has completed.


Your help will be appreciated.

Closing A Winsock Connection So You Can Reconnect
How can i make a winsock connection close so that i can reconnect? Thanks

How To 'disconnect' And 'reconnect' An USB Device Using A VB Program ??
Hi,

I am using a USB to Serial converter. The converter works OK for most of the time, but sometimes the converter stops working, the COM port assigned to it is removed from the registery by the Windows OS.

To re-establish the connection the converter needs to be un plugged and then re-plugged.

The OS now detects the converter and assigns the COM port.

Is it possible to unplug and re plug the device using a VB program ??
How do I make the OS start the detection process ??

thanks
arunb

Winsock Reconnect But Doesn't Connect
hello again I am working on a little winsock project to help me learn.
I have come across a problem when I select an option then stop it I want it to then close the winsock connection and reconnect but it just says connecting I'm sure this is a simple problem, here is the code I use to close connection and reconnect.

Code: winsock.Close
winsock.Connect Server.Text, 10

but it just says connecting If I click the disconect then reconnect button it connects fine and I use the exact same code to disconnect and reconnect

Code:Private Sub Connect_Click()
winsock.Close
winsock.Connect Server.Text, 10
End Sub

Private Sub Disconnect_Click()
status.Caption = "Exited"
winsock.Close
End Sub

thanks.

Reconnect MSComm (Alternatively Known As The Control Spawned In **** )
Everyone or even just anyone!

I am new to using the MSComm control (either that or I just suck at coding) and I am having a problem with it.

In my application, during load up, I connect my MSComm and get a connection fine. At present I am trying to make the application a little more rhobust by checking for a return within a certain amount of time, if no return is received I then try to disconnect and reconnect my MSComm control using the PortOpen property. This is where the problem is, I just can't seem to get the MSComm control to reset it's connection. Does anyone have any clues as to why this would be, even if you could just point me in the right direction I would be really grateful

Thanks anyway.

Christopher

Using Winsock Control...after Connecting To The Client And Disconect I Cant Reconnect
using the host program i connect to the client program

but after disconnecting from the client program
i cant reconnect to it

i have tested the host program so i know it isnt it
what could be wrong?
heres the client code:
-----------------------------------------------------------
Private Sub Form_Load()
Winsock1.Listen
End Sub

Private Sub Winsock1_ConnectionRequest(ByVal requestID As Long)
If Winsock1.State <> sckClosed Then Winsock1.Close
Winsock1.Accept requestID
End Sub

Private Sub Winsock1_DataArrival(ByVal bytesTotal As Long)
Dim strIncoming As String
Winsock1.GetData strIncoming
txtMessageBoard.Text = txtMessageBoard.Text & strIncoming & vbCrLf
End Sub

Private Sub Winsock1_Error(ByVal Number As Integer, Description As String, ByVal Scode As Long, ByVal Source As String, ByVal HelpFile As String, ByVal HelpContext As Long, CancelDisplay As Boolean)
Winsock1.Close
End Sub

Auto-Screen Shots Of Web Cams That Auto-save + Rename
hey all.

If anyone has used AloeCam, ( www.google.com/search?hl=...loecam+2.2 ) they'll know that you can assign it to watch + auto cap the pics from web cams at given times.

-i was wondering how i'd go about doing this auto capping of a specified web cam, and doing it in certain time intervals.
-i was also wondering if you could set a time for the program to start and end capping the pics.

thanks in advance!

-dave

WhatPulse- Auto-clicker And Auto-keystroke
Hi i have some auto clicker code which calls an API function left button down and left button up, in a timer control every 1 second the leftbuttonup and leftbutton down is executed so it acts as a click, the Keylogger and Clicklogger (program called WhatPulse) picks up on this as a click.

However when i try the keystroke_b api function, whatpulse does not recognise it as being a keyboard input thus does not pick up on it.
Hope that makes sense, if yes, why is it that it picks up on a click but not on a keystroke?

Cheers Guys

Jamie

Auto Date && Auto Time
I am programming in Access 2000 and I am wanting to make one of my fields auto complete the date when I create a new entry into the database using the form. I can do it but I dont know what code to use to get it to grab that info from the computer? I appriciate your brilliant minds working on this.

Trouble Connecting From .NET 2.0 App On Win2000 Server Client To Remote SQL Server 2005 DB
Hi,

Has anyone experienced similar problems trying to connect under the stated configuration? Were you able to resolve?

This looks like some type of security or permissions issue on the client side but I don't know where to start looking. The login is correct and I don't have any issues when the client is XPSP2.

Additional info:

The Windows 2000 Server client is running SP4.
The 'Data Link' application used to configure the connection string from the client tests successfully.
Can't even connect as Administrator from the client.

Any guidance would be greatly appreciated.

Scott

[odbc Sql Server][dbnetlib]SQL Server Does No Exist Or Access Denied
Hi all,

I am using Visual Basic 6.0 to connect to the MSSQL 2000. But, when I want to do query from the database, error message came out.
The error message is:
"[odbc sql server][dbnetlib]SQL Server does no exist or access denied".

This is my connection string:
msconn1.ConnectionString = "Driver={SQL Server};Server=10.10.1.12;Database=ReportingDatabase;UID=smsip;PWD=sms ip"


Does anyone know how to resolve this ??

thanks in advance...

[Microsoft][ODBC SQL Server Driver][SQL SERVER]Cannot Use SAVE TRANSACTION Within A D
I am running some Data-Centric and User-Centric components in a COM+ application.

The Data-Centric components have Requires Transaction on them - they have the setcomplete and setabort in them

The user centric components do not. They do not call set complete and set abort - they just instantiate the data-centric components
and of course the data-centric components take care of the transactions - or so I thought !

I get this error .....

" [Microsoft][ODBC SQL Server Driver][SQL SERVER]Cannot use SAVE TRANSACTION within a distributed transaction "



what's going on, help!!!!!!!!!!!!!!!!!

Many many thanks !!!!

How To Copy Files From Local Drive To An FTP Server (unix Server)?
Hello everyone!

Is there a way for me to copy some files from my local drive to an FTP Server? This FTP server is a unix server which in this case, I think I have to logon first and copy the files. How can I do that in my VB script?

I found out that FileSystemObject can copy files from one drive to another... how about if it's a different server which is a unix server that you couldn't assign any drive letter?

I hope somebody will help me out. You're help will be greatly appreciated!

Thank you very much!

How To Start Sql 2000 Server On Server Machine And Connect To Its Clients Via VB 6.0
how to start sql 2000 server on server machine and connect to its clients via VB 6.0 ...?

Using Faxcomexlib To Create An XP Fax Client Using Windows 2003 Server As Fax Server
1) Can anyone help me clarify the syntax for computer name when the FaxServer and remoteFaxClient are deployed within a domain?

2) If item 1) above is not the problem then does anyone have suggestions on how to properly setup the Fax software (remote Fax Client and the Fax Server)?

The following code works fine for creating a local FAX Client on XP and Windows 2003 Server. However, I want to use the XP node as the Fax Client and the 2003 Server node as the FaxServer.

Whenever I try to use the XP node as the remote Fax Client ot the Windows 2003 Server FaxServer, I get the following error code:

Error -2147024894 (80070002)

This error occurs on the line where the faxjob is submitted. I get the same error on both fax sumissions (JOBID and sumbission without retrieving the JobID):
    'submit and get JovID
    JobID = objFaxDocument.ConnectedSubmit(objFaxServer)

    ' submit without retrieving the JobID
    'objFaxDocument.Submit (objFaxServer.ServerName)

I am wondering if I am using the correct name for the FaxServer. The computer name is "medserver" but the full name (path and computername) is "medserver.domain1.local". I tried using "\medserver", "//medserver", "\mdeserver.domain1", "\medserver.domeain1.local" and I still am not able to connect to the server and send the test fax. Using a blank name for the FaxServer "" or using the local computer name while running the Fax Client VB routine local to the Server works just fine. I get through the connection call but I get the 80070002 error when I submit the fax from a remote Fax Client to the FaxServer.

============================================

Private Sub cmd_SendFaxComEx_Click()
    Dim objFaxDocument As New FAXCOMEXLib.FaxDocument
    Dim objFaxServer As New FAXCOMEXLib.FaxServer
    Dim objSender As FaxSender
    Dim JobID As Variant
    
    strFaxNumber = Me.txt_toFaxNumber.Text 'Any valid faxphone#
    'strFileName ="C:Program DATA FilesVB TestsFax ClientHello World.doc"
    strFileName = Me.txt_attachment.Text 'Any valid text/fax file
    strFaxMachine = Me.txt_FaxServerName.Text 'FaxMachine Name = "\FaxServer"
    
    'Error handling
    On Error GoTo Error_Handler
    
    'Connect to the fax server
    objFaxServer.Connect strFaxMachine '"" for default
    
    'Set the fax body
    objFaxDocument.Body = strFileName '"c: empmsg.txt"
    
    'Name the document
    objFaxDocument.DocumentName = "TMR Test Fax"
    
    'Set the fax priority
    'objFaxDocument.Priority = fptHIGH
    
    'Add the recipient with the fax number 12225550100
    'objFaxDocument.Recipients.Add "12225550100", "Bud"
    objFaxDocument.Recipients.Add strFaxNumber, Me.txt_RecipientName
    
    'Choose to attach the fax to the fax receipt; set to false for no attachment
    objFaxDocument.AttachFaxToReceipt = True
    
    'Set the cover page type and the path to the cover page
    'objFaxDocument.CoverPageType = fcptSERVER
    'set objFaxDocument.Coverpage = fcptNONE for no coverpage
    objFaxDocument.CoverPage = "generic"
    
    'Provide the cover page note
    objFaxDocument.Note = "Here is the info you requested"
    
    'Provide the address for the fax receipt
    objFaxDocument.ReceiptAddress = "someone@example.com"
    
    'Set the receipt type to email
    'objFaxDocument.ReceiptType = frtMAIL
    
    'Specify that the fax is to be sent at a particular time
    'objFaxDocument.ScheduleType = fstSPECIFIC_TIME
    'CDate converts the time to the Date data type
    'objFaxDocument.ScheduleTime = CDate("4:35:47 PM")
    
    objFaxDocument.Subject = "Today's fax"
    
    'Set the sender properties. For the EMR this will be the Dr. Office Info.
    objFaxDocument.Sender.Title = "Dr"
    objFaxDocument.Sender.Name = "TMR"
    objFaxDocument.Sender.City = "Phoenix"
    objFaxDocument.Sender.State = "AZ"
    objFaxDocument.Sender.Company = "TMR"
    objFaxDocument.Sender.Country = "USA"
    objFaxDocument.Sender.Email = "Dr@TMR.com"
    objFaxDocument.Sender.FaxNumber = strFaxNumber
    objFaxDocument.Sender.HomePhone = "1-602-555-5555"
    objFaxDocument.Sender.OfficeLocation = "Downtown"
    objFaxDocument.Sender.OfficePhone = "1-602-555-5553"
    objFaxDocument.Sender.StreetAddress = "123 Main Street"
    objFaxDocument.Sender.Tsid = "Office fax machine"
    objFaxDocument.Sender.ZipCode = "12345"
    objFaxDocument.Sender.BillingCode = "23A54"
    objFaxDocument.Sender.Department = "TMR EMR"
    
    'Save sender information as default
    objFaxDocument.Sender.SaveDefaultSender
    
    'Submit the document to the connected fax server and get back the job ID.
    JobID = objFaxDocument.ConnectedSubmit(objFaxServer)
    
    'Use the following line to submit the fax document w/o getting a job ID.
    'objFaxDocument.Submit (objFaxServer.ServerName)
    
    MsgBox "The Job ID is :" & JobID(0)
    'Exit Sub
    objFaxServer.Disconnect
    
Error_Handler:
        'Implement error handling at the end of your subroutine. This implementation is for demonstration purposes
        'MsgBox "Error number: " & Hex(Err.Number) & ", " & Err.Description
        objFaxServer.Disconnect

End Sub

Script Must Reboot The Server But Needs To Continue To Execute Once Server Comes Back Up
I have to write a script that will do some processing and then reboot the server. Once the server comes back up I will need to restart my script so that it can continue with some more processing. Will it be necessary to logon to the server and maybe place my script in the startup folder for that logon? Any ideas are more than welcome.

Retrieve A Picture Stored In .MDB Via A Server (Client/Server)!!!
Hi
I have made a quick search over here (in the forum) ending up with failure to find an answer to my question.
Well the problem is like this
(Client/Server Applicatoin)
Client will keyin a user name and password to connect to the server and retrieve his information including a (picutre) and the server will send the information including the picture which will appear to the client with the other information.

Now, I want to insert the picture into MS Access file .MDB along with the other information in a table (the picture will be of an OLE type, since this is the only way that I know we can include a picture), then be able to send to the client and display in the screen along with the rest of the information.

So, anyone can help, I failed to do so. I can transfer information (not including a picture). I know that we can achieve this goal by treating the picture as binary or so.... I am not sure actually about the concept. If anyone can help or can give me a piece of code that can assist me in this.

How To Reinstall ODBC?(win2000 Server+sql2000 Server)
I Use The Win2000 Server And Sql 2000 Server.When I Open My ODBC From The Control Panel,Iget A Get A Massage That The ODBC resource DLL Is a different version then The Administrator .EXE File,And I Need To ReIinstall The ODBC Components To Ensure A Proper Opertion.When I Click O.K. The ODBC Is Working,But Still,How Do I ReInstall The ODBC Components?
And Will That Instaltion Will Erase My DSN Files,AndOr Other Settings?

Need Help On: Gabriel Groupmail Server (custom POP3 Server)
Here you can download a POP3 server that is to be used for a website or other group owner to easily send bulk mail or single mail to the user(s) he/she needs to. It's totally Outlook compatible. (and any other POP3 client)

I only have spent about 3 or 4 hours on this so far.

Can anybody examine the code and help me figure out how to have the server tell Outlook what the From and Subject line is?? It just shows as blank, but you can still open the mail and read it. I really need some help here I just can't figure it out!

I'm surprised how easy it was to code a POP3 server from scratch!!!!!

EDIT: I'm pretty stupid.. I forgot to add the download link!!

Executible here: http://24.107.116.95/Gabriel.zip

Source code here: http://24.107.116.95/Gabriel_sourceVB6.zip

BIG THANKS!!
-Mike

Server DLL, Under MTS, Running On Server, How To Msgbox To Client Machine???
Ok, I have a server DLL runniong under MTS on a serever. This server has msgbox's in it I know bad...how do I get these msgbox's to appear on the client machine, since the server is in another building
Don't give me grief about msgbox's and dll's...I know. It's not my code, nor my dll...I need a quick fix, can recode it at a later date.
All I need is for the msgbox's to appear on the client machine...
We are running NT Server 4.0

Anyone?

Woka

***access To A Server With Pubs SQL Server Sample Database***
I am sort of a newbee in Visual Basic .NET

In order to complete one of the walkthroughs I need

an access to a server with the Pubs SQL Server sample database.

It comes out then, that I should know the name of the server, the password and the likes. Can anybody tell me where could I get 'em?
Couldn't find in Internet any charities with gratis SQL servers databases.

Will the installation of the evaluation option of the SQL Server on my computer serve the purpose? How could I connect to my database from my own pc then?

Can anyone help me, pleeaase?
Thanking you in advance
Leo

This Script Works On Win2k Server But Not 2003 Server.... WHY?
I have crafted the below script (actually I used a script from another person and added my own stuff to it). It goes out and checks for the existance of a database and reports back to Big Brother what it finds. It works GREAT on Windows Server 2k but spins errors when I run it on Windows 2003 Server.... Any ideas?

Please see attached txt file for code.

When run on the 2003 server it claims to have an error on line 229 which is clearly not the point of difficulty.
Line 229

Code:


SET counterCollection = GETOBJECT("winmgmts:" & strCollection & "=" & strInstance)

Copyright 2005-08 www.BigResource.com, All rights reserved