1. BCP out Error in SQL2000: SQLState = 37000, NativeError = 4060 stackoverflow.comI have created a proc that grabs all the user tables in a local DB on my machine. I want to be able to create a flat file of all my ... |
2. JDBC Connection to SQL Server 2000 reset randomly on Solaris server stackoverflow.comI have the following method being called in a Java EE web application. |
3. ms sql2000 arabic problem stackoverflow.comI hava a table in ms sql2000 with a column defined as nvarchar when query this table in java i get data for this column like this : يا هلا بالشباب الØلوين ... |
4. sqlserver 2000: how to make aynchoronous call to procedures in database? stackoverflow.com
|
5. Sql Server 2000 Connection problem forums.netbeans.orgHi Guys, need help... I made a simple Java+netbeans 6.7+sql server 2000 program. it's running fine on the machine where i developed it, but when i copy the ".jar" files on ... |
6. MS SQL Server 2000 connectivity coderanch.com |
7. Facing pblm to create new login in sql server 2000 coderanch.comRespected Sir, Recently I installed ms sql server 2000 in windows 2000 server plat form. server is in my system only. i am able to enter to sqlserver with query analizer by using windows authentication but when i am trying to create a new login to enter with sql server authorization ......it is not accepting. i tried to create a new ... |
8. How to create a new Login in ms sql server 2000 coderanch.com |
9. Solutions for Ms Sql Server 2000 coderanch.comHi Friends I am working on Ms Sql Server 2000 I faced some pblms with sql server interms of resultsets and statements. now some of the pblms i solved I will be helpful to you..... If you got any pblm with sql server pl reply this... i will try to clarify your pblms upto the possible extend bye Yours Suji |
10. SQL Server 2000 coderanch.com |
11. SQL Server 2000 Create Table coderanch.com |
12. ResultSet containing XML from SQL server 2000 coderanch.com |
13. MicroSoft 2000 SQL Server - recv failed problem coderanch.comOur aplpication has been using driver=net.avenir.jdbc2.Driver url=jdbc:AvenirDriver://ourWeb:1433/ourDB We are using MicroSoft 2000 SQL Server and we are trying to switch to the Microsoft JDBC driver. driver=com.microsoft.jdbc.sqlserver.SQLServerDriver, url=jdbc:microsoft:sqlserver://ourWeb:1433;DATABASENAME=ourDB I downloaded the driver and put the jar files in the classpath. No code changes. I have the following error. Please help if you have any idea. Thanks in advance! java.sql.SQLException: [Microsoft][SQLServer 2000 Driver ... |
14. ms sql server 2000 database link pool coderanch.com |
15. JDBC and SQL Server 2000 coderanch.comWhat did you setup for MS Sql Server 2000 ? With this procudure, you only installed a library that allow you to connect to MS SQL Server 2000. After that you have to configure "programmatically" the connection between your application and your MS SQL Server 2000 database. With an URL liek this one : jdbc:microsoft:sqlserver://127.0.0.1:1433;SelectMethod=cursor;DatabaseName=myDB |
16. JDBC and SQL Server 2000 Part II Question coderanch.comI was asked a question like this... "Is it possible that I have a web application (jsp/servlets using JDBC) running on Solaris and then the database is in different machine and it is MSSQL Server running on Windows NT? " I dont know what to say... All I know is it is possible Web application on a machine and Oracle on ... |
17. error reading from an iamge type field [ms sql 2000] coderanch.com |
18. SQL Server 2000,jdbc problem, coderanch.com |
19. "enterprise Manager" for SQL2000? coderanch.com |
20. Java and MS SQL Server 2000 coderanch.com- you need to download some JDBC drivers for SQL Server 2000 http://www.microsoft.com/downloads/details.aspx?FamilyID=86212d54-8488-481d-b46b-af29bb18e1e5&DisplayLang=en - run the setup.exe program which installs the drivers the setup program installs 3 jars to the following location: C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\ - include these jars in your classpath - try some code - of course you need to fill in some blanks ... |
21. JDBC connection to SQL Server 2000 coderanch.comI've run into this exact problem also. On our server, the issue was the security mode. It was set for "Windows Only", we changed it to "SQL Server and Windows"; which enabled us to log in using the "sa" account (and other accounts also). The setting can be found by going into the Enterprise Manager, properties on the server and the ... |
22. General Error in SQL Server 2000 coderanch.com |
23. MS SQL 2000 connection coderanch.com |
24. deadlock in MS SQL 2000 but not in Postgres coderanch.comI am facing deadlock in MS SQL 2000 sp3, but same code does not face any deadlock in postgres 7.3 database. How do i resolve the problem ? Even same case happpnes for time taken by postgreas to retrive @15000 records is @4-5 seconds and same no. of records is fetched by ms sql 2000 is @8-10 minutes. Please Help me. ... |
25. SQL SERVER 2000 Row-level coderanch.com |
26. JDBC MSSQL 2000 connection pool manager coderanch.comHi, I have a java console application which needs to connect to MSSQL 2000 DB. I installed the jdbc driver and set the classpath. Previously, I used to connect MySQL with ConnectionPool. I use the same connectionpool class to connect to the MSSQL 2000 by changing the parameters. JDBCDriver=com.microsoft.jdbc.sqlserver.SQLServerDriver JDBCConnectionURL=jdbc:microsoft:sqlserver://MSSERVER:1433 ConnectionPoolSize=5 ConnectionPoolMax=10 ConnectionUseCount=5 ConnectionTimeout = 2 User=mssql Password=mssql I read the ... |
27. SQL Server 2000 and JDBC,Registering cursor as OUT param coderanch.comHi Jules! First of all thanks a lot for the reply,I really appreciate. The problem out here is that we are dealing with migration of an Oracle DB to SQL Server.We have a code base of almost a thousand java files.I want to retain the same way of writing the procedures because if I change them, you know whats waiting for ... |
28. SQL Server 2000 Personal Edition coderanch.comHi all, Sorry to trouble u because this is not regarding java I am developing small software in java. I am using sql server 2000 personal edition as my data base. Some one told me that it is free and you can download it from the web. Is it true ? If it is can any one tell me where to ... |
29. SQL Server 2000 Return Value coderanch.comI used a stored procedure to add a record to the SQL Server 2000 DB, In my stored procedure I want to return the ID if the record has been successfully added, /********************************************************* statement = con.prepareCall("{?=call spAddEmployee(?, ?)}"); statement.registerOutParameter(1, Types.INTEGER); statement.setString(1, ...); ... int result = statmemt.executeQuery(); My spAddEMployee: CREATE PROCEDURE dbo.spAddEmployee( @ID char(20), @Name, char(30) ) declare AS INSERT INTO ... |
30. problem with preparedStatement with SQL Server 2000 coderanch.comi developed an app using MSAccess (for proof of concept only) works beautifully but i need to port to SQL Server 2000 (version 8.0 enterprise edition) i'm having some problems -- sometimes things work other times not for example: the following code gets "STuck" System.out.println("site and amt " + siteauth + amtauth); String preparedFinSQL = "SELECT finauth FROM Nyhfine WHERE fincls ... |
31. connected sql server 2000 coderanch.com |
32. different between inner join and outer join in MS SQL2000 coderanch.com |
33. Need JDBC Program for SQL server 2000 coderanch.com |
34. retrieving value from SQL Server 2000 stored procedure coderanch.comHi every body I want to execute an query in stored procedure and after some calculation I want to retrieve some value which is specified by variable i in the follwing stored procedure. CREATE procedure spTemp @i as int OUTPUT as --select * from customer ...... ...... ...... select @i=3; GO Follwing is the code snippet for retrieving values from stored ... |
35. JDBC with SQL server 2000 coderanch.com |
36. MS SQL Server 2000 - sp_cursorclose Issue coderanch.comHi, We have an issue with Microsoft SQL Server 2000, we connect to MS SQL Server 2000 SP 4 from WAS 6 using Microsoft type 4 JDBC Driver and as transactions happen, there is a lock caused by sp_cursorclose which stays locked for close to 5 hours causing the whole database inaccessible. The other database server is being locked by system ... |
37. Self Blocks with SQL Server 2000 SP 4 coderanch.comHi all, Am using MS SQL Server 2000 SP4 and having few issues with Deadlocks happening in my Database. My Block Logs mention that the Blocker (sp_cursorclose) and the Blockee (my query)have the same process ID, this is reported as a bug with MS SQL Server and has been fixed with Service pack 4. However the Fix says that it is ... |
38. JDBC with MS SQL 2000 coderanch.com |
39. SQL Server 2000 Database Connection using JDBC coderanch.comHello Friends, I had wrote a programme for connecting the Sql Server 2000 DataBase using JDBC.Programe code is import java.sql.*; public class createTable { public static void main (String[] args) { DB db = new DB(); Connection conn=db.dbConnect( "jdbc:sqlserver://localhost:1433/tempdb","sa","manager"); db.createTables(conn); } } class DB { public DB() {} public Connection dbConnect(String db_connect_string, String db_userid, String db_password ) { try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); ... |
40. Need to add a check constriant to SQL2000 coderanch.comI have the following table definitions. Message.fkDiscussionID is a foreign key linked to Discussion.pkDiscussionID. fkDiscussionID is not a unique value, so many rows can have it set to the same value. I want to do is add a contraint that says, "if fkDiscussionID of a new or existing updated row is equal to any existing row's fkDiscussionID, that only one row ... |
41. Calling a stored procedure for MSSQL 2000? coderanch.com |
42. Server Start (SQL2000) coderanch.comGee i suck at English too. Okay let me try being clearer. Okay in Netbeans you can create a Client/Server application right? Now in my 3Days Project. I must create a client server application, obviously for my client to retrieve eg...A list of music artists from SQL It must ask my server side. So now that same Java/Server App i created ... |
43. Wrong time retrieved in the resultset- MS SQL Server 2000 coderanch.comHi, I am using jtds-1.1.jar as a SQL Server Driver to connect to MS SQL Server 2000. I have the following 2 columns in a table. Job_Start_Time(datetime,null) | Job_End_Time(datetime,null) ------------------------------------------------------------------------ 1900-01-01 20:00:00.000 | 1900-01-02 04:00:00.000 When I try to retrieve this data using rs.getTime("Job_Start_Time") and rs.getTime("Job_End_Time"), I am getting it 20:23:20 and 04:23:20 respectively. Can anyone let me know the workaround ... |
44. SQL Server 2000 connectivity error coderanch.comHi I am using SQL Server2005 for my web application development. I am using the driver "com.microsoft.jdbc.sqlserver.SQLServerDriver" to connect the database. I am able to connect the database and also tested it on dev environment. I need to deploy this on a test machine where the database is SQL Server2000. When I deploy this application on that test machine i am ... |
45. SQL Server 2000 and returning results coderanch.comOkay, this is not a new problem...I am sure of that :-) I have created a store procedure in SQL Server 2000. The procedure is tested and is working. Now I am attempting to call the procedure and get the results. The results are not a resultset. I have an output parameter and a return code for success. proc = connection.prepareCall("{? ... |
46. migration from MS sql 2000 to MS sql 2008 coderanch.comat org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473) at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceControl ler.java:837) at $Proxy17.start(Unknown Source) at org.jboss.system.ServiceController.start(ServiceController.java:367) at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher. java:60) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53) at org.jboss.mx.server.Invocation.invoke(Invocation.java:86) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker. java:185) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473) at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176) at $Proxy31.start(Unknown Source) at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:31 3) at org.jboss.deployment.MainDeployer.start(MainDeployer.java:836) at org.jboss.deployment.MainDeployer.start(MainDeployer.java:828) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:645) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:608) at sun.reflect.GeneratedMethodAccessor11.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher. java:60) ... |
47. BlueJ and SQL Server 2000 java-forums.org |
48. image retrieving from sql server 2000 forums.oracle.com |
49. JDBC for MS SQL Server 2000 forums.oracle.comHi all, i'm newbie here and i have some problems doing with Java for my Final Project, just for my graduation... Here's the problem ... First i install the JDK 1.5 and MS SQL Server 2000. And then i also install JDBC for MS SQL Server 2000 sp3. Than i'm doing some experiments with JDBC, but its result error that i ... |
50. How to make Pet Store run on JBOSS using SQL Server 2000? forums.oracle.com |
51. MSSQL 2000 to java connection problem Problem forums.oracle.comHi All... I use the Mssql 2000 personnal edition and Download the Driver from MICROSOFT Site. MSSQL and Driver are loaded my system but when i run a java program for connectivity i got some error message like this Before Connection Es Connection Es jdbc:microsoft:sqlserver://localhost:1433;databaseName=exmp;selectMethod=cursor; java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for user 'kamlesh'. Reason: Not associated with a trusted ... |
52. store&read chinese characters in MS SQL server 2000 using Java forums.oracle.comHi, I have a problem to store Chinese characters in MS SQL Server 2000, storing question marks(??????) instead of Chinese characters I am using JSF framework, SUN APPLICATION Server 9.1 , MS SQL Server 2000 server and Microsoft data source driver class (com.microsoft.sqlserver.jdbc.SQLServerDataSource) to connect db. I have one solution: IN JSP: <%@page contentType="text/html"%> <%@page pageEncoding="UTF-8"%> and ... |
53. SQL Server 2000 Jdbc connection forums.oracle.com |
54. JDBC connectivity problem with MSSQL 2000 forums.oracle.comSir, I have a dabase (master file) in MSSQL 2ooo, i want to connect with my java program JDBC driver manager. But it gives error at the time of RUN, its class file have already made.I am giving its out put results as given below plz tell me how to solve this error.... C:\java>javac testConnection.java C:\java>java testConnection java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver at java.net.URLClassLoader$1.run(Unknown ... |
55. RowSet example using java and SQL SERVER 2000 forums.oracle.com |
56. SQL Server 2000 Reporting withJava forums.oracle.com |
57. problem with mssql server 2000 sp 4 forums.oracle.com |
58. SQL server 2000 with Java Problems forums.oracle.comI am a new user for SQL server 2000 with java. Nevertheless, I developed an application for store images and text data into SQL 2000 database using java. Presently my system is running 12-client computer with one server computer, I installed SQL server 2000 into server then I access (save, insert, select, and get report) through ODBC diver to server using ... |
59. JDBC Paging using MS SQL Server 2000 forums.oracle.com |