Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
adityamadisetty
Starting Member
1 Post |
 Posted - 2006-05-04 : 00:32:18
|
| Hi'I want to copy data in tables of one database to tables in another database,like keeping data backupconnections strings for these 2 connections were written in 2 database filesi included them in an asp page with the fallowing dataopenConn()openconn2() bcpquery = "insert upsselector_backup.dbo.upsselector1 (device,va,deviceType) select (device,va,deviceType) from upssolutions_com_au.dbo.upsselector" if inAction="backup" then response.Write bcpquery if (bcpQuery<>"") then conn2.execute(bcpQuery) end if%> </table></td></tr> <%if inAction="backup" then 'conn.execute(updQuery)%> <tr><td> <br>Successfully updated the Prices.</td></tr>i used this querry and resulted in an errorMicrosoft OLE DB Provider for SQL Server error '80004005' [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied |
|
|
|
|
|
copying dta from tables of one database to tables