How to setup two equal databases environment

Dear all,
I have an application running on a production database. And now, I
want to change a column of data to another of value and compare the result
between them. Since the data in production is changing. I need to
synchronize two set of data except the testing data. For do that, I build
replication on these two database. This is my first time using replication.
I found there's an initialize error on during synchronization job. Is there
any guideline on setup replication? Thanks
Rdgs
Ellis
Ellis,
can you explain this in a little more detail using column names and
explaining the relationship between the databases. Also, what type of
replication have you implemented.
TIA,
Paul Ibison
sql

How to 'share drive', SCSI HD's on servers

I am not using a SAN to setup Win2003 CLusters, two nodes.
How can I share the hard disk in order to make this work for both nodes ?
All documentation I read states that I must have shared hard disk common to
the two servers and that's not clear to me when all I have is that hard
drive on the respective servers.
You can use SCSI disks. Just make sure whatever you get is on the catalog:
http://www.microsoft.com/windows/cat...5-23e9cd3ae95b
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"Marlon Brown" <marlon_brown@.hotmail.com> wrote in message
news:OEEkMpCdEHA.3016@.tk2msftngp13.phx.gbl...
> I am not using a SAN to setup Win2003 CLusters, two nodes.
> How can I share the hard disk in order to make this work for both nodes ?
> All documentation I read states that I must have shared hard disk common
to
> the two servers and that's not clear to me when all I have is that hard
> drive on the respective servers.
>

How to Setup VS Studio 2005 for Import and Export to SQL Server 2005 Express as performed in SQL

Greetings all,

I have just been getting used to the new VS.NET 2005 IDE environment, IT ROCKS!. And this integrated help is pretty useful when we can all collaborate on the many technical topics we all share.

After reading many post blasting Microsoft for NOT including the DTS Import/Export functionality to SQL Server 2005 Express, and many people just threatening to go back to only use SQL Server 2000. I decided to look into this.

And found an actually simple way to do this.

The new Microsoft IDE in VS.NET 2005 includes the ability to define custom tools to be accessible in the Main Tools Menu.

Follow these steps:

1. Click Tools Menu (in VS.NET 2005 IDE)
2. Click External Tools
3. Define name for menu item in the Title text box
4. Define full path and name of executable in the Command text box
5. Define parameters to pass in the Arguments text box

You can launch any external application here, and a Menu Item is created. You can also pass parameters to this, and this is how we can do some DTS stuff if you do have SQL Server 2000 installed on either your local system, or a system you can access from your computer.

There is a program that ships with SQL Server 2000 call DTSWIZ.EXE. This
is used from the SQL Server Enterprise Manager. (Note: Make sure you have sufficient access to this location)

To use this, first check out the parameters is expects.

1. Shell out to DOS
Click Start, Run, then type in cmd and hit [ENTER]

2. Navigate to location of SQL Server
\Program Files\Microsoft SQL Server\80\Tools\Binn\dtswiz.exe

This program supports several parameters, you can launch this wizard in several ways.

example:

To start up DTS Import
dtswiz.exe /n /i

To start up DTS Export
dtswiz.exe /n /x

Once you have this in place, then you want to Import Data. Simply choose
Import from the Tools menu (the External Tool item you created above)

1. In the Data Source drop down, select SQL Native Client.
2. Click Properties Button (lower left corner)
3. In the Data Source of this screen, put full path to SQL 2005 Express Database
4. Choose authentication
5. Choose Exit

Follow the remaining steps of the wizard for selecting which tables you wanted to import.

This has been thoroughly tested on the following:

Pentium 3 Two-Gigerhz Dual Processer
1 Gig Memory
Running Visual Studio 2005, SQL Server 2005 Express
and SQL Server 2000 located on a different Server computer.

I've simply created a Mapped Network drive to the
\Program Files\Microsoft SQL Server\80\Tools\Binn
to have access to the tools.

Hopefully others can use this activating IMPORT and EXPORT functionality
so you can port some of your smaller SQL Server 2000 databases to a different data tier model.

I am starting to contribute here, hopefully others will get themself a Windows Password account if you don't have one already, and start sharing more material between ourselves.

?/"/"[ Dreams pull reality closer to use all ]"\"\"
Dim Mind as New Mind
If Mind.Thinking then
Mind.GetThought("VS.NET")
If Mind.Feelings = Feel.FreakingROCKS then
Call KeepThingsRockin
End If
End If
CodeDoctor

