MSSQL Mistake: version

Showing posts with label version. Show all posts

Friday, March 23, 2012

Muliple rows for group side by side with data

I have a report layout that has proved to be a little tricky. I hope
someone on this group can help me out.
I am going to show a simplified version that captures the problem. I
can easily create a report that looks like this:
NAME ADDR1 ADDR2 PHONE ITEM1
ITEM2
ITEM3
ITEM4
ITEM5
...
NAME2 ADDR ADDR PHONE ITEM1
...
where there could be zero or more items for each person. I have been
asked to create a report that looks somthing like thiS:
NAME ITEM1
ADDR1 ITEM2
ADDR2 ITEM3
PHONE ITEM4
ITEM5
...
If there are more than 4 items, then they appear below. If there are
less than 4 items, then the space to the right of the address and phone
is blank.
This is a simplified example. There are actually many more fixed
fields, and they don't fit on 1 line -- it'll take about 7 lines to fit
them. If I were to put the repeating items below the fixed fields,
then 5 items would take a total of 12 lines for this person. By having
the items side by side with the fixed fields, 5 items would only take
the 7 lines and we save a lot of space.
Has anyone done this? Can anyone tell me how to place detail items
side by side with multiple rows of group header data?
Thank you,
TedHi, This is possible with Unions in your dataset.
Select Name From ?
Union
Select ADDR1 From ?
Union
Select ADDR2 From ?
Etc.
gr.
Mike
"Ted K" wrote:
> I have a report layout that has proved to be a little tricky. I hope
> someone on this group can help me out.
> I am going to show a simplified version that captures the problem. I
> can easily create a report that looks like this:
> NAME ADDR1 ADDR2 PHONE ITEM1
> ITEM2
> ITEM3
> ITEM4
> ITEM5
> ...
> NAME2 ADDR ADDR PHONE ITEM1
> ...
> where there could be zero or more items for each person. I have been
> asked to create a report that looks somthing like thiS:
> NAME ITEM1
> ADDR1 ITEM2
> ADDR2 ITEM3
> PHONE ITEM4
> ITEM5
> ...
> If there are more than 4 items, then they appear below. If there are
> less than 4 items, then the space to the right of the address and phone
> is blank.
> This is a simplified example. There are actually many more fixed
> fields, and they don't fit on 1 line -- it'll take about 7 lines to fit
> them. If I were to put the repeating items below the fixed fields,
> then 5 items would take a total of 12 lines for this person. By having
> the items side by side with the fixed fields, 5 items would only take
> the 7 lines and we save a lot of space.
> Has anyone done this? Can anyone tell me how to place detail items
> side by side with multiple rows of group header data?
> Thank you,
> Ted
>|||Thanks Mike. I'm very good with SQL and am confident I can write the query
to get the data back however I want. What I'm looking for is help with the
RDL layout. I have tried nested tables, lists, and other ways, but each has
problems. For example, one layout came up with:
NAME ITEM1
ADDR1
ADDR2
PHONE
ITEM2
ITEM3
ITEM4
ITEM5
...
instead of:
NAME ITEM1
ADDR1 ITEM2
ADDR2 ITEM3
PHONE ITEM4
ITEM5
Any experts out there know how to put the detail rows to the right of the
header fields instead of below?
Thank you very much,
Ted
"Mike Klaarhamer" wrote:
> Hi, This is possible with Unions in your dataset.
> Select Name From ?
> Union
> Select ADDR1 From ?
> Union
> Select ADDR2 From ?
> Etc.
> gr.
> Mike
> "Ted K" wrote:
> > I have a report layout that has proved to be a little tricky. I hope
> > someone on this group can help me out.
> >
> > I am going to show a simplified version that captures the problem. I
> > can easily create a report that looks like this:
> >
> > NAME ADDR1 ADDR2 PHONE ITEM1
> > ITEM2
> > ITEM3
> > ITEM4
> > ITEM5
> > ...
> > NAME2 ADDR ADDR PHONE ITEM1
> > ...
> >
> > where there could be zero or more items for each person. I have been
> > asked to create a report that looks somthing like thiS:
> >
> > NAME ITEM1
> > ADDR1 ITEM2
> > ADDR2 ITEM3
> > PHONE ITEM4
> > ITEM5
> > ...
> >
> > If there are more than 4 items, then they appear below. If there are
> > less than 4 items, then the space to the right of the address and phone
> > is blank.
> >
> > This is a simplified example. There are actually many more fixed
> > fields, and they don't fit on 1 line -- it'll take about 7 lines to fit
> > them. If I were to put the repeating items below the fixed fields,
> > then 5 items would take a total of 12 lines for this person. By having
> > the items side by side with the fixed fields, 5 items would only take
> > the 7 lines and we save a lot of space.
> >
> > Has anyone done this? Can anyone tell me how to place detail items
> > side by side with multiple rows of group header data?
> >
> > Thank you,
> > Ted
> >
> >|||Hi Ted,
I've done a similar thing just via using simple Tables.
I just created 2 tables next to each other, and they should get layed out
correctly.
I'm no expert, but I'm thinking I'd want to create a List with 2 Tables
inside it, like so:
--LIST--
| Table1- Table2- |
|| | | | |
||______| |_____| |
--
And that way you can layout table 1 as you want with the name and address
details, and table 2 with the details of the Items.
Let me know if it works for you, and if u understand my funny explanations.
Andre
"Ted K" wrote:
> Thanks Mike. I'm very good with SQL and am confident I can write the query
> to get the data back however I want. What I'm looking for is help with the
> RDL layout. I have tried nested tables, lists, and other ways, but each has
> problems. For example, one layout came up with:
> NAME ITEM1
> ADDR1
> ADDR2
> PHONE
> ITEM2
> ITEM3
> ITEM4
> ITEM5
> ...
> instead of:
> NAME ITEM1
> ADDR1 ITEM2
> ADDR2 ITEM3
> PHONE ITEM4
> ITEM5
> Any experts out there know how to put the detail rows to the right of the
> header fields instead of below?
> Thank you very much,
> Ted
> "Mike Klaarhamer" wrote:
> > Hi, This is possible with Unions in your dataset.
> > Select Name From ?
> > Union
> > Select ADDR1 From ?
> > Union
> > Select ADDR2 From ?
> > Etc.
> >
> > gr.
> >
> > Mike
> >
> > "Ted K" wrote:
> >
> > > I have a report layout that has proved to be a little tricky. I hope
> > > someone on this group can help me out.
> > >
> > > I am going to show a simplified version that captures the problem. I
> > > can easily create a report that looks like this:
> > >
> > > NAME ADDR1 ADDR2 PHONE ITEM1
> > > ITEM2
> > > ITEM3
> > > ITEM4
> > > ITEM5
> > > ...
> > > NAME2 ADDR ADDR PHONE ITEM1
> > > ...
> > >
> > > where there could be zero or more items for each person. I have been
> > > asked to create a report that looks somthing like thiS:
> > >
> > > NAME ITEM1
> > > ADDR1 ITEM2
> > > ADDR2 ITEM3
> > > PHONE ITEM4
> > > ITEM5
> > > ...
> > >
> > > If there are more than 4 items, then they appear below. If there are
> > > less than 4 items, then the space to the right of the address and phone
> > > is blank.
> > >
> > > This is a simplified example. There are actually many more fixed
> > > fields, and they don't fit on 1 line -- it'll take about 7 lines to fit
> > > them. If I were to put the repeating items below the fixed fields,
> > > then 5 items would take a total of 12 lines for this person. By having
> > > the items side by side with the fixed fields, 5 items would only take
> > > the 7 lines and we save a lot of space.
> > >
> > > Has anyone done this? Can anyone tell me how to place detail items
> > > side by side with multiple rows of group header data?
> > >
> > > Thank you,
> > > Ted
> > >
> > >|||Thanks for replying. Before I tried to work out the 2 tables next to each
other (and how to get the rows to match up right), I got one of my other
layouts working.
In case anyone wants to know, I created a list for the group, put all of the
static fields down, then put a list for the detail items to the right of the
static fields. The important part was to make the detail list as tall as all
of the static fields and also to set CanShrink to true. If there were very
few items, the list would shrink. If there were a lot, the list would grow,
but would not push down any of the static fields because the bottom of the
list was already below the text boxes.
Ted
"Arkiliknam" wrote:
> Hi Ted,
> I've done a similar thing just via using simple Tables.
> I just created 2 tables next to each other, and they should get layed out
> correctly.
> I'm no expert, but I'm thinking I'd want to create a List with 2 Tables
> inside it, like so:
> --LIST--
> | Table1- Table2- |
> || | | | |
> ||______| |_____| |
> --
> And that way you can layout table 1 as you want with the name and address
> details, and table 2 with the details of the Items.
> Let me know if it works for you, and if u understand my funny explanations.
> Andre
> "Ted K" wrote:
> > Thanks Mike. I'm very good with SQL and am confident I can write the query
> > to get the data back however I want. What I'm looking for is help with the
> > RDL layout. I have tried nested tables, lists, and other ways, but each has
> > problems. For example, one layout came up with:
> >
> > NAME ITEM1
> > ADDR1
> > ADDR2
> > PHONE
> > ITEM2
> > ITEM3
> > ITEM4
> > ITEM5
> > ...
> >
> > instead of:
> >
> > NAME ITEM1
> > ADDR1 ITEM2
> > ADDR2 ITEM3
> > PHONE ITEM4
> > ITEM5
> >
> > Any experts out there know how to put the detail rows to the right of the
> > header fields instead of below?
> >
> > Thank you very much,
> > Ted
> >
> > "Mike Klaarhamer" wrote:
> >
> > > Hi, This is possible with Unions in your dataset.
> > > Select Name From ?
> > > Union
> > > Select ADDR1 From ?
> > > Union
> > > Select ADDR2 From ?
> > > Etc.
> > >
> > > gr.
> > >
> > > Mike
> > >
> > > "Ted K" wrote:
> > >
> > > > I have a report layout that has proved to be a little tricky. I hope
> > > > someone on this group can help me out.
> > > >
> > > > I am going to show a simplified version that captures the problem. I
> > > > can easily create a report that looks like this:
> > > >
> > > > NAME ADDR1 ADDR2 PHONE ITEM1
> > > > ITEM2
> > > > ITEM3
> > > > ITEM4
> > > > ITEM5
> > > > ...
> > > > NAME2 ADDR ADDR PHONE ITEM1
> > > > ...
> > > >
> > > > where there could be zero or more items for each person. I have been
> > > > asked to create a report that looks somthing like thiS:
> > > >
> > > > NAME ITEM1
> > > > ADDR1 ITEM2
> > > > ADDR2 ITEM3
> > > > PHONE ITEM4
> > > > ITEM5
> > > > ...
> > > >
> > > > If there are more than 4 items, then they appear below. If there are
> > > > less than 4 items, then the space to the right of the address and phone
> > > > is blank.
> > > >
> > > > This is a simplified example. There are actually many more fixed
> > > > fields, and they don't fit on 1 line -- it'll take about 7 lines to fit
> > > > them. If I were to put the repeating items below the fixed fields,
> > > > then 5 items would take a total of 12 lines for this person. By having
> > > > the items side by side with the fixed fields, 5 items would only take
> > > > the 7 lines and we save a lot of space.
> > > >
> > > > Has anyone done this? Can anyone tell me how to place detail items
> > > > side by side with multiple rows of group header data?
> > > >
> > > > Thank you,
> > > > Ted
> > > >
> > > >sql

