Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
quote:Not so much really. The "connection" isn't really the issue but, as Kronin555 pointed out, there are different "flavors" of SQL, so you would have to make your code as vanilla as possible, which would mean that you would not be able to take any advantage of your particular DBMS and its built in functions. Things like string and date functions differ widely between databases, and you would have a very hard time making your CF code portable.
You could design your application around an ODBC connection.
Copy link to clipboard
Copied
quote:
Originally posted by: tapping
I have created a Coldfusion application. I need for the users to use different database connections besides just SQL Server(our database at the office where I work). Can you configure Coldfusion to use any other database besides just SQL Server. We need to tell Coldfusion which database the user is using, and program ahead.
Thank you in advance.
Copy link to clipboard
Copied
Copy link to clipboard
Copied
quote:
Originally posted by: tapping
We will have the following situation:
Standard configuration is Coldfusion accessing SQL Server via DSN setup in Coldfusion.
We need to support users who may want to use MySQL, SyBase AnyWhere, or Oracle.
Can we tell ColdFusion via a configuration item which database type to use? Or do we need to configure this when we install coldfusion at our customer’s location?
Copy link to clipboard
Copied