I can't get this to work on Vista. I get an error that DTS couldn't create an instance.
|||

Am new to this. I have access to the DTS WIZ but cannot edit the saved package in SSE.

Going Mad!!!

Sudip

sql

How to Setup VS Studio 2005 for Import and Export to SQL Server 2005 Express as performed in SQL

Greetings all,

I have just been getting used to the new VS.NET 2005 IDE environment, IT ROCKS!. And this integrated help is pretty useful when we can all collaborate on the many technical topics we all share.

After reading many post blasting Microsoft for NOT including the DTS Import/Export functionality to SQL Server 2005 Express, and many people just threatening to go back to only use SQL Server 2000. I decided to look into this.

And found an actually simple way to do this.

The new Microsoft IDE in VS.NET 2005 includes the ability to define custom tools to be accessible in the Main Tools Menu.

Follow these steps:

1. Click Tools Menu (in VS.NET 2005 IDE)
2. Click External Tools
3. Define name for menu item in the Title text box
4. Define full path and name of executable in the Command text box
5. Define parameters to pass in the Arguments text box

You can launch any external application here, and a Menu Item is created. You can also pass parameters to this, and this is how we can do some DTS stuff if you do have SQL Server 2000 installed on either your local system, or a system you can access from your computer.

There is a program that ships with SQL Server 2000 call DTSWIZ.EXE. This
is used from the SQL Server Enterprise Manager. (Note: Make sure you have sufficient access to this location)

To use this, first check out the parameters is expects.

1. Shell out to DOS
Click Start, Run, then type in cmd and hit [ENTER]

2. Navigate to location of SQL Server
\Program Files\Microsoft SQL Server\80\Tools\Binn\dtswiz.exe

This program supports several parameters, you can launch this wizard in several ways.

example:

To start up DTS Import
dtswiz.exe /n /i

To start up DTS Export
dtswiz.exe /n /x

Once you have this in place, then you want to Import Data. Simply choose
Import from the Tools menu (the External Tool item you created above)

1. In the Data Source drop down, select SQL Native Client.
2. Click Properties Button (lower left corner)
3. In the Data Source of this screen, put full path to SQL 2005 Express Database
4. Choose authentication
5. Choose Exit

Follow the remaining steps of the wizard for selecting which tables you wanted to import.

This has been thoroughly tested on the following:

Pentium 3 Two-Gigerhz Dual Processer
1 Gig Memory
Running Visual Studio 2005, SQL Server 2005 Express
and SQL Server 2000 located on a different Server computer.

I've simply created a Mapped Network drive to the
\Program Files\Microsoft SQL Server\80\Tools\Binn
to have access to the tools.

Hopefully others can use this activating IMPORT and EXPORT functionality
so you can port some of your smaller SQL Server 2000 databases to a different data tier model.

I am starting to contribute here, hopefully others will get themself a Windows Password account if you don't have one already, and start sharing more material between ourselves.

?/"/"[ Dreams pull reality closer to use all ]"\"\"
Dim Mind as New Mind
If Mind.Thinking then
Mind.GetThought("VS.NET")
If Mind.Feelings = Feel.FreakingROCKS then
Call KeepThingsRockin
End If
End If
CodeDoctor

I can't get this to work on Vista. I get an error that DTS couldn't create an instance.
|||

Am new to this. I have access to the DTS WIZ but cannot edit the saved package in SSE.

Going Mad!!!

Sudip

How to Setup VS Studio 2005 for Import and Export to SQL Server 2005 Express as performed in

Greetings all,

I have just been getting used to the new VS.NET 2005 IDE environment, IT ROCKS!. And this integrated help is pretty useful when we can all collaborate on the many technical topics we all share.

After reading many post blasting Microsoft for NOT including the DTS Import/Export functionality to SQL Server 2005 Express, and many people just threatening to go back to only use SQL Server 2000. I decided to look into this.

And found an actually simple way to do this.

The new Microsoft IDE in VS.NET 2005 includes the ability to define custom tools to be accessible in the Main Tools Menu.

Follow these steps:

1. Click Tools Menu (in VS.NET 2005 IDE)
2. Click External Tools
3. Define name for menu item in the Title text box
4. Define full path and name of executable in the Command text box
5. Define parameters to pass in the Arguments text box

