[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

This was driving me nuts today -- trying to get Oracle SQL Developer 4 and/or a simple java code (in the style of http://stackoverflow.com/a/16626825/524504 ) to "connect" to a local Microsoft Access Database .mdb file. But I kept getting the not-very-helpful message

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

luckily, I have been able to sort out this problem with the help of

http://www.selikoff.net/2011/07/26/connecting-to-ms-access-file-via-jdbc-in-64-bit-java/

http://www.microsoft.com/en-us/download/details.aspx?id=13255

and

http://stackoverflow.com/questions/7116019/hand-install-of-64-bit-ms-access-odbc-drivers-when-32-bit-office-is-present

I have 32 bit office installed, so I didn't have the 64 bit Access Database odbc driver.
I love it when the biggest troubles in programming something are things like that.

I will change this.

Comments

Post a Comment

Popular posts from this blog

How to monitor a directory for changes with ReadDirectoryChangesW

Here's how to use  ReadDirectoryChangesW  without knowing all of this and without using this overkill C++ class library (remove the &o parameter in the call to make it blocking instead of async. Note: This only returns one change, you have to step trough a buffer of FILE_NOTIFY_INFORMATIONs if you need to get more): HANDLE hDirectory ; OVERLAPPED o = { 0 }; union { FILE_NOTIFY_INFORMATION i ; char d [ sizeof ( FILE_NOTIFY_INFORMATION )+ MAX_PATH ]; } fni ; int checkAutoCompile () { DWORD b ; if (! hDirectory ) { hDirectory = CreateFile ( "." , FILE_LIST_DIRECTORY | GENERIC_READ , FILE_SHARE_READ | FILE_SHARE_WRITE , 0 , OPEN_EXISTING , FILE_FLAG_BACKUP_SEMANTICS | FILE_FLAG_OVERLAPPED , 0 ); o . hEvent = CreateEvent ( 0 , 0 , 0 , 0 ); } ReadDirectoryChangesW ( hDirectory , & fni , sizeof ( fni ), TR
Read more

Coins - Pay to Win

Image
Coins, the purest Pay to Win game. Buy coins to rank highest. To win in this game, you need to buy more coins than anyone else! Can you afford it? https://coinspaytowin-50d3a.firebaseapp.com/ https://play.google.com/store/apps/details?id=com.paulfrischknecht.coinspaytowin (Microsoft Store Link Pending)
Read more

Fastest way to zero out memory - stream past cache with movntdq/_mm_stream_si128

As a rule of thumb, this technique is only beneficial if the buffer is larger than half the largest level cache. #include <time.h> #include <stdio.h> #include <stdlib.h> #include <stdlib.h> #include <emmintrin.h> #include <intrin.h> typedef unsigned long long ull ; ull tsc ; int clk ; // Stream 64 Bytes to DRAM, bypass caches. _p must be 16-byte aligned. template < typename T > inline void memstream ( T * _p , const __m128i & i ) { char * p = ( char *) _p ; _mm_stream_si128 (( __m128i *)& p [ 0 ], i ); _mm_stream_si128 (( __m128i *)& p [ 16 ], i ); _mm_stream_si128 (( __m128i *)& p [ 32 ], i ); _mm_stream_si128 (( __m128i *)& p [ 48 ], i ); } inline void serialize () { int a [ 4 ]; __cpuid ( a , 0 );} inline void starttimer () { clk = clock (); serialize (); tsc = __rdtsc ();} inline void stoptimer ( char * n ) { serialize (); ull tsc2 = __rdtsc
Read more