Does Sql Ce 3.5 beta version support remote access in Intranet

I need to connect to a sql ce data file via Intranet .
Does sql ce support that ?
When I attempt to connect that remote file, it show me the error message
"There is a file sharing violation .A different process migth be using this file".

Does this mean , I can not do this .

This means that SQL Compact is a single user, in-process database, so when opening a file on a network share it will acquire an exclusive lock to the database file. For more information, see these blog entries from Jim Wilson:

http://www.pluralsight.com/blogs/jimw/archive/2007/02/19/46151.aspx

|||Good answer .

Thank you ErikEJ

I like this forum.

Does Sql Ce 3.5 beta version support remote access in Intranet

I need to connect to a sql ce data file via Intranet .
Does sql ce support that ?
When I attempt to connect that remote file, it show me the error message
"There is a file sharing violation .A different process migth be using this file".

Does this mean , I can not do this .

This means that SQL Compact is a single user, in-process database, so when opening a file on a network share it will acquire an exclusive lock to the database file. For more information, see these blog entries from Jim Wilson:

http://www.pluralsight.com/blogs/jimw/archive/2007/02/19/46151.aspx

|||Good answer .

Thank you ErikEJ

I like this forum.

Does SP4 client work OK with SP3a server?

Can a SQL2000 SP4 client connect without problems to a SQL2000 SP3a server?
We are planning on updating all the client pcs to SP4 before we upgrade the
servers.
Thanks
Rondid you hear examnotes <Ron@.discussions.microsoft.com> say in
news:0D2D4D7E-7BAF-4600-A545-0B2FB6E82291@.microsoft.com:

> Can a SQL2000 SP4 client connect without problems to a SQL2000 SP3a
> server? We are planning on updating all the client pcs to SP4 before
> we upgrade the servers.
> Thanks
> Ron
I have a mix of 3a and 4 and my client db libs are 4. you should be ok.
(My 2)
Neil MacMurchy
http://spaces.msn.com/members/neilmacmurchy
http://spaces.msn.com/members/mctblogs|||You won't be able to use Query Analyzer's debugger against the SP3a
servers. In SP4, Microsoft upgraded the debugger to use the .NET
framework. Other than that, there should be no problems.
Josh
Ron wrote:
> Can a SQL2000 SP4 client connect without problems to a SQL2000 SP3a server
?
> We are planning on updating all the client pcs to SP4 before we upgrade th
e
> servers.
> Thanks
> Ronsql

Does SP4 client work OK with SP3a server?

Can a SQL2000 SP4 client connect without problems to a SQL2000 SP3a server?
We are planning on updating all the client pcs to SP4 before we upgrade the
servers.
Thanks
Rondid you hear =?Utf-8?B?Um9u?= <Ron@.discussions.microsoft.com> say in
news:0D2D4D7E-7BAF-4600-A545-0B2FB6E82291@.microsoft.com:
> Can a SQL2000 SP4 client connect without problems to a SQL2000 SP3a
> server? We are planning on updating all the client pcs to SP4 before
> we upgrade the servers.
> Thanks
> Ron
I have a mix of 3a and 4 and my client db libs are 4. you should be ok.
(My 2¢)
--
Neil MacMurchy
http://spaces.msn.com/members/neilmacmurchy
http://spaces.msn.com/members/mctblogs|||You won't be able to use Query Analyzer's debugger against the SP3a
servers. In SP4, Microsoft upgraded the debugger to use the .NET
framework. Other than that, there should be no problems.
Josh
Ron wrote:
> Can a SQL2000 SP4 client connect without problems to a SQL2000 SP3a server?
> We are planning on updating all the client pcs to SP4 before we upgrade the
> servers.
> Thanks
> Ron

Does personal edition sql server support jdbc connection?

if it does, what are the settings I must do in the server?
since I got the following error when connect :
com.inet.tds.SQLException: Connection refused: connect
java.net.ConnectException: Connection refused: connect
thanksHi
Yes it does. Check your connection string. AFAIK, Integrated Security is not
supported so make sure that you supply a username and password. Check that
the username/password combination work through query analyzer.
The SQL Event log might show an audit failure (if not, turn auditing on for
failures, restart SQL Server and try again).
Regards
Mike
"Friend" wrote:
> if it does, what are the settings I must do in the server?
> since I got the following error when connect :
> com.inet.tds.SQLException: Connection refused: connect
> java.net.ConnectException: Connection refused: connect
> thanks
>

