Try this <cfquery name="queryname" datasource="datasource" server="servename" username="username" password="password">
-----Original Message----- From: Dina Hess [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 12:01 PM To: CF-Talk Subject: Re: DBAs/SQL Server experts? > try and do a solid connection and see if it works....i.e. > > <cfquery name="queryname" > datasource="datasource" > username="username" > password="password"> > > select * from table > > </cfquery> Tried that already, but I'll give it another go. Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4