odbc – IT Nursery

what is the difference between OLE DB and ODBC data sources?

June 3, 2022 by IT Nursery

I was reading a MS Excel help article about pivotcache and wonder what they mean by OLE DB and ODBC sources …You should use the CommandText property instead of the SQL property, which now exists primarily for compatibility with earlier versions of Microsoft Excel. If you use both properties, the CommandText property’s value takes precedence. … Read more

java.sql.SQLException: No database selected – why?

April 5, 2022 by IT Nursery

Firstly, I am considering my answer to show you another better way for connection with MySQL Database, it’s much easier and less nu-expected Exception(s).You need to do some steps: Download Connector/J and add it to your class path(if you are using an IDE there is add the .jar to the library, or there is many … Read more