Does personal edition sql server support jdbc connection?

if it does, what are the settings I must do in the server?
since I got the following error when connect :
com.inet.tds.SQLException: Connection refused: connect
java.net.ConnectException: Connection refused: connect
thanks
Hi
Yes it does. Check your connection string. AFAIK, Integrated Security is not
supported so make sure that you supply a username and password. Check that
the username/password combination work through query analyzer.
The SQL Event log might show an audit failure (if not, turn auditing on for
failures, restart SQL Server and try again).
Regards
Mike
"Friend" wrote:

> if it does, what are the settings I must do in the server?
> since I got the following error when connect :
> com.inet.tds.SQLException: Connection refused: connect
> java.net.ConnectException: Connection refused: connect
> thanks
>

Does personal edition sql server support jdbc connection?

if it does, what are the settings I must do in the server?
since I got the following error when connect :
com.inet.tds.SQLException: Connection refused: connect
java.net.ConnectException: Connection refused: connect
thanksHi
Yes it does. Check your connection string. AFAIK, Integrated Security is not
supported so make sure that you supply a username and password. Check that
the username/password combination work through query analyzer.
The SQL Event log might show an audit failure (if not, turn auditing on for
failures, restart SQL Server and try again).
Regards
Mike
"Friend" wrote:

> if it does, what are the settings I must do in the server?
> since I got the following error when connect :
> com.inet.tds.SQLException: Connection refused: connect
> java.net.ConnectException: Connection refused: connect
> thanks
>sql

Does not connect with Enterprise Manger

I am not been able to connect to SQL Server with Enterprise Manger as I
increased the number of databases upto 170 .Earlier i had no problem when I
had less of databases .Moreover there is no problem in connecting through
Query Analyser.
Could any one help please ?
Regards
Musharraf SultanHi,
Are you getting any errors or any timeouts? Can you try the
enterperisemanager from the SQL server machine and see as well.
Thanks
Hari
SQL Server MVP
"NEWS" <musharrafs@.yahoo.com> wrote in message
news:eM$2fOlzGHA.4228@.TK2MSFTNGP06.phx.gbl...
>I am not been able to connect to SQL Server with Enterprise Manger as I
>increased the number of databases upto 170 .Earlier i had no problem when I
>had less of databases .Moreover there is no problem in connecting through
>Query Analyser.
> Could any one help please ?
> Regards
> Musharraf Sultan
>
>|||Thanks a lot ...
As soon as I try to connect from Enterprise Manager an Hourglass appears
and after some time if I see from Task manager
it shows NOT RESPONDING. The same thing happens on the Server as well as
from remote machines
Regards
Musharraf
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ebZ7GopzGHA.4920@.TK2MSFTNGP06.phx.gbl...
> Hi,
> Are you getting any errors or any timeouts? Can you try the
> enterperisemanager from the SQL server machine and see as well.
> Thanks
> Hari
> SQL Server MVP
> "NEWS" <musharrafs@.yahoo.com> wrote in message
> news:eM$2fOlzGHA.4228@.TK2MSFTNGP06.phx.gbl...
>|||Hi,
See the database option Autoclose is enabled. If yes use the SP_DBOPTION to
make the Autoclose disabled for all database.
Thanks
Hari
SQL Server MVP
"NEWS" <musharrafs@.yahoo.com> wrote in message
news:ePChVYB0GHA.2072@.TK2MSFTNGP06.phx.gbl...
> Thanks a lot ...
> As soon as I try to connect from Enterprise Manager an Hourglass appears
> and after some time if I see from Task manager
> it shows NOT RESPONDING. The same thing happens on the Server as well as
> from remote machines
> Regards
> Musharraf
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:ebZ7GopzGHA.4920@.TK2MSFTNGP06.phx.gbl...
>

Does not allow remote connections

