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.
