Hello,
Thank you in advance.
I plan to buy SQL 2000. My situation is: two IIS boxes (
dual CPU), one SQL server ( DUAL CPU, 5GB Memory), they
are all running in Windows 2000.
Those two IIS boxes have some other VB applications (<15)
may access database.
Question:
which licence model is good for me? Standard or Enterprise
version?
alex| Hello,
|
| Thank you in advance.
|
| I plan to buy SQL 2000. My situation is: two IIS boxes (
| dual CPU), one SQL server ( DUAL CPU, 5GB Memory), they
| are all running in Windows 2000.
| Those two IIS boxes have some other VB applications (<15)
| may access database.
|
| Question:
| which licence model is good for me? Standard or Enterprise
| version?
--
Hi Alex,
Checkout the licensing section of the SQL Server FAQ at:
http://www.microsoft.com/sql/howtobuy/faq.asp
Hope this helps,
--
Eric Cárdenas
SQL Server support|||Standard and Enterprise refer to the edition of SQL Server. The edition =is a separate item from the licensing mode. For licensing information =refer to http://www.microsoft.com/sql/howtobuy/default.asp. For =information on each edition of SQL Server, refer to this page: =http://www.microsoft.com/sql/evaluation/features/choosing.asp
-- Keith
"alex" <anonymous@.discussions.microsoft.com> wrote in message =news:033c01c3cf25$1d1152c0$a401280a@.phx.gbl...
> Hello,
> > Thank you in advance.
> > I plan to buy SQL 2000. My situation is: two IIS boxes ( > dual CPU), one SQL server ( DUAL CPU, 5GB Memory), they > are all running in Windows 2000.
> Those two IIS boxes have some other VB applications (<15) > may access database.
> > Question:
> which licence model is good for me? Standard or Enterprise > version?
> > alex >|||Thank you guys.
Please tell me how do I buy SQL server in simple words.
Alex
>--Original Message--
>Hello,
>Thank you in advance.
>I plan to buy SQL 2000. My situation is: two IIS boxes (
>dual CPU), one SQL server ( DUAL CPU, 5GB Memory), they
>are all running in Windows 2000.
>Those two IIS boxes have some other VB applications
(<15)
>may access database.
>Question:
>which licence model is good for me? Standard or
Enterprise
>version?
>alex
>.
>|||http://www.microsoft.com/sql/howtobuy/default.asp
Next Steps
1.. Review the SQL Server Licensing FAQ.
2.. Compare prices of Oracle9i and IBM DB2 to learn how much you can =save with SQL Server.
3.. To obtain copies of SQL Server 2000, you can:
a.. Call (800) 426-9400 from the United States or call (877) =568-2495 from Canada to speak with a Microsoft representative. b.. Purchase licenses from Microsoft licensing program resellers. =(http://shop.microsoft.com/helpdesk/mvlref.asp)
c.. Order from a U.S. reseller =(http://shop.microsoft.com/helpdesk/reseller.asp).=20
d.. Search the Microsoft Worldwide Information site =(http://www.microsoft.com/worldwide/) to find an international reseller =in your location. e.. Buy online from shop.microsoft.com. -- Keith
"alex" <anonymous@.discussions.microsoft.com> wrote in message =news:09b401c3cfc1$258421c0$a601280a@.phx.gbl...
> Thank you guys.
> > Please tell me how do I buy SQL server in simple words.
> > Alex
> > >--Original Message--
> >Hello,
> >
> >Thank you in advance.
> >
> >I plan to buy SQL 2000. My situation is: two IIS boxes ( > >dual CPU), one SQL server ( DUAL CPU, 5GB Memory), they > >are all running in Windows 2000.
> >Those two IIS boxes have some other VB applications > (<15) > >may access database.
> >
> >Question:
> >which licence model is good for me? Standard or > Enterprise > >version?
> >
> >alex > >
> >.
> >
Showing posts with label situation. Show all posts
Showing posts with label situation. Show all posts
Wednesday, March 28, 2012
Friday, March 9, 2012
HELP - urgent situation
Hey all
I've got a DTS package with a script that does this:
Set xlApp = CreateObject("Excel.Application")
This fails though. Do I have to install MS Office on the machine the SQL Server is on? Or can I simply copy a few DLLs over and register them??
Thanks! I gotta get this solved within 5 hrs :(I am by no means an expert on this particular situation, but I would think that your 'best' (meaning most likely to work the first time) solution would be to install MS Office (just the Excel portion of it) on the server.
Regards,
hmscott|||Our in-house IT guy won't install Excel/Office on the server that our SQL Server is on.. something about opening up for potential problems and/or security issues.
It seems to me that if you CreateObject("Excel.Application"), that there's some kind of ActiveX .dll that could be registered on the server to allow the creation of these Excel COM objects. Anyone know which files they are??|||Where is the Package called from?
If client side app I would suggest installing Excel would work,
If a VB app adding the Excel distributables in the compile should work.
Create a reference to the Excel Object in your VB app.
mine is at
C:\Program Files\Microsoft Office 2000\Office\EXCEL9.OLB
When installed the required registry entries should follow.
Good Luck|||It's an ActiveX script within a DTS package on the server. I'd LIKE to have Office installed, but IT won't allow it.
Is there some way I could place the EXCEL9.OLB file on the server, and reference it somehow in my VBScript??|||All DTS Packages are run on the client unless scheduled by SQL Server regardless of where the code resides.
Your users will need Excel on their PC to use the output anyway, as well as DTS dlls (read SQL Server Client).
Is XML an option? or a structured text file which they can import into Excel. If so you could use the fileScripting object in Active script.|||Well.. actually this is a web page executing the DTS package.. so all the proper DTS dlls are installed on the web server now. And the DTS package has an ActiveX script that tries to create an instance of Excel.Application..but can't do so because Office is not installed on the web server (and will never be).
Nope.. XML is not an option. They gave us an Excel workbook they want populated.. there's no room to budge on this, unfortunately.|||If all you are doing is a data migration into a template try to map to the Excel spreadheet and se a dtsDataPump|||What if you pumped the data to a Comma Separated Value file (.csv), and let Excel convert it from wherever the client happens to open it from?|||OK here's the solution we went with.. MS Office Web Components.
Problem is, I can't find any thorough documentation on it. I want to know if it's possible to open an Excel file with it.
Set objOWC = CreateObject("OWC10.Spreadsheet")
That's how it's created. I have a few examples that tell you how to create a new Excel file from scratch and save it. But not how to open an existing one, modify it, then save to a new file.
Does anyone know, or can point me to some documentation? Thanks!
I've got a DTS package with a script that does this:
Set xlApp = CreateObject("Excel.Application")
This fails though. Do I have to install MS Office on the machine the SQL Server is on? Or can I simply copy a few DLLs over and register them??
Thanks! I gotta get this solved within 5 hrs :(I am by no means an expert on this particular situation, but I would think that your 'best' (meaning most likely to work the first time) solution would be to install MS Office (just the Excel portion of it) on the server.
Regards,
hmscott|||Our in-house IT guy won't install Excel/Office on the server that our SQL Server is on.. something about opening up for potential problems and/or security issues.
It seems to me that if you CreateObject("Excel.Application"), that there's some kind of ActiveX .dll that could be registered on the server to allow the creation of these Excel COM objects. Anyone know which files they are??|||Where is the Package called from?
If client side app I would suggest installing Excel would work,
If a VB app adding the Excel distributables in the compile should work.
Create a reference to the Excel Object in your VB app.
mine is at
C:\Program Files\Microsoft Office 2000\Office\EXCEL9.OLB
When installed the required registry entries should follow.
Good Luck|||It's an ActiveX script within a DTS package on the server. I'd LIKE to have Office installed, but IT won't allow it.
Is there some way I could place the EXCEL9.OLB file on the server, and reference it somehow in my VBScript??|||All DTS Packages are run on the client unless scheduled by SQL Server regardless of where the code resides.
Your users will need Excel on their PC to use the output anyway, as well as DTS dlls (read SQL Server Client).
Is XML an option? or a structured text file which they can import into Excel. If so you could use the fileScripting object in Active script.|||Well.. actually this is a web page executing the DTS package.. so all the proper DTS dlls are installed on the web server now. And the DTS package has an ActiveX script that tries to create an instance of Excel.Application..but can't do so because Office is not installed on the web server (and will never be).
Nope.. XML is not an option. They gave us an Excel workbook they want populated.. there's no room to budge on this, unfortunately.|||If all you are doing is a data migration into a template try to map to the Excel spreadheet and se a dtsDataPump|||What if you pumped the data to a Comma Separated Value file (.csv), and let Excel convert it from wherever the client happens to open it from?|||OK here's the solution we went with.. MS Office Web Components.
Problem is, I can't find any thorough documentation on it. I want to know if it's possible to open an Excel file with it.
Set objOWC = CreateObject("OWC10.Spreadsheet")
That's how it's created. I have a few examples that tell you how to create a new Excel file from scratch and save it. But not how to open an existing one, modify it, then save to a new file.
Does anyone know, or can point me to some documentation? Thanks!
Wednesday, March 7, 2012
HELP - Running a Report with Dynamic Query from a web page
Here's the situation. I have a report that uses a dynamic query to select one
or all records from the dataset to display.The query looks like this
="SELECT abunch of fieds" &
"FROM a view" &
iif(Parameters!orgid.value = 0,"","WHERE organization_id = " &
Parameters!orgid.value)
Essentially if the report parameter (orgid) = 0 then get all records, if
it's something other than 0, get the specified record.
The report is called from an ASP web application which builds the required
URL depending on the organization selected. The URL looks like this:
"http://webserver/reporting/pages/report.aspx?ItemPath=pathtoreport/report&rc:Parameters=false&orgid=123
In the browser, the HTML (I guess) viewer opens, displays the Parameter bar,
prompts me for a orgid and sits there.
I don't want the Parameter bar to show, just run the report with the
parameter supplied in the url. What am I doing wrong' Or what am I not doing
right?You have set up the beginning of the url incorrectly.
It should look like this:
http://webserver/reportserver?/pathToReport/ReportName&rc:Parameters=false&orgid=123
See the following msdn article for details:
http://msdn2.microsoft.com/en-us/library/ms152835.aspx
Rowen McDermott|||Ah Rowen, if only it were so easy and straightforward. BTW, thanks for the
reply.
When I use the method described by MS and everybody else who wrote a book on
Reporting Services, this is what happens:
I'm re-directed to the reportserver home page with a URL of
http://<webserver>/<reportserver>/Pages/Folder.aspx. I can see the folder
that contains the report to run, I have an administrative Toolbar and that's
pretty much it. If I browse down to the report, I can click on it, the report
will start and prompt me for an orgid.
Have any other suggestions? I've got the sa who set up Reporting Services
checking on her end to see if she can get the report to run as advertised.
Thanks again.
The only way I've gotten the report to start is the method I first described.
"Rowen" wrote:
> You have set up the beginning of the url incorrectly.
> It should look like this:
> http://webserver/reportserver?/pathToReport/ReportName&rc:Parameters=false&orgid=123
> See the following msdn article for details:
> http://msdn2.microsoft.com/en-us/library/ms152835.aspx
> Rowen McDermott
>|||On Mar 20, 11:15 pm, JoeKoko <JoeK...@.discussions.microsoft.com>
wrote:
> Ah Rowen, if only it were so easy and straightforward. BTW, thanks for the
> reply.
> When I use the method described by MS and everybody else who wrote a book on
> Reporting Services, this is what happens:
> I'm re-directed to the reportserver home page with a URL of
> http://<webserver>/<reportserver>/Pages/Folder.aspx. I can see the folder
> that contains the report to run, I have an administrative Toolbar and that's
> pretty much it. If I browse down to the report, I can click on it, the report
> will start and prompt me for an orgid.
> Have any other suggestions? I've got the sa who set up Reporting Services
> checking on her end to see if she can get the report to run as advertised.
> Thanks again.
> The only way I've gotten the report to start is the method I first described.
>
In that case I'm afraid I cant help you. The method I described above
worked for me, so I can't say what is going on in your case.
I would suggest testing a very basic report with no parameters using
the microsoft documented method and see if it displays the report or
re-directs you to the report server home page.
Regards,
Rowen
or all records from the dataset to display.The query looks like this
="SELECT abunch of fieds" &
"FROM a view" &
iif(Parameters!orgid.value = 0,"","WHERE organization_id = " &
Parameters!orgid.value)
Essentially if the report parameter (orgid) = 0 then get all records, if
it's something other than 0, get the specified record.
The report is called from an ASP web application which builds the required
URL depending on the organization selected. The URL looks like this:
"http://webserver/reporting/pages/report.aspx?ItemPath=pathtoreport/report&rc:Parameters=false&orgid=123
In the browser, the HTML (I guess) viewer opens, displays the Parameter bar,
prompts me for a orgid and sits there.
I don't want the Parameter bar to show, just run the report with the
parameter supplied in the url. What am I doing wrong' Or what am I not doing
right?You have set up the beginning of the url incorrectly.
It should look like this:
http://webserver/reportserver?/pathToReport/ReportName&rc:Parameters=false&orgid=123
See the following msdn article for details:
http://msdn2.microsoft.com/en-us/library/ms152835.aspx
Rowen McDermott|||Ah Rowen, if only it were so easy and straightforward. BTW, thanks for the
reply.
When I use the method described by MS and everybody else who wrote a book on
Reporting Services, this is what happens:
I'm re-directed to the reportserver home page with a URL of
http://<webserver>/<reportserver>/Pages/Folder.aspx. I can see the folder
that contains the report to run, I have an administrative Toolbar and that's
pretty much it. If I browse down to the report, I can click on it, the report
will start and prompt me for an orgid.
Have any other suggestions? I've got the sa who set up Reporting Services
checking on her end to see if she can get the report to run as advertised.
Thanks again.
The only way I've gotten the report to start is the method I first described.
"Rowen" wrote:
> You have set up the beginning of the url incorrectly.
> It should look like this:
> http://webserver/reportserver?/pathToReport/ReportName&rc:Parameters=false&orgid=123
> See the following msdn article for details:
> http://msdn2.microsoft.com/en-us/library/ms152835.aspx
> Rowen McDermott
>|||On Mar 20, 11:15 pm, JoeKoko <JoeK...@.discussions.microsoft.com>
wrote:
> Ah Rowen, if only it were so easy and straightforward. BTW, thanks for the
> reply.
> When I use the method described by MS and everybody else who wrote a book on
> Reporting Services, this is what happens:
> I'm re-directed to the reportserver home page with a URL of
> http://<webserver>/<reportserver>/Pages/Folder.aspx. I can see the folder
> that contains the report to run, I have an administrative Toolbar and that's
> pretty much it. If I browse down to the report, I can click on it, the report
> will start and prompt me for an orgid.
> Have any other suggestions? I've got the sa who set up Reporting Services
> checking on her end to see if she can get the report to run as advertised.
> Thanks again.
> The only way I've gotten the report to start is the method I first described.
>
In that case I'm afraid I cant help you. The method I described above
worked for me, so I can't say what is going on in your case.
I would suggest testing a very basic report with no parameters using
the microsoft documented method and see if it displays the report or
re-directs you to the report server home page.
Regards,
Rowen
Subscribe to:
Posts (Atom)