AspWebSolution Forums » Products » ASP Report Wizard v2 » Not displaying tables

index | search | no replies | posting guidelines | help

login | register

» »

:: Not displaying tables :: (25)

Post a New Message | Post a Reply

Aug 30 2004, 10:21 PM

Not displaying tables

mahoy

from: Melb,Aust Hi there,

I have an issue, I have just installed ASP Report Wizard Version V2. I have successfully been able to connenct to the MYSQL server, as I do not get an error message. I have just used the connection string example from the online manual. However, it does not show any of the tables, that are in the database.

I want to get it working first before, I buy a License for the product.

Anyone's help would really be great.

Aug 31 2004, 5:32 AM

Re: Not displaying tables

ghost

from: Washington, DC Can I you send us your source code!
Also, what version of MySQL are you using?

-------------------------
Ghost

Aug 31 2004, 3:52 PM

Re: Not displaying tables

mahoy

from: Melb,Aust <%

Dim objWiz
Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2")

objWiz.Init("DRIVER={MySQL ODBC 3.51 Driver};DESC=;" & _
"DATABASE=extranet;SERVER=localhost;" & _
"UID=root;PASSWORD=test;" & _
"PORT=;OPTION=0;STMT=;" )

objWiz.DisplayReports

Set objWiz = Nothing

%>

I am using MYSQL version 5.0

Aug 31 2004, 6:36 PM

Re: Not displaying tables

mahoy

from: Melb,Aust I am also running Windows 2000 Server with IIS 5.0

Aug 31 2004, 7:13 PM

Re: Not displaying tables

whichman

from: Laurel, MD This version of the wizard was tested on version 4+.
I will check the latest version of MySQL and let you know if any changes have been made by the next release

-------------------------
Master of the Game

Aug 31 2004, 7:18 PM

Re: Not displaying tables

mahoy

from: Melb,Aust So, if I install version 4 that should work, or will a new release be out soon?

Sep 1 2004, 5:31 AM

Re: Not displaying tables

ghost

from: Washington, DC For now it will be better to use MySQL 4.0 because MySQL 5.0 is still just an alpha release. We will however provide full support for it when it is pre- released.

-------------------------
Ghost

Sep 1 2004, 6:32 PM

Re: Not displaying tables

mahoy

from: Melb,Aust I have installed MySql Version 4 and still getting the same.

I have about 8 tables are none are showing.

Please, please help.

Sep 2 2004, 3:14 AM

Re: Not displaying tables

jonny

from: Ireland I am also trying to use the Report wizard with MySQL.
I usually connect using a DSN and I tried the DSN with the Report wizard but I also get no tables showing up. I am using MySQL v 4.0.18nt
Another question - will the report wizard work with SQL Server/MSDE ?

Sep 2 2004, 5:39 AM

Re: Not displaying tables

whichman

from: Laurel, MD Execute the following code (SHOW TABLES) under MySQL Control Center
against your database and let me know what happens

-------------------------
Master of the Game

Sep 2 2004, 6:38 AM

Re: Not displaying tables

jonny

from: Ireland I don't use Control Centre much - I use one called MySQLFront but they're much the same (in that they send the same command line stuff)
I sent SHOW TABLES; and received a list of my database tables.

Sep 2 2004, 12:41 PM

Re: Not displaying tables

whichman

from: Laurel, MD I can't seem to understand why this is happening because SHOW TABLES is the command the wizard uses to get all the legal tables from the database.
Make sure the userid you are using in your connection string has the rights to execute this command against your database.
Also, try to use the UseTables property and let me know if anything works

objWiz.UseTables = "Table1,Budget,Table5"

thanx!

-------------------------
Master of the Game

Sep 2 2004, 4:50 PM

Re: Not displaying tables

mahoy

from: Melb,Aust Still, not working.

Here is the code I am using.

Please, help!

<%

Dim objWiz
Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2")

'Make sure you initialize before adding any HTML text
'TODO: Change this to your actual connection tring
objWiz.Init("DRIVER={MySQL ODBC 3.51 Driver};DESC=MySQL ODBC 3.51 Driver DSN;" & _
"DATABASE=extranet;SERVER=localhost;" & _
"UID=root;PASSWORD=test;" & _
"PORT=3306;OPTION=0;STMT=;")

'put this where you want your reports
objWiz.DisplayReports

objWiz.UseTables = "13weekrev,finalsubmit,movieinfo,ordering,orderupdates,savedata,test,testorder,userid"

Set objWiz = Nothing

%>

Sep 2 2004, 7:53 PM

Re: Not displaying tables

whichman

Send this author a private message

Visit author's homepage

from: Laurel, MD

Please set ALL Properties before you initialize your connection string.

objWiz.UseTables = "Table1, Table2, TableX"
objWiz.Init(Your Connection String)
'...start your HTML code
objWiz.DisplayReports()
Set objWiz = Nothing

-------------------------
Master of the Game

Sep 2 2004, 8:06 PM

Re: Not displaying tables

mahoy

from: Melb,Aust OK, now the tables show up. But click a checkbox next to a table and then click build report it opens a select teh fields you want to display box, but there are no fields to select although in my databases teher are many fileds in each table.

Also, when i just click on the table hyperlink I get this error message

[MySQL][ODBC 3.51 Driver][mysqld-4.0.20a-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '[userid]' at line 1

Please, help!

Sep 3 2004, 6:22 AM

Re: Not displaying tables

whichman

from: Laurel, MD It seems your connection string is invalid for your MySQL build.
This is my connection string and it works well

strConn = "DRIVER={MySQL ODBC 3.51 Driver};DESC=;DATABASE=NorthWind;SERVER=THETMAN;UID=sa;PASSWORD=sa;PORT=;OPTION=0;STMT=;"

-------------------------
Master of the Game

Oct 5 2004, 4:31 AM

Re: Not displaying tables

jonny

from: Ireland I have tried to follow the advice in this thread to get reports from a MySQL database (both on my developer machine & on the production machine) with no luck, and my trial period has run out. Any advice? Can I re-new the trial? Has anyone got this working with MySQL?
I apologise for the despondent questions.

Oct 5 2004, 6:17 AM

Re: Not displaying tables

ghost

from: Washington, DC The trial period never expires. Only the minor version expires

Just download the latest release - version 2.4.62 and you will be good to go

P/S: Minor versions (unlicensed only) have a life span of 3-4 months. This is to insure that our users have the latest bug-free, uptimized version of the Report Wizard

-------------------------
Ghost

Oct 5 2004, 7:39 AM

Re: Not displaying tables

jonny

from: Ireland Thanks I am up and running again and everything works fine when I use an Access database, but my problem is that I use MySQL mostly and I still get errors when using MySQL connection strings. I have tried the Connection Strings you recommended and I even used a DSN but I still get the following error, which is why I think there is a problem elsewhere outside of the connection string. For example, is there a semi-colon missing in the SQL string or an invalid SQL command? - just ideas.
Error is:
[MySQL][ODBC 3.51 Driver][mysqld-4.0.20a-debug]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '[tblcourse]' at line 1

Oct 5 2004, 12:05 PM

Re: Not displaying tables

ghost

from: Washington, DC try this:

add this line before you initialize your connection string
objWiz.DatabaseType = "MySQL"

Note: Saved reports are based on the databases from which they were created

Let me know if this helps

-------------------------
Ghost

Pages: (2) [1] … Last »