[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name

I realized after further study that the connection string that was in CF Admin was pointing to the master DB instead of Blinkey.  I changed that  and now I getting the error below:

• Connection verification failed for data source: Blinkey
  java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database "Blinkey" requested by the login. The login failed.
  The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database "Blinkey" requested by the login. The login failed.

I read somewhere that if you set the authentication to both Windows and SQL authentication (in SSMS) then you don't enter a username and password in CF Admin.

Some suggestions:

1) Verify that there exists a table named OWContacts in the database that you registered in the Blinkey datasource. Is the name of the table perhaps OWContact ?  Was the database made case-sensitive?

2) Add try/catch as follows, and share the dump with the forum:

<cftry>

    <CFQUERY NAME="GetUser" DATASOURCE="Blinkey">

        SELECT *

        FROM OWContacts

        WHERE UserLogin  = <cfqueryparam cfsqltype="cf_sql_varchar" value="#Form.UserLogin#">

        AND UserPassword = <cfqueryparam cfsqltype="cf_sql_varchar" value="#Form.UserPassword#">

    </CFQUERY>

    <cfdump var="#GetUser#">

<cfcatch type="any">

    <cfdump var="#cfcatch#" >

</cfcatch>

</cftry>

There are some things you are not saying, which may help us help you:

• what "object" did it report was invalid? it could be the table name or the column names (or both)
• is the sql server being called from CF2018 the exact same one called from CF9? And is it the same database? and using the same user defined in the CF Admin (of both CF9 and 2018)?

If you did change to using a new SQL Server instance, you may be assuming that things on the "new" sql server are configured the same as the "old", but they may not be.

• for instance, it could be that user set in the CF Admin (for the DSN) is defined in the "new" server to not have the same default schema as was true for that user on the "old" server 
• this is another reason why I'm asking what object it errors on. Or is there no named object?
• have you tried just prefixing the table name with "dbo.", as in "dbo.OWContacts"? That's a traditional schema, which may work for such an old code base. But it may not work, fi your schema names are different (in sql server, for that database)
• If that does work, then obviously you won't want to change all your code.  Again, the solution is to change that user in sql server to use that schema as their default for the table (or you may be able to change it for the table. I will leave others to elaborate on options)

If none of the above help, and especially if the error message doesn't identify the object, another option would be to copy this code into a new test page and run it from there. You could take out all but the cfquery, of course. And you could put in some sample values for the values that were to be passed in as variables. If you do that, do you get the same error?

• what if you then take out the where clause? (you may want to change the "select *" to a "select count(*)", so that it doesn't return ALL rows and cols, but instead just a count of the number of rows)

Those are a few thoughts to try to get you started.