o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

Do I need to install Excel inDatabase server -

Hi , Can anyone help me in this regard...
My system works on ASP as front end and Sql server2005 as backend. The database server and file servers are on different IPs.I have written a package in which several stored procedures are there and some of them operate microsft excel to generate reports.
I have used Microsoft.OleDB.Jet 4.0 engine to operate excel from stored procedure.
The package runs smoothly but the excel sheets are not generated.
Do I need to install excel.exe in the database server/File server???
Please help me I am in big trouble...
Thanks

 

Do I need to install Excel inDatabase server -
Hi , Can anyone help me in this regard... My system works on ASP as front end and Sql server2005 as backend. The database server and file servers are on different IPs.I have written a package in which several stored procedures are there and some of them operate microsft excel to gener

VB .Net & Excel Reporting -
I have created some Excel templates and an EXE that opens them, get data from a DB, writes it and saves it. It works great on my machine because Excel is installed on it. I need to move the code to a production server where excel is not running, what are my options? I am making us

[2005] creating excel files on server -
I need to create and save excel files to a folder on the server, not just display them in a browser. Must you have excel installed on the server or is adding a refrence enough ?I'm getting a "com" error. If I need to install excel on the server I concerned about licenc

Exporting to Excel (No MS Excel on Server) -
I am binding a dataset to my GridView. I want to Export it to Excel. Server does not have MS Excel and we cannot install it. All the Client Machines will have MS Excel. How to start about it? Any Article to start with? Thanks

Operating excel from Sqlserver storedprocedure -
Hi ...Please help me regarding this problem. I am inserting rows to Excel 8.0 from a sql server database using Microsoft.Jet.OLEDB.4.0 database engine.I have written in a stored procedure in sql server 2000 database. The process is packaged in a dts package. Now we are moving the da

Using Excel in VB -
I've built an active-X component that uses the "MS Excel runtime library" to read from and write to different Exceldocuments. So far so good...the question is how I gets it to work on a Server that do not have MS Excel installed. To make it work on my own server I've jus

Excel Distribution -
I have some asp. pages that use a component based on Excel for creating some charts and reports. Recently, I moved to a new server and it does not have excel installed on it. Obviously, the component does not work The question is: Is there any library, component, viewer, runtim

How to install sql server 2000 in XP -
Dear guys, I wish to install sql server 2000 in xp. but sql server 2000 shows only to install client components in xp. What are the steps that i have to follow to install sql server 2000 in xp. please give remedy. cheers, senthil

how to deploy excel app to server without MS office -
Hi There I am writing a program in vb.net to read data in an Excel file. The program works file in my PC but not in a server. My PC had been installed Excel 2003, but the server has no any MS Office. To install my application in the server I generated a setup.exe and msi fil

navigation to excel file with web browser -
Greetings, New to VB 2008, and VB in general, but loving it so far. I am using a web browser in an MDI window to access an a few excel files with some buttons to call some macros. Right now the excel templates I am using are just in a folder on our server. I am navigating to the fil

Is there any safe way to use VS 7 on a production server -
I am trying to install Microsoft's reporting services but have found that it will not install on a computer that does not have the full version of SQL installed nor will it install on a server that does not have Visual Studio installed. Unless I am missing something it seems that it

[2005] client or server install -
HI Previously in VB6 we always installed on server and created shortcuts on workstations to the main program file. Now we are converting to VB.Net and wonder what is the best way to deploy. 1. Install on server and create shortcuts on workstations as before or 2. Install exe and d

Sql 2000 on WIN XP -
Hi all, I am hvaing WIN XP Pro , i want to install SQL server 2000 Personal Edition - client & Server . But unable to install . At the end of installation system responds that Server cannot be considered , read c:\windows\sqllogs file(something like that) Please help me to

Does XP Pro only run SQL Server Personal Edition -
Hey all. I got Enterprise Edition. Then it wouldn't install the server component. It said, only the client components will install on this NT Workstation (which is really XP Pro) I found a site for SQL Server help that says the Enterprise Edition cannot run on XP due to the lim

Use a VB.NET app. located on a server -
Hi, I want to install my VB.NET application on a server, so that 10-15 client PC will only have a shortcut on their desktop targeting the .exe file on the server. I don't want to install the app on the 10-15 PC and run their own .exe. It's too complex when there is an update of

Excel, VB, SQL Server Problem -
Hi! I want to be able to update SQL Server from the excel spreadsheet, using VB Program. The Excel range will be selected and the columns in SQL Server Table should be updated according to excel columns. Can somebody please help

Package & Deployment requires "EXCEL.EXE" even though Excel is installed! -
My program uses Excel to print spreadsheets containing information stored in a database. If I compile my program (which is on a USB stick which is plugged into a PC with Office Pro 2003 and .NET 1.1 and 2.0), then run it, it behaves perfectly. However, if I use the Package and Deplo

Error when using Excel Object_ASP.NET_Access denied. -
Hi Folks, In asp.net using VB I am using an excel object as .... Dim xlApp As New Excel.Application. (after com referencing) .... Its working fine in the development server but it is giving error when I install in the production server. The error says .... Access is d

[2008] VB .NET and Sql Server -
Hi to all! I have a question for you! [very very newby] If i use Microsoft SQL Server express in my app, i must install Sql Server on the machine where i install my app or when i create the package from VB all is in it? Thenks a lot to all boy!!!

