"guian@att.net" wrote:

> I'm trying to connect to a local SQL Server 2000 'Personal Edition'
> running on Windows XP Professional. I've tried everything, and
> searched the forums for similar problems, but I can't get the
> connection to work... :(
>
> Using jdbc, with the follwing URL
>
> jdbc:microsoft:sqlserver://localhost:1433;databaseName=mydb;
>
> I call:
>
> DriverManager.getConnection(url, userName, password)
>
> and I get the following:
>
> jdbc:microsoft:sqlserver://GS-DELL:1433;databaseName=gpldb;
> SQLState: 08001
> code: 0
> Error establishing socket.
> Connection refused: connect
> Error establishing socket.
>
> I've also tried using ADO but I 'Login refused: Not associated with a
> trusted connection'
>
> However, Query Analyzer connects just fine, and I can even use ISQL
> with no problem from a DOS command prompt!!
>
> I have set Mixed Authentication (SQL Server and Windows) for the
> server, and I've confirmed my user/psw about 6 times (Query Analyzer
> has no problem accessing the database...)
>
> Please help! Any suggestions???
>
> Are there some restrictions with SQl Server Personal Edition on XP???
>
> Posted Via Usenet.com Premium Usenet Newsgroup Services
> ----------------------------------------------------------
> ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
> ----------------------------------------------------------
> http://www.usenet.com