Wednesday, March 21, 2012

MSSQServer 2000 for pocket pc

Hi to all.
I have a windows ce mssqlserver 2000 version.
I have writted a java application and i needed a database connection.
I wish a driver for execute the connection to mssql server 2000 into pocket pc.

The connection string that i use is

connessione = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databasename=A&MMobile", "sa", "sa");

Ok?

Which are the driver that i needed?

Thanx,

SimonaOriginally posted by simona
Hi to all.
I have a windows ce mssqlserver 2000 version.
I have writted a java application and i needed a database connection.
I wish a driver for execute the connection to mssql server 2000 into pocket pc.

The connection string that i use is

connessione = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databasename=A&MMobile", "sa", "sa");

Ok?

Which are the driver that i needed?

Thanx,

Simona

Sorry but i'cant help you.

But i'm interrested for your java application.

which is the JVM which you use ?
Could you give me a java for ppc sample code 'HELLO WORLD!' ?

thank you,

Guiguix.|||Hi,
yhe java code is traditionally.

You write a "Hello world" java code and you copy it in the pocket pc.
The jvm is Creme. It support swing! But the needed java version is very old. I use the java 1.1.8 ;(

Bye :)|||There are two steps to establish a connection:

(1) loading the driver
If you want to use the JDBC-ODBC Bridge driver, the following code will load it.

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

