Connecting To MSSQL Server 2000 Using JDBC
Jun 18, 2007
Hello,
I am developing an application which needs JDBC connection to a Named Instance of SQL Server 2000 (other than default instance). I am facing problem in this regard as my code gives an exception "Time Out" or "Connection Failed". However it works fine with the default named instance...The main driver class is "com.microsoft.sqlserver.jdbc.SQLServerDriver"
and Connection URL is
"jdbc: sqlserver://localhost;instanceName=Testing:1432;databaseName=testDB;"
It gives the exception that Unable to connect to named instance....
Please if any one have any knowledge in this regard....do let me know....I have read an article on MSDN according to which on MS SQL Server 2000 the named Instance other than default can be accessed only through named pipes.
http://msdn2.microsoft.com/en-us/library/aa224779(sql.80).aspx
if some body can tell me Connection string for JDBC driver which utilizes named pipes...the it will be very help full for me.........any help from MSDN Experts is really appreciated...
Thanks
View 4 Replies
ADVERTISEMENT
Jul 20, 2005
Hi,I have installed MQ SQL Server 2000 on my laptop and trying to useSPRINTA 2000 JDBC Driver (inetmssql.jar) to connect to the local db. Iwrote a sample Java app to test the connection and I get the followingerror trace,DriverManager.initialize: jdbc.drivers = nullJDBC DriverManager initializedSQLException: SQLState(08S01){sql7=true, port=1433, user=sa, url=jdbc:inetdae7:US0211737-WP01:1433,password=wasfe, host=US0211737-WP01}getConnection failed: com.inet.tds.SQLException: Connection refused:connectcom.inet.tds.SQLException: Connection refused: connectjava.net.ConnectException: Connection refused: connectat java.net.PlainSocketImpl.socketConnect(Native Method)at java.net.PlainSocketImpl.doConnect(Unknown Source)at java.net.PlainSocketImpl.connectToAddress(Unknown Source)at java.net.PlainSocketImpl.connect(Unknown Source)at java.net.Socket.connect(Unknown Source)at java.net.Socket.connect(Unknown Source)at java.net.Socket.<init>(Unknown Source)at java.net.Socket.<init>(Unknown Source)at com.inet.tds.TdsDriver.a(Unknown Source)at com.inet.tds.TdsDriver.run(Unknown Source)at java.lang.Thread.run(Unknown Source)I tried searching the web and product doc. Nothing seems to help me.Has anyone come across similiar problems? Any pointers will beappreciated also.Thanks,Swami.
View 6 Replies
View Related
Sep 30, 2007
dear all i tried to connect to online mssql2000 database from enterprise manager,but i can't as i have a proxy server.how can i overcome this proxy server during connection ?
View 3 Replies
View Related
Jul 20, 2005
Hello to all,I am using windows 2000 and i want to connect to ms sql server withjdbc type 4 driver.can you give me sample code and few tips to get me through this.,thank you in advance,vishnu.
View 2 Replies
View Related
Sep 6, 2006
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 Related
Mar 21, 2008
Hi
I am using JDK 1.6 . I have downoladed the JDBC driver from
http://www.microsoft.com/downloads/details.aspx?familyid=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en
This page mentions certain versions of JDK that this driver works with, but 1.6 is not one of them.
How can I use this driver with JDK 1.6?
Thanks
J.
View 3 Replies
View Related
Mar 12, 2008
I've got an import app written in Java. One table I'm importing from contains 22 million records. When I run the app in a 2000 environment, I have my max heap set at 512, and the table gets imported. When I run in a 2005 environment, I have to change the max heap to 1152 or it will error out with a similiar error:
com.microsoft.sqlserver.jdbc.SQLServerException: The system is out of memory. Use server side cursors for large result sets:Java heap space. Result set size:854,269,999. JVM total memory size:1,065,484,288. (<--this is with max heap at 1024)
what is the difference between the 2000 and 2005 JDBC that I have to set max heap in one and not the other?
View 3 Replies
View Related
Jul 10, 2007
Hi,
Am using Mcafee and it has a built in MSSQL Database. Am not able to get data frrom database. Can anyone let me know how to connect to Built in MSSQL database using JAVA? Need very quick reply. Any help is greatly appreciated.
thanks,
Jags
View 3 Replies
View Related
Jan 28, 2008
I'm having some problems with my JApplet and MS-SQL 2005 using JDBC 1.2 driver
most of the time the applet works just fine but every now and then (after reloading 5 times or so) I get one of these messages in console
Code Snippetbasic: New window ID: 36049c3
basic: Value of xembed: 1
basic: setWindow: call before applet exists:36049c3
basic: Referencing classloader: sun.plugin.ClassLoaderInfo@1eef0a8, refcount=1
basic: Added progress listener: sun.plugin.util.GrayBoxPainter@7a7f6b
basic: Loading applet ...
basic: Initializing applet ...
basic: Starting applet ...
basic: completed perf rollup
network: Connecting socket://192.168.5.4:1433 with proxy=DIRECT
network: Cache entry not found [url: http://192.168.5.8/development/emiel/tagbis_dev/viewers/oqm%20viewer/system/organigram/com/microsoft/sqlserver/jdbc/SQLServerResource_nl.class, version: null]
network: Connecting http://192.168.5.8/development/emiel/tagbis_dev/viewers/oqm%20viewer/system/organigram/com/microsoft/sqlserver/jdbc/SQLServerResource_nl.class with proxy=DIRECT
network: Connecting http://192.168.5.8/development/emiel/tagbis_dev/viewers/oqm%20viewer/system/organigram/com/microsoft/sqlserver/jdbc/SQLServerResource_nl.class with cookie "password=admin; username=admin; autologin=true; ZDEDebuggerPresent=php,phtml,php3; PHPSESSID=rqdrj8p11i0muta0f5kq9p4qu1"
network: Cache entry not found [url: http://192.168.5.8/development/emiel/tagbis_dev/viewers/oqm%20viewer/system/organigram/com/microsoft/sqlserver/jdbc/SQLServerResource_nl.properties, version: null]
network: Connecting http://192.168.5.8/development/emiel/tagbis_dev/viewers/oqm%20viewer/system/organigram/com/microsoft/sqlserver/jdbc/SQLServerResource_nl.properties with proxy=DIRECT
network: Connecting http://192.168.5.8/development/emiel/tagbis_dev/viewers/oqm%20viewer/system/organigram/com/microsoft/sqlserver/jdbc/SQLServerResource_nl.properties with cookie "password=admin; username=admin; autologin=true; ZDEDebuggerPresent=php,phtml,php3; PHPSESSID=rqdrj8p11i0muta0f5kq9p4qu1"
network: Cache entry not found [url: http://192.168.5.8/development/emiel/tagbis_dev/viewers/oqm%20viewer/system/organigram/com/microsoft/sqlserver/jdbc/SQLServerResource_nl_NL.class, version: null]
network: Connecting http://192.168.5.8/development/emiel/tagbis_dev/viewers/oqm%20viewer/system/organigram/com/microsoft/sqlserver/jdbc/SQLServerResource_nl_NL.class with proxy=DIRECT
network: Connecting http://192.168.5.8/development/emiel/tagbis_dev/viewers/oqm%20viewer/system/organigram/com/microsoft/sqlserver/jdbc/SQLServerResource_nl_NL.class with cookie "password=admin; username=admin; autologin=true; ZDEDebuggerPresent=php,phtml,php3; PHPSESSID=rqdrj8p11i0muta0f5kq9p4qu1"
network: Cache entry not found [url: http://192.168.5.8/development/emiel/tagbis_dev/viewers/oqm%20viewer/system/organigram/com/microsoft/sqlserver/jdbc/SQLServerResource_nl_NL.properties, version: null]
network: Connecting http://192.168.5.8/development/emiel/tagbis_dev/viewers/oqm%20viewer/system/organigram/com/microsoft/sqlserver/jdbc/SQLServerResource_nl_NL.properties with proxy=DIRECT
network: Connecting http://192.168.5.8/development/emiel/tagbis_dev/viewers/oqm%20viewer/system/organigram/com/microsoft/sqlserver/jdbc/SQLServerResource_nl_NL.properties with cookie "password=admin; username=admin; autologin=true; ZDEDebuggerPresent=php,phtml,php3; PHPSESSID=rqdrj8p11i0muta0f5kq9p4qu1"
com.microsoft.sqlserver.jdbc.SQLServerException: The result set is closed.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.checkClosed(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(Unknown Source)
at Main.Laden(Main.java:1019)
at Main.init(Main.java:267)
at sun.applet.AppletPanel.run(AppletPanel.java:419)
at java.lang.Thread.run(Thread.java:619)
network: Connecting socket://192.168.5.4:1433 with proxy=DIRECT
network: Cache entry found [url: http://192.168.5.8/development/emiel/tagbis_dev/viewers/oqm%20viewer/system/organigram/organisatieschema.jar, version: null]
Code Snippetbasic: New window ID: 3604eaf
basic: Value of xembed: 1
basic: setWindow: call before applet exists:3604eaf
basic: Referencing classloader: sun.plugin.ClassLoaderInfo@1eef0a8, refcount=1
basic: Added progress listener: sun.plugin.util.GrayBoxPainter@1ba4a47
basic: Loading applet ...
basic: Initializing applet ...
basic: Starting applet ...
basic: completed perf rollup
network: Cache entry not found [url: http://192.168.5.8/development/emiel/tagbis_dev/viewers/oqm%20viewer/system/organigram/org/jdesktop/swingx/plaf/resources/swingx.class, version: null]
network: Connecting http://192.168.5.8/development/emiel/tagbis_dev/viewers/oqm%20viewer/system/organigram/org/jdesktop/swingx/plaf/resources/swingx.class with proxy=DIRECT
network: Connecting http://192.168.5.8/development/emiel/tagbis_dev/viewers/oqm%20viewer/system/organigram/org/jdesktop/swingx/plaf/resources/swingx.class with cookie "password=admin; username=admin; autologin=true; ZDEDebuggerPresent=php,phtml,php3; PHPSESSID=rqdrj8p11i0muta0f5kq9p4qu1"
network: Cache entry found [url: http://192.168.5.8/development/emiel/tagbis_dev/viewers/oqm%20viewer/system/organigram/swingx-0.9.0.jar, version: null]
network: No certificate info for unsigned JAR file: http://192.168.5.8/development/emiel/tagbis_dev/viewers/oqm%20viewer/system/organigram/swingx-0.9.0.jar
network: Connecting socket://192.168.5.4:1433 with proxy=DIRECT
28-jan-2008 7:57:29 com.microsoft.sqlserver.jdbc.TDSReader throwInvalidTDS
SEVERE: TDSReader@101f935 ( ConnectionID:7 TransactionID:0x0000000000000000) got unexpected value in TDS response at offset:1503
com.microsoft.sqlserver.jdbc.SQLServerException: Unexpected IOException processing character stream Reader.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.DDC.convertReaderToString(Unknown Source)
at com.microsoft.sqlserver.jdbc.DDC.convertNonUnicodeNonPLPToObject(Unknown Source)
at com.microsoft.sqlserver.jdbc.ServerDTVImpl.getValue(Unknown Source)
at com.microsoft.sqlserver.jdbc.DTV.getValue(Unknown Source)
at com.microsoft.sqlserver.jdbc.Column.getValue(Unknown Source)
at com.microsoft.sqlserver.jdbc.Column.getValue(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getString(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getString(Unknown Source)
at Main.Laden(Main.java:1024)
at Main.init(Main.java:267)
at sun.applet.AppletPanel.run(AppletPanel.java:419)
at java.lang.Thread.run(Thread.java:619)
com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.checkClosed(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.checkClosed(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(Unknown Source)
at Boom.MaakBoomStructuur(Boom.java:241)
at Boom.access$0(Boom.java:110)
at Boom$2.run(Boom.java:74)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
network: Connecting socket://192.168.5.4:1433 with proxy=DIRECT
network: Cache entry found [url: http://192.168.5.8/development/emiel/tagbis_dev/viewers/oqm%20viewer/system/organigram/organisatieschema.jar, version: null]
Now I've looked all over the web but nowhere can they offer any help, best I could find was a diffrent driver for MS-SQL which in version history says it was a bug and they fixed it..
**EDIT**
for some aditional info.. I never get these errors when using appletviewer, only when the applet gets started within browser
View 1 Replies
View Related
Jul 6, 2006
Hi this is my first post
I really needs some help
I have been stressing with issue for last few days.
I have a stored Procedure ramApplicationAddTest, I can run it through SQL Query Analyser without any problem.
I can call this using JDBC and it works, here is how I make call I make to SP
var con1 = DBDriver.getConnection ("alias:ProclaimConnect");
var stmt = con1.prepareCall( "{call ramApplicationAddTest(?,?,?,?,?)}");
stmt.setString(1,'BuildApp');
stmt.setString(2,'BASwimPool');
stmt.setString(3,'Test Test....');
stmt.setString(4,'');
stmt.setFloat(5,0);
stmt.execute();
stmt.close();
con1.close();
I also have another SQL 2000 Stored Procedure called
RamApplicationAddTest1, I can run this SP also through SQL Query Analyser without any problem.
But when I try to run this using JDBC it, gives me following Exception.
SQLState[ERR-Unexpected]ErrorCode[0]Message[java.lang.NullPointerException
at com.hs.form.jdbc.JDBCErrorhandler.isMssqlConnectio nErrorInTx(JDBCErrorHanlder.
An exception 'DatabaseQueryException' has occurred at DatabaseQueryClientWinInetImpl.cpp (291).
var con2 = DBDriver.getConnection ("alias:ProclaimConnect");
var stmt = con2.prepareCall( "{call ramApplicationAddTest1(?,?,?)}");
stmt.setString(1,’BuildApp’);
stmt.setString(2,’BASwimPool’);
stmt.setString(3,’Test’);
stmt.execute();
stmt.close();
con2.close();
I hope somebody can give me some hints to fix this.
Amar
View 1 Replies
View Related
May 13, 2004
I have SQL server installed on a XP box. I need to access it from other machines using Java code. Where can I download a JDBC driver?
Thanks.
View 6 Replies
View Related
Dec 13, 2005
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 Related
Oct 10, 2006
Hi,
I am trying to connecting Eclipse to SQLserver2005 on Win2000, and the driver I use is JDBC.
My problem is: No matter what kind of authentification I try, it always throws out the exception of:
The user is not associated with a trusted SQL Server connection.
I tried 2 ways for connection: one is the windows, and another is Sql server authentification
To the window authentification, I appended Trusted_Connection=yes to the URL, and omit the user and password fields, and it failed. But even I used the user and password options, it didn't work, either.
To the Sqlserver authentification, I tried with the user and password, but it failed. Before that, I also added the user account in the Security option and for the specified Database.. while failed again.
And also for example:
when using the windows authentification, I tried this:
String SERVANDDB ="jdbc:sqlserver://localhost:1433;DatabaseName=TestDB;Trusted_Connection=Yes";
....
con = DriverManager.getConnection(SERVANDDB);
This throw the exception of user' ' is not a trust_connection....blabla
when using the sqlserver authentification, I tried like this:(the user ABC is assigned authority to database TestDB)
String SERVANDDB ="jdbc:sqlserver://localhost;DatabaseName=TestDB";
String USER = "ABC";
String PWD = "CBA";
con = DriverManager.getConnection(SERVANDDB, USER,PWD);
(The server is runing on my computer)
Thank you.
View 3 Replies
View Related
May 24, 2006
Hi,
I've found problems when executing
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
I get a java.lang.ClassNotFoundException, and I have done this steps:
1º I got the driver from msdn web page
2º I modified the classpath in Windows XP adding the path to the sqljdbc.jar, testing if there was any problems with blanks in the path, I tried to put the .jar file in a more simple folder, but it didn't work.
Perhaps I've to do something whith my policy.java or so archives to let applets do something about this but I have no idea.
Can someone help me? Thanks!
View 6 Replies
View Related
Apr 5, 2004
Hi,
Recently, I found a bug in Microsoft's official SQL Server2000 JDBC driver.
It seemed to lie in the Statement's setDate() method. Maybe they simply assumed
all date are represented in 12-hours format.
The test code is below:
public void testMisc() throws Exception {
Connection conn = TransactionManager.getConnection();
String sql = "select count(salescheck0_.ID) as x0_0_ " +
"from T_CHK_OUT_BILL_TEST salescheck0_ " +
"where (salescheck0_.EX_TIME>?)" +
"and(salescheck0_.EX_TIME<?)";
PreparedStatement stmt = conn.prepareCall(sql);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
Date timefrom = sdf.parse("2004-04-02 00:00:00.000");
Date timeto = sdf.parse("2004-04-02 23:00:00.000");
stmt.setDate(1, new java.sql.Date(timefrom.getTime()));
stmt.setDate(2, new java.sql.Date(timeto.getTime()));
// stmt.setString(1, "2004-04-02 00:00:00.000" );
// stmt.setString(2, "2004-04-02 23:59:59.000" );
ResultSet rs = stmt.executeQuery();
if(rs.next()) {
int count = rs.getInt(1);
System.out.println("count = " + count);
}
}
The test data is following:
ID, SO_ID,WH_ID,CLIENT_ID,CODE,OPERATOR,CHK_OUT_TIME, STATUS,CREATE_TIME,DELIVER_TYPE
86179,67521,1,661,SLCCK200404020016,xuwei,2004-4-2 12:15,20,2004-4-2 9:40,10
86229,67566,1,118,SLCCK200404020066,xuwei,2004-4-2 12:23,20,2004-4-2 9:41,10
86231,67568,1,130,SLCCK200404020068,xuwei,2004-4-2 12:23,20,2004-4-2 9:41,10
86232,67569,1,134,SLCCK200404020069,xuyili,2004-4-2 11:08,20,2004-4-2 9:41,10
86233,67571,1,151,SLCCK200404020070,xuwei,2004-4-2 12:23,20,2004-4-2 9:41,10
86234,67572,1,55,SLCCK200404020071,xuwei,2004-4-2 12:23,20,2004-4-2 9:41,10
86235,67573,1,71,SLCCK200404020072,xuwei,2004-4-2 12:23,20,2004-4-2 9:41,10
86252,67590,1,298,SLCCK200404020089,xuwei,2004-4-2 12:33,20,2004-4-2 9:41,10
86268,67576,1,25,SLCCK200404020105,xuwei,2004-4-2 12:23,20,2004-4-2 10:18,10
86269,67588,1,271,SLCCK200404020106,xuwei,2004-4-2 12:33,20,2004-4-2 10:20,10
86270,67506,1,42,SLCCK200404020107,xuwei,2004-4-2 12:15,20,2004-4-2 10:21,10
86271,67531,1,751,SLCCK200404020108,xuyili,2004-4-2 11:28,20,2004-4-2 10:22,10
86272,67570,1,149,SLCCK200404020109,xuwei,2004-4-2 12:23,20,2004-4-2 10:29,10
86273,67600,1,6,SLCCK200404020110,xuwei,2004-4-2 12:15,20,2004-4-2 10:40,10
86373,67665,3,686,SLCCK200404020210,root,2004-4-2 17:18,20,2004-4-2 16:32,10
86374,67657,3,883,SLCCK200404020211,root,2004-4-2 17:18,20,2004-4-2 16:32,10
86375,67666,3,686,SLCCK200404020212,root,2004-4-2 17:18,20,2004-4-2 16:32,10
86376,54799,1,395,SLCCK200404020213,zhouliyi,2004-4-2 19:52,20,2004-4-2 19:51,10
86377,55383,1,341,SLCCK200404020214,zhoulingyi,200 4-4-2 19:52,20,2004-4-2 19:51,10
Given the code and data, the expected output ought to be "count = 19"
But it's "count = 19" instead.
However, if you set date by using alternative method like the commented statements,
you can get the correct result.
Does anybody know if there exists any patch?
Could we expect Mircosoft to fix this bug? If so, where could I submit this bug report?
Regards,
Justin
View 3 Replies
View Related
Sep 3, 2007
Hi,
We are running one shopping site for our organisation, which includes Tomcat 5.0.28 , IIS & SQL Server 2000 SP3 hosted on platform Microsoft Windows Server 2003 Enterprise Ed. , we are running jsp pages server side and site is hosted on internet,
but it is observed that after every 1/2 days , page will throw following exception, and site get blocked.
javax.servlet.ServletException: Network error IOException: No buffer space available (maximum connections reached?) : connect
Can anybody help please?
I am beginner with JDBC - SQL Server Connectivity ,
I am giving our configuration details:
Driver Used - Microsoft SQL Server Driver 2000 SP3
Protocol Used - TCP/IP which open socket connection on default port 1433
Authentication - Mix Mode Authetication ( using sa account login)
Even setting done within LOCAL instance running on server to allow max. connections i.e 32767
My observation is that some kind of virus threat may causing this error, because if server will be rebooted, we doesn't
get any error and everything works fine.
Waiting for your suggestions and advise.
Thanks a lot.
Regards,
Mandar Velankar
View 3 Replies
View Related
Oct 5, 2006
Hi,
I'm using JDBC driver for Server 2005 (version 1.1.1501) to access Server 2000. I have no problems reading my data, but every update returns "Cursor is READ ONLY".
If I use driver for Server 2000 I have no problems. And I have no problems running the same program with 2005 driver against SQL Server Express.
Where should I start debugging?
Thank you,
View 1 Replies
View Related
Jul 20, 2005
Hi,I have a problem to set a JDBC connection as READ UNCOMMITED.setTransactionIsolation(Connection.TRANSACTION_REA D_UNCOMMITTED)This is causing lots of blocking on tablesand update or insert doesn't work properly.Does anyone have any idea what I'm missing here?I asked i-net support and they suggested to callsetAutoCommit(false) after the above functionand it didn't work.also suggested impltrans = true, and I changed that option on SQLand it caused more blocking.Thanks in advance for any info.
View 24 Replies
View Related
Mar 24, 2008
Hi,
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.
View 2 Replies
View Related
May 3, 2008
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
View 6 Replies
View Related
Jun 15, 2006
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"
View 1 Replies
View Related
Nov 17, 2007
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.
View 3 Replies
View Related
Dec 21, 2006
Hi I'm an experienced programmer, but just don't have much experience with ASP or MSSQL. I inherited a website and now need to set up an automated backup system for a fairly large (40MB) MSSQL database hosted by a 3rd party provider of reasonable quality with ASP and SQL Server 2000. Let's avoid ASP.NET solutions since the website I inherited is written in "straight up" ASP (old school).
I have access to the database, login etc. I'm thinking I should combine an ASP script with the database connectivity and write daily/weekly backups to a dir on the hosting server.
Where do I begin? Tools? Examples?
Thanks for any assistance.
Stoob
View 1 Replies
View Related
Feb 16, 2004
Hi Friends,
I am doing my final semester project. It is a migration tool that converts the DB2 PL dialect into MSSQL Server's T-SQL dialect.
I am in need of sample DB2 PL files(procedures, UDFs, triggers) for testing the tool. Please point out me to some DB2 files repository links or if you have some files, please give me the same. I will use this only for testing purposes.
Appreciate your help.
Thanks & Regards,
Jake
View 2 Replies
View Related
Nov 12, 2007
Hello,
I've got a weird problem that started today on our SQL server at work. Apparently the transaction logs filled up for one DB, and SQL server decided to create 230 gb of errors on the subject, filling my D: drive. Well, I had no problem deleting the error logs and truncating the transaction logs, but my Enterprise Manager MMC will no longer function.
Search results turned up a fix that worked for most people, but not for me. So I'm pretty sure I've got no choice but to reinstall over-the-top. But, will this cause any loss of existing databases (obviously back them up first), users/security, and scheduled tasks (db backups, etc)?
I'd like to do minimal damage to this thing because there are several DB's set up from before my time, and I don't have time to manage this thing completely (as you might have guessed, no one really manages things here). Any help is appreciated.
View 4 Replies
View Related
Jan 9, 2007
This is kind of the wrong place to ask VBA questions, but I've been poking around for a day and haven't got the answer, so I am hoping I can get some help here.
I am wondering if I can connect to MSSQL in MS Word Macro. If so, can I have some sample code please?
Thanks
View 3 Replies
View Related
May 15, 2008
I'm just starting to learn ASP.NET (3.5) and I've gotten most of it down, but my failure to use a database is realy crippling my learning ability.
How do I connect to MSSQL? I have Godaddy so they provide me with the username, password, url, etc. If I could get a few examples for the following it would really help ALOT!
Connect to database
View 3 Replies
View Related
May 23, 2007
This is the first asp.net application that I am trying to make.
After hours struggling wiht Plesk 8.1 I managed to create a MS SQL database and add a table to it.
How can I make a connection to this database now through ASP.NET?
Just mention it that I am using Visual Studio.net and I am working on a remote server.
View 1 Replies
View Related
May 22, 2007
Hi there,
I have 2 servers on our compny'ssql server does not exist or access denied lan, one with fixed ip and the other one with internal ip. I installed SQL server 2000 on the one with internal ip and I want to access it from the other server. when I want to register sql server instanse , I can see the name of that instance in the list but I can't register it. I keep reciving this error : sql server does not exist or access denied!
Could any one told me what to do?
View 2 Replies
View Related
Dec 23, 2005
Hi
I am running Visual Studio 2005 Visual Web Developer Standard Edition on a machine with SQL Server 2000. Could you please teach me how to modify the connection string below so that it connects to SQL Server 2000 with the database called "VisualWebDev".
Thank you.
Jim
<connectionStrings>
<add name="Personal" connectionString="Data Source=.SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Personal.mdf" providerName="System.Data.SqlClient"/>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=.SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf"/>
</connectionStrings>
View 12 Replies
View Related
Jul 23, 2005
Hi,I am total newbie to SQL Server. My new host tells me I can connect throughAccessXP or 2002. I have Access 2000. Can I not connect with that also?Thanks, JA
View 4 Replies
View Related
Jun 19, 2004
Hello,
I am working on a couple fo the ASP.NET walkthoughs and I would like to practice with a Database that I created in Access. I realize that I could use the Access DB, but I would like to learn to work with a more industrial strength DB. Is there a method to export to MSSQL server 2000 from Access ?
Regards,
James
View 4 Replies
View Related
Jul 5, 2006
Hi,
Does anybody know if MSSQL 2000 and SQL Server 2005 Express Edition can live together on the same machine?
I need to keep MSSQL 2000 up and running while evaluating the SQL Server 2005 Express Edition.
Thank you,
Paul
View 2 Replies
View Related