You can launch any external application here, and a Menu Item is created. You can also pass parameters to this, and this is how we can do some DTS stuff if you do have SQL Server 2000 installed on either your local system, or a system you can access from your computer.

There is a program that ships with SQL Server 2000 call DTSWIZ.EXE. This
is used from the SQL Server Enterprise Manager. (Note: Make sure you have sufficient access to this location)

To use this, first check out the parameters is expects.

1. Shell out to DOS
Click Start, Run, then type in cmd and hit [ENTER]

2. Navigate to location of SQL Server
\Program Files\Microsoft SQL Server\80\Tools\Binn\dtswiz.exe

This program supports several parameters, you can launch this wizard in several ways.

example:

To start up DTS Import
dtswiz.exe /n /i

To start up DTS Export
dtswiz.exe /n /x

Once you have this in place, then you want to Import Data. Simply choose
Import from the Tools menu (the External Tool item you created above)

1. In the Data Source drop down, select SQL Native Client.
2. Click Properties Button (lower left corner)
3. In the Data Source of this screen, put full path to SQL 2005 Express Database
4. Choose authentication
5. Choose Exit

Follow the remaining steps of the wizard for selecting which tables you wanted to import.

This has been thoroughly tested on the following:

Pentium 3 Two-Gigerhz Dual Processer
1 Gig Memory
Running Visual Studio 2005, SQL Server 2005 Express
and SQL Server 2000 located on a different Server computer.

I've simply created a Mapped Network drive to the
\Program Files\Microsoft SQL Server\80\Tools\Binn
to have access to the tools.

Hopefully others can use this activating IMPORT and EXPORT functionality
so you can port some of your smaller SQL Server 2000 databases to a different data tier model.

I am starting to contribute here, hopefully others will get themself a Windows Password account if you don't have one already, and start sharing more material between ourselves.

?/"/"[ Dreams pull reality closer to use all ]"\"\"
Dim Mind as New Mind
If Mind.Thinking then
Mind.GetThought("VS.NET")
If Mind.Feelings = Feel.FreakingROCKS then
Call KeepThingsRockin
End If
End If
CodeDoctor

I can't get this to work on Vista. I get an error that DTS couldn't create an instance.|||

Am new to this. I have access to the DTS WIZ but cannot edit the saved package in SSE.

Going Mad!!!

Sudip

How to setup two equal databases environment

Dear all,
I have an application running on a production database. And now, I
want to change a column of data to another of value and compare the result
between them. Since the data in production is changing. I need to
synchronize two set of data except the testing data. For do that, I build
replication on these two database. This is my first time using replication.
I found there's an initialize error on during synchronization job. Is there
any guideline on setup replication? Thanks
Rdgs
EllisEllis,
can you explain this in a little more detail using column names and
explaining the relationship between the databases. Also, what type of
replication have you implemented.
TIA,
Paul Ibison

How to setup two equal databases environment

Dear all,
I have an application running on a production database. And now, I
want to change a column of data to another of value and compare the result
between them. Since the data in production is changing. I need to
synchronize two set of data except the testing data. For do that, I build
replication on these two database. This is my first time using replication.
I found there's an initialize error on during synchronization job. Is there
any guideline on setup replication? Thanks
Rdgs
Ellis
Ellis,
can you explain this in a little more detail using column names and
explaining the relationship between the databases. Also, what type of
replication have you implemented.
TIA,
Paul Ibison

How to setup two equal databases environment

Dear all,
I have an application running on a production database. And now, I
want to change a column of data to another of value and compare the result
between them. Since the data in production is changing. I need to
synchronize two set of data except the testing data. For do that, I build
replication on these two database. This is my first time using replication.
I found there's an initialize error on during synchronization job. Is there
any guideline on setup replication? Thanks
Rdgs
EllisEllis,
can you explain this in a little more detail using column names and
explaining the relationship between the databases. Also, what type of
replication have you implemented.
TIA,
Paul Ibison

how to setup this query?

hi,
i have a table which has an ID, Time (unix time in seconds), and a score. th
e data looks something like this:
ID Time Score
1 1079748053937 1.0
2 1079748053945 0.67
3 1079748053945 0.32
4 1079748053945 0.01
5 1079748053950 0.90
6 1079748053950 0.1
my problem is that i want to write a query that will get the highest score a
t a given time. can anyone offer any help'
thanks!If I understand what you want, the highest score for each
time can be obtained with something like:
select time, max(score)
from your table
group by time
-Sue
On Mon, 22 Mar 2004 11:51:14 -0800, "mike"
<anonymous@.discussions.microsoft.com> wrote:

