CF7 (Linux) & SQL2k "No more data available to read"

[Oblio]

Suse 9.2 & CFMX7 (+hf2 & new drivers)
cannot connect to:
Win2k SP4 & SQLENT2k SP4

The reason is always "No more data available to read" - my SQL server says the
connection opened, but the login packet was invalid.

[Oblio]

:| I believe that SQL Server SP4 breaks JDBC driver support. Can anyone confirm?

[cfstubborn]

I am having a similar problem with CFMX6.1 on my laptop where SQLSERVER2K
desktop is installed. I can get the administrator to verify the datasource, but
a cfquery returns "[Macromedia][SQLServer JDBC Driver]No more data available to
read." I updated my drivers, and even referenced the SQL error online. It
references an issue with the connection being dropped. I walked through the
account settings for the SQLSERVER account and everything seems fine. In
addition, I can connect fine to another SQLSERVER2K datasource on a remote
server using the same laptop Cold FUsion server. Please help!

[Oblio]

See, I can't even get the admin to verify, with default CF driver or MS JDBC.

Please post your versions and service pack levels so we can compare.

[cfstubborn]

I created an ODBC datasource to get around the problem. You can do this with
your administrator tools(this is under the system DSN tab). You will see
options on different types of databases. Doubkle click the one that says its
for SQLServer, and walk through the options (you will be prompted for the user
account info during the process). After you test it, go back to CFADMINISTRATOR
and connect over ODBC

I do not use SP2 on my Windows box because it prevents me from accessing an
intranet that I use. Otherwise, I have updated my computer thorouhly. Cold
Fusion MX 6.1. SQLServer 2000 Desktop engine.

I had to check the connection priveledges for my connection role also. See my
other post similar to my original reply in this thread under database
connection problems

[Oblio]

Thanks, but I think you're missing my point. I'm unable to connect a Linux box
to the database. All those options are unavailable to me.

When I say "SP", I'm not talking about the OS (which you don't mention, but
by sp2, I assume you're on XP), I'm talking about the SQL Server's patches.

[Oblio]

Anyone have any insight?

[Oblio]

per the microsoft.public.sqlserver.jdbcdriver newsgroup:

The Microsof SQL Server 2000 Driver for JDBC does not support SSL
encryption.

There was an issue prior to Service Pack 4 for SQL Server 2000 where the
JDBC driver was able to connect to a SQL Server database even though the
"force protocol encryption" option was set on the server. The SQL Server
would incorrectly allow an unencrypted connection with the JDBC driver.

In Service Pack 4 for SQL Server 2000 this was fixed so that only clients
that support SSL can connect to the server if the "force protocol
encryption" option is set on the server. This will exclude the JDBC driver
since it does not support SSL and you will receive an error on the client.

Thanks,
Kamil


Kamil Sykora
Microsoft Developer Support - Web Data

[Oblio]

More information:

If anyone is looking for a JDBC driver that can support SSL, I had success with [url]http://jtds.sourceforge.net/[/url]. I had to use the ssl=request parameter, but everything looks good.

[PaulH]

and its quicker than some other drivers.