(2) making the connection
If you are using the JDBC-ODBC Bridge driver, you can use

String url = "jdbc: odbc:ODBC_DataSourceName";
Connection con = DriverManager.getConnection(url, "myLogin", "myPassword");

Note that there is no space between jdbc: and odbc in url. If I remove it a sign will be shown in the code.|||And is this ok for pocket pc?
Wow!|||When you say "pocket PC", it is a laptop, right? I didn't try the connection on SQL Server 2000 Windows CE Edition, but it works for the other versions of SQL Server 2000.|||Pocket pc is a palm. Not Palm OS, but pocket pc.
MSSqlServer 2000 works on pc desktop but not on pocket pc.
Moreover the strings

----------------------
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

String url = "jdbc: odbc://localhost:1433;databasename=AeMMobile";

connessione = DriverManager.getConnection(url, "sa", "sa");
-----------------------

don't work.

While with

----------------------

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

connessione = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databasename=AeMMobile", "sa", "sa");

--------------------

on pc desktop is ok.
My problem is on pocket pc?
Do you know the solution?|||I do not know what the pocket PC is. I have a question. Since the SQL server is on the desktop which should be a Windows server, is your pocket PC connected to that server?|||The pocket pc is an hp 2002.
If you means that pocket pc is connected with replication data... yes.

Monday, March 12, 2012

MSSQLSERVER errors on PC running MSDE

I have a retail account with 2 PC's running the latest version of
Microsofts RMS. One of the PC's
acts as the server using MSDE. In the event viewer for this PC there are
hundreds of
errors that show this:
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 11/25/2004
Time: 2:55:04 AM
User: N/A
Computer: W_CM1
Description:
Error: 644, Severity: 21, State: 3
Could not find the index entry for RID '160000019f9af100' in index page
(1:28465), index ID 0, database 'conrevhb2'.
Data:
0000: 84 02 00 00 15 00 00 00 ?......
0008: 06 00 00 00 57 00 5f 00 ...W._.
0010: 43 00 4d 00 31 00 00 00 C.M.1...
0018: 0a 00 00 00 63 00 6f 00 ...c.o.
0020: 6e 00 72 00 65 00 76 00 n.r.e.v.
0028: 68 00 62 00 32 00 00 00 h.b.2...
Can someone help me out?
Thanks
John"John" <jk@.rt.com> wrote in message
news:%23EknDWi1EHA.304@.TK2MSFTNGP11.phx.gbl...
>I have a retail account with 2 PC's running the latest version of
>Microsofts RMS. One of the PC's
> acts as the server using MSDE. In the event viewer for this PC there are
> hundreds of
> errors that show this:
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> Date: 11/25/2004
> Time: 2:55:04 AM
> User: N/A
> Computer: W_CM1
> Description:
> Error: 644, Severity: 21, State: 3
> Could not find the index entry for RID '160000019f9af100' in index page
> (1:28465), index ID 0, database 'conrevhb2'.
> Data:
> 0000: 84 02 00 00 15 00 00 00 ?......
> 0008: 06 00 00 00 57 00 5f 00 ...W._.
> 0010: 43 00 4d 00 31 00 00 00 C.M.1...
> 0018: 0a 00 00 00 63 00 6f 00 ...c.o.
> 0020: 6e 00 72 00 65 00 76 00 n.r.e.v.
> 0028: 68 00 62 00 32 00 00 00 h.b.2...
> Can someone help me out?
> Thanks
> John
>
>
Your clustered index on database conrevhb2 has problems with it. Take a
look at the BOL for DBCC CHECKDB command. There are some repair options.
If that doesn't work, you may need to drop and recreate your clustered
index. (Keep in mind that it may be your Primary key constraint as well, as
this automatically creates a clustered index by default.).
HTH
Rick Sawtell
MCT, MCSD, MCDBA|||Rick,
Thanks for the reply but, I am not a database admin so I know I can do a
google search and see what you are suggesting but is this correct for a
database using the MSDE engineon a Win2K Pro machine?
TIA
John
"Rick Sawtell" <quickening@.msn.com> wrote in message
news:uLLOjpi1EHA.1264@.TK2MSFTNGP12.phx.gbl...
> "John" <jk@.rt.com> wrote in message
> news:%23EknDWi1EHA.304@.TK2MSFTNGP11.phx.gbl...
>>I have a retail account with 2 PC's running the latest version of
>>Microsofts RMS. One of the PC's
>> acts as the server using MSDE. In the event viewer for this PC there are
>> hundreds of
>> errors that show this:
>> Event Type: Error
>> Event Source: MSSQLSERVER
>> Event Category: (2)
>> Event ID: 17052
>> Date: 11/25/2004
>> Time: 2:55:04 AM
>> User: N/A
>> Computer: W_CM1
>> Description:
>> Error: 644, Severity: 21, State: 3
>> Could not find the index entry for RID '160000019f9af100' in index page
>> (1:28465), index ID 0, database 'conrevhb2'.
>> Data:
>> 0000: 84 02 00 00 15 00 00 00 ?......
>> 0008: 06 00 00 00 57 00 5f 00 ...W._.
>> 0010: 43 00 4d 00 31 00 00 00 C.M.1...
>> 0018: 0a 00 00 00 63 00 6f 00 ...c.o.
>> 0020: 6e 00 72 00 65 00 76 00 n.r.e.v.
>> 0028: 68 00 62 00 32 00 00 00 h.b.2...
>> Can someone help me out?
>> Thanks
>> John
>>
> Your clustered index on database conrevhb2 has problems with it. Take a
> look at the BOL for DBCC CHECKDB command. There are some repair options.
> If that doesn't work, you may need to drop and recreate your clustered
> index. (Keep in mind that it may be your Primary key constraint as well,
> as this automatically creates a clustered index by default.).
> HTH
> Rick Sawtell
> MCT, MCSD, MCDBA
>|||MSDE uses the same DLLs that SQL Server uses. It has certain built-in
limitations on how it operates, but this is essentially what needs to be
fixed.
If you don't have Query Analzer, you may try to use osql and do this work
from the command line.
Rick
"John" <jk@.rt.com> wrote in message
news:ec$IJyi1EHA.3596@.TK2MSFTNGP12.phx.gbl...
> Rick,
> Thanks for the reply but, I am not a database admin so I know I can do a
> google search and see what you are suggesting but is this correct for a
> database using the MSDE engineon a Win2K Pro machine?
> TIA
>
> John
>
> "Rick Sawtell" <quickening@.msn.com> wrote in message
> news:uLLOjpi1EHA.1264@.TK2MSFTNGP12.phx.gbl...
>> "John" <jk@.rt.com> wrote in message
>> news:%23EknDWi1EHA.304@.TK2MSFTNGP11.phx.gbl...
>>I have a retail account with 2 PC's running the latest version of
>>Microsofts RMS. One of the PC's
>> acts as the server using MSDE. In the event viewer for this PC there
>> are hundreds of
>> errors that show this:
>> Event Type: Error
>> Event Source: MSSQLSERVER
>> Event Category: (2)
>> Event ID: 17052
>> Date: 11/25/2004
>> Time: 2:55:04 AM
>> User: N/A
>> Computer: W_CM1
>> Description:
>> Error: 644, Severity: 21, State: 3
>> Could not find the index entry for RID '160000019f9af100' in index page
>> (1:28465), index ID 0, database 'conrevhb2'.
>> Data:
>> 0000: 84 02 00 00 15 00 00 00 ?......
>> 0008: 06 00 00 00 57 00 5f 00 ...W._.
>> 0010: 43 00 4d 00 31 00 00 00 C.M.1...
>> 0018: 0a 00 00 00 63 00 6f 00 ...c.o.
>> 0020: 6e 00 72 00 65 00 76 00 n.r.e.v.
>> 0028: 68 00 62 00 32 00 00 00 h.b.2...
>> Can someone help me out?
>> Thanks
>> John
>>
>>
>> Your clustered index on database conrevhb2 has problems with it. Take a
>> look at the BOL for DBCC CHECKDB command. There are some repair options.
>> If that doesn't work, you may need to drop and recreate your clustered
>> index. (Keep in mind that it may be your Primary key constraint as well,
>> as this automatically creates a clustered index by default.).
>> HTH
>> Rick Sawtell
>> MCT, MCSD, MCDBA
>>
>|||Thanks Rick!!
John
"Rick Sawtell" <quickening@.msn.com> wrote in message
news:%23xY1J%23i1EHA.2540@.TK2MSFTNGP09.phx.gbl...
> MSDE uses the same DLLs that SQL Server uses. It has certain built-in
> limitations on how it operates, but this is essentially what needs to be
> fixed.
> If you don't have Query Analzer, you may try to use osql and do this work
> from the command line.
> Rick
>
> "John" <jk@.rt.com> wrote in message
> news:ec$IJyi1EHA.3596@.TK2MSFTNGP12.phx.gbl...
>> Rick,
>> Thanks for the reply but, I am not a database admin so I know I can do a
>> google search and see what you are suggesting but is this correct for a
>> database using the MSDE engineon a Win2K Pro machine?
>> TIA
>>
>> John
>>
>> "Rick Sawtell" <quickening@.msn.com> wrote in message
>> news:uLLOjpi1EHA.1264@.TK2MSFTNGP12.phx.gbl...
>> "John" <jk@.rt.com> wrote in message
>> news:%23EknDWi1EHA.304@.TK2MSFTNGP11.phx.gbl...
>>I have a retail account with 2 PC's running the latest version of
>>Microsofts RMS. One of the PC's
>> acts as the server using MSDE. In the event viewer for this PC there
>> are hundreds of
>> errors that show this:
>> Event Type: Error
>> Event Source: MSSQLSERVER
>> Event Category: (2)
>> Event ID: 17052
>> Date: 11/25/2004
>> Time: 2:55:04 AM
>> User: N/A
>> Computer: W_CM1
>> Description:
>> Error: 644, Severity: 21, State: 3
>> Could not find the index entry for RID '160000019f9af100' in index page
>> (1:28465), index ID 0, database 'conrevhb2'.
>> Data:
>> 0000: 84 02 00 00 15 00 00 00 ?......
>> 0008: 06 00 00 00 57 00 5f 00 ...W._.
>> 0010: 43 00 4d 00 31 00 00 00 C.M.1...
>> 0018: 0a 00 00 00 63 00 6f 00 ...c.o.
>> 0020: 6e 00 72 00 65 00 76 00 n.r.e.v.
>> 0028: 68 00 62 00 32 00 00 00 h.b.2...
>> Can someone help me out?
>> Thanks
>> John
>>
>>
>> Your clustered index on database conrevhb2 has problems with it. Take a
>> look at the BOL for DBCC CHECKDB command. There are some repair
>> options. If that doesn't work, you may need to drop and recreate your
>> clustered index. (Keep in mind that it may be your Primary key
>> constraint as well, as this automatically creates a clustered index by
>> default.).
>> HTH
>> Rick Sawtell
>> MCT, MCSD, MCDBA
>>
>>
>

