Home > Software engineering >  Vba did not find the data source name and did not specify a default driver
Vba did not find the data source name and did not specify a default driver

Time:09-19






Excel03 version is why will appear this kind of error code is not compatible or what reason?

CodePudding user response:

Upupup their top

CodePudding user response:

In a 64 - bit Windows:
64 exe and DLL in the directory c: \ Windows \ sys tem32 directory.
32 bit exe and DLL in the directory c: \ Windows \ sys wow64 directory.
So pay attention to:
In win64 system registered under 32-bit ocx DLL to 32 ocx or copy the DLL to the c: \ Windows \ syswow64 \ directory,
And registered to c: \ Windows \ syswow64 \ regsvr32 XXXXXXX ocx or DLL
Under win64 a system set up 32-bit programs use a database alias to c: \ Windows \ \ syswow64 \ cliconfg exe
Under win64 a system set up a 32-bit application system DSN to c: \ Windows \ \ syswow64 \ odbcad32 exe
A 64 - bit Windows platform attention point of the file system redirection http://www.cnblogs.com/jiake/p/4981555.html
64 - bit Windows platforms attention point of the registry to redirect http://www.cnblogs.com/jiake/p/4956218.html

CodePudding user response:

It does not support MySQL driver?

I remember the time of installation VB6 enterprise edition of "database component" option, there seems to be no such thing as a "MySQL",
VBA used in the database environment, should with VB6 is the same,

You try, the connection string, only the "Microsoft ODBC connection format to write,

CodePudding user response:

http://bbs.csdn.net/topics/392143402
  • Related