DEVELOPMENT: Cannot obtain the schema rowset “DBSCHEMA_TABLES_INFO” for OLE DB provider “SQLNCLI” for linked server
May 08, 2009
Running a query from SQL Server 2008 over a linked server connection to a SQL Server 2000 server causes the following error: OLE DB provider “SQLNCLI10″ for linked server “mylinkedserver” returned message “Unspecified error”. OLE DB provider “SQLNCLI10″ for linked server “mylinkedserver” returned message “The stored procedure required to complete this operation could notbe found […]
READ MORECONNECTIT: new reseller group on LinkedIn
Apr 09, 2009
The purpose of the ConnectIt Resellers Group is to provide an additional support forum for ConnectIt application links, to keep members up to date with the latest news in the ConnectIt range of products and for members to share thoughts and experiences of implementing ConnectIt in various vertical industry sectors. The group will never replace […]
READ MOREQUOTEWERKS: new reseller group on LinkedIn
Apr 09, 2009
The purpose of this group is for members to keep each other up-to-date on QuoteWerks-related product news, provide an additional support / discussion forum for resellers only, and to share tips, tricks and experiences in implementing QuoteWerks-based solutions in different vertical industry sectors. Group members are actively encourage to contribute news on QuoteWerks, tips and […]
READ MORECONNECTIT: CRM, QuoteWerks and Sage resellers and consultants
Jan 08, 2009
10 Good Reasons to Start Reselling ConnectIt Generous commission structure on all licenses, support & services sold. Free support to ConnectIt resellers. Free marketing resources to ConnectIt resellers. Comprehensive online knowledgebase & suite of video tutorials. Online demo environment provided free for your use. Online demos conducted by ConnectIt Support on your behalf. Lead follow […]
READ MOREQuoteWerks tip on using layout formulae to trim strings (a real world example)
Jan 06, 2009
The below formula uses a function to get a set of numbers from an 18 digit field. So in this case documentheaders->soldtoponumber the format of the field is 0000.0000.00.00.00 What one of our clients wanted was that to filter out and generate the report based on the middle 4 digits highlight above. What we did […]
READ MOREQUOTEWERKS: Free report showing your business’ performance
Dec 17, 2008
Would like to know how well your business has done in the last 12 months? Then get this free QuoteWerks report to summarise your business’ performance. This free report summarises sales by Sales Rep by Month and details the invoiced amount, profit, number of invoices and average sales value for the year January to December. […]
READ MOREQUOTEWERKS: Business Intelligence reports
Dec 17, 2008
Please find below a couple of formulae you could add as page footers to your QuoteWerks management reports to give them an added bit of professionalism… Just open your QuoteWerks document layout, click the formula button, give the formula a name (i.e. “PAGE_X_OF_Y”), click OK and copy/paste the formula in. PAGE_X_OF_Y: “Page “+text(sys->page)+” of “+text(sys->page_count) […]
READ MOREQUOTEWERKS: Getting the address on documents to "look right"
Dec 17, 2008
Are you struggling to get the address on your QuoteWerks document layouts to “look right”? With all the fields available – Address1, Address2, Address3, City, State, Zip and Country – an actual address might be held in just a few or all seven of these fields. Then try these formulae – just open your QuoteWerks […]
READ MOREDEVELOPMENT: issue with DateTime datatype in SQL Server Reporting Services
Nov 02, 2008
We recently upgraded a client’s SQL Server 2000 business intelligence reports to SQL Server 2005, and from a Visual Studio .net 1.1 software development environment to Visual Studio 2005. It should be a simple transition we thought, which it was… apart from some anomalies around the datetime parameters in SQL Server 2005 Reporting Services. There […]
READ MORE