Re:CFMX and MSDE

[Robert Everland III]

I am using MSDE with an ip address 127.0.0.1 to be exact, I'm using a native SQL login of sa. I did the same thing with the ODBC driver and it connected. I was wondering if there is an update or something. It's just my personal machine I am having issues. I have also installed the latest Java SDK 1.4.2_01 . I would like to be able to use the driver with the most performance if at all possible, especially if there could be some issues between using the 2 different drivers.

Bob

>> I have installed MX 6.1 and MSDE SP3. Now I can connect with
>> an ODBC datasource, but I can't choose Microsoft SQL Server
>> as the datasource. When I try to connect to the server it says:
>>
>> Connection verification failed for data source: test
>> []java.sql.SQLException: [Macromedia][SQLServer JDBC
>> Driver]Error establishing socket. Connection refused: connect
>> The root cause was that: java.sql.SQLException:
>> [Macromedia][SQLServer JDBC Driver]Error establishing socket.
>> Connection refused: connect
>>
>> So I have had to use ODBC socket, which while it works I
>> would like to know why the above mentioned does not work. The
>> ODBC datasource connects the exact same way, but it is able
>> to make a connection.
>
>There are several limitations within JDBC that may cause this. You need to
>use TCP/IP to connect, instead of Named Pipes, you need to have a native SQL
>login within your database instead of using Windows Authentication, if
>you're using SQL Server 2000 with multiple instances you need to have SQL
>Server SP2 I think.
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>voice: (202) 797-5496
>fax: (202) 797-5444
>

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---