Re^4: Using DBD::ODBC and cygwin to connect to MS SQL?

Hi! You can easily use an existing ODBC connection on windows by just installing DBD::ODBC.

https://gist.github.com/genio/7c7fc52fcb8be5d486aa#file-03_example_perl-pl shows the DSNs for both linux/unix and Windows.

Once you have an ODBC connection setup in Windows (pay attention to 32 vs 64-bit), you can use that connection easily with the DSN string on that gist.

Comment on Re^4: Using DBD::ODBC and cygwin to connect to MS SQL?

Replies are listed 'Best First'.
Re^5: Using DBD::ODBC and cygwin to connect to MS SQL? by soonix (Chancellor) on Jul 14, 2016 at 10:22 UTC
Hi! You can easily use an existing ODBC connection on windows by just installing DBD::ODBC. From the OP I can't see whether he has an existing, functioning ODBC connection or not. To rule that out, I'd try to connect to the database from a "standard" tool (first via "native" Driver, then via ODBC). BTW in your gist, this should go into the missing `01_setup_Windows.md` :-) Your cue about 32- vs. 64- bit is very important. From my last adventure in this area ISTR that Google (or even perlmonk's Super Search) had all necessary info about this point, but of course I didn't write it down :-/	[reply] [d/l]

Replies are listed 'Best First'.

Re^5: Using DBD::ODBC and cygwin to connect to MS SQL?
by soonix (Chancellor) on Jul 14, 2016 at 10:22 UTC

Hi! You can easily use an existing ODBC connection on windows by just installing DBD::ODBC.

existing

BTW in your gist, this should go into the missing 01_setup_Windows.md :-)

[reply]
[d/l]