I've only set up a SQL datasource a few times and haven't yet had any
luck doing it from the CF Administrator. On the Administrator's 'Edit
ODBC Datasource' page (in CF 4.0.1 anyway), under 'Login Info' there's
form field where you can fill in the database.
One other thing that tripped me up recently is that even if you've enter
a username and password for the ODBC datasource within the control panel
applet, you still have to enter them in CF's ODBC setup.
Jim
-----Original Message-----
From: avex <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Date: Sunday, September 24, 2000 8:39 PM
Subject: Re: access to SQL server woes
>
>Hi Jim...
>thanks for your answer.....
>it fixed the problem!
>
>I never even entered the ODBC setup....which of course set the default
value
>to "master".
>
>but just a qustion.....i didn't think i had to set it up within the
ODBC
>setup?
>I thought I could just do it within cold fusion....at least that is
what i
>have been doing.....
>
>So when i setup datasources do i do it through the ODBC setup, and then
in
>CF admin?
>
>thanks
>chad
>
>
>> I recently got this error when I failed to change the default
database
>> during the ODBC setup. If you do the ODBC setup from the control
panel,
>> and within the setup wizard you fail to notice this step, then you're
>> likely pointing your ODBC datasource at the 'master' database. I
>> believe the wizard presents a drop-down box that shows all of the
>> databases on the server.
>>
>> Jim
>>
>>
>> -----Original Message-----
>> From: avex <[EMAIL PROTECTED]>
>> To: CF-Talk <[EMAIL PROTECTED]>
>> Date: Sunday, September 24, 2000 7:48 PM
>> Subject: access to SQL server woes
>>
>>
>> >hi everyone.....
>> >
>> >sorry if this is kid stuff......but i finally decided to make the
jump
>> from
>> >access to SQL server on one of the applications i have done.....
>> >
>> >I used the import wizard in the SQL enterprise manager...and from
the
>> look
>> >of it it imported all the tables and content correctly...
>> >
>> >I set up the sql datasource in the cold fusion administrator...
>> >changed my datasource name to point to the new datasource...
>> >
>> >and at this stage i thought it was suprisingly easy....
>> >and then i ran my templates and i got errors....
>> >
>> >from this query:
>> ><cfquery name="lastupdate" datasource="#datasource#" dbtype="ODBC">
>> >SELECT *
>> >FROM lastupdatetable
>> ></cfquery>
>> >
>> >I got this error:
>> >ODBC Error Code = S0002 (Base table not found)
>> >[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
>> >'lastupdate'.
>> >The error occurred while processing an element with a general
>> identifier of
>> >(CFQUERY), occupying document position (4:1) to (4:105) in the
template
>> file
>> >D:\INETPUB\WWWROOT\CITY\DATABASE\REVIEW.CFM
>> >
>> >Is there something else I need to do......
>> >is it obvious what i am doing wrong......
>> >any help is greatly appreciated.......
>> >
>> >thanks
>> >chad
>>
>>
>> ---------------------------------------------------------------------
-----
>----
>> Archives: http://www.mail-archive.com/[email protected]/
>> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
>send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
>the body.
>>
>
>
>-----------------------------------------------------------------------
-------
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