I have installed SQL Server 2005 Std on an XP system for development using VS 2005. When I try to
connect to the DB via Server Management Studio, I get the message that "... does not allow remote
connections".
When I launch Surface Area Configuration and select the Surface Area Configuration for Services and
Connections, I see only 4 services listed: Analysis, Reporting, Integration and SQL Server Browser.
There is no Database Engine Service listed!
Have I installed incorrectly?
TIA LarsHello,
Please check if the following folder exist:
%programfiles%\Microsoft sql server\mssql.1\mssql\data
If it does not exist, it seems the database engine is not installed, you
may want to go to Add/Remove program to install this component.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>NNTP-Posting-Date: Fri, 10 Mar 2006 01:47:30 -0600
>From: larzeb <larzeb@.community.nospam>
>Newsgroups: microsoft.public.sqlserver.server
>Subject: Does not allow remote connections
>Date: Thu, 09 Mar 2006 23:47:23 -0800
>Message-ID: <oeb212ljn7hj2gqd0b795dkcd0mqv6qf3h@.4ax.com>
>X-Newsreader: Forte Agent 3.1/32.783
>MIME-Version: 1.0
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>Lines: 11
>X-Trace:
sv3-PjJxXeuzs9DydzPoFbzAokDHiY6O/KXDzjV8O7hEwxj/ljIdWbzP3wItPsTOueQ5nFw/SN8L
okMLvDY!lpKWpYf6RQBHuNvVXmwxsNoiCv3bMHVGU73LWN6CN48tFv9p/w4z0jbRyZAA6ZBcpvbv
WXA=>X-Complaints-To: abuse@.giganews.com
>X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
>X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
>X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your
complaint properly
>X-Postfilter: 1.3.32
>Path:
TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!border2.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.gigan
ews.com!local01.nntp.dca.giganews.com!news.giganews.com.POSTED!not-for-mail
>Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.server:423971
>X-Tomcat-NG: microsoft.public.sqlserver.server
>I have installed SQL Server 2005 Std on an XP system for development using
VS 2005. When I try to
>connect to the DB via Server Management Studio, I get the message that
"... does not allow remote
>connections".
>When I launch Surface Area Configuration and select the Surface Area
Configuration for Services and
>Connections, I see only 4 services listed: Analysis, Reporting,
Integration and SQL Server Browser.
>There is no Database Engine Service listed!
>Have I installed incorrectly?
>TIA Lars
>

Does it possibile use SQL Client 2000 and connect to the SQL7?

I'd like to know if SQL 2000 client and SQL 7 Server are compatible.
I need to connect a Windows 2003 Std Edition to the SQL Server 7.0, but as
you it is not possibile to install SQL 7.0 Client on the Windows server2003.
Tx
Suzana
Hi
Yes it is. SQL Server 2000 components are backward compatible with SQL
Server 7.0
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Suzan" <Suzan@.discussions.microsoft.com> wrote in message
news:D5D97C69-033D-4AF6-9343-22C11FA7F625@.microsoft.com...
> I'd like to know if SQL 2000 client and SQL 7 Server are compatible.
> I need to connect a Windows 2003 Std Edition to the SQL Server 7.0, but as
> you it is not possibile to install SQL 7.0 Client on the Windows
> server2003.
> Tx
> Suzana
>
|||Could you please tell me where can I find more information about
compatibility between SQL Client2000 and SQL server 7.0.
I found some information about how to connect a SQL Server 7.0 client to a
SQL Server 2000 but not vice versa
Thanks,
Suzan
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> Yes it is. SQL Server 2000 components are backward compatible with SQL
> Server 7.0
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Suzan" <Suzan@.discussions.microsoft.com> wrote in message
> news:D5D97C69-033D-4AF6-9343-22C11FA7F625@.microsoft.com...
>
>
|||Hi
This is all I found:
http://msdn.microsoft.com/library/de...bckwd_3vlc.asp
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Suzan" <Suzan@.discussions.microsoft.com> wrote in message
news:90E6271F-C04C-40F6-B0CC-E9D66D9A800F@.microsoft.com...[vbcol=seagreen]
> Could you please tell me where can I find more information about
> compatibility between SQL Client2000 and SQL server 7.0.
> I found some information about how to connect a SQL Server 7.0 client to a
> SQL Server 2000 but not vice versa
> Thanks,
> Suzan
>
> "Mike Epprecht (SQL MVP)" wrote:

Does Force Protocol Encryption on Server Require Certificate to be Installed on Client?

So I was able to enable the option to Force Protocol Encryption using
SQL. However, I was still able to connect to this instance of SQL
using the Query Analyzer tool from a machine without the certificate
(public key) installed.
This leads me to believe that the client connected to the server w/out
encrypting communications or that the client doesnt require a
certificate in order to connect (encrypted) to the instance of SQL now
configured to force protocol encryption. As a result, I have the
following question.
Once protocol encryption is enabled on the server using the SQL Server
Network Utility, must the certificate (public key) be installed on the
client in order to access SQL on the server (now configured to force
protocol encryption)?
What does it mean when I connect to the instance of SQL from a machine
w/out the certificate? How is this working? Are communications still
encrypted from client to server?
Thanks in advance for any help/direction.
If found a good article.
http://msdn.microsoft.com/library/de...SecNetHT19.asp
"Note that, in all cases, SQL Server sends its server authentication
certificate in the clear to the client at the beginning of the
communication sequence. This is part of the SSL protocol. Note that
this occurs even when neither the server nor the client requires
encryption."
nasteric@.yahoo.com (nasteric) wrote in message news:<e651d8ae.0406012052.5e1c2f41@.posting.google. com>...
> So I was able to enable the option to Force Protocol Encryption using
> SQL. However, I was still able to connect to this instance of SQL
> using the Query Analyzer tool from a machine without the certificate
> (public key) installed.
> This leads me to believe that the client connected to the server w/out
> encrypting communications or that the client doesnt require a
> certificate in order to connect (encrypted) to the instance of SQL now
> configured to force protocol encryption. As a result, I have the
> following question.
> Once protocol encryption is enabled on the server using the SQL Server
> Network Utility, must the certificate (public key) be installed on the
> client in order to access SQL on the server (now configured to force
> protocol encryption)?
> What does it mean when I connect to the instance of SQL from a machine
> w/out the certificate? How is this working? Are communications still
> encrypted from client to server?
> Thanks in advance for any help/direction.

Does Force Protocol Encryption on Server Require Certificate to be Installed on Client?

So I was able to enable the option to Force Protocol Encryption using
SQL. However, I was still able to connect to this instance of SQL
using the Query Analyzer tool from a machine without the certificate
(public key) installed.
This leads me to believe that the client connected to the server w/out
encrypting communications or that the client doesnt require a
certificate in order to connect (encrypted) to the instance of SQL now
configured to force protocol encryption. As a result, I have the
following question.
Once protocol encryption is enabled on the server using the SQL Server
Network Utility, must the certificate (public key) be installed on the
client in order to access SQL on the server (now configured to force
protocol encryption)?
What does it mean when I connect to the instance of SQL from a machine
w/out the certificate? How is this working? Are communications still
encrypted from client to server?
Thanks in advance for any help/direction.If found a good article.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetHT19.asp
"Note that, in all cases, SQL Server sends its server authentication
certificate in the clear to the client at the beginning of the
communication sequence. This is part of the SSL protocol. Note that
this occurs even when neither the server nor the client requires
encryption."
nasteric@.yahoo.com (nasteric) wrote in message news:<e651d8ae.0406012052.5e1c2f41@.posting.google.com>...
> So I was able to enable the option to Force Protocol Encryption using
> SQL. However, I was still able to connect to this instance of SQL
> using the Query Analyzer tool from a machine without the certificate
> (public key) installed.
> This leads me to believe that the client connected to the server w/out
> encrypting communications or that the client doesnt require a
> certificate in order to connect (encrypted) to the instance of SQL now
> configured to force protocol encryption. As a result, I have the
> following question.
> Once protocol encryption is enabled on the server using the SQL Server
> Network Utility, must the certificate (public key) be installed on the
> client in order to access SQL on the server (now configured to force
> protocol encryption)?
> What does it mean when I connect to the instance of SQL from a machine
> w/out the certificate? How is this working? Are communications still
> encrypted from client to server?
> Thanks in advance for any help/direction.

