How do you connect Multi_script to a CE database.

Single-click script execution on multiple SQL Servers.

Moderators: JonathanWatts, Anu Deshpande, dlkj, Colin Millerchip, Michelle Taylor

How do you connect Multi_script to a CE database.

Postby johnc650 » Fri Apr 17, 2009 12:09 am

I was reading this article about reading the windows CE database using multiScript.. http://www.sqlservercentral.com/articles/Backup/61968/.

One thing it did not explain was how to connect to a CE database with MultiScript..

I don't see any way to connect anything but a normal sql database... Am I missing something??

-jfc-
johnc650
 
Posts: 10
Joined: Tue Feb 05, 2008 9:45 pm

Postby Brian Donahue » Fri Apr 17, 2009 11:32 am

Hi John,

SQL Multi-script supports Microsoft SQL Server databases only -- it currently doesn't have CE or ODBC capability. The theme of the article that you linked to was about how to retrieve backup history from a SQL Backup data repository, which is a SQL CE database, but is being accessed via T-SQL queries that are sent to a SQL Server.

These queries use the sqbdata extended stored procedure, which is getting the SQL CE data from the repository and feeding the results through the MS SQL connection.

So aside from querying SQL Backup activity history, this is not a method that you can generally use to connect to any CE database and query it.

I hope that this clarifies things.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

SQL CE...

Postby johnc650 » Tue Apr 21, 2009 6:43 pm

Ahhh got it now... Did not realize it was running the sqbdata out of master db..

Thanks,

-jfc-
johnc650
 
Posts: 10
Joined: Tue Feb 05, 2008 9:45 pm


Return to SQL Multi Script 1

Who is online

Users browsing this forum: No registered users and 1 guest