BOXI via PHP

pete101

Hi guys,

I use LiveOffice to import BOXI (Business Objects XI) data into an Excel spreadsheet.

However, I would like to also access the data via PHP, but I can't get the right syntax to connect to the database.

The info I have is:

Username/Password = Both Valid
Web Services URL = http://myserver/pathname/directory
System = SysId
Authentication = Enterprise
SQL Database = MyDatabase
SQL Table = Mytable

No matter what "string" combination I use to try and connect it just doesn't work.

Does anyone have the correct format I need to use?

Many thanks,

Pete

dalecosp

Hello, and welcome to PHPBuilder. 🙂

Any chance we could see the relevant excerpt from your PHP code?

Please wrap it in [php] [/php] tags for readability and syntax formatting. 😉

pete101

Hi dalecosp,

Many thanks for your quick response.

Basically I used the standard connection code
i.e. mysql_connect(servername,username,password);

However, I also added the extra fields i.e. system, authentication, etc, but it didn't seem to work.

I'm pretty sure that there is a way, but I just haven't found the correct syntax.

Any ideas?

Cheers,

Pete

Ashley_Sheridan

It would still really help to see your actual code (with DB credentials hidden) that you're using. Posting back mentioning one function you're using to connect is of no help at all really.

dalecosp

No kidding, Ash. Not to mention, the errors received upon execution, or the output my [man]mysql_error/man ... snippets from the server error log, &c, &c....