martinrybak / sqlclient Goto Github PK

I used type branch's files for SQLClient framework, but used SQLClient.h and m file in master branch.
Because type branch's h&m file is not completed one and issue happened with compiling.
But when i use original h&m file in master branch it is working in compile step.
Also can get the image data but
"jpegdecompresssurface : picture decode failed" this issue happened and the image is not loading 100%
how can i do this?

I'm trying to compile my project with this framework in the device, but there is a internal library inside in the project (libfreetds.a) that is not compile to iOS 9. I try to disable bitcode in pods project, but if I do this, the app will crash in the device. Please, recompile all the project with iOS 9.

It's not possible for me to update from 0.1.3 on an existing project to 1.0.0 via Cocoapods, so I decided to install it manually. After copying the files into the project and importing the header, Xcode tells me that there is no SQLClientDelegate and no callbackQueue property anymore.

Would be great if you could help us to solve these problems...

#57

I can't get a successful build for 64-bit idevices

Hi Martin

Your SQLClient wrapper has been very useful so far. Thanks!

I know it is "for iOS" but until libfreetds.a was updated a month ago, things built fine on OS X.

However now: "URGENT: building for OSX, but linking in object file libfreetds.a(dblib.o) built for iOS. Note: This will be an error in the future."

Earlier you indicated you built freetds using a build.sh here: https://github.com/patchhf/FreeTDS-iOS

But that repo is gone (and ... for iOS).

Do you have a libfreetds.a build for OS X?

Dennis

I noticed an issue which is quite repeatable.

You can just set up a test table like below to repeat the issue.
Let's say a column named myColumn, it is either varchar(5) or decimal(3,1).
Have 3 rows of result. Row1, Row2, Row3.

If All these rows have NULL value of myColumn, the sql query result is fine.
If only Row3 is NULL, it is also fine.
If only Row2 is NULL, while Row1 is not, then there is a Problem. The query result for Row2 is not NULL, instead it uses the value from Row1.

I believe there is something wrong inside the function

• (void)execute:(NSString_)sql completion:(void (^)(NSArray_ results))completion

Please fix it, thanks.

Hey there,

In the app I'm using I have some custom alerts for when the app fails to connect, but there are also several errors that pop up from the SQLClient itself. I've browsed through most of the code and I can't find where they're coming from. What's the best to take those out/suppress them? Thank you!

Kyle