>hi,
> i have a table which has an ID, Time (unix time in seconds), and a score.
the data looks something like this:
>ID Time Score
>1 1079748053937 1.0
>2 1079748053945 0.67
>3 1079748053945 0.32
>4 1079748053945 0.01
>5 1079748053950 0.90
>6 1079748053950 0.1
>my problem is that i want to write a query that will get the highest score
at a given time. can anyone offer any help'
>thanks!

how to setup the permission of share fold in log shipping ?

when I set up log shipping in SQL SERVER 2000
I got the following error:
'Unable to copy the initialization file to the secondary server '%s' '
I know this is permission question about the share fold to log file.
I want to know the following thing:
one is how to setup permisson about about the share fold to log file?
two is whether log shpping primary and the secondary db must be run
in domin mode or not?
thanks in advance!
1. if your logshipping jobs are owned by 'sa', the acct for sqlserver
service needs to have access to the shared.
2. no, they do not have to be running in a same domain. the key here is to
ensure each server can access the shared.
-oj
<lovexueer@.gmail.com> wrote in message
news:1143611950.475014.180370@.i39g2000cwa.googlegr oups.com...
> when I set up log shipping in SQL SERVER 2000
> I got the following error:
> 'Unable to copy the initialization file to the secondary server '%s' '
> I know this is permission question about the share fold to log file.
> I want to know the following thing:
> one is how to setup permisson about about the share fold to log file?
> two is whether log shpping primary and the secondary db must be run
> in domin mode or not?
>
> thanks in advance!
>

how to setup the permission of share fold in log shipping ?

when I set up log shipping in SQL SERVER 2000
I got the following error:
'Unable to copy the initialization file to the secondary server '%s' '
I know this is permission question about the share fold to log file.
I want to know the following thing:
one is how to setup permisson about about the share fold to log file?
two is whether log shpping primary and the secondary db must be run
in domin mode or not?
thanks in advance!1. if your logshipping jobs are owned by 'sa', the acct for sqlserver
service needs to have access to the shared.
2. no, they do not have to be running in a same domain. the key here is to
ensure each server can access the shared.
-oj
<lovexueer@.gmail.com> wrote in message
news:1143611950.475014.180370@.i39g2000cwa.googlegroups.com...
> when I set up log shipping in SQL SERVER 2000
> I got the following error:
> 'Unable to copy the initialization file to the secondary server '%s' '
> I know this is permission question about the share fold to log file.
> I want to know the following thing:
> one is how to setup permisson about about the share fold to log file?
> two is whether log shpping primary and the secondary db must be run
> in domin mode or not?
>
> thanks in advance!
>

how to setup the permission of share fold in log shipping ?

when I set up log shipping in SQL SERVER 2000
I got the following error:
'Unable to copy the initialization file to the secondary server '%s' '
I know this is permission question about the share fold to log file.
I want to know the following thing:
one is how to setup permisson about about the share fold to log file?
two is whether log shpping primary and the secondary db must be run
in domin mode or not?
thanks in advance!1. if your logshipping jobs are owned by 'sa', the acct for sqlserver
service needs to have access to the shared.
2. no, they do not have to be running in a same domain. the key here is to
ensure each server can access the shared.
--
-oj
<lovexueer@.gmail.com> wrote in message
news:1143611950.475014.180370@.i39g2000cwa.googlegroups.com...
> when I set up log shipping in SQL SERVER 2000
> I got the following error:
> 'Unable to copy the initialization file to the secondary server '%s' '
> I know this is permission question about the share fold to log file.
> I want to know the following thing:
> one is how to setup permisson about about the share fold to log file?
> two is whether log shpping primary and the secondary db must be run
> in domin mode or not?
>
> thanks in advance!
>|||sorry,I don't understand what you said to the first quesiton?
can you tell furthur detailed information about how to setup the
permisson of shared fold ?sql

How to setup SQL Mail on SQL 2005 express