MSSQLSERVER errors on PC running MSDE

Friday, March 9, 2012

MSSQL2005 SP1 setup

I have an Evaluation version of Enterprise edition MSSQL2005 for development. I tried to install MSSQL2005 sp1 and it is necessary to upgrade to the release version of SQL2005. Currently, I just got the release CD on hand, how can I upgrade the evaluation version to release version except uninstalling the eval and install with the release edition? Thanks in advance

You can "Upgrade" from Eval to the release version by launching setup from the CD. Setup will find the existing eval instance inform you that you can upgrade the instance.

jeff.

Wednesday, March 7, 2012

MSSQL2005 64 bit + Client's 32 bit ODBC

Hi,
If I have a Intel x86 64 bit server, installed Win2003 64bit OS + MSSQL2005
64 bit version, and the client running Intel "Core2 Duo" (32 bit), installed
WinXP Prof, is the client able to connect to MSSQL2005 64 bit Database thro
ODBC drivers?
Thanks.Correcttion: Intel x64 not x86. x86 is 32 bit.
Of course they can.
You even can even install SQL Server 2005 x86 on your x64 environment. (of
course you better install x64 ver.)
However you can not install x64 on an x86 environment.
--
Ekrem Önsoy
"Markco Wong" <markcowong@.markcowong.com> wrote in message
news:erneasQ8HHA.3900@.TK2MSFTNGP02.phx.gbl...
> Hi,
> If I have a Intel x86 64 bit server, installed Win2003 64bit OS +
> MSSQL2005 64 bit version, and the client running Intel "Core2 Duo" (32
> bit), installed WinXP Prof, is the client able to connect to MSSQL2005 64
> bit Database thro ODBC drivers?
> Thanks.
>

