Hi,
I have a Apache TOMCAt 5 server running as my web server and I would like to connect my web app to a MS SQL database, can anyone help me out on how to connect my MS SQL with the Web app which is running on my TOMCAT web server.
TOMCAT+Apache is running in Linux system.
MS SQL is running in windows system
Thanks,
Vadiraj
Hi all.
I've had a web service developed in PHP5 running on an Apache webserver for the last 9 months. It handles a lot of XML requests and stores/reads from an MSSQL Server 2005 DB (Express, if that matters).
Occasionally, I will come across the error 'Could not connect to database'. Refreshing the page works 99% of the time removes the error and the system continues as normal. I'd say this is happening about 1/100 requests at the moment, and my client is steadily becoming more irritated by it.
As far as I know, the system settings are mainly stock. It was set up by another developer.
I'm out of ideas with regards to debugging this problem.
Can anybody shed some light, or some possible solutions?
Kind Regards,
Jomn
I have been running Apache 2.2 and PHP 5.0 with MySQL 5.0 on my XP system. I installed MS SQL today, an I'm unable to connect to the MS SQL server through PHP. When I installed MS SQL I:
added extension=php_mssql.dll to php.ini, and I copied ntwdblib.dll into the windows/system32 directory. I still can't access the server.
The server is running, when I start Windows. I can open the SQL Server Service Manager, and it shows Server: XP-LINUX, Services: SQL Server. I can also open the Web Data Administrator tool at: http://localhost:8080/webadmin/default.aspx, and work with databases. I can open it on port 80, because Apache is using that port.
Anyone know what's up whit PHP?
Thanks in adavance...
Darin
hi all,
I 've done the mirroring in sql server 2005 sp1 now I 've to write the connection string for partner and failover server in tomcat root.xml file anyone know how to write the connectionstring?
my normal connection related stuffs which I am writing in root.xml is
<!-- SQL Server -->
<Resource
name="jdbc/LiferayPool"
auth="Container"
type="javax.sql.DataSource"
driverClassName="net.sourceforge.jtds.jdbc.Driver"
url="jdbc:jtdsqlserver://localhost:1433/normal_db"
username="sa"
password="ok"
maxActive="20"
/>
Here is an obscure question that I am sure can be dealt with from a10,000 ft view:I have installed Fuego (an enterprise level BPM). Another applicationwas built in-house to connect to Fuego (Fuego has two SQL 2000databases to handle the business process flow and instance flow). Thisin-house application then uses Tomcat & JDBC to connect to the abovementioned Fuego databases and a third SQL 2000 database that handlesthe actual data.The entire gist is this: The application(s) run the SQL calls as astandardIt is SQL Server performing all of the cursor work; I'm guessingthrough whatever translation layer. Maybe JDBC is causing this? Hasanyone seen this before?My second problem is that I let the application run for 1 day in useracceptance testing and I ended up with 1.8GB procedure cache (allcursors) at 50% cache hit ratio and 140MB of data cache at 99% cachehit ratio. What could be the cause?Thanks,Josh
View 1 Replies View RelatedI am trying to get mysql 4, php5, and apache to work on my winxp sp2 comp,unfortunately even though php5 and apache seems to work ok I am unable toutilise mysql with php and apache, I have yet to see a guide that has aproblem free installation, if there is such a guide or a fix on how to getphp5, apache and mysql all working on winxp sp2, after having movedlibmysql.dll to the c:php directory as well as the c:windowssystemdirectory,. and amended php.ini to show the path to c:phpext (althoughthis version of php didn't automatically create an ext directory) and havingamended pathn the system environments to point to c:php, as well asnumerous other recommendations, I am stuck as to how to proceed. Any helpwill be greatly appreciated.
View 1 Replies View Related
Hi,
I am facing problem in configuring and using connection pooling on tomcat 5.0. I am using JDBC Driver v.1.1 for SQL Server 2005.
Can anybody point me to appropriate samle code or guideline?
Thanks & Regards,
Bhavin P Panchal
can any one guide me how to change the default port address of apache which is 80 to any other port number. coz the default port number is taken by iis also.
View 1 Replies View Related
Hi, We are looking for a way to create the jdbc connection with Microsoft jdbc driver on a TomCat server ? Meaning the exact information to enter within the server.xml file or within the Tomcat web server administration tool - data source GUI.
thanks
We are using SQL Server Reporting Services 2012 with SharePoint 2013, we had publish the App with Apache Reverse Proxy.
The detail of the server is:
/serveis/app/apache/bin/apachectl -version
Server version: Apache/2.2.29 (Unix)
Server built:Â Â Apr 14 2015 10:36:40
We can open the report with no problem, but when we click in Actions menu we have a time out.I need to know if it is possible to know which url is trying to open, or if it is any kind of debug mode.
How many result-rows does mssql return should be used asynchronous method to use mssql cursor, can get the best performance in any time in any result offset?
i want to make the cursor fast in any time whatever how many results returned
Hi,
i was planning to create a database migration tool ..
its a certain database of a DMS (document management system) to
another DMS (two different DMS)... from DMS using msde 2000 server .. and tranfer to a DMS using a postgre sql or mssql .. depends ..
they have different table structures and names . . :D
i was thing of what language shall i use.. or what language is the best to work on this kind of project :)
hoping for your kind help guys. thanks :)
br
Frozenice
Does enabling/disabling Data Execution Prevention have a performanceimpact on SQL 2000 or SQL 2005?For SQL best performance - how should I configure for:Processor Scheduling:Programs or Background servicesMemory Usage:Programs or System Cache
View 9 Replies View RelatedHi,
I am a bit new to the MSSQL server. In our application, we use so many SQL queries. To imporve the performance, we used the Database enigine Tuning tool to create the indexes. The older version of the application supports MSSQL 2000 also. To re-create these new indexes, I have an issue in running these "CREATE INDEX" commands as the statements generated for index creation are done in MSSQL 2005. The statements include "INCLUDES" keyword which is supported in MSSQL 2005 but not in MSSQL 2000.
Ex:-
CREATE INDEX IND_001_PPM_PA ON PPM_PROCESS_ACTIVITY
(ACTIVITY_NAME ASC, PROCESS_NAME ASC, START_TIME ASC, ISMONITORED ASC)
INCLUDE
(INSTANCE_ID, ACTIVITY_TYPE, STATUS, END_TIME, ORGANIZATION);
Any help in creating such indexes in 2000 version is welcome.
Thanks,
Suresh.
Hello
We are using SQL 2005 and now we are planning to use SQL 2000. what are the ways to do the process.
We taken the script spcificall for 2000 and run it in SQL 200. But we are getting the error in SCRIPT?
Could you please give me the step to do?
Thanks,
Sankar R
Hello:
I am currently work on mssql 6.5. On my workstation, I have mssql 6.5
cient software.
However, I would like to install mssql 7.0 server on my nt workstation
and work with it to become familiar with 7.0. Can I install mssql 7.0
server on my nt workstation? Can mssql 6.5 client coexist with mssql 7.0
on the same machine if they are in different directories?
Thanks.
David Spaisman
Ben writes "I have a sql script that doesn't function very well when it's executed on a SQL 2000 server.
The scrpt looks like this:
---------------------------------------------------------------------------------------------------
USE [master]
GO
IF NOT EXISTS (SELECT * FROM master.dbo.syslogins WHERE loginname = N'SSDBUSERNAME')
EXEC sp_addlogin N'SSDBUSERNAME', N'SSDBPASSWORD'
GO
GRANT ADMINISTER BULK OPERATIONS TO [SSDBUSERNAME]
GO
GRANT AUTHENTICATE SERVER TO [SSDBUSERNAME]
GO
GRANT CONNECT SQL TO [SSDBUSERNAME]
GO
GRANT CONTROL SERVER TO [SSDBUSERNAME]
GO
GRANT CREATE ANY DATABASE TO [SSDBUSERNAME]
GO
USE [master]
GO
If EXISTS (Select * FROM master.dbo.syslogins WHERE loginname = N'SSDBUSERNAME')
ALTER LOGIN [SSDBUSERNAME] WITH PASSWORD=N'SSDBPASSWORD'
GO
GRANT ADMINISTER BULK OPERATIONS TO [SSDBUSERNAME]
GO
GRANT AUTHENTICATE SERVER TO [SSDBUSERNAME]
GO
GRANT CONNECT SQL TO [SSDBUSERNAME]
GO
GRANT CONTROL SERVER TO [SSDBUSERNAME]
GO
GRANT CREATE ANY DATABASE TO [SSDBUSERNAME]
GO
USE [master]
GO
IF EXISTS (select * from dbo.sysdatabases where name = 'ISIZ')
DROP DATABASE [ISIZ]
GO
USE [SurveyData]
GO
exec sp_adduser 'SSDBUSERNAME'
GRANT INSERT, UPDATE, SELECT, DELETE
TO SSDBUSERNAME
GO
USE [SurveyManagement]
GO
exec sp_adduser 'SSDBUSERNAME'
GRANT INSERT, UPDATE, SELECT, DELETE
TO SSDBUSERNAME
---------------------------------------------------------------
I need to be converted to a script that can be executed on both MSSQL 2000 and MSSQL 2005.
I was wondering if somebody there could help me with this problem?!
Thanks,
Ben"
I've been tasked to move our production databases on MSSQL 2000 to 2005. I've supported MSSQL since version 6.5 and performed migrations to successor versions.
Current Environment is MSSQL 2000 32-bit with current Service Packs.
I've performed mock migrations on Test servers upgrading all Production instances simultaneously from MSSQL 2000 to 2005 32-bit. The Test environment is identical to Production minus server name, IP etc. Also I have a separate server with MSSQL 2005 installed where I use the DETACH / ATTACH and BACKUP / RESTORE method for migration / acceptance testing. There are approximately 30 databases totaling 70 GB. This has gone as expected and fairly successful. Vendors have been coordinated with to update code and staff for acceptance testing.
I'd prefer going directly to MSSQL 2005 64-bit instead if possible due to memory benefits etc. This is where I'd like some feedback prior to borrowing a 64-bit server for testing.
Upgrade options:
1. Is it better to migrate from MSSQL 2000 32-bit to 2005 64-bit via:
a. DETACH / ATTACH
b. BACKUP / RESTORE
c. Is one method more advantageous relating to the end result?
2. Regarding XP clients, have issues been experienced with the default SQL Server driver or is an alternate recommended for XP clients to connect to a MSSQL 64-bit server databases?
3. If you have performed this migration and have relevant experience please pass them along.
DB is developed on local computer with MSSQL 2005 Express. My host is on MSSQL 2005 workgroup. Are they compatible, because I am getting errors? Is my approach wrong?
I have tried several approaches.
A) I created a backup of database on my local, then placed a copy on the server. Then I tried to restore through Server Management Studio. I get this error.
TITLE: Microsoft SQL Server Management Studio
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database.
RESTORE FILELIST is terminating abnormally. (Microsoft SQL Server, Error: 3169)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.2039&EvtSrc=MSSQLServer&EvtID=3169&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
B: I also have tried copying the database. I put it in the same path as the other databases that can be read with server management studio on the server. Then, tried to get to it through server managements studio and it did not appear. So I tried to attach it. Then I received this error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Attach database failed for Server 'MROACH1'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Could not find row in sysindexes for database ID 10, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Could not open new database 'LodgingDB'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
C: I have also tried opening the Database, and back up file through Server Management Studio. without success.
D: I also tried Windows and Software update at microsoft update, but no updates were recommended for Version on Server.
I'm surprised this is so hard. My original data base was created in same family of software. 2005 MS SQL Express. I could use some direct help from someone experienced with this. Am I doing it wrong or are the DB versions incompatible.
Mark Roach
How to convert a database in MSSQL 2000 to MSSQL 2005 database.Is there any tool or documentation available for this?
View 3 Replies View RelatedI have my MSSQL hosted, any interface i can use so i can't connect to the data source?
for Mysql, i know i can use phpmyadmin, or mysql interface.
i have no idea for MSSQL, any advices?
i know there is one, which is Toad, but it has a lots of limitations, any good idea?
thanks.
Hi,
till now i have used mysql with php.now i want to use mssql with php.my php and apache versions are
php 5.2.3
apache 2.2.4
from where i can get mssql and what i need to run my php scripts with mssql database.iam newbie in mssql.any of your help will be surely appreciated
thanks
mrjameer
Hi!
What is the best way to migrate MSSQL 2005 Express -> MSSQL 2005 Srv?
Hey guys, im trying to write an application to connect to a database on a mssql server using asp.net. Thus far any code i've seen and tried seems to not recognize the ODBC connections, so i was hoping you guys can offer some suggestions. For the example lets say the server is mssql9.aaa.com the db name is xyz with a username of welsh_welsh and the password is q with a table named abc in the database. How exactly would you go about connecting. The code i've tried so far is below:
<%
"Data Source = mssql9.aaa.com;Initial Catalog = xyz;UserID = welsh_welsh;Password = q;"
%>
The error i get from the sever is
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: BC30035: Syntax error.
any free videos to study mssql server 2000 queries
View 1 Replies View RelatedIm trying to write a very basic stored porcedure that looks up some data and performs simple calculations, the results of which are then saved (updated) to a specific table. To be more specific, I use the avg function in a simple select statement to average some figures based on a where clause:
SELECT AVG(exactskip)FROM HistoryWHERE Exact = '023'
...This should return 425.66, but it returns either 425 or 425.0000.
The results which are returned and being saved are being shown as a rounded integer or shown with 4 zeros after the decimal. I know it should be ending with a decimal in almost all cases. The column in the table that the result are being saved to is formated as smallmoney. The column in the table whos data is being averaged is set as an integer. Question, how can I make the avg function calculate the decimal values and save the appropriate decimal results. What changes do I need to make to my select statement. Any help would be appreciated.
I am still very new to all this, so please be specific and somewhat step by step in any reply
Thanks
Scott
I have an SQL 2000 server set up that runs perfectly, and an IIS set up that runs perfectly but I can not get the webpage to read data from the dbase. Is there a connection that I have to make or a program I have to load? The page is a .asp page, and when I run the page that should connectI do not get any errors in the dbase at all, so I can only imagine that it is not even seeing an attemptat a connection. Any help is appreciated.
View 1 Replies View Relatedhi,
I'm starting to write web application using ASP, the backend is MSSQL7.
Can I have some sample codes to look at. How to get connection and
select statements and get results and display onto the web.
thanks
Hi, is there an easy way to open a SQL 7 db using DAO code. Seems like a simple
set db = currentdb
won't do the trick. I also tried to open a workspace first, but I keep getting error when I try to do something with the recordsets, and I can't RunSQL. Any suggestions?
I am trying to run a DTS from a vbs but I am pulling my hair out at this point (grey anyway). Here is the script.
set objDTSPackage = CreateObject("DTS.Package")
objDTSPackage.LoadFromSQLServer "(local)", "sa", "", DTSSQLStgFlag_Default, "", "", "", "dts_download", 0
it is not doing it, and giving me error on all steps within the package
your help is greatly appreciated
thank you
Hey Guys, are you aware of anyone moving from MYSQL to MSSQL or vice versa - what were your experiences - Mark Smith
View 1 Replies View RelatedI just installed windows server update services on a 2k3 system. I am using mssql dekstop edition as the database. trend micro office scan also uses mysql. When I try to approve an update it sometimes just times out. When it does work it takes for ever. The CPU usage shoots through the roof. about %99 by the sqlservr process. It also take 190,000 k of RAM. Is this normal and how can I fix it? I think its a problem with the mysql but i don't know what. I have tried restarting. Its a 2.4 GHz system with 1gb of RAM. It only has 2 machines connected to the WSUS(more to come) Anyone any ideas would be great
View 1 Replies View Related-- =============================================-- Create table with IDENTITY column-- =============================================create table logviewer(idLog smallint IDENTITY(1, 1),timeLog, Char(14) NOT NULL,dateLog, Char(14) NOT NULL,typeLog, Char(14) NOT NULL,adressLog, Char(90) NOT NULL,messageLog, Char(254) NOT NULL)Server: Nachr.-Nr. 173, Schweregrad 15, Status 1, Zeile 8Die Definition für die timeLog-Spalte muss einen Datentyp enthalten.eng. define timLog colom as datatypeCould anyone help me please?
View 3 Replies View Related