Hi All,
I know the full version of SQL 2005 uses SMTP, and I know where to set it
up. I just installed SQL express and I can't find where to setup mail.
TIA,
JoeHere's a quote from 2005 BOL:
"Note:
Database Mail is not available in SQL Server 2005 Express Edition. "
Consider using xp_smtp_sendmail (Google) instead.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:57DCA9FF-798E-440F-AF6C-B4C6B19D08F2@.microsoft.com...
> Hi All,
> I know the full version of SQL 2005 uses SMTP, and I know where to set it
> up. I just installed SQL express and I can't find where to setup mail.
> TIA,
> Joe
>|||Database Mail is not supported under Express (neither is SQL Mail).
You can write your own or there are also some downloads and scripts
available on the Internet that you can use for Mail in Express. One
download is amDBObj at:
http://www.asql.biz/en/Download2005.aspx
-Sue
On Tue, 13 Mar 2007 06:50:36 -0700, jaylou
<jaylou@.discussions.microsoft.com> wrote:
>Hi All,
>I know the full version of SQL 2005 uses SMTP, and I know where to set it
>up. I just installed SQL express and I can't find where to setup mail.
>TIA,
>Joe

How to setup SQL Mail on SQL 2005 express

Hi All,
I know the full version of SQL 2005 uses SMTP, and I know where to set it
up. I just installed SQL express and I can't find where to setup mail.
TIA,
Joe
Database Mail is not supported under Express (neither is SQL Mail).
You can write your own or there are also some downloads and scripts
available on the Internet that you can use for Mail in Express. One
download is amDBObj at:
http://www.asql.biz/en/Download2005.aspx
-Sue
On Tue, 13 Mar 2007 06:50:36 -0700, jaylou
<jaylou@.discussions.microsoft.com> wrote:

>Hi All,
>I know the full version of SQL 2005 uses SMTP, and I know where to set it
>up. I just installed SQL express and I can't find where to setup mail.
>TIA,
>Joe

How to setup SQL Mail on SQL 2005 express

Hi All,
I know the full version of SQL 2005 uses SMTP, and I know where to set it
up. I just installed SQL express and I can't find where to setup mail.
TIA,
JoeHere's a quote from 2005 BOL:
"Note:
Database Mail is not available in SQL Server 2005 Express Edition. "
Consider using xp_smtp_sendmail (Google) instead.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:57DCA9FF-798E-440F-AF6C-B4C6B19D08F2@.microsoft.com...
> Hi All,
> I know the full version of SQL 2005 uses SMTP, and I know where to set it
> up. I just installed SQL express and I can't find where to setup mail.
> TIA,
> Joe
>|||Database Mail is not supported under Express (neither is SQL Mail).
You can write your own or there are also some downloads and scripts
available on the Internet that you can use for Mail in Express. One
download is amDBObj at:
http://www.asql.biz/en/Download2005.aspx
-Sue
On Tue, 13 Mar 2007 06:50:36 -0700, jaylou
<jaylou@.discussions.microsoft.com> wrote:

>Hi All,
>I know the full version of SQL 2005 uses SMTP, and I know where to set it
>up. I just installed SQL express and I can't find where to setup mail.
>TIA,
>Joe

HOW TO setup SQL MAIL

hi, I want to receive a mail when SQL Server Agent JOB fail,so I go to setup the SQL MAIL,but it skip an error "xp_get_mapi_profiles: Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client." Someboby can tell me how to solve it?

thank you!

Hi,

SQL Mail needs a mapi file.

You can create this file either with Outlook or with Outlook Express.

regards matthias

|||

Thank you ! can you tell me the detailed resolvent.

|||

don't forget, if you're using SQL 2005, you should use "Database Mail" instead of "SQL Mail" which is being deprecated

http://www.microsoft.com/sql/prodinfo/features/top30features.mspx

http://www.sql-server-performance.com/da_email_functionality.asp

sql

How to setup SQL Express for course use

I will be teaching a web scripting course, and I would like to switch from using MS Access to MS SQL as a database. Please forgive my ignorance, as have much to learn about SQL Express. We have installed SQL Express on a web server (windows box).

Question1:
is SQL like MS Access, in that the SQL Express software should be installed locally on the users machine. The user will create databases and tables locally, then upload the resulting database(s) to the appropriate folder on the web server along with web scripting files?
-- OR
is MS SQL like MySQL, where the db is installed on the remote server, and user accounts are created within the database with appropriate priv.'s. The user logs in to the db application remotely to create tables within a given database.

