April 20, 2005 at 12:51 am
is it possible to back up from a data base (SQL)
on a VB program
with out any source code of its VB program ?
April 20, 2005 at 6:35 am
I hate to say this but Hunh??!?!?! Are you asking is it possible to restore a VB application with a SQL BACKUP/RESTORE?
Good Hunting!
AJ Ahrens
webmaster@kritter.net
April 21, 2005 at 6:56 am
No that's not what he's after. There was a second post and if I think I've got it, he has a VB app point to a SQL Server database and he wants to move the DB from the existing server machine to another machine. VB source is not available.
Unless something "out there" was done in the VB app, assume the VB app connects to the DB using ADO or DAO. Embedded in the VB app is probably a connection string, unless the developers decided to store this in a registry setting or some other external support file. If this is the case, you're in luck -- just find the registry entry or wherever the connection string is and point it to the new SQL Server. Otherwise, you're probably stuck with the existing connection string. If this is the case you can move the SQL database but the new "target" machine will have to have the same name and more than likely the same IP address as the existing server. The SQL database(s) will also require the same name. That way if you have an embedded connection string like ""Provider=SQLOLEDB.1;Initial Catalog=MYDB;Data Source=MYSERVER" the string will still point to the right server/database.
Hope this helps a bit... Steve
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply