Hi Ryan, thanks so much for your suggestions. Here is the output from running your program with my original connection string, which works in python using pyodbc:
Allocating env handle... done: 0 0 Setting ODBC version... done: 0 0 Allocating db handle... done: 0 0 Connecting... done: -1 This is where it hangs. Based on your suggestions about trying different drivers, I tried switching drivers from the "ODBC Driver 17 for SQL Server” that I had been using to the FreeTDS driver the example in your program uses. I was able to successfully connect using the FreeTDS driver in python using pyodbc. Using the same connection string, I ran your program again. This time, running your program didn't hang, but the output was not promising either: Allocating env handle... done: 0 0 Setting ODBC version... done: 0 0 Allocating db handle... done: 0 0 Connecting... done: -1 odbc-driver-connect: SQLSTATE: context...: .../generic/interfaces.rkt:170:0: raise-sql-error .../odbc/connection.rkt:781:0: handle-status* call-with-values call-in-empty-metacontinuation-frame body of "/Users/jinho/git/eoddata/test-odbc.rkt" temp35_0 run-module-instance! perform-require! namespace-require+ proc call-in-empty-metacontinuation-frame thunk_10 call-in-empty-metacontinuation-frame call-with-empty-metacontinuation-frame-for-swap I also confirmed using odbc-driver-connect directly that no connection is actually made. Do you have any other suggestions? Thanks again! -- "Ad astra per alia porci" > On Sep 19, 2020, at 8:12 AM, Ryan Culpepper <rmculpepp...@gmail.com> wrote: > > The last time I tested connecting to MS SQL Server on Windows (several years > ago), I think I was able to connect using some drivers but not others. I was > simultaneously trying to figure out authentication and the connection string > format, so once I got a working configuration I stopped investigating. Lately > I've been testing using the Docker image on Linux. > > I've attached a program you can run to find out where the connection process > hangs. If you can report the results of running the program that should help > narrow down the problem. > > Ryan > > > On Sat, Sep 19, 2020 at 12:25 AM Jin-Ho King <jinho.k...@gmail.com > <mailto:jinho.k...@gmail.com>> wrote: > Does anyone have experience using Racket to query a MS SQL Server? I'm > attempting to use the db-lib package (https://docs.racket-lang.org/db/ > <https://docs.racket-lang.org/db/>) and odbc-driver-connect, but running the > method just hangs, with no feedback. By contrast, using the same connection > string, I can successfully connect using python and pyodbc. > > Any suggestions or tips would be appreciated! > > -- > You received this message because you are subscribed to the Google Groups > "Racket Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to racket-users+unsubscr...@googlegroups.com > <mailto:racket-users+unsubscr...@googlegroups.com>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/racket-users/58e03456-b76e-4212-a170-82e1fc4fb178n%40googlegroups.com > > <https://groups.google.com/d/msgid/racket-users/58e03456-b76e-4212-a170-82e1fc4fb178n%40googlegroups.com?utm_medium=email&utm_source=footer>. > <test-odbc.rkt> -- You received this message because you are subscribed to the Google Groups "Racket Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to racket-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/racket-users/17E4ACF8-8920-4FD2-A10E-09DF8EEB2624%40gmail.com.