MSSQL2000 Maximum Memory

Hi,
I want to use MSSQL2000 on a server with 8GB ram amount.
Is there a way to use this ram under Win2003 Server?
What version of MSSQL2000 do I have to use?
thx
reinhold
Hi
You need to use:
Windows 2003 Enterprise Edition
SQL Server 2000 Enterprise Edition
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Reinhold" wrote:

> Hi,
> I want to use MSSQL2000 on a server with 8GB ram amount.
> Is there a way to use this ram under Win2003 Server?
> What version of MSSQL2000 do I have to use?
> thx
> reinhold
>
>
|||See if this helps:
http://support.microsoft.com/default...274750&sd=tech
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Reinhold" <reinholderlacher@.msn.com> wrote in message
news:OrbtVcisFHA.3424@.TK2MSFTNGP14.phx.gbl...
Hi,
I want to use MSSQL2000 on a server with 8GB ram amount.
Is there a way to use this ram under Win2003 Server?
What version of MSSQL2000 do I have to use?
thx
reinhold
|||> I want to use MSSQL2000 on a server with 8GB ram amount.
> Is there a way to use this ram under Win2003 Server?
Assuming 32-bit, you need Windows 2003 Server Enterprise Edition and SQL
Server Enterprise Edition. SQL Server AWE needs to be enabled to address
over 3GB. Windows 2003 Standard has a 4GB max memory limitation and SQL
Server Standard is limited to 2Gb.
Windows 2003 system requirements:
http://www.microsoft.com/windowsserv...s/default.mspx
How to configure memory for more than 2 GB in SQL Server:
http://support.microsoft.com/default...b;en-us;274750
Hope this helps.
Dan Guzman
SQL Server MVP
"Reinhold" <reinholderlacher@.msn.com> wrote in message
news:OrbtVcisFHA.3424@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I want to use MSSQL2000 on a server with 8GB ram amount.
> Is there a way to use this ram under Win2003 Server?
> What version of MSSQL2000 do I have to use?
> thx
> reinhold
>

MSSQL2000 Maximum Memory

Hi,
I want to use MSSQL2000 on a server with 8GB ram amount.
Is there a way to use this ram under Win2003 Server?
What version of MSSQL2000 do I have to use?
thx
reinholdHi
You need to use:
Windows 2003 Enterprise Edition
SQL Server 2000 Enterprise Edition
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Reinhold" wrote:

