I have 2 MS SQL datasources connected in the ColdFusion Administrator, no problem.
Today, I went to go add a new Postgres datasource. I had to use 'other' as the type, and I had to install the postgres .jar file onto the server, and point to it (/opt/coldfusionmx/lib/) on the Java and JVM page of the administrator. It worked fine.
BUT since I did that, all of a sudden my 2 MS SQL datasources are giving me this error:
No suitable driver available for RISK, please check the driver setting in jrun-resources.xml, error: com.microsoft.jdbc.sqlserver.SQLServerDriver
Did I mess something up by adding the postgres JDBC driver? How do I get them both to work?
Thanks!
Today, I went to go add a new Postgres datasource. I had to use 'other' as the type, and I had to install the postgres .jar file onto the server, and point to it (/opt/coldfusionmx/lib/) on the Java and JVM page of the administrator. It worked fine.
BUT since I did that, all of a sudden my 2 MS SQL datasources are giving me this error:
No suitable driver available for RISK, please check the driver setting in jrun-resources.xml, error: com.microsoft.jdbc.sqlserver.SQLServerDriver
Did I mess something up by adding the postgres JDBC driver? How do I get them both to work?
Thanks!