Member Avatar for sam1981

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.

  • 2 Contributors
  • 2 Replies
  • 113 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by sam1981
Member Avatar for bkendall

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

<cfquery name="qname" datasource="dbname">

instead of

<cfquery name="qname" datasource="#session.dbsource#">

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

Thanks

Member Avatar for sam1981

Hi,

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

Sam.x.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.