3
votes
1answer
37 views

Excel ODBC - General 'How does it work?'

Thinking of moving a couple of linked spreadsheets into a database model instead. However, I have a lot of non-technical uses who can just barely use Excel but having them use something like MS Access ...
0
votes
0answers
145 views

How to fix Microsoft ODBC for Oracle on a Windows Server 2008 R2 RDP

I share a Windows Server 2008 R2 RDP with several colleagues and we all make heavy use of Microsoft ODBC to do our jobs. One of the important databases we have to connect to is an Oracle database ...
0
votes
1answer
740 views

Writing typical MySQL query in excel

I'm trying to run a MySQL query in excel. I've set up ODBC in excel and the connection to database is solid. Is there a way to input my usual query (e.g. select * from table where date= 20131212) to ...
0
votes
0answers
20 views

Unable to view the ouptut in netbeans IDE 7.1 when I use fullscreen

Hi Everyone I am doing a new project on web services, actually I should get output from database and display it in the front end. I have used NETBEANS IDE as the front-end and then I have completed ...
0
votes
1answer
303 views

Can LibreOffice Base directly use MySQL syntax?

From what I can see, LibreOffice Base comes with an HSQLDB implementation by default. I understand that ODBC allows users to connect to different data sources, including databases that use different ...
1
vote
0answers
350 views

What's the best way to get a MySQL database into SQL Server 2012 Reporting Services?

I'm trying to get a MySQL database into SQL Server 2012 reporting services as a shared data source, and getting absolutely nowhere after a day. I've tried a couple of options. First, my specs: ...
0
votes
2answers
1k views

MySQL ODBC driver 5.1 and Windows 7

I successfully installed the MySQL ODBC 5.1 driver for Windows: But unfortunaly it doesn't appear in the ODBC Data Source Administrator of Windows (yes, I even did a log off + log on): Why?
1
vote
0answers
114 views

MS Access ignores confirmation dialog when updating linked MySQL table

I have a MySQL database (Version 5.1.63) which is connected to MS Access (2002) via ODBC (MySQL ODBC 5.1 Driver). In MySQL I created a simple table like this: CREATE TABLE IF NOT EXISTS `test` ( ...
0
votes
0answers
147 views

How to ssl-secure mysql connection on Windows XP?

I use MS Access to connect my remote MySQL database, and use MySQL ODBC connector for that. I would like to secure the connection with SSL. ODBC connector offers some SSL setup, but I don't have idea ...
0
votes
1answer
541 views

MySQL ODBC Debugging to myodbc.sql overwrites file instead of appending new queries

I am using the MySQL ODBC driver on a Windows Server 2008 R2 64-bit box. I enabled the debug feature on the odbc driver using the ODBC administrator at %windir%\SysWOW64\odbcad32.exe It does write ...
1
vote
2answers
608 views

How to have a whole, refreshable MySQL database inside Excel

I have a MySQL database and have a lot of users that want to use Excel to process this data. I know how to do two things that I don't want: I know how to import a MySQL database into Excel. I know ...
5
votes
1answer
6k views

Anyway to use SSMS to connect to MySql?

I've grown to love SQL server management studio (ssms), I realise that it is not naturually compatible, however is there a way of connecting to MySQL? Perhaps using an ODBC connection? I realise ...