>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]
