-
Sep 30th, 2006, 06:02 PM
#1
Thread Starter
Lively Member
[SOLVED] RunTime Error 3704 (Another One)....
Hi everybody... I know that this problem has been questioned many times here... but I did asearch but I couldn't quite get a hint over my problem... So here I am...
First of all the information:
- I'm usin ADO with Access over a Win2K machine...
- I only get the error once a run the EXE file (If I run the program in the IDE it works fine).
- I'm opening DB over the network.
- In the EXE file the error is generated only when I try to connect to a broken link (A computer that is not currently connected to the network), if the link is OK I get no error...
That's all I have for now... now lets see the code... The bolded line is where I get the error
VB Code:
Path1 = ComBTE(0).List(ComBTE(0).ListIndex) 'Get Path From combo box filled via OpenFile CommonDialog
DataSpec.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" + Path1 + ";"
MsgBox "A Punto De Abrir DB", vbInformation, "Error En Verificación de DB"
[B]DataSpec.Open[/B]
MsgBox "Cerifica Abrir DB", vbInformation, "Error En Verificación de DB"
Before that I have an OnError GoTo ErrSec, and after that I have:
VB Code:
ErrSec:
MsgBox "Hubo Error", vbInformation, "Error En Verificación de DB"
Select Case Err.Number ' Evaluate error number.
Case -2147467259 ' "Time Out Connection" error.
If RepComb.ListIndex = 0 Then
FGRacklist.TextMatrix(UsedRows, 0) = ComBTE(0).List(Btecount)
FGRacklist.TextMatrix(UsedRows, 1) = "No Se Pudo Conectar"
ColFGRack UsedRows, 255, 0, 255, True
UsedRows = UsedRows + 1
Else
FGRacklist.TextMatrix(0, 0) = ComBTE(0).List(ComBTE(0).ListIndex)
FGRacklist.TextMatrix(0, 1) = "No Se Pudo Conectar"
ColFGRack 0, 255, 0, 255, True
End If
Case -2147217843 ' "Authentification Error" error.
If RepComb.ListIndex = 0 Then
FGRacklist.TextMatrix(UsedRows, 0) = ComBTE(0).List(Btecount)
FGRacklist.TextMatrix(UsedRows, 1) = "Falló Autentificación"
ColFGRack UsedRows, 255, 0, 255, True
UsedRows = UsedRows + 1
Else
FGRacklist.TextMatrix(0, 0) = ComBTE(0).List(ComBTE(0).ListIndex)
FGRacklist.TextMatrix(0, 1) = "Falló Autentificación"
ColFGRack 0, 255, 0, 255, True
End If
Case Is <> 0
MsgBox Err.Description + CStr(Err.Number), vbCritical, "Error"
' Handle other situations here...
End Select
So just to make sure everything is explained... the msgbox are just to verify in which line the error is being generated. The Error Handling just tell me the reason why I couldn't open the DB... and as a said before in the IDE works perfecr... but as an EXE I got the error in the open after that it goes to ErrSec... and that's it...
Hope you can help me understand whats happening because I don't see any reason why this could be happening...
Tnx!
Last edited by G-Hawk; Oct 3rd, 2006 at 09:15 PM.
Reason: Problem solved...
-
Oct 1st, 2006, 12:30 AM
#2
Re: RunTime Error 3704 (Another One)....
You neglected to state where are you running this exe.
-
Oct 2nd, 2006, 02:22 PM
#3
Thread Starter
Lively Member
Re: RunTime Error 3704 (Another One)....
Sorry about that... but I'm running the EXE in the same computer where I'm coding the project... that's why I don't understand the problem...
-
Oct 2nd, 2006, 05:09 PM
#4
Thread Starter
Lively Member
Re: RunTime Error 3704 (Another One)....
Any Ideas?... ...
-
Oct 2nd, 2006, 08:44 PM
#5
Re: RunTime Error 3704 (Another One)....
In the same folder as your development project?
-
Oct 3rd, 2006, 10:51 AM
#6
Thread Starter
Lively Member
Re: RunTime Error 3704 (Another One)....
Yep... Randem!... Everything is in the same place (Project And EXE)
-
Oct 3rd, 2006, 06:04 PM
#7
Re: RunTime Error 3704 (Another One)....
Well, an exe runs much faster than the code in the IDE does and you may experience timeouts. You would need to set the connection timeout to a larger number.
-
Oct 3rd, 2006, 07:29 PM
#8
Thread Starter
Lively Member
Re: RunTime Error 3704 (Another One)....
OK... thanks I'll try that... Just a simple question... where can I modify the connection timeout (In the connection string or is a property of the connection?)...
-
Oct 3rd, 2006, 07:35 PM
#9
Re: RunTime Error 3704 (Another One)....
It's a property of the connection. I generally use 600.
-
Oct 3rd, 2006, 09:14 PM
#10
Thread Starter
Lively Member
Re: RunTime Error 3704 (Another One)....
Thanks Randem That did it... I get rid of the anoying 3704 Error....
-
May 12th, 2014, 09:40 PM
#11
Addicted Member
Re: [SOLVED] RunTime Error 3704 (Another One)....
thank you, i experience the same thing, want to try this, later i will confirm whether solved or not
-
May 12th, 2014, 09:51 PM
#12
Re: [SOLVED] RunTime Error 3704 (Another One)....
Originally Posted by jedifuk
thank you, i experience the same thing, want to try this, later i will confirm whether solved or not
If you problem is not resolved after you have tried the above method start a new thread detailing the problem.
when you quote a post could you please do it via the "Reply With Quote" button or if it multiple post click the "''+" button then "Reply With Quote" button.
If this thread is finished with please mark it "Resolved" by selecting "Mark thread resolved" from the "Thread tools" drop-down menu.
https://get.cryptobrowser.site/30/4111672
-
May 19th, 2014, 10:04 AM
#13
Addicted Member
Re: [SOLVED] RunTime Error 3704 (Another One)....
thank you..now it worked...amazing. i never experienced this before. saluteee
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|