You can install it either way (locally or remotely). I could see advantages to both. If they install it locally to each machine, you wouldn't have to worry about setting up users/permissions/remote connections, etc on a central server. But if you install it on a central server, you only have to go through the install one time and don't have to worry about the student upload/transfer.

If you don't have much experience with Express, I'd suggest installing Express Advanced so you can get the GUI management tools as well.

Thanks,
Sam Lester (MSFT)

How to setup SQL auth. for SQLserver 2005 express?

Hi,

I can't seem to set up SQL server authentication for SQLserver 2005 Express edition..

I simply can't find the settings for that. I have Management Studio Express installed and I can see the SA user but I can't login using that user.. I know that there's supposed to be a setting for turning on SQL auth. but it's not like it used to be in Enterprise manager :) so I can't find it.. ;/ I couldn't find any documentation on how to do this so I thought I'll try here..

(I need SQL auth for my project :) - it must be done with that..)

Thanks in advance,

ZenX

Hi,

have a look in on my site in the Screencast section, there is a detailed Screencast for this which will show you the steps.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

How to setup Sharepoint Portal Server 2003 with SQL Sever 2005

Hello, everyone

I try to set up Sharepoint Portal Server 2003 in SQL Server 2005 database (on Windows 2003 Server R2). But It cannot create new portal site... the Error message told about "cannot access instance..." (in fact that I input the correct instance, user, and password)...? I wanna know that How to setup it...

Setapong

? Hi, Read the topic Deploying Reporting Services and Windows SharePoint Services Side-by-Side in Books Online. Andrew Watt [MVP] <Setapong@.discussions.microsoft.com> wrote in message news:7f684d78-a79f-4004-8611-cc687d9cff43@.discussions.microsoft.com... Hello, everyone I try to set up Sharepoint Portal Server 2003 in SQL Server 2005 database (on Windows 2003 Server R2). But It cannot create new portal site... the Error message told about "cannot access instance..." (in fact that I input the correct instance, user, and password)...? I wanna know that How to setup it... Setapong

How to setup SelectParameters programmatically?

Hi,

I am using Visual Web Developer 2005 Express Edition.

I am trying to SELECT three information fields from a table when the Page_Load take place (so I select the info on the fly). The refering page, sends the spesific record id as "Articleid", that looks typically like this: "http://localhost:1424/BelaBela/accom_Contents.aspx?Articleid=2". I need to extract the "Article=2" so that I can access record 2 (in this example).

How do I define the SelectParameters or QueryStingField on the fly so that I can define the WHERE part of my query (see code below). If I remove the WHERE portion, then it works, but it seem to return the very last record in the database, and if I include it, then I get an error "Must declare the scalar variable @.resortid". How do I programatically set it up so that @.resortid contains the value that is associated with "Articleid"?

My code is below.

Thank you for your advise!

Regards
Jan

/******************************************************************************** RETRIEVE INFORMATION FROM DATABASE*******************************************************************************/// specify the data sourcestring connContStr = ConfigurationManager.ConnectionStrings["tourism_connect1"].ConnectionString;SqlConnection myConn =new SqlConnection(connContStr);// define the command queryString query ="SELECT resortid, TourismGrading, resortHits FROM Resorts WHERE ([resortid] = @.resortid)";SqlCommand myCommand =new SqlCommand(query, myConn);// open the connection and instantiate a datareadermyConn.Open();SqlDataReader myReader = myCommand.ExecuteReader();// loop thru the readerwhile (myReader.Read()){ Label5.Text = myReader.GetInt32(0).ToString(); Label6.Text = myReader.GetInt32(1).ToString(); Label7.Text = myReader.GetInt32(2).ToString();}// close the reader and the connectionmyReader.Close();myConn.Close();

You can try the following, but you may need to change the resotid if it is an integer type.

SqlCommand myCommand =new SqlCommand(query, myConn);

myCommand.Parameters.Add("@.resortid"

,SqlDbType.NVarChar, 10).Value =Request.QueryString("resortid");|||

Something like this: 

String ArticleID;if (Request.QueryString["ArticleID"] !=null) ArticleID = Request.QueryString["ArticleID"];else// handle bad parameterSqlParameter param =new SqlParameter();param.ParameterName ="@.resortId";param.Value = ArticleID.ToInt32();myConn.Parameters.Add(param);

|||

Hi Limno and SGWellens,

Thanks for your help - I managed to get it working like a charm!

Regards

Jan