D.B. connection fails for EXE files.

Discussion forum about all things Gupta, OpenText and the community.
gigit
Italy
Posts: 23
Joined: 14 Jun 2017, 15:04
Location: Italy

D.B. connection fails for EXE files.

Post by gigit » 21 May 2018, 10:29

Hi to all.
I am facing this problem:
EXE files made with different versions of TD (4.1, 6.0, 7.0) cannot connect to any database on the network, neither SqlServer2008 via ODBC neither SqlBase 9.0 via native connection. Only Access d.b. with connection string (REMOTEDBNAME=CARSHOP,Driver=Microsoft Access Driver (*.mdb);Dbq=G:\database\access\carshop.mdb;MaxBufferSize=2048;PageTimeout=5;UID=admin;
)
Connection strings for SqlServer databases are similar (REMOTEDBNAME=ORTOF,Driver=Sql Server;Server=GIGI00\SQL2008;Database=ORTOF;LastUser=sa;UseProcForPrepare=0;AnsiNPW=No;QuotedId=No;AutoTranslate=No;Language=English;
).
On local d.b. for sqlserver 2008R2 or 2012 there is no problem.
The strange thing is that at runtime I can connect to any d.b. on network or local. With SqlTalk too.
Only one SQL.INI along the path. SqlBase environment variable correctly set. firewall disabled for private and public networks. No changes from last week. Only a W10 upgrade :evil: . I am sure that this is the problem but what it changed?
Many thanks in advance

-----
Gigi
-----

FRBhote
India
Posts: 1233
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

D.B. connection fails for EXE files.

Post by FRBhote » 22 May 2018, 04:50

What is the error?

gigit
Italy
Posts: 23
Joined: 14 Jun 2017, 15:04
Location: Italy

D.B. connection fails for EXE files.

Post by gigit » 22 May 2018, 06:26

Hi FRBhote.
Cannot open database. So generic as unuseful. Even for Sqlbase that for Sqlserver. Only Access d.b. are opened. But with SqlTalk or TD i can reach all databases.

bheilscher
Germany
Posts: 21
Joined: 22 May 2018, 08:59
Location: Braunichswalde

D.B. connection fails for EXE files.

Post by bheilscher » 22 May 2018, 09:05

Hi,

do you start your exe from a shared network drive and use windows 10 1803 ?
if true, copy your start directory to a local drive and try it again!

Bernd

gigit
Italy
Posts: 23
Joined: 14 Jun 2017, 15:04
Location: Italy

D.B. connection fails for EXE files.

Post by gigit » 22 May 2018, 09:28

YOU ARE GREAT, GUY. ....!!!!! :P :D
Windows not :twisted: :evil:

This, of course, is a little problem. so I have to copy and maintain all executables in a local directory instead having all EXE on the network.
This problem happens here to me, I hope that my customers will be safe.
Some workaround?

Many thanks.

P.S.
great bheilscher again

bheilscher
Germany
Posts: 21
Joined: 22 May 2018, 08:59
Location: Braunichswalde

D.B. connection fails for EXE files.

Post by bheilscher » 22 May 2018, 10:11

Hi,

Windows 10 update 1803 does not open network connections on executables files on SMBv1 share.
You have to change the network protocol to SMBv2 on your server. Starting with Windows Server 2008, this version is supported.

Regards,
Bernd

Dave Rabelink
Founder/Site Admin
Founder/Site Admin
Netherlands
Posts: 1088
Joined: 24 Feb 2017, 09:12
Location: Gouda, The Netherlands

D.B. connection fails for EXE files.

Post by Dave Rabelink » 22 May 2018, 10:57

Superb info Bernd!!
Regards,
Dave Rabelink

Image
Articles and information on Team Developer Tips & Tricks Wiki
Download samples, documents and resources from TD Sample Vault
Videos on TDWiki YouTube Channel

gigit
Italy
Posts: 23
Joined: 14 Jun 2017, 15:04
Location: Italy

D.B. connection fails for EXE files.

Post by gigit » 22 May 2018, 15:29

Hi, Bernd.
I found on Microsoft Italian support an answer with this link

https://www.google.com/url?q=https%3A%2 ... A_Cj9WwUWw

and the guy suggested to verify if SMB.1 was active. Of course it isn't enough. Many thanks again.

Gerrymueller63
Canada
Posts: 1
Joined: 28 May 2018, 00:39
Location: Edmonton, Canada

D.B. connection fails for EXE files.

Post by Gerrymueller63 » 13 Jun 2018, 04:10

We ran into this issue today, thanks for the info.

:D

Uwe van der Horst
Site Admin
Site Admin
Germany
Posts: 82
Joined: 05 Mar 2017, 14:21
Location: Wetter (Ruhr), Germany

D.B. connection fails for EXE files.

Post by Uwe van der Horst » 29 Jun 2018, 07:20

Microsoft has fixed this and other network issues with Patch KB4284848 (win 10).

https://support.microsoft.com/en-us/hel ... -kb4284848
Best regards,
Uwe van der Horst
Advo-web GmbH

gigit
Italy
Posts: 23
Joined: 14 Jun 2017, 15:04
Location: Italy

D.B. connection fails for EXE files.

Post by gigit » 25 Jul 2018, 13:46

Hi.
Yes, I can confirm. I applied all upgrades automatically hoping in this, and today I tested the issue. IT IS TRUE!!! Connections are back.
Thank you Uwe.
I solved copying all exeutables I needed in a local directory in C: and running them from there. Now I have reset the situation quo ante.
Thank you

Return to “General Discussion”

Who is online

Users browsing this forum: efarina and 0 guests