Skip to main content
J
jgonzalez144
Participant
April 26, 2009
Question

Data Sources error:[Macromedia][SQLServer JDBC Driver]No more data available to read.

  • April 26, 2009
  • 1 reply
  • 2539 views

I have just set up the developer edition coldfusion and a standard SQL Server. When trying to set up a datasource i recieve the following error:  [Macromedia][SQLServer JDBC Driver]No more data available to read. I have no clue what this means. I have tried to find some documentation on this but with now luck. Can anyone help?

Here are some details:

SQL SERVER CONNECTION MANAGER:

  • Trying to connect to a localhost sql server
  • I have TCP/IP Enabled
  • Dynamic Ports is set to 0 under IP ALL
  • 127.0.0.1 is enabled and the port is set to 1433

COLDFUSION ADMIN:

  • server: 127.0.0.1
  • port 1433
  • username/password set to null (using windows authentication)

Has anyone ran in to this issue?

Thanks for helping.

    This topic has been closed for replies.

    1 reply

    Michael Borbor
    Michael Borbor
    Inspiring
    April 26, 2009

    As far as I know you can connect to SQL using windows credentials, because

    the way CF works you'll need to provide sql credentials in order to have

    access to your DB.

    J
    jgonzalez144Author
    Participant
    April 26, 2009

    Hmm, Ok I will try and set up this database to a sql authentication. Cross fingers

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices