1
all41
XOOPS and ODBC
  • 2003/6/5 8:10

  • all41

  • Just popping in

  • Posts: 2

  • Since: 2003/6/5 7


Hi! I have finally made something for Open Source community.
This file is ODBC layer for XOOPS - PHP Content Management System.
Installing it You can Use XOOPS with almost any database (supporting ODBC).
There are still some problems especially when CREATING TABLES but this layer will
let you connect to a "existing" database via ODBC.

Soon You will be able to download it from www.xoops.org.(I hope)

Please test it and tell me if it can be used.
----------------------
All41
roznicki@o2.pl

2
onokazu
Re: XOOPS and ODBC
  • 2003/6/5 9:30

  • onokazu

  • XOOPS Founder

  • Posts: 617

  • Since: 2001/12/13


Sounds very interesting..it's now available for download on this site here.

3
frank_lin
Re: XOOPS and ODBC
  • 2003/7/24 12:29

  • frank_lin

  • Just popping in

  • Posts: 2

  • Since: 2002/10/18


hi,
(1)installed odbc layer, modified mainfile.php
(2)export MySQL tables into Microsoft Access 2000( xoops.mdb)
(3)created data source name xoops_access
(4)http://XXXX/xoops, i got a lot of error messages..

any body can help me!
Thanks
best regards
frank

Notice: Undefined offset: 0 in C:\Inetpub\wwwroot\twxoops203_20030626\html\kernel\session.php on line 102

Notice: Undefined variable: rs_assoc in C:\Inetpub\wwwroot\twxoops203_20030626\html\class\database\odbc\db.php on line 127

Warning: SQL error: [Microsoft][ODBC Microsoft Access driver ] query expression 'b.bid=m.block_id LEFT JOIN xoops_group_permission l ON l.gperm_itemid=b.bid' systax error (no operand)。, SQL state 37000 in SQLExecDirect in C:\Inetpub\wwwroot\twxoops203_20030626\html\class\database\odbc\db.php on line 232

Warning: odbc_fetch_into(): supplied argument is not a valid ODBC result resource in C:\Inetpub\wwwroot\twxoops203_20030626\html\class\database\odbc\db.php on line 121

Warning: Invalid argument supplied for foreach() in C:\Inetpub\wwwroot\twxoops203_20030626\html\class\database\odbc\db.php on line 123

Notice: Undefined variable: rs_assoc in C:\Inetpub\wwwroot\twxoops203_20030626\html\class\database\odbc\db.php on line 127

4
_masi
Re: XOOPS and ODBC
  • 2003/7/24 12:42

  • _masi

  • Just popping in

  • Posts: 19

  • Since: 2003/3/28


Try to make brackets around the ON-part of the FROM-clause in the lines 297 and 415 of class/xoopsblocks.php:

$sql .= "FROM ".$db->prefix("newblocks")." b LEFT JOIN ".$db->prefix("group_permission")." l ON (l.gperm_itemid=b.bid) WHERE gperm_name = 'block_read' AND gperm_modid = 1";


$sql 'SELECT b.* FROM '.$db->prefix('block_module_link').' m LEFT JOIN '.$db->prefix('newblocks').' b ON (b.bid=m.block_id) LEFT JOIN '.$db->prefix('group_permission')." l ON (l.gperm_itemid=b.bid) WHERE l.gperm_name = 'block_read' AND gperm_modid = 1";


5
stac
Re: XOOPS and ODBC
  • 2004/6/8 14:16

  • stac

  • Just popping in

  • Posts: 13

  • Since: 2002/1/30


I have install odbc for xoops. all does well but I am not able to identify me. Could you help me?

6
stac
Re: XOOPS and ODBC
  • 2004/6/8 17:33

  • stac

  • Just popping in

  • Posts: 13

  • Since: 2002/1/30


Can you help me please ?

7
stac
Re: XOOPS and ODBC
  • 2004/6/10 15:09

  • stac

  • Just popping in

  • Posts: 13

  • Since: 2002/1/30


Any help.

8
stac
Re: XOOPS and ODBC
  • 2004/6/10 15:10

  • stac

  • Just popping in

  • Posts: 13

  • Since: 2002/1/30


Any help.

9
stac
Re: XOOPS and ODBC
  • 2004/6/10 15:11

  • stac

  • Just popping in

  • Posts: 13

  • Since: 2002/1/30


Any help.

10
limecity
Re: XOOPS and ODBC
  • 2004/6/10 16:02

  • limecity

  • Friend of XOOPS

  • Posts: 1602

  • Since: 2003/7/6 0


don't flood dude..
u will get worse response.. if u do that.
probably your post will be ignored.

Login

Who's Online

233 user(s) are online (153 user(s) are browsing Support Forums)


Members: 0


Guests: 233


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits