Hi,

can anybody out there tell me how to set up a datasource in the cfadmin and use the datasource attribute instead of the connectstring attribute?

I need to do this because it happens to be that my client for which i have developed a web based database for is running CF5 or below and need to transfer the filkes over to a server which has a later version of coldfusion.


Im a novice developer hence this is all jargon to me!

Is there anybody out there that can help?

Sam.x.

Setting up the database is just a matter of clicking the data sources link under Data & Services in the menu on the left (cfMx). From here all you need to do is select the data base type from the drop down and type the name of the db.

As for data base attribute I am guessing you are referring to using [HTML]<cfquery name="qname" datasource="dbname">[/HTML] instead of
[HTML]<cfquery name="qname" datasource="#session.dbsource#">[/HTML]

Let me know is this is what you were looking for.

Thanks

Hi,

Thanks for your help. The web application is working successfully now.

Sam.x.