|
|
Discuss
>
Etcetera
|
|
|
User
|
metropolice
|
|
Date
|
3/29/2008 3:03 am
|
|
Views
|
891
|
|
Rating
|
-1
Rate [ | ]
|
|
|
Previous
·
Next
|
metropolice
|
Date: 3/29/2008 3:03 am · Subject: mssql sqlform · Rating: -1
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 [ | ]
|
| |
|
|
Recent Discussions Color Key |
| Design: |
|
| Development: |
|
| Et Cetera: |
|
| Install/Upgrade: |
|
| Smoketest: |
|
| Template Group: |
|
Re: Navigation links by rogier - Fri @ 04:06pm Re: Navigation links by techwriter - Fri @ 03:23pm Re: Best way to make files available to webgui comunity by bernd - Fri @ 02:50pm Re: Best way to make files available to webgui comunity by lctn2 - Fri @ 01:55pm Re: Strategic Roadmap by JT - Fri @ 01:55pm Re: Navigation links by rogier - Fri @ 01:55pm Re: 2009 Presidents Meeting by JT - Fri @ 01:10pm Re: navigation new window by rogier - Fri @ 01:03pm Re: navigation new window by rogier - Fri @ 12:53pm Re: WUC 2009 by JT - Fri @ 12:50pm Re: Best way to make files available to webgui comunity by preaction - Fri @ 12:35pm Re: Pagination markup by rogier - Fri @ 12:35pm Re: Best way to make files available to webgui comunity by kristi - Fri @ 12:29pm
|
