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"
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.
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...
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.
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 ?
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.
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
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.
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?
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.
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
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.
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
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:
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.
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");
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?
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
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.
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.
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
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?!
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.
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.
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.
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.
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
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!
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?
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
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
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 ?
