Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Interbase ODBC crash when accessed in RDP session - Server 2012R2 (RDS)


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 1 - Last Post: May 21, 2015 2:29 PM Last Post By: quinn wildman
alex oosterom

Posts: 1
Registered: 5/16/15
Interbase ODBC crash when accessed in RDP session - Server 2012R2 (RDS)  
Click to report abuse...   Click to reply to this thread Reply
  Posted: May 19, 2015 12:50 AM
We have a 2012R2 RDS (remote desktop) environment for our users.
The need to query a Interbase DB from this environment. We use the latest XE7 ODBC from embarcadero.

When the database is accessed from a user (normal rights) under console (\admin) with Excel 2013 the ODBC driver does work as expected.
When the database is accessed from the same user (normal rights) but with a rdp session the driver crashes when accessing the database.

Summarizing:
When an normal user (RDP session) tries to pull data with MS query from excel i get the errors show below (eventvwr, sorry for the dutch language). So it look like a problem in gds.dll
This did work in the old (2008R2) environment.

I have tried to look where it goes wrong with process explorer but i can't find the problem.
The version of the GDS.dll is version 12.0.1.261

Logboeknaam: Application
Bron: Application Error
Datum: 23-04-2015 20:31:35
Gebeurtenis-id:1000
Taakcategorie: (100)
Niveau: Fout
Trefwoorden: Klassiek
Gebruiker: n.v.t.
Computer: TRG-RDS01.triangelgroep.local
Beschrijving:
Naam van toepassing met fout: MSQRY32.EXE, versie: 15.0.4635.1000, tijdstempel: 0x53a98d36
Naam van module met fout: GDS32.DLL, versie: 11.0.2.615, tijdstempel: 0x51d26860
Uitzonderingscode: 0xc0000005
Foutmarge: 0x000406ec
Id van proces met fout: 0xe34
Starttijd van toepassing met fout: 0x01d07df3b61a8741
Pad naar toepassing met fout: C:\Program Files (x86)\Microsoft Office\Office15\MSQRY32.EXE
Pad naar module met fout: C:\Windows\SYSTEM32\GDS32.DLL

Logboeknaam: Application
Bron: Application Error
Datum: 23-04-2015 20:32:02
Gebeurtenis-id:1000
Taakcategorie: (100)
Niveau: Fout
Trefwoorden: Klassiek
Gebruiker: n.v.t.
Computer: TRG-RDS01.triangelgroep.local
Beschrijving:
Naam van toepassing met fout: MSQRY32.EXE, versie: 15.0.4635.1000, tijdstempel: 0x53a98d36
Naam van module met fout: GDS32.DLL, versie: 11.0.2.615, tijdstempel: 0x51d26860
Uitzonderingscode: 0xc0000005
Foutmarge: 0x000406ec
Id van proces met fout: 0x3504
Starttijd van toepassing met fout: 0x01d07df3c8f05cba
Pad naar toepassing met fout: C:\Program Files (x86)\Microsoft Office\Office15\MSQRY32.EXE
Pad naar module met fout: C:\Windows\SYSTEM32\GDS32.DLL
Rapport-id: 082c10a8-e9e7-11e4-80ff-000d3a21ea17

Can anyone help me in the right direction or does anyone know if this is known issue?
quinn wildman

Posts: 856
Registered: 12/2/99
Re: Interbase ODBC crash when accessed in RDP session - Server 2012R2 (RDS)  
Click to report abuse...   Click to reply to this thread Reply
  Posted: May 21, 2015 2:29 PM   in response to: alex oosterom in response to: alex oosterom
Definitely not a known problem. My suspicion is the problem has nothing
to do with ODBC. To begin investigating the problem, I have a few
suggestions:

1. Make a connection using IBConsole (or isql) instead of ODBC. Trying
running some queries there you would guess your ODBC connection is making.

2. Do an ODBC trace. Look at the trace log and see if you see anything
interesting. I don't hold out much hope on this one.

3. Verify your database and make sure it is not corrupted.

alex oosterom wrote:
We have a 2012R2 RDS (remote desktop) environment for our users.
The need to query a Interbase DB from this environment. We use the latest XE7 ODBC from embarcadero.

When the database is accessed from a user (normal rights) under console (\admin) with Excel 2013 the ODBC driver does work as expected.
When the database is accessed from the same user (normal rights) but with a rdp session the driver crashes when accessing the database.

Summarizing:
When an normal user (RDP session) tries to pull data with MS query from excel i get the errors show below (eventvwr, sorry for the dutch language). So it look like a problem in gds.dll
This did work in the old (2008R2) environment.

I have tried to look where it goes wrong with process explorer but i can't find the problem.
The version of the GDS.dll is version 12.0.1.261

Logboeknaam: Application
Bron: Application Error
Datum: 23-04-2015 20:31:35
Gebeurtenis-id:1000
Taakcategorie: (100)
Niveau: Fout
Trefwoorden: Klassiek
Gebruiker: n.v.t.
Computer: TRG-RDS01.triangelgroep.local
Beschrijving:
Naam van toepassing met fout: MSQRY32.EXE, versie: 15.0.4635.1000, tijdstempel: 0x53a98d36
Naam van module met fout: GDS32.DLL, versie: 11.0.2.615, tijdstempel: 0x51d26860
Uitzonderingscode: 0xc0000005
Foutmarge: 0x000406ec
Id van proces met fout: 0xe34
Starttijd van toepassing met fout: 0x01d07df3b61a8741
Pad naar toepassing met fout: C:\Program Files (x86)\Microsoft Office\Office15\MSQRY32.EXE
Pad naar module met fout: C:\Windows\SYSTEM32\GDS32.DLL

Logboeknaam: Application
Bron: Application Error
Datum: 23-04-2015 20:32:02
Gebeurtenis-id:1000
Taakcategorie: (100)
Niveau: Fout
Trefwoorden: Klassiek
Gebruiker: n.v.t.
Computer: TRG-RDS01.triangelgroep.local
Beschrijving:
Naam van toepassing met fout: MSQRY32.EXE, versie: 15.0.4635.1000, tijdstempel: 0x53a98d36
Naam van module met fout: GDS32.DLL, versie: 11.0.2.615, tijdstempel: 0x51d26860
Uitzonderingscode: 0xc0000005
Foutmarge: 0x000406ec
Id van proces met fout: 0x3504
Starttijd van toepassing met fout: 0x01d07df3c8f05cba
Pad naar toepassing met fout: C:\Program Files (x86)\Microsoft Office\Office15\MSQRY32.EXE
Pad naar module met fout: C:\Windows\SYSTEM32\GDS32.DLL
Rapport-id: 082c10a8-e9e7-11e4-80ff-000d3a21ea17

Can anyone help me in the right direction or does anyone know if this is known issue?
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02