Question about InstallShield Update Service Version 3
I am trying to install a program called F9, which is a Microsoft Excel add-in for pulling financial data from a SQL database. In the installation process, I am getting a Feature Transfer Error and the message is Error: -2 Transform Package. I have been told this is a problem with InstallShield from the program vendor, but I have not been able to find a solution. Any suggestions?
SOURCE: Running SQL queries on Excel
Yes, there is if you have Access as well. You can declare your Excel spreadsheet a data source in Access and then query using SQL. To do that, create a new DB and select Insert --> Table --> Link Table. Change "File of type" to show all files and select your Excel spreadsheet. Follow the wizard and you'll have a link to the sheet and can query it as if it were a table in access. However I doubt you really need that. Excel's functions should be a match for most queries. Can you give a sample of what you try to query (or why you want the SQL queries?
Posted on Aug 14, 2007
SOURCE: SQL Server 2000
An easy way to transfer objects (tables, user defined functions, stored procedures, etc.) is to use Enterprise Manager's "Generate SQL" feature. Use this process at your own risk. Doing it wrong could mess up your existing database.
1. In Enterprise Manager, right-click on the old database and choose "All Tasks" then "Generate SQL Script".
2. In the dialog that comes up, click "Show All" then select the checkboxes for "all stored procedures" and "all user defined functions". (You might also want to check some other boxes, depending on your exact situation.)
3. Click the "generate" button and save the script that it creates.
4. Run the script in the NEW database.
If you run the script in your OLD database, it may destroy your objects, and that would be very bad. Make sure you run the script in your NEW database. (While we're on this subject, it's a good time to mention that you should back up your database before you start this process, and you should make changes to a test system before migrating it to production.)
That should move your stored procedures and user defined functions over.
You can use a similar process to move tables, views, users, and other objects over as well.
Posted on Jan 17, 2008
this page says you need service pack 3:
and here is Microsoft's information
Posted on Jan 22, 2008
SOURCE: SQL 401: cannot open database
Sounds like a security issue with SQL server.
Check your SQL database connections. You will probably have to recreate them so that PC can have access to them.
Posted on Jun 10, 2008
Tips for a great answer:
Sep 13, 2015 | IBM Lotus Notes (d53t7ll-bl) for PC, Mac
Apr 23, 2014 | IBM Lotus Notes (d53t7ll-bl) for PC, Mac
Jun 03, 2011 | Business Objects BusinessObjects...
Jun 30, 2010 | Apple Computers & Internet
Mar 25, 2009 | Compaq Parallel Database Cluster...
Jan 16, 2009 | Veritas Cluster Server for Solaris Oracle...
May 23, 2008 | Computers & Internet
Mar 10, 2008 | Quest Software Spotlight On Windows...
Mar 06, 2008 | Danware NetOp School for Windows 3.0...
478 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: