ODBC Socket Connection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lynda - 25 Oct 2007 18:10 GMT

Can anyone tell me why I would run into the following error when using an ODBC
Socket Connection vs the MS SQL Server driver?

"ByteArray objects cannot be converted to strings."

I am using a SQL uniqueidentifier as a folder name I want to direct users to.
On my remote sql server I use the sql driver. On my local sql server I use the
socket connection (I cannot get the sql driver to work). All works as expected
if I use my remote connection. The local gives the error above.

Reply to this Message

cf_dev2 - 25 Oct 2007 18:23 GMT

Sounds like its returning the UUID as some type of binary value, not a string.
Until you get your JDBC connection working...what happens if you explicitly
CAST the value as a varchar/char in your query?

Reply to this Message

Lynda - 25 Oct 2007 20:08 GMT

Converting the value in the query solves that problem but I am running into several other problems that seem to be related to the socket connection.

Reply to this Message

cf_dev2 - 25 Oct 2007 20:23 GMT

I don't use ODBC Socket but that wouldn't surprise me. The JDBC connection is definitely the way to go. I know you're still working on it ..

Reply to this Message

Lynda - 25 Oct 2007 21:54 GMT

I can't get the JDBC to work. I get the following error:

"No suitable driver found for jdbc:microsoft:sqlserver://MIWEB/MIWEB:1433"

URL: jdbc:microsoft:sqlserver://MIWEB/MIWEB:1433;
Driver class: macromedia.jdbc.MacromediaDriver

I recently upgraded to CF 8. Is there something I have to setup first before
using the JDBC connection?

Reply to this Message

cf_dev2 - 25 Oct 2007 22:10 GMT

I haven't done an "upgrade" but it should install the drivers automatically.
They're usually found in in c:\coldfusion8\lib\macromedia_drivers.jar.

On the datasource page are you selecting sql server from the list of drivers
or are using type "other"?

Reply to this Message

Lynda - 25 Oct 2007 22:17 GMT

I've tried both. I tried the SQL Server driver and other with the settings in my last message.

Reply to this Message

cf_dev2 - 25 Oct 2007 23:04 GMT

> jdbc:microsoft:sqlserver://MIWEB/MIWEB:1433;

Do you have your slashes reversed, or is CF just garbling the url in the error message?

ServerName \ InstanceName

Reply to this Message

Lynda - 26 Oct 2007 14:11 GMT

I have tried the slashes both ways. No luck.

Reply to this Message

Webmaster Forum / ColdFusion / Database Access / October 2007

ODBC Socket Connection