Does Force Protocol Encryption on Server Require Certificate to be Installed on Client

So I was able to enable the option to Force Protocol Encryption using
SQL. However, I was still able to connect to this instance of SQL
using the Query Analyzer tool from a machine without the certificate
(public key) installed.
This leads me to believe that the client connected to the server w/out
encrypting communications or that the client doesnt require a
certificate in order to connect (encrypted) to the instance of SQL now
configured to force protocol encryption. As a result, I have the
following question.
Once protocol encryption is enabled on the server using the SQL Server
Network Utility, must the certificate (public key) be installed on the
client in order to access SQL on the server (now configured to force
protocol encryption)?
What does it mean when I connect to the instance of SQL from a machine
w/out the certificate? How is this working? Are communications still
encrypted from client to server?
Thanks in advance for any help/direction.If you have a certificate on the Server and Force Protocol Encryption
turned on then the traffic is encrypted to and from all clients. The client
does not need a certificate.
Look at the following article:
HOW TO: Enable SSL Encryption for SQL Server 2000 with Microsoft Management
Console
http://support.microsoft.com/?id=316898
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Previous post:
"Once protocol encryption is enabled on the server using the SQL Server
Network Utility, must the certificate (public key) be installed on the
client in order to access SQL on the server (now configured to force
protocol encryption)?
"
The client only requires that the Trusted Root is updated if you enable
protocol encryption from the client.
If it is enabled via Server Network Utility, then the client doesn't need
to Trust the same Root Authority.
Essentially, all you need is a valid certificate on the server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||If found a good article.
NetHT19.asp" target="_blank">http://msdn.microsoft.com/library/d.../>
NetHT19.asp
"Note that, in all cases, SQL Server sends its server authentication
certificate in the clear to the client at the beginning of the
communication sequence. This is part of the SSL protocol. Note that
this occurs even when neither the server nor the client requires
encryption."
nasteric@.yahoo.com (nasteric) wrote in message news:<e651d8ae.0406012052.5e1c2f41@.posting.go
ogle.com>...
> So I was able to enable the option to Force Protocol Encryption using
> SQL. However, I was still able to connect to this instance of SQL
> using the Query Analyzer tool from a machine without the certificate
> (public key) installed.
> This leads me to believe that the client connected to the server w/out
> encrypting communications or that the client doesnt require a
> certificate in order to connect (encrypted) to the instance of SQL now
> configured to force protocol encryption. As a result, I have the
> following question.
> Once protocol encryption is enabled on the server using the SQL Server
> Network Utility, must the certificate (public key) be installed on the
> client in order to access SQL on the server (now configured to force
> protocol encryption)?
> What does it mean when I connect to the instance of SQL from a machine
> w/out the certificate? How is this working? Are communications still
> encrypted from client to server?
> Thanks in advance for any help/direction.

Does Force Protocol Encryption on Server Require Certificate to be Installed on Client

So I was able to enable the option to Force Protocol Encryption using
SQL. However, I was still able to connect to this instance of SQL
using the Query Analyzer tool from a machine without the certificate
(public key) installed.
This leads me to believe that the client connected to the server w/out
encrypting communications or that the client doesnt require a
certificate in order to connect (encrypted) to the instance of SQL now
configured to force protocol encryption. As a result, I have the
following question.
Once protocol encryption is enabled on the server using the SQL Server
Network Utility, must the certificate (public key) be installed on the
client in order to access SQL on the server (now configured to force
protocol encryption)?
What does it mean when I connect to the instance of SQL from a machine
w/out the certificate? How is this working? Are communications still
encrypted from client to server?
Thanks in advance for any help/direction.If found a good article.
NetHT19.asp" target="_blank">http://msdn.microsoft.com/library/d.../>
NetHT19.asp
"Note that, in all cases, SQL Server sends its server authentication
certificate in the clear to the client at the beginning of the
communication sequence. This is part of the SSL protocol. Note that
this occurs even when neither the server nor the client requires
encryption."
nasteric@.yahoo.com (nasteric) wrote in message news:<e651d8ae.0406012052.5e1c2f41@.posting.go
ogle.com>...
> So I was able to enable the option to Force Protocol Encryption using
> SQL. However, I was still able to connect to this instance of SQL
> using the Query Analyzer tool from a machine without the certificate
> (public key) installed.
> This leads me to believe that the client connected to the server w/out
> encrypting communications or that the client doesnt require a
> certificate in order to connect (encrypted) to the instance of SQL now
> configured to force protocol encryption. As a result, I have the
> following question.
> Once protocol encryption is enabled on the server using the SQL Server
> Network Utility, must the certificate (public key) be installed on the
> client in order to access SQL on the server (now configured to force
> protocol encryption)?
> What does it mean when I connect to the instance of SQL from a machine
> w/out the certificate? How is this working? Are communications still
> encrypted from client to server?
> Thanks in advance for any help/direction.

