what DB are you using... MSSQL, mySql?
----- Original Message ----- From: "Mik Muller" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Friday, November 10, 2006 3:08 PM Subject: Re: restoring a db without an existing odbc connection > Ok. I gave up on trying to restore through code. Did it manually and have what I think is a working DB, but I cannot connect through CF > > Connection verification failed for data source: NemoManager > java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect > The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect > > Any ideas? Do I have to update Java or something? Sorry, I'm a little dense when it comes to server stuff and Java. > > Windows 2003 Server Enterprise > MS SQL Server 2005 > CF 7 > > Thanks, > > Michael > > > > At 02:55 PM 11/10/2006, Mik Muller wrote: > > >Sample code I'm using: > > > ><cfquery name="qr" datasource="#request.ds#"> > > RESTORE DATABASE [#theDBName#] > > FROM DISK='#request.BackupDBFolder#\#theBaseDB#.bak' > > WITH > > MOVE 'master_default_dat' TO '#request.SitesDBFolder#\#theDBName#.mdf', > > MOVE 'master_default_log' TO '#request.SitesDBFolder#\#theDBName#.ldf' > ></cfquery> > > > > > > > >At 02:21 PM 11/10/2006, Mik Muller wrote: > >>To: cf-talk@houseoffusion.com > >>From: Mik Muller <[EMAIL PROTECTED]> > >>Subject: restoring a db without an existing odbc connection > >>In-Reply-To: <[EMAIL PROTECTED]> > >>References: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> > >> > >> > >>Hey all, > >> > >>I'm looking for a way to restore a db as the first db in an application I have written. The app normally restores DBs as a way of automatically creating new sites, but if this is a new box and code determines the main manager DB doesn't exist, how does one restore a DB... without an existing ODBC to connect to the DB server through? I'm talking specifically about SQL Server on Win2003. > >> > >>Any advice? > >> > >>Thanks, > >> > >>Michael > > > >-------- > >Michael Muller > >Admin, MontagueMA.net Website > >work (413) 863-0030 > >cell (413) 320-5336 > >fax (518) 713-1569 > >skype: michaelBmuller > >email [EMAIL PROTECTED] > >http://www.MontagueMA.net > > > >Eschew Obfuscation > > -------- > Michael Muller > Admin, MontagueMA.net Website > work (413) 863-0030 > cell (413) 320-5336 > fax (518) 713-1569 > skype: michaelBmuller > email [EMAIL PROTECTED] > http://www.MontagueMA.net > > Eschew Obfuscation > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259957 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
