A few questions about connecting to data (error 1090)

[dallin]

Hi, I'm trying to connect to data with the PHP Report Generator and I've been running into a lot of problems. I'm using SQL Server for my database. Could some one help me with any of these questions:

1. I tried to connect to a localhost server and was unable to do it. I was successful in connecting to a remote server. Perhaps I'm formatting the connection string wrong? I did something like this: Server=localhost;Database=MYDATABASE;User Id=MYUSERNAME;Password=MYPASSWORD;

2. After getting a successful connection to my remote database (the Test button said it was successful), I created a new DataSource, typed in some simple SQL, and clicked 'Retrieve Columns'. It came back with "Error #1090" and did not get the columns. Is this a Stimulsoft error? Where do I find Error codes for Report Generator? What does this error code mean and how can I fix it?

3. I tried to connect to my remote database using the AIR client .exe file rather than in the web and when I tested the connection or tried to retrieve the columns I would get this message: "This feature is not supported in AIR report Designer". How do I connect to data with the AIR executable?

Thanks so much for anyone that can help!

[Vladimir]

Hello,

Regarding questions 1. and 2.
Please say, for the connection are you using the AIR designer or Web based designer? If you are using the Web based designer, please check whether notices and warnings are disabled in the file php.ini - option error_reporting = E_ALL & ~ E_NOTICE
Also, we recommend you use the latest prerelease build that is available on our website http://www.stimulsoft.com/en/downloads/reports-fx-php because there have been many changes since the official release.

3. The AIR designer supports only these data sources because Flash does not have other built-in adapters (such as Oracle, MSSQL, and others).

Thank you.