Deploying Access applications on Citrix servers, using Word/Excel .olbs -
I'm trying to deploy an Access 2000 mde file on a Citrix server. The application uses the Word and Excel olb's. I deploy my application with the Access 2000 runtime, which (under normal circumstances, function correctly). The system works fine until it hits a section of the code that u

Trying To Install SQL Server 2005 -
Trying To Install SQL Server 2005 i really dont know what to do.. it doesnt install me that program.. Is it better for me to use visual .net studio ? that i will have all programs in 1 setup ?

install sql express 2008 -
i am trying to install sql server express 2008 and it is a disaster. i am a newbie at it. I just want a simple database to use with vb.net so i only want basic feature installed but WHAT ARE THEY? I need to install windows install 4,5 and then install MSE i click on install

MS SQL Server + nOOb -
I have just started to mess with SQL server(7.0) that shipped with VB Enterprise edition. I was hoping someone could point me to some tutorials on it. Also, if I create an application for someone, and I use SQL Server to create the DB, and have a VB fron-end, Do I need to install

install SQL Server 2005 Enterprise edition -
hi when i try to install SQL Server 2005 Enterprise edition he told that i cant install it because my computer does not reach the Minimum Hardware Requirement and i cant install unless workstation component, Book Online and development tools ------------------ The current system

Running a program from the server -
This may be a really stupid question but.... ....What does it take to have a program that run from a server when a user, at their own computer, wants to use the program? What a basically want is not to have to install the program on each users' computer. Is there anything sp

Excel Object Crashes non-XP systems -
I am creating an Excel object in my VB6 app. My development machine has Excel 10 (XP), and so I set a reference to "Mcirosoft Excel 10 Library" and then do this: Dim xl As Excel.Application Private Sub Form_Load() Set xl = New Excel.Application xl.Workbooks.O

Run an excel app on a web server -
I have a complex excel application, that I need to run on the server, called by an ASP page. I want the app to run and save the result on a shared folder. The end user then can open the excel file after completed. 1) Can this be done with out running excel on the client? 2) How woul

WinXP (HomeEd) And Using IIS -
I just pruchased VS.NET 2003 Pro. - I know that I need IIS to create web apps. And I know that WinXP doesn't have IIS. - I also want to install the C1 components (from resource cd), but I get an install error 1720. I have met all requirements except the IIS to install the c1 cont

beginning ASP.NET -
I created my first web form to diplay time, when I tried to run the program I get the error: 'unable to start debugging on the web server. The server does not support debugging of the ASP.NET or ATL Server applications. Run setup to install the Visual Studio .NET server components.

run-time error 429 (Excel apllication) -
Can I write a vb program that create an excel workbook and run it on a pc that doesn't have excel? I was just trying to see if it works, I wrote a vb form with a cmd button to add a Excel application, add a workbook, with 2 columns on sheet1, make an exe, install on a pc that doesn't

[1.0/1.1] Service Not Installing -
Hello All, I have built an installation package so that I could install one of the services I have developed. I have been able to create successfully the service on one of my servers but on another server, the install package is not creating the service. I do not receive any error

[02/03] Installing SQL Server Express with my application -
Hi, I have a commercial application that uses the DB Access 2003. But I'm thinking to migrate to SQL Server 2005 Expresss. This app is developed by VB.NET 2003 and the app can be installed in one PC or more. To date I did not have any problem to install DB with my app (I was usin

sending excel file to SQL server table -
Hi I have about 360 excel files,each excel file contains up to 500 rows. I want to send the 360 excel files to a single SQL server table(in another words,the SQL server table should contain all the 360 excel files).I want to developp a VB6 project that send an excel file upon clickin

Excel to SQL Server Uploading Issue -
Hi Everyone, Anyone here knows how to upload data from excel to sql server 2005, in such a way that it will first evaluate the rows of the excel before it will be written to the sql database. By the way I am using ASP.NET using C#. The reason why I want to evaluate the excel data; r

SQL Server -
I'm learning VB.NET and I've come to the database handling section of my course and I've hit a problem. How can I perform SQL connections and testing on my home system (Windows XP)? My course instructions tell me to install SQL Server 2000 and configure it to us MS IIS virutal direc

Remote File search -
Hi guys. I need some help retrieving a file name. Here is the situation. We receive a file ever few weeks and it needs to be edited and sent back out. It happens to be an excel file and all the editing is straight forward so I am automating the process. The server the file comes i

installing MSDE on machine with SQL Server 05 client -
hello, is it possible to install msde on a machine which contain the SQL Server 2005 client. Machine is Windows XP Service Pack 2 i have been trying to install msde but have been getting some errors during the install. such as 1. "Your SQL server installation is either

[02/03] Install a printer -
hello again everyone! Let me give you the big picture.. I need to determine whether or not a person has included headers and footers, what the margins are etc. in his Excel spreadsheet. The problem is: Excel needs a printer to be installed before, I can access thqt type of info

Registering DLL from server -
HELP!!!! I want to register a dll on several desktops but I don't want to install the dll on the desktops - I want it to reside on a server. The reason the dll is on the server is so that I can update it when needed and not have to deploy it to all the desktops again. Will this wo

Return Excel sheet from Server to client -
Hello, I am trying to show a report (in Ms-Excel format) in the client-side - but have the excel file in the server. I have a DLL that opens the Excel file and returns the same to the client. The problem is that the report is opened in the Server instead of in the client. Can anyone