> Hi,
> I want to use MSSQL2000 on a server with 8GB ram amount.
> Is there a way to use this ram under Win2003 Server?
> What version of MSSQL2000 do I have to use?
> thx
> reinhold
>
>|||See if this helps:
http://support.microsoft.com/defaul...;274750&sd=tech
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Reinhold" <reinholderlacher@.msn.com> wrote in message
news:OrbtVcisFHA.3424@.TK2MSFTNGP14.phx.gbl...
Hi,
I want to use MSSQL2000 on a server with 8GB ram amount.
Is there a way to use this ram under Win2003 Server?
What version of MSSQL2000 do I have to use?
thx
reinhold|||> I want to use MSSQL2000 on a server with 8GB ram amount.
> Is there a way to use this ram under Win2003 Server?
Assuming 32-bit, you need Windows 2003 Server Enterprise Edition and SQL
Server Enterprise Edition. SQL Server AWE needs to be enabled to address
over 3GB. Windows 2003 Standard has a 4GB max memory limitation and SQL
Server Standard is limited to 2Gb.
Windows 2003 system requirements:
http://www.microsoft.com/windowsser...qs/default.mspx
How to configure memory for more than 2 GB in SQL Server:
http://support.microsoft.com/defaul...kb;en-us;274750
Hope this helps.
Dan Guzman
SQL Server MVP
"Reinhold" <reinholderlacher@.msn.com> wrote in message
news:OrbtVcisFHA.3424@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I want to use MSSQL2000 on a server with 8GB ram amount.
> Is there a way to use this ram under Win2003 Server?
> What version of MSSQL2000 do I have to use?
> thx
> reinhold
>

MSSQL2000 Maximum Memory

Hi,
I want to use MSSQL2000 on a server with 8GB ram amount.
Is there a way to use this ram under Win2003 Server?
What version of MSSQL2000 do I have to use?
thx
reinholdHi
You need to use:
Windows 2003 Enterprise Edition
SQL Server 2000 Enterprise Edition
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Reinhold" wrote:
> Hi,
> I want to use MSSQL2000 on a server with 8GB ram amount.
> Is there a way to use this ram under Win2003 Server?
> What version of MSSQL2000 do I have to use?
> thx
> reinhold
>
>|||See if this helps:
http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Reinhold" <reinholderlacher@.msn.com> wrote in message
news:OrbtVcisFHA.3424@.TK2MSFTNGP14.phx.gbl...
Hi,
I want to use MSSQL2000 on a server with 8GB ram amount.
Is there a way to use this ram under Win2003 Server?
What version of MSSQL2000 do I have to use?
thx
reinhold|||> I want to use MSSQL2000 on a server with 8GB ram amount.
> Is there a way to use this ram under Win2003 Server?
Assuming 32-bit, you need Windows 2003 Server Enterprise Edition and SQL
Server Enterprise Edition. SQL Server AWE needs to be enabled to address
over 3GB. Windows 2003 Standard has a 4GB max memory limitation and SQL
Server Standard is limited to 2Gb.
Windows 2003 system requirements:
http://www.microsoft.com/windowsserver2003/evaluation/sysreqs/default.mspx
How to configure memory for more than 2 GB in SQL Server:
http://support.microsoft.com/default.aspx?scid=kb;en-us;274750
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Reinhold" <reinholderlacher@.msn.com> wrote in message
news:OrbtVcisFHA.3424@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I want to use MSSQL2000 on a server with 8GB ram amount.
> Is there a way to use this ram under Win2003 Server?
> What version of MSSQL2000 do I have to use?
> thx
> reinhold
>

MSSQL Version

I have currently Standard Edition of MSSQL installed on my various servers. These servers are interacting with my one central server which also has Standard Edition of MSSQL.
Please let me know if I change my central server Standard Edition of MSSQL to Enterprise Edition and keep the other server with the Standard Edition, will this effect the working ?
Also please confirm, what are the changes in terms of query syntax or database setting that I will have to change for this change of version.i would not imagine there'd be any change required in your sql code as it remains fairly standard.

if you change the central server to enterprise edition you will obviously have to do some reconfigurations, but that's a given when installing something new, but i wouldn't imagine anything too drastic.

should connect and run well, good luck|||You can run a mix of Developer, Personal, Standard, and Enterprise versions of SQL Server with no problem. The Transact-SQL syntax is exactly the same on all of them, although there may be some SQL features that only exist on certain versions. As an example, clustering is only available to the Enterprise version, so you can't use clustering features in the Standard version, although the syntax would be the same if you could.

-PatP|||Thanks a lot !

MSSQL v7 sp4 Timesync

can anyone tell me if I can sync my server to a time server on the net while running this version of MSSQL? I am also running InSQL v 7.1 SP8 on the same machine. Win2K Server SP4.

Thanks

Gary

forgot to mention that the time zone has to be set to casablanca monrovia, is there any time servers out there with that zone?

Saturday, February 25, 2012

MSSQL to Oracle

hello,

I built my application using SQLClient classes and MSSQL database

i have another version of the database with Oracle, is changing to OracleClient classes the only change i have to do in order to run the program and the connection string?

Thanks

Nope...You also have to install the Oracle client, and give the accountthat your ASP.Net application is running under access to the directorythat the Oracle client is in.

Monday, February 20, 2012

