Re: Bug with instanceName property?



I am sorry the previous message is not legible for some reason. trying
again:

The only thing I can think of is that the Sql server 2000 you have installed
on that machine at port 1433 has a user=sa, password=123 and it does not
have a database called cc.

What do you get when you try the following:
jdbc:sqlserver://ITH:1433;user=sa;password=123;
jdbc:sqlserver://ITH:1433;forwardReadOnlyMethod=direct;user=sa;password=123;
jdbc:sqlserver://ITH:1433;forwardReadOnlyMethod=direct;databaseName=cc;user=sa;password=123;

what about this:
jdbc:sqlserver://ITH;instanceName=SQLSERVER2005;user=sa;password=123;
jdbc:sqlserver://ITH;instanceName=SQLSERVER2005;forwardReadOnlyMethod=direct;user=sa;password=123;
jdbc:sqlserver://ITH:;instanceName=SQLSERVER2005;forwardReadOnlyMethod=direct;databaseName=cc;user=sa;password=123;


.



Relevant Pages

  • Re: If ACCESS 2002 is the back end database for VB6, then should I use ADO???
    ... Say the app is a home movie or CD database. ... Access would be fine for that and there's no reason to think you'd EVER need to switch from Access. ... Now, if the application were used in a corporate environment with concurrent users, I'd stay away from an Access backend from the very beginning even if Access would meet requirements for the forseeable future (I'd probably go with MSDE since it upgrades very nicely and easily to SQL Server). ...
    (microsoft.public.vb.general.discussion)
  • Re: tool to re-reference forms after usizing?
    ... The reason we are upgrading is the database was originally built in access ... reports and about 1000 queries i dont really want to be going through them ... >> I am in the process of upsizing an access database to sql server. ...
    (microsoft.public.access.conversion)
  • Re: OK, stupid question about picture managment programs...
    ... I'm a Windows developer, ... But it's all the more reason you might want to be a beta tester. ... I had thought of just adding another table to the ThumbsPlus database. ... I'm also toying with the idea of purchasing Thumbs Plus and running it against SQL Server rather than Access. ...
    (rec.photo.digital)
  • Problem creating a new task
    ... I am using Project 2000 and have a project stored in a SQL Server ... database. ... Prev by Date: ...
    (microsoft.public.project)
  • Uploading downloading Image to SQL Server using ASP.net and VB.Net
    ... including the image to the SQL server. ... Microsoft application block's to insert the ... data to the database. ... Prev by Date: ...
    (microsoft.public.dotnet.framework.aspnet)

Loading