Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved System data source name (empty list)

  1. Issue
0
Votes
Undo
  1. shoaib siddiqui
    shoaib siddiqui
  2. SnapDevelop
  3. Thursday, 29 July 2021 14:55 PM UTC

hi,

I am using PB2019 R3 with ASE(ODBC) 32BIT ,  I am able to define new ODBC profiles and all DB connection are working fine, but when I go to SnapDevelop IDE and try to create new DB connection I don't see data source in the list. Does SnapDevelop requires 64BIT database drivers? 

 

Saving image to remote database using Snapdevelop
Data Type "Numeric()" Identity column not supporte...
Accepted Answer
René Ullrich
René Ullrich Accepted Answer Pending Moderation
  1. Friday, 30 July 2021 05:33 AM UTC
  2. SnapDevelop
  3. # Permalink

It seems only to support 64 bit drivers. I checked it with my installation with ODBC SQL Anywhere and I have only data sources with 64 bit drivers in the list.

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Friday, 30 July 2021 09:45 AM UTC
I was thinking the same thing, Snapdevelop is probably asking you for the connection to be used on the server itself and needs it to be 64 bit?

So that would mean that maybe, you also have to install the 64 bit ODBC driver for ASE on the development PC, and surely on the server?
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Friday, 30 July 2021 09:46 AM UTC
I'm not sure if there's a way to make snapdevelop use 32 bit connections on the server.
  1. Helpful
There are no comments made yet.
Responses (2)
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Friday, 30 July 2021 15:24 PM UTC
  2. SnapDevelop
  3. # 1

The SnapDevelop IDE itself is developed in .NET, and it is compiled with AnyCPU option.  So what that means is if you run SnapDevelop on a 32-bit Windows it will run in 32-bit mode and you run it on 64-bit Windows it will run in 64-bit mode.  There is no way to force it to run 32-bit if your Windows is 64-bit.  As Rene pointed out, if the IDE is running 64-bit you need 64-bit DB drivers/DSN.

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Monday, 2 August 2021 15:06 PM UTC
So not some option like we had in powerserver? There was some .Ini file in which you could set some "platform...=32bit" if I remember well.

regards.
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Monday, 2 August 2021 15:32 PM UTC
I've just tried it myself:

Downloaded the standalone installer of SnapDevelop,

Edited the product.ini file and under "[Product]" added the line:

Platform=32



Then installed but ... only see 64 bit odbc connection profiles, so Armeen is right and Appeon chose not to implement the same functionality for SnapDevelop as for PowerServer?

regards.
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Monday, 2 August 2021 16:38 PM UTC
We compiled SnapDevelop using AnyCPU option rather than making two separate builds. You can read more about it here: https://social.msdn.microsoft.com/Forums/vstudio/en-US/e2ffb9a5-d5c1-4f94-9867-1c86f46a653d/what-does-quotany-cpuquot-mean-?forum=visualstudiogeneral
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.