plainblack.com
Username Password
search
Community Support
WebGUI User Guides
Wiki
Forums
Report A Bug
Request Features
WebGUI 8
WebGUI TV
Add-ons and Plug-ins
Service Providers
webGUI in the news
Karma
API Docs
the people behind wg
webgui worldwide
Mascot
wallpapers
powered by icons
Sightings
Bookmark and Share

    

mssql sqlform
User metropolice
Date 3/29/2008 3:03 am
Views 1163
Rating 9    Rate [
|
]
Previous · Next
User Message
metropolice
Date: 3/29/2008 3:03 am   ·   Subject: mssql sqlform  ·   Rating: 9

Existe alguna forma de utilizar el sqlform con mssql como con el sqledit? Gracias. Is there any way to use the mssql sqlform with. Thanks.

--- (Edited on 3/29/2008 3:03 am [GMT-0500] by metropolice) ---



Back to Top
Rate [
|
]
 
 
bartjol
Date: 3/29/2008 7:01 am   ·   Subject: Re: mssql sqlform  ·   Rating: 7

Off course there is, you can extract data from the WebGUI database or another one if you defined one with a database link.
The only thing you should know are the tables and field in the database to define what you want to extract.
And the data is templatable in a SQL report template

--- (Edited on 3/29/2008 1:01 pm [GMT+0100] by bartjol) ---



Back to Top
Rate [
|
]
 
 
koen
Date: 3/31/2008 3:48 pm   ·   Subject: Re: mssql sqlform  ·   Rating: 0

This is a double post, and the other one is being used to answer the question. 

Koen de Jonge - ProcoliX
http://www.procolix.com
Hosting - WebGUI - Virtualization

--- (Edited on 31-March-2008 22:48 [GMT+0200] by koen) ---



Back to Top
Rate [
|
]
 
 
metropolice
Date: 4/1/2008 11:01 am   ·   Subject: Re: mssql sqlform  ·   Rating: 0

[Translate Google]
    
Thank you for your reply.

With a SqlReport does this datalink
______________________________________________
Database Link ID    4UogaoM1hlB-zfQSIVoEiw
Title            Mienlace
DSN            dbi:ADO:Provider=sqloledb;Data Source=10.95.0.222;Initial Catalog=SD
Database User        sa
Database Password    ******
Allowed keywords    select
            describe
            show
Allow access macros     yes
Additional db parameter    
______________________________________________

    
If I make a DataForm with the same databaselink I jump page error, and the log I get webgui:

______________________________________________
2008/04/01 17:42:49 - FATAL - pda.net.conf - main::[[undef]] - Couldn't execute prepared statement: show grants for current_user : With place holders: .  Root cause: Can't Execute Command 'show grants for current_user'

  Package    : DBD::ADO::st
  Filename   : C:/data/wre/prereqs/site/lib/DBD/ADO.pm
  Line       : 1142
  Last error : -2147217900

OLE exception from "Microsoft OLE DB Provider for SQL Server":

Syntax incorrect near the keyword 'for'.

Win32::OLE(0.1707) error 0x80040e14
    in METHOD/PROPERTYGET "Execute"

        Description : Syntax incorrect near the keyword 'for'.
        HelpContext :
           HelpFile :
        NativeError : 156
             Number : -2147217900
             Source : Microsoft OLE DB Provider for SQL Server
           SQLState : 42000
    

        Description : Unable to prepare instruction or instructions.
        HelpContext :
           HelpFile :
        NativeError : 8180
             Number : -2147217900
             Source : Microsoft OLE DB Provider for SQL Server
           SQLState : 42000
______________________________________________

I you can help, please, thanks.

--- (Edited on 4/1/2008 11:01 am [GMT-0500] by metropolice) ---



Back to Top
Rate [
|
]
 
 
    



© 2012 Plain Black Corporation | All Rights Reserved