Ah ha.. That explains things.. Can you enable this for CFMX1017 Please !! George
----- Original Message ----- From: "Snake Hollywood" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, October 19, 2003 2:53 PM Subject: RE: [ cf-dev ] Problems with access and odbc's > From the user guide > > Adding a DSN > > (Your database must be uploaded first into the /db folder) > > go to the DOMAINS menu and select your domain, and click the ADVANCED > SETTINGS icon. > Now click ODBC DSN's > Click ADD NEW > Microsoft Access should be checked. This is the only type of database > you can choose unless you have purchased an SQL Server database. > Click next. > Now give a name for your DSN and select your database file. > NOTE: Because of the way CFMX handles DSN's we need to manually enable > your DSN in the ColdFusion Administrator after you have created it. SO > please contact support with your account Number and DSN after you have > set it up. > > > > -----Original Message----- > > From: Jens Anders Bakke [mailto:[EMAIL PROTECTED] > > Sent: 19 October 2003 14:18 > > To: [EMAIL PROTECTED] > > Subject: Re: [ cf-dev ] Problems with access and odbc's > > > > > > It has to be set up by the administrator? oh.. haven't read > > that part of > > any instructions.. > > > > Ellwood wrote: > > > > >Have you asked for the odbc to be setup by the administrator? I had > > >similar probs because I did not read the instructions at all. > > > > > > > > >-----Original Message----- > > >From: Jens Anders Bakke [mailto:[EMAIL PROTECTED] > > >Sent: 19 October 2003 13:25 > > >To: [EMAIL PROTECTED] > > > > > >Hi! > > >I've added an ODBC(dsn) to my account, but it seems to be something > > >wrong with it.. > > >Cause.. it gives an error no mather what you try to do with the db.. > > >either it's SELECTing data or INSERTing data.. > > > > > >www.enzomnia.net << there's the error... > > > > > >and here's the code.. >> > > > > > ><cfquery name="qGetPageSetup" datasource="#Request.Source["Name"]#" > > >username="#Request.Source["User"]#" > > password="#Request.Source["Pass"]#"> > > >SELECT Page_Name, Page_ID, Page_Center > > >FROM Pages > > >WHERE Sec_URL_String = <cfqueryparam cfsqltype="cf_sql_char" > > >value="#URL.sec#"> > > >AND SubSec_URL_String = <cfqueryparam cfsqltype="cf_sql_char" > > >value="#URL.SubSec#"> > > ></cfquery> > > > > > > > > >Looking away from this issue.. the server is SWEEET!! :) > > > > > >- Jens Anders Bakke > > > > > > > > > > > > > > > > > > > > > > > -- > > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: > > [EMAIL PROTECTED] For human help, e-mail: > > [EMAIL PROTECTED] > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