Does anyone know where I can connect to a test SQL box?

I recently lost my job and wanted to do some test development to keep my skills up to date. The problem is I don't have access to any data sources. Is there such a thing around? I tried installing microsoft's trial of SQL 2005 but can't get it to run on my laptop and SQL 2000 trial no longer exists. I simply need to create a SQL db/tables etc. Thanks in advance.

You probably want SQL 2005 Express.

Jeff

|||

jeff@.zina.com:

You probably want SQL 2005 Express.

Jeff

Thanks. I'll take a look at it.|||

wescosoft:

I recently lost my job and wanted to do some test development to keep my skills up to date. The problem is I don't have access to any data sources. Is there such a thing around? I tried installing microsoft's trial of SQL 2005 but can't get it to run on my laptop and SQL 2000 trial no longer exists. I simply need to create a SQL db/tables etc. Thanks in advance.

An employer will not give you Express for development so it is better to download the eval version which is good for 180 days to use for your development. The product almost self install after you choose components Hope this helps.

http://www.microsoft.com/sql/downloads/trial-software.mspx

|||Odd, my employer gave me Express for development. But we also have production, test, and staging sql servers as well.|||

Motley:

Odd, my employer gave me Express for development. But we also have production, test, and staging sql servers as well.

Most employers give personnal edition which is complete SQL Server for development. Express installs with VS, that does not mean employers give Express for development.

|||

SQL Personal Edition, SQL Desktop, and MSDE are what SQL Express is in 2005. And I've found that employers don't normally give anything, development teams and shops have different methods of development. Most that I deal with use development servers, which are full SQL Server editions that match the deployment servers.

There are limitations to SQL Express, but most shouldn't impede using it for web development.

Jeff

|||

jeff@.zina.com:

SQL Personal Edition, SQL Desktop, and MSDE are what SQL Express is in 2005. And I've found that employers don't normally give anything, development teams and shops have different methods of development. Most that I deal with use development servers, which are full SQL Server editions that match the deployment servers.

There are limitations to SQL Express, but most shouldn't impede using it for web development.

Jeff

Personnal is not MSDE so it is not Express, MSDE is Express and it is not a way to learn data driven web application development because a lot of what you need to run your application are SQL Server Agent dependent and there is no Agent in Express.

|||There is no 2005 Personal Edition, atleast not that I am aware of. Enterprise, Standard, Workgroup, Express, Developer, and I believe there is a Mobile Edition as well. You may be thinking of the Developer Edition which is similiar in fuctionality to Enterprise with some licensing restrictions.|||I did not say there is personnal in SQL Server 2005 but Express is not a replacement for personnal because it was a complete SQL Server. That is the reason I gave the user the eval version.

does anyone know the answer?

i have two Running Total Fields
Total NWN and Total Keyed
how can i add these two Running Total Fields?
and how can i connect mysql to crystal report?
thanks1) Just add them in a formula
{#Total NWN} + {#Total Keyed}

2) Don't know|||i have two Running Total Fields
Total NWN and Total Keyed

how can i add these two Running Total Fields?
At the end of outer group which calculates total of these fields,
add like this: {Total Keyed} + {Total NWN}.
Please try since i didn't test this syntax.

and how can i connect mysql to crystal report?

thanks
Did you read the answer in your previous started thread? ("http://www.dev-archive.com/forum/showthread.php?t=437244) :mad: