Database
Hello TechyV buddies!
DELETE DISTINCTROW LINKED_TABLE.*, [tblItem1].[item2], [LINKED_TABLE].[item3] FROM LINKED_TABLE INNER JOIN tblItem1 ON LINKED_TABLE.item1=tblItem1.item1 WHERE ((tblItem1.item2 = True)
and (LINKED_TABLE.item3 = Forms!frmItem3!DateField)); Only solution I find is moving INNER JOIN clause to new line (HEX (0D 0A)) as follows: DELETE DISTINCTROW LINKED_TABLE.*, [tblItem1].[item2], [LINKED_TABLE].[item3] FROM LINKED_TABLE
INNER JOIN tblItem1 ON LINKED_TABLE.item1=tblItem1.item1 WHERE ((tblItem1.item2 = True)
- 1397 views
- 1 answers
- 0 votes
Hello Techyv buddies!
I am having some issue regarding Microsoft SQL server. We were notified recently about an error on MS SQL Server Management Studio.
They said that an error will occur when we try to connect to the MSSQL 2012 database externally.
The error seems to talk about permission in doing a certain action. The error is this:
This error is displayed when you right click on the MSSQL 2012 database and selecting its properties.
Can anyone help me figure this one out?
I can’t find any solution to the problem so I am bringing it to the public.
Any help will be much appreciated.
Thank you!
- 1335 views
- 2 answers
- 0 votes
Hi TechyV buddies!
I am having some problem with my MSSQL server. I am using Windows Server 2003, II 6, PHP 5.2.17 – FastCGI (Plesk) and MSSQL server 2008 in another server. Everything works well until I installed drivers php_sqlsrv_52_ts_vc6.dll and php_pdo_sqlsrv_52_ts_vc6.dll and added this as an extension: extension=php_sqlsrv_52_ts_vc6.dll
extension=php_pdo_sqlsrv_52_ts_vc6.dll
After that, I have restarted the web server for the installed drivers to work. However an error occurred. The following error showed up.
FastCGI Error
The FastCGI Handler was unable to process the request. Error Details:
The FastCGI process exited unexpectedly
- 1718 views
- 1 answers
- 0 votes
Hi TechyV buddies!
- 844 views
- 1 answers
- 0 votes
Hello Techyv buddies!
I have managed to create a database link successfully, and an item can be selected from the table in the remote database. However, when I start to describe a table on the remote database. (decs tablename@remotedb),
I end up receiving the following message:
“ORA-12663: Services required by the client not available
on the server.”
Can you tell me what could have caused this issue?
I would greatly appreciate the effort to solve this problem.
Thank you!
- 1024 views
- 1 answers
- 0 votes
Hi,
Yesterday I'm working on my database project. Currently I'm working on MS Access 2007 when I am trying to save my database in earlier versions like 2003. Sometimes it generates a window and database cant save in earlier version.
You cannot save database in an earlier version format, because it uses features that require the current file format.
Features that require the current file format include attachments, multi valued fields, offline data, or link to external files that are not supported by earlier version of Access.
OK
Why this window occur during the save?
- 1078 views
- 2 answers
- 0 votes
Hello
I am getting the following error message when I attempt to install a printer using group policy in Windows Server 2008.
I need to solve it. Please help me.
Thanks.
Print Management
- 868 views
- 1 answers
- 0 votes
Hi expert,
We have a cloud server in here we configured, JBPM 5.3 with JBOSS 7.
And we could create the procedure successfully. But when we start the process, at human task, it displays the error in FTL files. From my machine, I am entrancing the jbpm-console from server.
I need to solve it.
This Webpage is not available
Please help me.
- 1040 views
- 1 answers
- 0 votes
Hi Experts
I have attempted all possible side from mine. But still I got this.
The problem is, I am attempting to set up SQL Server 2005 Express version on Windows 7.But it fails in the installation process and the error message is
- 992 views
- 1 answers
- 0 votes
I’m installing the Rational Quality Manager Custom Reporting, when I installed and configured Rational Quality Manager and DB2 and while installing the Rational Quality Manager Custom Reporting, the Installation Manager stops with the following error:
Install Packages
Error during install phase:
OK << Details
An error occurred whiIe installing the Data Warehouse.
CRREW4513E: Error creating database
Any idea?
- 874 views
- 1 answers
- 1 votes