A null value in temp table (using the #) in a column not marked as nullable will prevent any results from being returned and fires the error:code:severity:, with code #515, "General SQL Error, check messages from server" (or something like this). This can be worked around by marking the tables as nullable on the server end.

Hi,
Using this SQLClient with iOS on macSierra and Xcode8.1, I've got a problem.
I'm retrieving image data from MSSQL DB, but I can not get the image field.
In other words, the Image field is not in the result of SQLClient query execute.
I can not use the key for image.
Please help.
Best Regards

Hi Martin,
I found this very useful for connecting to SQL Server.
For IPV4 connections, I used
In client connect:@"server:port" - XXX.XXX.XXX.XXX:XXXX & its working perfectly.
I have specific IPV6 address & port for the server & still I am not able to connect the same in IPV6. Also I use freeTDS 1.00.15 & it supports IPV6 too.
Is there something which I need to do or am I missing something?

-- When i try to build project i am getting this error.

ld: '/Users/............./Pods/SQLClient/SQLClient/SQLClient/SQLClient/libfreetds.a(dblib.o)' does not contain bitcode. You must rebuild it with bitcode enabled (Xcode setting ENABLE_BITCODE), obtain an updated library from the vendor, or disable bitcode for this target. for architecture arm64

I have an app that executes a query every 5 seconds, at some point of executing a query it crashes by a “bad access error” in the methods connection failure and connection success, it appears that at some point the login variable gets freed and the bad access exception is thrown crashing my app. I haven’t been able to track this error to a possible fix.
Another thing to mention, is that this happens on the iOS simulator, i have not been able to test the app in a real device.

Hope the image looks well, and help with the issue.

Hello Martin,

After a long time I am getting again crashes due to sql library in my app. Please check below screen shot for details.

I don't see how to retrieve the key when a table has a generated key.

Hi,
I need to load data from a table with a binary column.
Its defined as varbinary(max). Its a pdf-document. (300kb-1mb).
The loaded row is truncated after 255 chars.

I ve created a stored proc on the server to split the data into many rows.
But thats a very bad way.

Is there another (better) way to do it?

Thank you.

ps.
I've also seen that I can load 8000 chars but the binary data will be converted to ascii.
And the strings will be truncated.

Regards
Ronny

Hi,

Today I got again crash and here i have paste crash report:-

Incident Identifier: EFCA15A8-101F-4D72-9798-CFC55EF01458
CrashReporter Key: 8591fba743bb55ea2ec90643bcaf023fb49ff59c
Hardware Model: iPhone5,2
Process: Saudi_Traffic_Department [1162]
Path: /var/mobile/Applications/226DF00B-19AB-42BB-8A74-F5F07D6F7D37/Saudi_Traffic_Department.app/Saudi_Traffic_Department
Identifier: a.Saudi-Traffic-Department
Version: 1.0 (1.0)
Code Type: ARM (Native)
Parent Process: launchd [1]

Date/Time: 2014-01-22 18:58:44.086 +0400
OS Version: iOS 7.0.4 (11B554a)
Report Version: 104

Exception Type: EXC_BAD_ACCESS (SIGSEGV)
Exception Subtype: KERN_INVALID_ADDRESS at 0x51e213b5
Triggered by Thread: 5

Thread 0:
0 libobjc.A.dylib 0x3984b894 bool objc::DenseMapBase<objc::DenseMap<objc_object*, unsigned long, true, objc::DenseMapInfo<objc_object*> >, objc_object_, unsigned long, objc::DenseMapInfo<objc_object_>, true>::LookupBucketFor<objc_object*>(objc_object* const&, std::1::pair<objc_object, unsigned long> const_&) const + 132
1 libobjc.A.dylib 0x3984b63a objc::DenseMapBase<objc::DenseMap<objc_object_, unsigned long, true, objc::DenseMapInfo<objc_object> >, objc_object_, unsigned long, objc::DenseMapInfo<objc_object_>, true>::erase(objc_object* const&) + 10
2 libobjc.A.dylib 0x3984ab4e objc_object::sidetable_clearDeallocating() + 58
3 libobjc.A.dylib 0x3983bc72 objc_destructInstance + 46
4 CoreFoundation 0x2f412fc6 CFRelease + 874
5 CoreFoundation 0x2f4f085c __CFCalendarCreateUCalendar + 120
6 CoreFoundation 0x2f450594 CFCalendarCreateWithIdentifier + 524
7 CoreFoundation 0x2f4c6856 __CFLogCString + 102
8 CoreFoundation 0x2f450360 _CFLogvEx + 192
9 Foundation 0x2fe0965e NSLogv + 82
10 Foundation 0x2fe095fe NSLog + 22
11 Saudi_Traffic_Department 0x001c76e4 -PatrolsonDuty_ByHour_ViewController message:
12 Saudi_Traffic_Department 0x0022e820 __21-[SQLClient message:]_block_invoke (SQLClient.m:336)
13 Foundation 0x2fe218a4 -[NSBlockOperation main] + 128
14 Foundation 0x2fe11aa0 -[__NSOperationInternal _start:] + 768
15 Foundation 0x2feb5968 __NSOQSchedule_f + 56
16 libdispatch.dylib 0x39d240ac _dispatch_client_callout + 20
17 libdispatch.dylib 0x39d269a4 _dispatch_main_queue_callback_4CF + 264
18 CoreFoundation 0x2f4ad5ac __CFRUNLOOP_IS_SERVICING_THE_MAIN_DISPATCH_QUEUE** + 4
19 CoreFoundation 0x2f4abe78 __CFRunLoopRun + 1304
20 CoreFoundation 0x2f41646c CFRunLoopRunSpecific + 520
21 CoreFoundation 0x2f41624e CFRunLoopRunInMode + 102
22 GraphicsServices 0x341502e6 GSEventRunModal + 134
23 UIKit 0x31ccb840 UIApplicationMain + 1132
24 Saudi_Traffic_Department 0x0019f1e0 main (main.m:16)
25 libdyld.dylib 0x39d38ab4 start + 0

Thread 1:
0 libsystem_kernel.dylib 0x39ddc838 kevent64 + 24
1 libdispatch.dylib 0x39d2b0d0 _dispatch_mgr_invoke + 228
2 libdispatch.dylib 0x39d2561e _dispatch_mgr_thread + 34

Thread 2:
0 libsystem_kernel.dylib 0x39defc7c __workq_kernreturn + 8
1 libsystem_pthread.dylib 0x39e53e06 _pthread_wqthread + 306
2 libsystem_pthread.dylib 0x39e53cc0 start_wqthread + 4

Thread 3 name: com.apple.NSURLConnectionLoader
Thread 3:
0 libsystem_kernel.dylib 0x39ddca84 mach_msg_trap + 20
1 libsystem_kernel.dylib 0x39ddc87c mach_msg + 36
2 CoreFoundation 0x2f4ad554 CFRunLoopServiceMachPort + 152
3 CoreFoundation 0x2f4abc74 __CFRunLoopRun + 788
4 CoreFoundation 0x2f41646c CFRunLoopRunSpecific + 520
5 CoreFoundation 0x2f41624e CFRunLoopRunInMode + 102
6 Foundation 0x2fe514bc +[NSURLConnection(Loader) _resourceLoadLoop:] + 316
7 Foundation 0x2fec6c32 __NSThread__main + 1058
8 libsystem_pthread.dylib 0x39e55c5a _pthread_body + 138
9 libsystem_pthread.dylib 0x39e55bca _pthread_start + 98
10 libsystem_pthread.dylib 0x39e53ccc thread_start + 4

Thread 4 name: com.apple.CFSocket.private
Thread 4:
0 libsystem_kernel.dylib 0x39def440 select$DARWIN_EXTSN + 20
1 CoreFoundation 0x2f4b1456 __CFSocketManager + 482
2 libsystem_pthread.dylib 0x39e55c5a _pthread_body + 138
3 libsystem_pthread.dylib 0x39e55bca _pthread_start + 98
4 libsystem_pthread.dylib 0x39e53ccc thread_start + 4

Thread 5 Crashed:
0 Saudi_Traffic_Department 0x0032084c tds_dstr_zero + 24
1 Saudi_Traffic_Department 0x003187d8 tds_free_login + 24
2 Saudi_Traffic_Department 0x002fc20a dbloginfree + 98
3 Saudi_Traffic_Department 0x0022e1c6 -SQLClient connectionSuccess:
4 Saudi_Traffic_Department 0x0022d49c __59-[SQLClient connect:username:password:database:completion:]_block_invoke (SQLClient.m:124)
5 Foundation 0x2fe218a4 -[NSBlockOperation main] + 128
6 Foundation 0x2fe11aa0 -[__NSOperationInternal _start:] + 768
7 Foundation 0x2feb5968 __NSOQSchedule_f + 56
8 libdispatch.dylib 0x39d284b2 _dispatch_async_redirect_invoke + 106
9 libdispatch.dylib 0x39d297d4 _dispatch_root_queue_drain + 220
10 libdispatch.dylib 0x39d299c0 _dispatch_worker_thread2 + 52
11 libsystem_pthread.dylib 0x39e53dfc _pthread_wqthread + 296
12 libsystem_pthread.dylib 0x39e53cc0 start_wqthread + 4

Thread 6:
0 libsystem_kernel.dylib 0x39defc7c __workq_kernreturn + 8
1 libsystem_pthread.dylib 0x39e53e06 _pthread_wqthread + 306
2 libsystem_pthread.dylib 0x39e53cc0 start_wqthread + 4

Thread 5 crashed with ARM Thread State (32-bit):
r0: 0x51e213b5 r1: 0x00000000 r2: 0x0033bfb8 r3: 0xffffffff
r4: 0x1e3b28a0 r5: 0xffffffff r6: 0x0000004c r7: 0x06ab0c44
r8: 0x00000000 r9: 0x00000004 r10: 0x000000d8 r11: 0x00000058
ip: 0x3bbcf28c sp: 0x06ab0c3c lr: 0x003187dd pc: 0x0032084c
cpsr: 0x40000030

Binary Images:
0xc2000 - 0x389fff Saudi_Traffic_Department armv7s <8d082490116237e3879ac50f339e91c5> /var/mobile/Applications/226DF00B-19AB-42BB-8A74-F5F07D6F7D37/Saudi_Traffic_Department.app/Saudi_Traffic_Department
0x2bedd000 - 0x2bf00fff dyld armv7s /usr/lib/dyld
0x2e25f000 - 0x2e368fff IMGSGX543RC2GLDriver armv7s /System/Library/Extensions/IMGSGX543RC2GLDriver.bundle/IMGSGX543RC2GLDriver
0x2e49d000 - 0x2e49dfff Accelerate armv7s <9340338f3cdf347abe4a88c2f59b5b12> /System/Library/Frameworks/Accelerate.framework/Accelerate
0x2e4a7000 - 0x2e674fff vImage armv7s <479b5c4701833284ab587a1d2fdb5627> /System/Library/Frameworks/Accelerate.framework/Frameworks/vImage.framework/vImage
0x2e675000 - 0x2e757fff libBLAS.dylib armv7s /System/Library/Frameworks/Accelerate.framework/Frameworks/vecLib.framework/libBLAS.dylib
0x2e758000 - 0x2ea13fff libLAPACK.dylib armv7s <066ea8372dd23f6d89011f9a4a872d6f> /System/Library/Frameworks/Accelerate.framework/Frameworks/vecLib.framework/libLAPACK.dylib
0x2ea14000 - 0x2ea82fff libvDSP.dylib armv7s /System/Library/Frameworks/Accelerate.framework/Frameworks/vecLib.framework/libvDSP.dylib
0x2ea83000 - 0x2ea95fff libvMisc.dylib armv7s /System/Library/Frameworks/Accelerate.framework/Frameworks/vecLib.framework/libvMisc.dylib
0x2ea96000 - 0x2ea96fff vecLib armv7s <663aefa25bc5367baa72ca144ac26d18> /System/Library/Frameworks/Accelerate.framework/Frameworks/vecLib.framework/vecLib
0x2ea97000 - 0x2eab6fff Accounts armv7s <811f7e5dcd353c57af6d6de859848774> /System/Library/Frameworks/Accounts.framework/Accounts
0x2eab8000 - 0x2eb1dfff AddressBook armv7s /System/Library/Frameworks/AddressBook.framework/AddressBook
0x2ed86000 - 0x2f0a2fff AudioToolbox armv7s /System/Library/Frameworks/AudioToolbox.framework/AudioToolbox
0x2f0a3000 - 0x2f1a8fff CFNetwork armv7s <36562cff956f38a09956da9218198ccf> /System/Library/Frameworks/CFNetwork.framework/CFNetwork
0x2f1a9000 - 0x2f204fff CoreAudio armv7s <34f47ad0c4d530249298888a1217316f> /System/Library/Frameworks/CoreAudio.framework/CoreAudio
0x2f205000 - 0x2f21bfff CoreBluetooth armv7s <0211d5169d0d3838a9cbb9dd5086a312> /System/Library/Frameworks/CoreBluetooth.framework/CoreBluetooth
0x2f21c000 - 0x2f40dfff CoreData armv7s <4ed490c5fd693fefac89d75a47eab553> /System/Library/Frameworks/CoreData.framework/CoreData
0x2f40e000 - 0x2f551ff0 CoreFoundation armv7s <37c6b3b7abca3774bec8fecf79f07013> /System/Library/Frameworks/CoreFoundation.framework/CoreFoundation
0x2f552000 - 0x2f676fff CoreGraphics armv7s /System/Library/Frameworks/CoreGraphics.framework/CoreGraphics
0x2f678000 - 0x2f6b3fff libCGFreetype.A.dylib armv7s <4be02e4373903a7d8295e4e0859326ab> /System/Library/Frameworks/CoreGraphics.framework/Resources/libCGFreetype.A.dylib
0x2f6b5000 - 0x2f6bffff libCMSBuiltin.A.dylib armv7s <23411d17163a35269e923c9d1a21f1b6> /System/Library/Frameworks/CoreGraphics.framework/Resources/libCMSBuiltin.A.dylib
0x2f8a4000 - 0x2f8befff libRIP.A.dylib armv7s <40d9d1ad277338ac900b7d97b26c6575> /System/Library/Frameworks/CoreGraphics.framework/Resources/libRIP.A.dylib
0x2f8bf000 - 0x2f997fff CoreImage armv7s <5cb9106c864730e8b36ba1f7f14d9c7f> /System/Library/Frameworks/CoreImage.framework/CoreImage
0x2f998000 - 0x2f9e5fff CoreLocation armv7s /System/Library/Frameworks/CoreLocation.framework/CoreLocation
0x2fa1d000 - 0x2fa94fff CoreMedia armv7s <7a5f55d144f73dc594127c6469e49587> /System/Library/Frameworks/CoreMedia.framework/CoreMedia
0x2fa95000 - 0x2fb3dfff CoreMotion armv7s /System/Library/Frameworks/CoreMotion.framework/CoreMotion
0x2fb3e000 - 0x2fb96fff CoreTelephony armv7s <53697e7196f637cba3234d37798635b2> /System/Library/Frameworks/CoreTelephony.framework/CoreTelephony
0x2fb97000 - 0x2fc26fff CoreText armv7s <7eaf2f4eaadf382daff13c72e6f1f3b6> /System/Library/Frameworks/CoreText.framework/CoreText
0x2fc27000 - 0x2fc36fff CoreVideo armv7s /System/Library/Frameworks/CoreVideo.framework/CoreVideo
0x2fdf9000 - 0x2ffe3fff Foundation armv7s <19e2d0f6233d3765adecfb5ba59d9b7e> /System/Library/Frameworks/Foundation.framework/Foundation
0x301c1000 - 0x30217fff IOKit armv7s <2c6e904057f13394b4008615454063b7> /System/Library/Frameworks/IOKit.framework/Versions/A/IOKit
0x30218000 - 0x30428fff ImageIO armv7s /System/Library/Frameworks/ImageIO.framework/ImageIO
0x30429000 - 0x30671fff JavaScriptCore armv7s <54f2231ea9e43666befddcdc18a910eb> /System/Library/Frameworks/JavaScriptCore.framework/JavaScriptCore
0x30672000 - 0x30715fff MapKit armv7s <934c186ad02e3012801b8aad1984e5e0> /System/Library/Frameworks/MapKit.framework/MapKit
0x30716000 - 0x3071afff MediaAccessibility armv7s <6b18e226cdae3e4dbfb3b6b826e26f8f> /System/Library/Frameworks/MediaAccessibility.framework/MediaAccessibility
0x30901000 - 0x30bbafff MediaToolbox armv7s <80730d8eae0338d0a992404f584240bf> /System/Library/Frameworks/MediaToolbox.framework/MediaToolbox
0x30c57000 - 0x30cbafff MobileCoreServices armv7s <4e4cc0e2dc763d5f8f9c5ed5cbc704fb> /System/Library/Frameworks/MobileCoreServices.framework/MobileCoreServices
0x31631000 - 0x316edfff GLEngine armv7s /System/Library/Frameworks/OpenGLES.framework/GLEngine.bundle/GLEngine
0x316ee000 - 0x316f6fff OpenGLES armv7s /System/Library/Frameworks/OpenGLES.framework/OpenGLES
0x316f8000 - 0x316f8fff libCVMSPluginSupport.dylib armv7s <5c255052c907399eb0201ea98dd2855a> /System/Library/Frameworks/OpenGLES.framework/libCVMSPluginSupport.dylib
0x316f9000 - 0x316fbfff libCoreFSCache.dylib armv7s /System/Library/Frameworks/OpenGLES.framework/libCoreFSCache.dylib
0x316fc000 - 0x316fffff libCoreVMClient.dylib armv7s <0a471be053a43e1ca78e79defaa47ad1> /System/Library/Frameworks/OpenGLES.framework/libCoreVMClient.dylib
0x31700000 - 0x31707fff libGFXShared.dylib armv7s <61521d6895eb360b9587478aa39a149d> /System/Library/Frameworks/OpenGLES.framework/libGFXShared.dylib
0x31708000 - 0x31748fff libGLImage.dylib armv7s /System/Library/Frameworks/OpenGLES.framework/libGLImage.dylib
0x31749000 - 0x3187dfff libGLProgrammability.dylib armv7s <6aba293deb4d3f38a696fd8d6c6e514b> /System/Library/Frameworks/OpenGLES.framework/libGLProgrammability.dylib
0x318e1000 - 0x31a26fff QuartzCore armv7s <723bf8706f6f3fe28a714ed9466c54aa> /System/Library/Frameworks/QuartzCore.framework/QuartzCore
0x31a80000 - 0x31ac1fff Security armv7s <8d356745d35b357e9c08dc578f8b2044> /System/Library/Frameworks/Security.framework/Security
0x31c0a000 - 0x31c59fff SystemConfiguration armv7s /System/Library/Frameworks/SystemConfiguration.framework/SystemConfiguration
0x31c5c000 - 0x3237dfff UIKit armv7s /System/Library/Frameworks/UIKit.framework/UIKit
0x3237e000 - 0x323ccfff VideoToolbox armv7s /System/Library/Frameworks/VideoToolbox.framework/VideoToolbox
0x3276b000 - 0x3276ffff AggregateDictionary armv7s /System/Library/PrivateFrameworks/AggregateDictionary.framework/AggregateDictionary
0x32982000 - 0x32cbdfff Altitude armv7s <078611587d1f3e61bab83ee96f53e909> /System/Library/PrivateFrameworks/Altitude.framework/Altitude
0x32cf2000 - 0x32d2ffff AppSupport armv7s /System/Library/PrivateFrameworks/AppSupport.framework/AppSupport
0x32e4f000 - 0x32e5cfff AssetsLibraryServices armv7s /System/Library/PrivateFrameworks/AssetsLibraryServices.framework/AssetsLibraryServices
0x32e9d000 - 0x32ec0fff BackBoardServices armv7s <851e6a2fca27396a901cadb1dd564305> /System/Library/PrivateFrameworks/BackBoardServices.framework/BackBoardServices
0x32ec3000 - 0x32ec8fff BluetoothManager armv7s /System/Library/PrivateFrameworks/BluetoothManager.framework/BluetoothManager
0x32ec9000 - 0x32eedfff Bom armv7s /System/Library/PrivateFrameworks/Bom.framework/Bom
0x32f8c000 - 0x32f94fff CaptiveNetwork armv7s /System/Library/PrivateFrameworks/CaptiveNetwork.framework/CaptiveNetwork
0x32f95000 - 0x3306ffff Celestial armv7s /System/Library/PrivateFrameworks/Celestial.framework/Celestial
0x3307c000 - 0x33081fff CertUI armv7s /System/Library/PrivateFrameworks/CertUI.framework/CertUI
0x331bb000 - 0x331c6fff CommonUtilities armv7s <38e170cdcb583bc7b0918a9fd2d56189> /System/Library/PrivateFrameworks/CommonUtilities.framework/CommonUtilities
0x331c7000 - 0x331cbfff CommunicationsFilter armv7s /System/Library/PrivateFrameworks/CommunicationsFilter.framework/CommunicationsFilter
0x33293000 - 0x33295fff CoreAUC armv7s /System/Library/PrivateFrameworks/CoreAUC.framework/CoreAUC
0x33527000 - 0x33545fff CoreServicesInternal armv7s <9c1c34613680340cb8b7ee3b8f12a08f> /System/Library/PrivateFrameworks/CoreServicesInternal.framework/CoreServicesInternal
0x33546000 - 0x33547fff CoreSurface armv7s /System/Library/PrivateFrameworks/CoreSurface.framework/CoreSurface
0x335ee000 - 0x33648fff CoreUI armv7s <40d696324564353e981f4f8ba480586f> /System/Library/PrivateFrameworks/CoreUI.framework/CoreUI
0x33649000 - 0x33696fff CoreUtils armv7s /System/Library/PrivateFrameworks/CoreUtils.framework/CoreUtils
0x33697000 - 0x3369cfff CrashReporterSupport armv7s /System/Library/PrivateFrameworks/CrashReporterSupport.framework/CrashReporterSupport
0x33865000 - 0x3387afff DataAccessExpress armv7s <16e4c6b2b55e3644b4bcc9ef328153a8> /System/Library/PrivateFrameworks/DataAccessExpress.framework/DataAccessExpress
0x338b5000 - 0x338b8fff DataMigration armv7s <167a3e3059a4355ab50f4b6f6cfa06a3> /System/Library/PrivateFrameworks/DataMigration.framework/DataMigration
0x338bf000 - 0x338d9fff DictionaryServices armv7s /System/Library/PrivateFrameworks/DictionaryServices.framework/DictionaryServices
0x338f5000 - 0x33912fff EAP8021X armv7s <460bfb71241d33ea9d9e191ec0cb69c7> /System/Library/PrivateFrameworks/EAP8021X.framework/EAP8021X
0x3391b000 - 0x33926fff ExFAT armv7s <0f2de9eb7f6139de8a51ba3eccbec8d2> /System/Library/PrivateFrameworks/ExFAT.framework/ExFAT
0x33965000 - 0x33d80fff FaceCore armv7s /System/Library/PrivateFrameworks/FaceCore.framework/FaceCore
0x33db3000 - 0x33db9fff libGPUSupportMercury.dylib armv7s /System/Library/PrivateFrameworks/GPUSupport.framework/libGPUSupportMercury.dylib
0x33fb0000 - 0x34148fff GeoServices armv7s <84b62d5c98ac3914bf90cb356d0fe875> /System/Library/PrivateFrameworks/GeoServices.framework/GeoServices
0x34149000 - 0x34157fff GraphicsServices armv7s <963e9b456da7301cb752303a69f27d10> /System/Library/PrivateFrameworks/GraphicsServices.framework/GraphicsServices
0x34503000 - 0x3455dfff IMFoundation armv7s <2e56e96350c733ed8fc9eb2dc065d718> /System/Library/PrivateFrameworks/IMFoundation.framework/IMFoundation
0x34564000 - 0x34566fff IOAccelerator armv7s /System/Library/PrivateFrameworks/IOAccelerator.framework/IOAccelerator
0x34567000 - 0x3456efff IOMobileFramebuffer armv7s /System/Library/PrivateFrameworks/IOMobileFramebuffer.framework/IOMobileFramebuffer
0x3456f000 - 0x34574fff IOSurface armv7s /System/Library/PrivateFrameworks/IOSurface.framework/IOSurface
0x346b2000 - 0x3472bfff ManagedConfiguration armv7s /System/Library/PrivateFrameworks/ManagedConfiguration.framework/ManagedConfiguration
0x3472e000 - 0x347a6fff MediaControlSender armv7s /System/Library/PrivateFrameworks/MediaControlSender.framework/MediaControlSender
0x347de000 - 0x347e8fff MediaRemote armv7s <5f6dc798e39b32c1ab4cf554668ce7ea> /System/Library/PrivateFrameworks/MediaRemote.framework/MediaRemote
0x3494b000 - 0x34956fff MobileAsset armv7s <5129443f89f937238576308808e62124> /System/Library/PrivateFrameworks/MobileAsset.framework/MobileAsset
0x3497a000 - 0x34982fff MobileBluetooth armv7s <4d8e6011aca13a058fe6a7988ab3e1d4> /System/Library/PrivateFrameworks/MobileBluetooth.framework/MobileBluetooth
0x3499d000 - 0x349a0fff MobileInstallation armv7s /System/Library/PrivateFrameworks/MobileInstallation.framework/MobileInstallation
0x349a1000 - 0x349a9fff MobileKeyBag armv7s <6a7ed5c70f603339bb2b7fe8d3446d0c> /System/Library/PrivateFrameworks/MobileKeyBag.framework/MobileKeyBag
0x349d1000 - 0x349d4fff MobileSystemServices armv7s <708039aee4ec32899e4bbf817407798f> /System/Library/PrivateFrameworks/MobileSystemServices.framework/MobileSystemServices
0x349f3000 - 0x349fefff MobileWiFi armv7s <59c298c093e63ac8ade746aa2ad0fe44> /System/Library/PrivateFrameworks/MobileWiFi.framework/MobileWiFi
0x34c6d000 - 0x34c72fff Netrb armv7s /System/Library/PrivateFrameworks/Netrb.framework/Netrb
0x34c73000 - 0x34c78fff NetworkStatistics armv7s <28a54cc525333d80a2d0e882a8e63243> /System/Library/PrivateFrameworks/NetworkStatistics.framework/NetworkStatistics
0x34c97000 - 0x34c99fff OAuth armv7s <4726833fd7d9357a8bbdd3487dcfa9c9> /System/Library/PrivateFrameworks/OAuth.framework/OAuth
0x353f1000 - 0x3542cfff OpenCL armv7s /System/Library/PrivateFrameworks/OpenCL.framework/OpenCL
0x359d2000 - 0x359f8fff PersistentConnection armv7s <1137f9d6610337be8d208465d7caea23> /System/Library/PrivateFrameworks/PersistentConnection.framework/PersistentConnection
0x35e13000 - 0x35e40fff PhysicsKit armv7s <8fa2fcdc554d387fa59ea688840048d0> /System/Library/PrivateFrameworks/PhysicsKit.framework/PhysicsKit
0x35f2f000 - 0x35f66fff PrintKit armv7s <6bc12fe7b63739e79d7dba91a4f2560c> /System/Library/PrivateFrameworks/PrintKit.framework/PrintKit
0x35f6a000 - 0x35ff1fff ProofReader armv7s /System/Library/PrivateFrameworks/ProofReader.framework/ProofReader
0x35ff2000 - 0x35ffcfff ProtocolBuffer armv7s <5b4e6b3fda35338582564205c2124948> /System/Library/PrivateFrameworks/ProtocolBuffer.framework/ProtocolBuffer
0x36377000 - 0x3638bfff SpringBoardServices armv7s <07b50ddb252a3670ae27c994e345d32d> /System/Library/PrivateFrameworks/SpringBoardServices.framework/SpringBoardServices
0x365a2000 - 0x366bafff StoreServices armv7s <64f930de40553f1b941468839bb35795> /System/Library/PrivateFrameworks/StoreServices.framework/StoreServices
0x36769000 - 0x3676bfff TCC armv7s /System/Library/PrivateFrameworks/TCC.framework/TCC
0x367b5000 - 0x367d6fff TelephonyUtilities armv7s <452c156104483fc3aea85ebaf9f5c734> /System/Library/PrivateFrameworks/TelephonyUtilities.framework/TelephonyUtilities
0x36b49000 - 0x36b6dfff TextInput armv7s /System/Library/PrivateFrameworks/TextInput.framework/TextInput
0x36dc8000 - 0x36e88fff UIFoundation armv7s /System/Library/PrivateFrameworks/UIFoundation.framework/UIFoundation
0x36ea0000 - 0x36ea3fff UserFS armv7s <8cadaf260e5c331a98f0cbc94efbc6a6> /System/Library/PrivateFrameworks/UserFS.framework/UserFS
0x36eb9000 - 0x37108fff VectorKit armv7s <16fa240357ab3113a02f6971195cce29> /System/Library/PrivateFrameworks/VectorKit.framework/VectorKit
0x37323000 - 0x37dd1fff WebCore armv7s <7df88f9af79231758f97431994ad6be8> /System/Library/PrivateFrameworks/WebCore.framework/WebCore
0x37dd2000 - 0x37e92fff WebKit armv7s <2d9a513d87bd3c2d8de0098df694485c> /System/Library/PrivateFrameworks/WebKit.framework/WebKit
0x37fd9000 - 0x37fe1fff XPCObjects armv7s /System/Library/PrivateFrameworks/XPCObjects.framework/XPCObjects
0x38d49000 - 0x38d50fff libAccessibility.dylib armv7s <652dee07b3fe371fb8230aee2c9537b4> /usr/lib/libAccessibility.dylib
0x38f49000 - 0x38f5ffff libCRFSuite.dylib armv7s <06362cba96bf3a679a91d40f125057cc> /usr/lib/libCRFSuite.dylib
0x38f75000 - 0x38f8afff libMobileGestalt.dylib armv7s <7abc89974a6d36558d5efa60184e43c2> /usr/lib/libMobileGestalt.dylib
0x38f8b000 - 0x38f91fff libMobileGestaltExtensions.dylib armv7s <2fab5a9933e730b380744f325b384e30> /usr/lib/libMobileGestaltExtensions.dylib
0x38fa8000 - 0x38fa9fff libSystem.B.dylib armv7s /usr/lib/libSystem.B.dylib
0x39014000 - 0x39040fff libTelephonyUtilDynamic.dylib armv7s <56f4820a03da3b71bc7ea2114e81060d> /usr/lib/libTelephonyUtilDynamic.dylib
0x3918a000 - 0x39196fff libbsm.0.dylib armv7s <34a4b8ea80e4390ab8a146e0de95b6b1> /usr/lib/libbsm.0.dylib
0x39197000 - 0x391a1fff libbz2.1.0.dylib armv7s /usr/lib/libbz2.1.0.dylib
0x391a2000 - 0x391edfff libc++.1.dylib armv7s <18b3a243f7923c39951c97ab416ed3e6> /usr/lib/libc++.1.dylib
0x391ee000 - 0x39208fff libc++abi.dylib armv7s <2e20d75c97d339a297a21de19c6a6d4b> /usr/lib/libc++abi.dylib
0x39218000 - 0x3921ffff libcupolicy.dylib armv7s /usr/lib/libcupolicy.dylib
0x39266000 - 0x39353fff libiconv.2.dylib armv7s /usr/lib/libiconv.2.dylib
0x39354000 - 0x394a5fff libicucore.A.dylib armv7s <719aeeaa9cc7301e8eb9117644f94b38> /usr/lib/libicucore.A.dylib
0x394ad000 - 0x394adfff liblangid.dylib armv7s <9babf315c8b739ff98c078fb894ba3c4> /usr/lib/liblangid.dylib
0x394ae000 - 0x394b8fff liblockdown.dylib armv7s <5623ee432246307eb3ca6b212542d69d> /usr/lib/liblockdown.dylib
0x394b9000 - 0x394cefff liblzma.5.dylib armv7s /usr/lib/liblzma.5.dylib
0x397fa000 - 0x3980efff libmis.dylib armv7s <10ffee9d35cc3a3aafad5a1f3fe1e3e7> /usr/lib/libmis.dylib
0x39837000 - 0x399d6fff libobjc.A.dylib armv7s <0cc1bf8b5caa39fd90ca9cfc94e03fcb> /usr/lib/libobjc.A.dylib
0x39a9e000 - 0x39ab3fff libresolv.9.dylib armv7s <763ddffb38af3444b74501dde37a5949> /usr/lib/libresolv.9.dylib
0x39adc000 - 0x39b73fff libsqlite3.dylib armv7s <0cd7d6e04761365480a2078daee86959> /usr/lib/libsqlite3.dylib
0x39b74000 - 0x39bc1fff libstdc++.6.dylib armv7s <894bc61807683540a1d475ae8b117140> /usr/lib/libstdc++.6.dylib
0x39bc2000 - 0x39be8fff libtidy.A.dylib armv7s <9ac4925f9e803e48a846ae28aba6d355> /usr/lib/libtidy.A.dylib
0x39bec000 - 0x39c9ffff libxml2.2.dylib armv7s <810acee8bebe317492118d752643bde3> /usr/lib/libxml2.2.dylib
0x39ca0000 - 0x39cc1fff libxslt.1.dylib armv7s /usr/lib/libxslt.1.dylib
0x39cc2000 - 0x39ccefff libz.1.dylib armv7s /usr/lib/libz.1.dylib
0x39ccf000 - 0x39cd3fff libcache.dylib armv7s <371dad0c805634ac9ad03150a7bb227d> /usr/lib/system/libcache.dylib
0x39cd4000 - 0x39cdcfff libcommonCrypto.dylib armv7s <95f921d990c936a2a185363d6d606fae> /usr/lib/system/libcommonCrypto.dylib
0x39cdd000 - 0x39ce1fff libcompiler_rt.dylib armv7s /usr/lib/system/libcompiler_rt.dylib
0x39ce2000 - 0x39ce8fff libcopyfile.dylib armv7s <6e0607b0ba0c3b5297beb5c2291803f3> /usr/lib/system/libcopyfile.dylib
0x39ce9000 - 0x39d22fff libcorecrypto.dylib armv7s <8af5878efc1a3eeb8e3ca9ec454855a8> /usr/lib/system/libcorecrypto.dylib
0x39d23000 - 0x39d36fff libdispatch.dylib armv7s <20e9bf9f001f376bafe977a315d87fd7> /usr/lib/system/libdispatch.dylib
0x39d37000 - 0x39d38fff libdyld.dylib armv7s <93c82bcfda94398b997952820e4b22bf> /usr/lib/system/libdyld.dylib
0x39d39000 - 0x39d39fff libkeymgr.dylib armv7s /usr/lib/system/libkeymgr.dylib
0x39d3a000 - 0x39d40fff liblaunch.dylib armv7s /usr/lib/system/liblaunch.dylib
0x39d41000 - 0x39d44fff libmacho.dylib armv7s <32be9d5e3cf331449dc721918fe68901> /usr/lib/system/libmacho.dylib
0x39d45000 - 0x39d46fff libremovefile.dylib armv7s /usr/lib/system/libremovefile.dylib
0x39d47000 - 0x39d54fff libsystem_asl.dylib armv7s <466e30f1d8f03803975292042874ed17> /usr/lib/system/libsystem_asl.dylib
0x39d55000 - 0x39d55fff libsystem_blocks.dylib armv7s /usr/lib/system/libsystem_blocks.dylib
0x39d56000 - 0x39db8fff libsystem_c.dylib armv7s /usr/lib/system/libsystem_c.dylib
0x39db9000 - 0x39dbbfff libsystem_configuration.dylib armv7s /usr/lib/system/libsystem_configuration.dylib
0x39dbc000 - 0x39dc2fff libsystem_dnssd.dylib armv7s /usr/lib/system/libsystem_dnssd.dylib
0x39dc3000 - 0x39ddbfff libsystem_info.dylib armv7s <3dc1420e94d733cabb8711b2acd45fec> /usr/lib/system/libsystem_info.dylib
0x39ddc000 - 0x39df4fff libsystem_kernel.dylib armv7s <352b213c6b3e3e4f87f40eeb524bac2a> /usr/lib/system/libsystem_kernel.dylib
0x39df5000 - 0x39e13fff libsystem_m.dylib armv7s <096ddc81fbf539429dfe0e73afbd894f> /usr/lib/system/libsystem_m.dylib
0x39e14000 - 0x39e25fff libsystem_malloc.dylib armv7s <56fc79587a40330e9bae6a276e7999fd> /usr/lib/system/libsystem_malloc.dylib
0x39e26000 - 0x39e45fff libsystem_network.dylib armv7s <18bb09e9a5243a298528743763efdea3> /usr/lib/system/libsystem_network.dylib
0x39e46000 - 0x39e4dfff libsystem_notify.dylib armv7s <1d2d6d25db4b3ce6ba2ff898554c2c6f> /usr/lib/system/libsystem_notify.dylib
0x39e4e000 - 0x39e52fff libsystem_platform.dylib armv7s <544403ae9e5834bfafdef5250aa5deeb> /usr/lib/system/libsystem_platform.dylib
0x39e53000 - 0x39e58fff libsystem_pthread.dylib armv7s <3b9209ad7912375c9ba09eaf8d98f987> /usr/lib/system/libsystem_pthread.dylib
0x39e59000 - 0x39e5afff libsystem_sandbox.dylib armv7s <94b38e062c2a3f77bf631ba6eb96af85> /usr/lib/system/libsystem_sandbox.dylib
0x39e5b000 - 0x39e5dfff libsystem_stats.dylib armv7s /usr/lib/system/libsystem_stats.dylib
0x39e5e000 - 0x39e5efff libunwind.dylib armv7s <6fdd98b80180359199c8f01ae5272f2a> /usr/lib/system/libunwind.dylib
0x39e5f000 - 0x39e79fff libxpc.dylib armv7s <8ae3aa0d5ebe3f139e7bfb4b32638d1c> /usr/lib/system/libxpc.dylib

Please give a stable solution.
Thanks

This code result in only one digit being returnem from sql server in column.value. Is there and error in my swift understanding or something with library?

override func viewDidLoad() {
            super.viewDidLoad()

            let client = SQLClient.sharedInstance()


            client?.connect(Constants.serwerAdress, username: Constants.userName, password: Constants.password, database: Constants.databaseName) {
                success in

                if success {
                    client?.execute("select A FROM B") {
                        results in

                        for table in results as AnyObject! as! NSArray {
                            for row in table as AnyObject! as! NSArray {

                                for column in row as! NSDictionary {

                                    print("\(column.key) = \(column.value)")
                                }
                            }
                        }
                        client?.disconnect()
                        DoSomethingElse()
                    }
                }
            }

        }

If it's possible, how should i insert UIImage files converted to Data type into sql table? (i mean what kind of query should be used here)

Hi Martin! I'm trying to load a variable of type varchar (max), or text, but it only brings a piece of that variable. Is there a fix for this?

Thanks

Here is my code trying to execute multiple commands at a time. i am unable get data getting bad access error.

SQLClient* client = [SQLClient sharedInstance];
client.delegate = (id)self;
[client connect:@"port" username:@"un" password:@"pwd" database:@"db" completion:^(BOOL success) {
if (success)
{
for(int i=0;i<=onholdarraycount;i++){
NSString query=[NSString stringWithFormat:@"select a.Invoice_Number,a.OnHoldID,a.Cashier_ID,a.Section_ID,a.Status,a.Occupied,b.ShapeType from Invoice_OnHold a,Table_Diagram b where a.OnHoldID=b.Table_Number and a.Section_ID='%@'",sectionaname];
[client execute:query completion:^(NSArray results) {
for (NSArray* table in results)
nslog(@“%@”,table);
}
[client disconnect];
}else{
}
}];

Thanks for help in advance.

Hi all,
Anyone else have an issue where the client won't connect and throws the error 'Adaptive Server connection failed'?

I've tried it on several devices and it all works fine except for one iPad. It just so happens that this is the most important device.

I've reset the network settings on the iPad and it still throws the error. It has a SIM card and I've tried using the 4G network, wireless network, and personal hotspot but still throws the same error.

There are no VPN's set or proxy etc...

Any other suggestions?

Thanks,
Mof.

I notice that you free the db connection at the end of execution:

- (void)executionFailure:(void (^)(NSArray* results))completion
{
    [self.callbackQueue addOperationWithBlock:^{
        if (completion)
            completion(nil);
    }];

    //Clean up
    dbfreebuf(connection);
}

//Invokes execution completion handler on callback queue with results array
- (void)executionSuccess:(void (^)(NSArray* results))completion results:(NSArray*)results
{
    [self.callbackQueue addOperationWithBlock:^{
        if (completion)
            completion(results);
    }];

    //Clean up
    dbfreebuf(connection);
}

Then should I still have to call the disconnect function in the callback closure like you did in the sample code?

Hello!

I can not connect to database using ipv6 address (which is requirement of Apple now).

How can I compile FreeTDX to support OSX?

I created issue at: #52

I still can not install SQLClient via cocoapod, could you check it again? @martinrybak

ld: '/MyProject/Pods/SQLClient/SQLClient/SQLClient/SQLClient/libsybdb.a(dblib.o)' does not contain bitcode. You must rebuild it with bitcode enabled (Xcode setting ENABLE_BITCODE), obtain an updated library from the vendor, or disable bitcode for this target. for architecture arm64
clang: error: linker command failed with exit code 1 (use -v to see invocation)

This error happens when I uncomment "use_frameworks!" in pod file to use other swift pod project, that pod and SQLCLient are important too, what should I do now?

Hi Martin,

Last time at blog you told to add nslog above line 120.

In log I am getting name of data base which I have passed at the time of connection.

Now please tell me How I fix this crashing?
You can see code file from this link....
https://gist.github.com/ramsince88/8535996
I am showing screen shot of crashing...

The latest version supported by Cocoapods seems to be a very old version.
Why did you delete the podspec?

Please see the screenshot...

Hi Martin,

I am developing a cocoa app that is connecting to SQL Server using SQLClient. I need to compare two databases at different instances (checking for updates purpose). I have found "sp_addlinkedserver" method while one using MSSQL but how we can achieve the same using SQLClient. Please suggest.

Also we are facing some issue regarding pdf and image data insertion, according to you it was fixed under 'types' branch but we are unable to find it.

Thanks

I'm attempting to pull data from a varchar(MAX) column, but it truncates to 4096 characters - any idea what's happening?
thanks

@martinrybak I need your help
[!] Unable to satisfy the following requirements:

• SQLClient (~> 1.0.0) required by Podfile

None of your spec sources contain a spec satisfying the dependency: SQLClient (~> 1.0.0).

jpegdecompresssurface : picture decode failed : e00002d1
I can get exact same data as image data from sql server.
So i try to load image from NSData, below the code,

• (void)process:(NSArray*)results
  {
  NSArray *table=[results objectAtIndex:0];
  NSDictionary *row=[table objectAtIndex:0];
  NSData *image_source=[row objectForKey:@"Company_Logo"];
  UIImage *image=[[UIImage alloc] initWithData:image_source];
  image=[UIImage imageWithData:image_source];
  [self.imageView setImage :image];
  }
  but the final step , it is showing like this, in here
  // [self.imageView setImage :image];
  jpegdecompresssurface : picture decode failed : e00002d1
  Any one can help me?
  Regards.

Hi, I've tried to use SQLClient in Swift project.
But I can not include SQLClient.h.
Please provide the way how to use this in Swift project.

Thanks

Adonis

I managed to connect to typical SQL-Server on both local and not local server. But what i want to try to do now is to connect to azure database. Every time i try to do this i get this error:

Server name not found in configuration files
Unknown host machine name 

Should i specify port differently?

If a column has null values, the client will exit code and will report an error code.

I get columns number out of range for multiple columns. I tried the following queries:

SELECT * FROM myTable; <======== Column out of range error

SELECT tableID FROM myTable <====== This worked.

SELECT tableID, name FROM myTable <======= Failed with Column out of range error (There are no Null's in any of the columns.)

Is there a way around this issue?

Thanks,
Hamid

Sorry for the next issue, but the next problem is here:

With 0.1.3 the output of SELECT * FROM dbo.V_TOUR; is:

["mze": "1", "abholung": "0", "tour": "29", "tourname": "Mo. Hopfen [1]", "tournr": "5"] ["mze": "1", "abholung": "1", "tour": "11", "tourname": "Abholer", "tournr": "2"] ["mze": "1", "abholung": "0", "tour": "31", "tourname": "Die. Oberstdorf [1]", "tournr": "6"] ["mze": "1", "abholung": "0", "tour": "105", "tourname": "Lagerumbuchung HV nach Prod.", "tournr": "7777"] ["mze": "1", "abholung": "0", "tour": "17", "tourname": "Lieferung", "tournr": "1"] ["mze": "1", "abholung": "0", "tour": "19", "tourname": "Spedition", "tournr": "3"] ["mze": "1", "abholung": "0", "tour": "107", "tourname": "Lagerumbuchung Prod nach HV", "tournr": "7778", "elb": "ELB Produktion"]

Printing at the same place with 1.0.0 gives the following output:

["tourname": "Mo. Hopfen [1]"] ["tourname": "Abholer"] ["tourname": "Die. Oberstdorf [1]"] ["tourname": "Lagerumbuchung HV nach Prod."] ["tourname": "Lieferung"] ["tourname": "Spedition"] ["tourname": "Lagerumbuchung Prod nach HV", "elb": "ELB Produktion"]

No matter which Database/View targeting... the same error. Only receiving Strings.

I've set a timeout value of 3 (this is 3 seconds, right?).

I've executed a query to select 30,000 rows from a table with several columns (in practice, I don't need a result this big, but I'm forcing the issue here). Timing the query results in a time of over 4 seconds. This doesn't count the time to display or do anything with the date. The first time is marked just before execute is called and the second time is marked as the first line in the completion block of the execute method. The query should have timed out before this.

I ran the pod install from terminal as per the instructions.
At the end of the installation i am getting this output

Setting up CocoaPods master repo
Setup completed
Analyzing dependencies
[!] The dependency SQLClient (~> 0.1.3) is not used in any concrete target.

Is this an issue? is so what to do to fix

Hi,

I am getting crash on dbloginfree(login) in connectionSuccess method of SQLClient class. Can anyone please help me

Thanks

I am having a strange error while attempting to debug a program that I wrote. I am running devices with two different iOS versions. Some are running iOS 7.1.2 and some are running 9.3.5. The devices running 7.1.2 have no issue whatsoever and function exactly as desired. The devices running 9.3.5, however, run in to the problem some others have had with the "dbloginfree" line. I've updated the SQL Client with the most recent updates using CocoaPods still with no success. The 9.3.5 devices will function as intended about 20% of the time, failing with the error below the other 80%. Any tips? Thanks in advance!

Hi Martin,

I am using the library, so far without any problems, but not sure if the library supports binary data, since when I try to do an insert (using base64encode) goes ok, but when I fetch the record, instead of bring data, it's bring char and send an error, may I be doing something wrong?

Thanks,
Marco

Please i have error in dbloginfree(login) sometimes

I am using xcode Version 8.2.1 and i am trying to write ios 10.2 app. After using cocoa method of

Open a Terminal window. Update RubyGems by entering: sudo gem update --system. Enter your password when prompted.
Install CocoaPods by entering sudo gem install cocoapods.
Create a file at the root of your Xcode project folder called Podfile.
Enter the following text: pod 'SQLClient', '~> 0.1.3'
In Terminal navigate to this folder and enter pod install.
You will see a new SQLClient.xcworkspace file. Open this file in Xcode to work with this project from now on.

adding sql to my project i can see this error :

ld: '.../Pods/SQLClient/SQLClient/SQLClient/SQLClient/libfreetds.a(dblib.o)' does not contain bitcode. You must rebuild it with bitcode enabled (Xcode setting ENABLE_BITCODE), obtain an updated library from the vendor, or disable bitcode for this target. for architecture arm64

But changing Enable_bitcode to NO on both projects is not working.

i also tried: Build Settings > Architectures > "Build Active Architecture Only" to No?
same result.

if (pcol->type != SYBCHAR && pcol->type != SYBTEXT && pcol->type != SYBIMAGE)
                pcol->size = dbwillconvert(pcol->type, SYBCHAR);

            //Allocate memory in the current pcol struct for a buffer
            if ((pcol->buffer = calloc(1, pcol->size + 1)) == NULL)
                return [self executionFailure:completion];

            //Bind column name
            erc = dbbind(connection, c, NTBSTRINGBIND, pcol->size + 1, (BYTE*)pcol->buffer);
            if (erc == FAIL)
                return [self executionFailure:completion];

            //Bind column status
            erc = dbnullbind(connection, c, &pcol->status);
            if (erc == FAIL)
                return [self executionFailure:completion];

I think SYBTEXT's size convert to SYBCHAR's size...

Any time a column would return a text or varchar datatype that is over 256 characters, it instead just returns the first 256 and fires the error:code:severity: method with code 20049, "Data-conversion resulted in overflow."

jpegdecompresssurface : picture decode failed : e00002d1
I can get exact same data as image data from sql server.
So i try to load image from NSData, below the code,

• (void)process:(NSArray*)results
  {
  NSArray *table=[results objectAtIndex:0];
  NSDictionary *row=[table objectAtIndex:0];
  NSData *image_source=[row objectForKey:@"Company_Logo"];
  UIImage *image=[[UIImage alloc] initWithData:image_source];
  image=[UIImage imageWithData:image_source];
  [self.imageView setImage :image];
  }
  but the final step , it is showing like this, in here
  // [self.imageView setImage :image];
  jpegdecompresssurface : picture decode failed : e00002d1
  How can i solve this?
  Regards.

I am getting a SQLClient[29151:3076997] Error #20017: Unexpected EOF from the server . Looking into FreeTDS this appears to be due to the TDS version. Has anyone else experienced this, and is there a way to set the version.

Hello,

      On ipv4 network my application working good, But on ipv6 fetching the error **Adaptive Server is unavailable or does not exist” error connecting to SQL Server**.

for ipv6 network is there any changes, please let me know if i missing something.

Hello,

I'm trying to connect to a server and get some info from a table, where one of the columns is a GUID. When I look at the values in the dictionary, the GUID is not matching with what is in the table when I look at it from running a SQL query in Visual Studio Code. The last 2 portions are correct, but the first 3 portions have the correct values, but are not in the correct order. Any idea what is going on there? This is running on macOS 10.13.4 on a MacBook Pro.

Thanks

Hello Martin,
your project is really cool.
I am using it in my project with swift.
It works fine with one execution but I need a few executions parallel.
But it doesn't work. The app crashes. I need multiple instances of SQLClient
and I am instantiating a few SQLClient's and I do not use the sharedInstance.

The connection establishes and in the callback I am executing the sql statement with the
execute-method, and then it crashes.

libc++abi.dylib: terminating with uncaught exception of type NSException

With the sharedInstance it works.

Hope you can help.
Regards
Ronny