Posted - 05/04/2006 : 00:32:18
I want to copy data in tables of one database to tables in another database,like keeping data backup
connections strings for these 2 connections were written in 2 database files
i included them in an asp page with the fallowing data
bcpquery = "insert upsselector_backup.dbo.upsselector1 (device,va,deviceType) select (device,va,deviceType) from upssolutions_com_au.dbo.upsselector"
if inAction="backup" then
if (bcpQuery<>"") then conn2.execute(bcpQuery)
<%if inAction="backup" then
<tr><td> <br>Successfully updated the Prices.</td></tr>i used this querry and resulted in an error
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied