CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • General Discussion (please no support requests here!) (Moderator: Michał Mach) »
  • CiviCRM access through MSQuery
Pages: [1]

Author Topic: CiviCRM access through MSQuery  (Read 4221 times)

Sarah

  • I post occasionally
  • **
  • Posts: 72
  • Karma: 3
    • American Friends Service Committee - Southeastern New England
CiviCRM access through MSQuery
March 28, 2008, 01:44:59 pm
Can anyone tell me if it is possible, or if they have accessed CiviCRM through MSQuery? If so can you describe what's involved in setting up such a connection?

lcdweb

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1620
  • Karma: 116
    • www.lcdservices.biz
  • CiviCRM version: many versions...
  • CMS version: Joomla/Drupal
  • MySQL version: 5.1+
  • PHP version: 5.2+
Re: CiviCRM access through MSQuery
March 28, 2008, 01:56:50 pm
I haven't used MSQuery much. But as I understand it, you need to connect to a data source via ODBC. So in order to do that, you'd need to install the MySQL ODBC driver (http://dev.mysql.com/downloads/connector/odbc/3.51.html), setup the connection in the ODBC connection manager, and then use MSQuery to access the tables.

Doesn't really have anything to do with the CiviCRM app -- it's just a matter of connecting to the MySQL database. I've found the MySQL ODBC connector to be somewhat unreliable. The connection seems to crash pretty easily. But it does work. If you're using shared hosting, you might need to register your IP address through the control panel to permit remote access to the MySQL dbs.

-Brian
support CiviCRM through 'make it happen' initiatives!
http://civicrm.org/mih

Sarah

  • I post occasionally
  • **
  • Posts: 72
  • Karma: 3
    • American Friends Service Committee - Southeastern New England
Re: CiviCRM access through MSQuery
March 28, 2008, 02:07:01 pm
thanks very much.  ;D

speleo

  • Ask me questions
  • ****
  • Posts: 396
  • Karma: 28
  • CiviCRM version: 4.3.1
  • CMS version: J! 2.5,9
  • MySQL version: 5.1
  • PHP version: 5.3.24
Re: CiviCRM access through MSQuery
March 31, 2008, 01:01:17 am
This might help you too http://wiki.civicrm.org/confluence/display/CRMDOC/Remote+Access+to+your+DB
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • General Discussion (please no support requests here!) (Moderator: Michał Mach) »
  • CiviCRM access through MSQuery

This forum was archived on 2017-11-26.