ms-sql server "light"

I have read that there is a free version of Ms-Sql Server for educational
purposes. Is it true? thank you.Microsoft does have discounted licensing programmes available for
educational institutions but, as far as I'm aware, there isn't a special
"educational version".
http://www.microsoft.com/education/?ID=HowToBuy

MSDE is a free distributable version of SQLServer with certain limitations
and without the client tools:
http://www.microsoft.com/sql/msde/

There is also a 120 day evaluation available as a free download:
http://www.microsoft.com/sql/evalua...ial/default.asp

--
David Portas
----
Please reply only to the newsgroup
--

"billo" <jalden@.NOSPAM.it> wrote in message
news:dK%xb.121072$hV.4371271@.news2.tin.it...
> I have read that there is a free version of Ms-Sql Server for educational
> purposes. Is it true? thank you.|||Should have mentioned that there is also a Developer Edition priced at
$49.95. However, there are licensing restrictions on the use of this. You
would need to verify that your intended use comes within the terms of the
licence.

http://www.microsoft.com/sql/howtobuy/development.asp

--
David Portas
----
Please reply only to the newsgroup
--

"billo" <jalden@.NOSPAM.it> wrote in message
news:dK%xb.121072$hV.4371271@.news2.tin.it...
> I have read that there is a free version of Ms-Sql Server for educational
> purposes. Is it true? thank you.|||"billo" <jalden@.NOSPAM.it> wrote in message
news:dK%xb.121072$hV.4371271@.news2.tin.it...
> I have read that there is a free version of Ms-Sql Server for educational
> purposes. Is it true? thank you.

You're probably thinking of MSDE:

http://www.microsoft.com/sql/msde/d...ds/download.asp

Simon|||Ok it could be the MSDE2000. But with it what can I do? is like
MsSqlServer(ide,...) or is only an engine?

"Simon Hayes" <sql@.hayes.ch> ha scritto nel messaggio
news:3fc89409_1@.news.bluewin.ch...
> "billo" <jalden@.NOSPAM.it> wrote in message
> news:dK%xb.121072$hV.4371271@.news2.tin.it...
> > I have read that there is a free version of Ms-Sql Server for
educational
> > purposes. Is it true? thank you.
> You're probably thinking of MSDE:
> http://www.microsoft.com/sql/msde/d...ds/download.asp
> Simon|||"billo" <jalden@.NOSPAM.it> wrote in message news:<jZ8yb.123661$hV.4486085@.news2.tin.it>...
> Ok it could be the MSDE2000. But with it what can I do? is like
> MsSqlServer(ide,...) or is only an engine?
> "Simon Hayes" <sql@.hayes.ch> ha scritto nel messaggio
> news:3fc89409_1@.news.bluewin.ch...
> > "billo" <jalden@.NOSPAM.it> wrote in message
> > news:dK%xb.121072$hV.4371271@.news2.tin.it...
> > > I have read that there is a free version of Ms-Sql Server for
> educational
> > > purposes. Is it true? thank you.
> > > > You're probably thinking of MSDE:
> > http://www.microsoft.com/sql/msde/d...ds/download.asp
> > Simon

You can see the details of what's in MSDE on the MS web site. The main
points are that databases are limited to 2GB, performance drops with 5
or more concurrent connections, and there are no client tools except
for command line ones such as osql.exe (no Query Analyzer, Enterprise
Manager, Profiler etc.).

If those limitations aren't acceptable, then you could look at the
development edition, which I believe is the same as Enterprise
Edition, but only licensed for development.

Simon|||It's "only" the engine. If your purpose is to teach people the SQL Server
tools/IDE stuff then you'll need to check with MS what the best licensing
scheme for you is for the full SQL Server product.

> Ok it could be the MSDE2000. But with it what can I do? is like
> MsSqlServer(ide,...) or is only an engine?

Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvfor...p?SRV=MSDevApps
(faqxxx.zip in lib 7)
or http://www.ntfaq.com/Articles/Index...epartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq

Friday, March 23, 2012

Muliple rows for group side by side with data

Wednesday, March 21, 2012

MSSQServer 2000 for pocket pc

Monday, March 12, 2012

MSSQLSERVER errors on PC running MSDE

MSSQLSERVER errors on PC running MSDE

MSSQLSERVER errors on PC running MSDE

Friday, March 9, 2012

MSSQL2005 SP1 setup

Wednesday, March 7, 2012

MSSQL2005 64 bit + Client's 32 bit ODBC

MSSQL2000 Maximum Memory

MSSQL2000 Maximum Memory

MSSQL2000 Maximum Memory

MSSQL Version

MSSQL v7 sp4 Timesync

Saturday, February 25, 2012

MSSQL to Oracle

Monday, February 20, 2012

ms-sql server "light"

MSSQL Mistake

Blog Archive

About Me