'Instances' of SQL Server 2000?

Our application requires multiple instances of SQL Server 2000 in order to h
ave multiple databases, which the app clients use. Has something to do with
the name of the SQL Server instance; each instance needs to be named differe
ntly.
How does this work? Do I install SQL Server multiple times in different loca
tions, or is it simply a defined thing in SQL Server? Is there a 'per instan
ce' licensing issue, or will my one SQL Server license cover the multiple in
stances of SQL Server on on
e server system?
Thanks,
JohnI believe Standard edition is licensed per instance but Enterprise Edition
can be installed with multiple instances on a server. It's best to check
the EULA to be totally certain though. But having to buy one new copy of SE
could be worth looking at why this very odd requirement was "assumed" in the
application's design IMO.
hth
Eric
John wrote:
> Our application requires multiple instances of SQL Server 2000 in
> order to have multiple databases, which the app clients use. Has
> something to do with the name of the SQL Server instance; each
> instance needs to be named differently.
> How does this work? Do I install SQL Server multiple times in
> different locations, or is it simply a defined thing in SQL Server?
> Is there a 'per instance' licensing issue, or will my one SQL Server
> license cover the multiple instances of SQL Server on one server
> system?
> Thanks,
> John|||> Our application requires multiple instances of SQL Server 2000 in order to
have multiple databases
That's the part I don't get. Why can't the application use multiple
databases in a single instance?

> How does this work? Do I install SQL Server multiple times in different
locations
For multiple instances, yes.

> Is there a 'per instance' licensing issue
Depending on the edition of SQL Server, the licensing model you're using,
the OS, etc. You really should verify licensing compliance with a local
Microsoft rep. They can give you the legal answer as opposed to collating a
variety of opinions here.
http://www.aspfaq.com/
(Reverse address to reply.)|||It is poor design IMO, but I have to live with it. On the matter of the mult
iple instances, what is meant by 'instance'? multiple installations? multipl
e 'spawnings' of SQL Server under a parent 'SQL Server manager-like' server
process? does it end up loo
king like multiple servers systems each running a SQL Server, each with diff
erent names, data paths, etc, but actually all running on the same server sy
stem?
John
"Eric Sabine" wrote:

> I believe Standard edition is licensed per instance but Enterprise Edition
> can be installed with multiple instances on a server. It's best to check
> the EULA to be totally certain though. But having to buy one new copy of
SE
> could be worth looking at why this very odd requirement was "assumed" in t
he
> application's design IMO.
> hth
> Eric
> John wrote:
>
>|||Think of an instance of how many times you ran setup.exe through completion
of the wizard. Every instance after the default (if the default is taken
at first install) has the name of the server _and_ instance name as the name
of the sql server itself.
John wrote:[vbcol=seagreen]
> It is poor design IMO, but I have to live with it. On the matter of
> the multiple instances, what is meant by 'instance'? multiple
> installations? multiple 'spawnings' of SQL Server under a parent 'SQL
> Server manager-like' server process? does it end up looking like
> multiple servers systems each running a SQL Server, each with
> different names, data paths, etc, but actually all running on the
> same server system?
> John
> "Eric Sabine" wrote:
>

'Instances' of SQL Server 2000?

Our application requires multiple instances of SQL Server 2000 in order to have multiple databases, which the app clients use. Has something to do with the name of the SQL Server instance; each instance needs to be named differently.
How does this work? Do I install SQL Server multiple times in different locations, or is it simply a defined thing in SQL Server? Is there a 'per instance' licensing issue, or will my one SQL Server license cover the multiple instances of SQL Server on on
e server system?
Thanks,
John
I believe Standard edition is licensed per instance but Enterprise Edition
can be installed with multiple instances on a server. It's best to check
the EULA to be totally certain though. But having to buy one new copy of SE
could be worth looking at why this very odd requirement was "assumed" in the
application's design IMO.
hth
Eric
John wrote:
> Our application requires multiple instances of SQL Server 2000 in
> order to have multiple databases, which the app clients use. Has
> something to do with the name of the SQL Server instance; each
> instance needs to be named differently.
> How does this work? Do I install SQL Server multiple times in
> different locations, or is it simply a defined thing in SQL Server?
> Is there a 'per instance' licensing issue, or will my one SQL Server
> license cover the multiple instances of SQL Server on one server
> system?
> Thanks,
> John
|||> Our application requires multiple instances of SQL Server 2000 in order to
have multiple databases
That's the part I don't get. Why can't the application use multiple
databases in a single instance?

> How does this work? Do I install SQL Server multiple times in different
locations
For multiple instances, yes.

> Is there a 'per instance' licensing issue
Depending on the edition of SQL Server, the licensing model you're using,
the OS, etc. You really should verify licensing compliance with a local
Microsoft rep. They can give you the legal answer as opposed to collating a
variety of opinions here.
http://www.aspfaq.com/
(Reverse address to reply.)
|||It is poor design IMO, but I have to live with it. On the matter of the multiple instances, what is meant by 'instance'? multiple installations? multiple 'spawnings' of SQL Server under a parent 'SQL Server manager-like' server process? does it end up loo
king like multiple servers systems each running a SQL Server, each with different names, data paths, etc, but actually all running on the same server system?
John
"Eric Sabine" wrote:

> I believe Standard edition is licensed per instance but Enterprise Edition
> can be installed with multiple instances on a server. It's best to check
> the EULA to be totally certain though. But having to buy one new copy of SE
> could be worth looking at why this very odd requirement was "assumed" in the
> application's design IMO.
> hth
> Eric
> John wrote:
>
>
|||Think of an instance of how many times you ran setup.exe through completion
of the wizard. Every instance after the default (if the default is taken
at first install) has the name of the server _and_ instance name as the name
of the sql server itself.
John wrote:[vbcol=seagreen]
> It is poor design IMO, but I have to live with it. On the matter of
> the multiple instances, what is meant by 'instance'? multiple
> installations? multiple 'spawnings' of SQL Server under a parent 'SQL
> Server manager-like' server process? does it end up looking like
> multiple servers systems each running a SQL Server, each with
> different names, data paths, etc, but actually all running on the
> same server system?
> John
> "Eric Sabine" wrote:
sql

Instance confusion

I have built an application in web developer that has a sql data base in the App_Data

folder. It works locally fine.

I have uploaded it to my web host client successfully and it all displays. The web host is enabled

for asp.net. But the sql data base is not working...no information is getting from the web application into

my instance of sql in App_Data.

My web host has given me an e:/webs/mywebsitename.com/data/nameofdb.mdf

to alter in my web config connection string which I have done, but still not working.

I have also tried every version of this in connection string without success

Im just confused about the e: part............how is that going to get to my App_Data?

Can someone give me a quick overview of what the problem might be

richard

repling to myself now.....this is the holy grail

http://blogs.msdn.com/sqlexpress/archive/2006/11/22/connecting-to-sql-express-user-instances-in-management-studio.aspx

Instance and Application databases?

Hi... I came across the terms "instance database" and "application database" in a book "MCITP 70-444: Optimizing and Maintaining... SQL Server 2005".

Up until now, I thought there were "user databases" and "system databases."

I found an article about these new terms here: http://msdn2.microsoft.com/en-us/library/ms166482.aspx

Are these terms specific to Notification Services?

Hi,

Yes. It is.

Application database is a database like any other database that you might create and it holds subscriber and device information.

Instance database is again a database like any other database that you might create and it holds subscription, events and other information.

Note that both the above database are created by Notification Services based on the inforamition that you provide in Application Definition File and Instance Definiton File.

Shamir|||Thanks.... this book is talking about designing a database for the first time and giving consideration to long term growth. The "application-" and "instance databases" then came way out of left field and confused me. I have added this note about Notification Services to the book so I won't have to re-ask. Thanks!|||In SSNS 2005 the instance and application object may now be created in an existing database, however you'll still routinely see those objects collectively referred to as the instance and application databases.

I've described the process of creating those objects in an existing database here.

HTH..

Joe

Installting sqlserver 2005 on the client machine for windows application

Hi
I developed a windows application in Visual studio 2005 and the database is sqlexpress.
I wanted my application to run on another system.For that i have installed sqlexpress 2005 on that machine.But that machine doesn't show me any enterprise manager or query manager for sqlserver.
Is there any solution for this.

Thanks

hi,

yes... you have to separately download and install SQL Server Management Studio Express... http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

regards

|||SQL Server Express does not come with EM or Query Analyzer. These two components have been merged into the SQL Server Managment Studio. The SQL Server Management Studio Express (which actually is a stripped of SQL Server Managment Studio (aka SSMS)) can be downloaded separately from Microsoft or is already included in the Express Advanced Edition (which actually includes some other cool features like Reporting Services for SQL Server Express).

http://msdn.microsoft.com/vstudio/express/sql/download/

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.desql

Installing/Deploying Windows App with SQL Server 2005 CE

I am a little bit confused about making an installer/deployer.

I have an application using SQL Server 2005 CE (I have just updated to the most recent version Jan 2007). It will run on a new desktop PC (windows XP) if I install the SQL CE runtime and then copy the .EXE and the .SDF database file. This is great but my client wants the whole thing to install as one operation. I thought click once could do this but it seems that is only for Pocket PC targets? Can anyone point me to a method to make an appropriate installer please?

Pete

I am using the following:
SQLServerCE31-EN.msi - installer for SQL CE server runtime
SSCE31VSTools-ENU.exe - installed over VS 2005 SP1.Have you tried publishing it? - I have no problem doing this for standard apps.

In Brian Noyes' book "Smart Client Deployment with ClickOnce' there are several small sections on how to deploy CE

P235 "An example is the SQL Server 2005 CE CTP that is available at the time of this writing. You can download the .msi file to do and install of SQL Compact and you can also download the Bootstrapper Manifest needed to add SQL Compact to your Bootstrapper. If you are provided the Bootstrapper files, all you need to do is place the files in the right location."

I can recommend this book - written in a logical straightforward manner. Also covered is Deploying a (sic CE) Client Database with your Application (starting P 167)

Here is the video link from Steve Lasker's blog on CE deployment http://blogs.msdn.com/stevelasker/archive/2006/07/06/SQLServerEverywhereDeploymentOptions.aspx|||If you use something like Inno Setup you can just have the installer copy the SQL Server Compact Edition dll files to the application's folder. Then you won't have to worry about using the MSI file. Check the SQL Server Compact Edition Books Online for more.

Or, (still using Inno Setup) add the MSI file to the setup project and run it with the necessary options to install it right before the installation ends.
|||Great responses guys! I'll try everything you suggest and feed back here.

Pete|||Ok, thanks for the references to Steve Laskers blog. The screencast of deployment options gave me the information I needed. I have ended up using the VS Setup project to install the SQL CE dlls into the app folder and the GAC. That is great for me (I didn't want publish/deploy). I am sure Inno would have done the same but I don't have time to learn another setup app now (I've used NCIS as well in the past). Anyway, kudos to all of you and Steve Lasker and the MS Virtual PC people without which I would need 2 PCs to test all this...

Pete|||I should mention that it looks like just copying SQL Server Compact Edition's DLLs is not a way to do it anymore. I remember seeing it in the SQL Server Everywhere Edition Books Online but it seems to have been removed from the SQL Server Compact Edition Books Online. Just thought I shouldd mention this for anyone else who reads this thread.

Installing sqlxml for a .NET app

Hi,
I have created a .NET client application that uses the managed SQLXML
components. I now need to create a installer for my app. I wnat to a void
having to run sqlxml.msi separatly. Is there an easy way to avoid this?
Is there a merge module I can use? if not what files ect. do I need to
include?
Thanks
Steven EvansWe only package SqlXml in msi's and there are no seperatate mergeable
installers.
"Steven Evans" <Steven Evans@.discussions.microsoft.com> wrote in message
news:348E0FD8-3158-4AD8-A577-EF7F4E872D06@.microsoft.com...
> Hi,
> I have created a .NET client application that uses the managed SQLXML
> components. I now need to create a installer for my app. I wnat to a
> void
> having to run sqlxml.msi separatly. Is there an easy way to avoid this?
> Is there a merge module I can use? if not what files ect. do I need to
> include?
> Thanks
> Steven Evans

Installing sqlxml for a .NET app

Hi,
I have created a .NET client application that uses the managed SQLXML
components. I now need to create a installer for my app. I wnat to a void
having to run sqlxml.msi separatly. Is there an easy way to avoid this?
Is there a merge module I can use? if not what files ect. do I need to
include?
Thanks
Steven Evans
We only package SqlXml in msi's and there are no seperatate mergeable
installers.
"Steven Evans" <Steven Evans@.discussions.microsoft.com> wrote in message
news:348E0FD8-3158-4AD8-A577-EF7F4E872D06@.microsoft.com...
> Hi,
> I have created a .NET client application that uses the managed SQLXML
> components. I now need to create a installer for my app. I wnat to a
> void
> having to run sqlxml.msi separatly. Is there an easy way to avoid this?
> Is there a merge module I can use? if not what files ect. do I need to
> include?
> Thanks
> Steven Evans
sql

Installing SQL Server 2005 Express as Part of My Application

I have found a lot of info on MS site regarding installing SQL Server 2005 Express as part of an application. I have found these articles to be extremely inaccurate or at best incomplete.

1. The documentation says all I need is the setup.exe from SQLEXP but this is not true.

2. When I do launch setup.exe during my app's install, it fails because setup.exe trys to run the support.msi. Of course this causes failure because my install is also an msi.

So, does anyone know how to install SQLEXPRESS as part of my app's install?

Thanks.

Hi Shawn,

I think you might be misreading the documentation you've found, Setup.exe is simply a bootstrapper that launches other SQL component installations. You have to deploy the entire SQL Express package, not just the setup.exe file.

You should deploy either SQLEXPR.EXE or SQLEXPR_ADV.EXE with your application, depending on which flavor of SQL Express you want to install. You should call these files by chaining them together. Most installer development tools allow you to specify additional installer packages to call at the end of your application installation. VS 2005 includes the ability to specify SQL Express as a prerequisite, which will automatically include SQLEXPR.EXE in your deployment package and create a custom bootstrapper that will install SQL Express and then your custom application. I know that VS Pro includes the installer projects, I'm not sure about VS Std.

You should also explore ClickOnce Deployment, this has the same ability to deploy SQL Express as a prerequisite and is supported in all Editions of VS, including the Express Editions.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

Installing SQL Server 2005 DB via .NET application

Hello all,

I've developed a visual basic .net (2005) application that uses sql server 2005 (express edition) as a database and I created a setup project that installes my application. Now, my question is how can I create a "all-in-one" installation procedure/file that will install both the SQL server (engine + db) and my application?

I've found the following link:

http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp#sqlexpuser_topic10

That mentions under: "Distribution and Deployment" section, something that sounds like what I'm looking for, but I didn't find any further information on how to do that. Can anyone help?

Thanks in advanced!

Tom.

I have the same question...bump...

_ANY_ resources out there?

|||

Hi,

SQL Server Express doesn′′t use merge modules anymore. It uses now the msi pakcage functionalty which is described in the help of Visual Studio, its like configuring any other MSI package within a setup project to deploy.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Installing SQL Server 2005 DB via .NET application

Hello all,

I've developed a visual basic .net (2005) application that uses sql server 2005 (express edition) as a database and I created a setup project that installes my application. Now, my question is how can I create a "all-in-one" installation procedure/file that will install both the SQL server (engine + db) and my application?

I've found the following link:

http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp#sqlexpuser_topic10

That mentions under: "Distribution and Deployment" section, something that sounds like what I'm looking for, but I didn't find any further information on how to do that. Can anyone help?

Thanks in advanced!

Tom.

I have the same question...bump...

_ANY_ resources out there?

|||

Hi,

SQL Server Express doesn′′t use merge modules anymore. It uses now the msi pakcage functionalty which is described in the help of Visual Studio, its like configuring any other MSI package within a setup project to deploy.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Installing Sql server 2005 Compact edition

I have a PDA application that manage a database.

My application uses Sql server 2005 Mobile edition and I want to change to

Sql server 2005 Compact edition.

I have an application that automatically upgrade new version of my software at users (customers sites) It is shipped on a memrory card (SD Card).

I want in my upgrade tool to install Sql server 2005 Compact edition so I do it by running the two cab files :

sqlce30.repl.wce5.armv4i.CAB and sqlce30.wce5.armv4i.CAB

It works ok but I want also to uninstall Sql server 2005 Mobile edition and I do not find out how to do it automatically, First I do not know how to find out if Sql server 2005 Mobile edition is installd and if so how to uninstall it.

I want to do it all automatcally in my upgrade utility because my customers do not know to do it manually by theself.

Second I want to know if I have to use the Sql server 2005 Compact edition Uprade tool to upgrade my clients old databases because the now application works ok without Upgrading the database.

Thanks

Ofer Ebert

If your users are using PocketPC devices, you should use these cab files: sqlce30.ppc.wce5.armv4i.CAB, sqlce30.repl.ppc.wce5.armv4i.CAB, the files you mention are for "generic" Windows Mobile 5.0 devices. Installing these cab files will automatically uninstall SQL Mobile. The file format between SQL 2005 Mobile and and SQL 2005 Compact Edition has not changed, so there is no requirement to run the upgrade tool.

|||

Thanks for the quick answer.

I changed to work with the files you mentiond still after installing both cab files I see that SQL Mobile is still installd on my PDA so it is not automatically uninstalld.

Do ypu have a suggestion

Ofer Ebert

|||

How do you determine that SQL Mobile is still installed.
I think you will find that only one set of the files called sqlce...30.dll (sqlcece30.dll and so on) are installed (in the \windows folder).
If these files are dated 22/12 2006, version 3.0.5300, then only SQL Compact Edition is installed.

|||

When running setup/system/ "Remove Programs" I see Sql Compact twice (Because I install two cab files) and also Sql Mobile

Thanks

Ofer

|||

Yes, but please check this:

I think you will find that only one set of the files called sqlce...30.dll (sqlcece30.dll and so on) are installed (in the \windows folder).
If these files are dated 22/12 2006, version 3.0.5300, then only SQL Compact Edition is installed.

|||

Yes I see only one set of files dated 22/12/2006

Thanks

Ofer Ebert

Integrated Security with IIS6.0 identity impersonate=true

Hi,
I'm struggling trying to catch the current user in MSSQL with
SYSTEM_USER through an Intranet Application. I try to do this to create
audit trail of changes to data. (I'm aware of the performance penalties
it causes due to application pooling problems with integrated
security.)
Now to my problem:
Using IIS6.0 ASP.NET 1.1 on Windows2003 with Windows Authentication
enabled and Anonymous logon disabled. I get the correct user and can
verify him/her in IIS. Now I want this identity to be used when logging
into SQLServer. To keep things simple, lets say the SQLServer is on the
same machine (it is right now, but won't be further on). The aspx-pages
use a wrapper to call COM-dll's that connect to the database using an
ODBC file DSN. I have set <indentity impersonate="true" /> in
Web.Config and have created the Windows Integrated Security login
accounts in SQLServer with proper db-roles to update the data.
Unfortunately I keep getting stuck with the NT AUTHORISATION/NETWORK
SERVICE account when the connection reaches SQLServer. It was working
last week, but now I've made a clean install and just can't get it to
work.
Please help with any ideas! The <identity impersonate="true" /> isn't
listening to me.
/RichardIt looks like you might be missing setting up delegation.
The following articles should get you started:
How To: Implement Kerberos Delegation for Windows 2000
http://msdn.microsoft.com/library/d.../>
NetHT05.asp
How to use Kerberos authentication in SQL Server
http://support.microsoft.com/?id=319723
-Sue
On 15 May 2006 17:23:09 -0700, richard.allgardh@.medinit.se
wrote:

>Hi,
>I'm struggling trying to catch the current user in MSSQL with
>SYSTEM_USER through an Intranet Application. I try to do this to create
>audit trail of changes to data. (I'm aware of the performance penalties
>it causes due to application pooling problems with integrated
>security.)
>Now to my problem:
>Using IIS6.0 ASP.NET 1.1 on Windows2003 with Windows Authentication
>enabled and Anonymous logon disabled. I get the correct user and can
>verify him/her in IIS. Now I want this identity to be used when logging
>into SQLServer. To keep things simple, lets say the SQLServer is on the
>same machine (it is right now, but won't be further on). The aspx-pages
>use a wrapper to call COM-dll's that connect to the database using an
>ODBC file DSN. I have set <indentity impersonate="true" /> in
>Web.Config and have created the Windows Integrated Security login
>accounts in SQLServer with proper db-roles to update the data.
>Unfortunately I keep getting stuck with the NT AUTHORISATION/NETWORK
>SERVICE account when the connection reaches SQLServer. It was working
>last week, but now I've made a clean install and just can't get it to
>work.
>Please help with any ideas! The <identity impersonate="true" /> isn't
>listening to me.
>/Richard

integrate report manager in an asp.net application

I thought I can probably find out how the report manager works and create a similar application so that I can define my own things in there.

Looks like there is no sample where I could get a lead. Now I have decided if I can include the report manager in a new aspx page in my application and disable the stuff which is not required by the user to look at it.

I can definitely include the report manager url in the Iframe but how do I disable the stuff from the report manager.

Please help, I am having real hard time.

Thanks in advance.

There is no way that I know of to customize report manager and include its functionality in your own app like you would a control.

Have you looked at the report viewer web control? If you need to integrate report viewing and report export capability in your asp.net application, it is very powerful. You could use this, along with the available Web services in reporting services to build your own version of the report manager in asp.net with most, if not all of the same functionality.

A link to the report viewer control:

http://msdn2.microsoft.com/en-us/library/ms251671(VS.80).aspx

A link to the web services provided by report server:

http://msdn2.microsoft.com/en-us/library/ms154697.aspx

integrate report manager in an asp.net application

I thought I can probably find out how the report manager works and create a similar application so that I can define my own things in there.

Looks like there is no sample where I could get a lead. Now I have decided if I can include the report manager in a new aspx page in my application and disable the stuff which is not required by the user to look at it.

I can definitely include the report manager url in the Iframe but how do I disable the stuff from the report manager.

Please help, I am having real hard time.

Thanks in advance.

There is no way that I know of to customize report manager and include its functionality in your own app like you would a control.

Have you looked at the report viewer web control? If you need to integrate report viewing and report export capability in your asp.net application, it is very powerful. You could use this, along with the available Web services in reporting services to build your own version of the report manager in asp.net with most, if not all of the same functionality.

A link to the report viewer control:

http://msdn2.microsoft.com/en-us/library/ms251671(VS.80).aspx

A link to the web services provided by report server:

http://msdn2.microsoft.com/en-us/library/ms154697.aspx

integer datatype and null value error

I'm getting a datatype error: "Application uses a value of the wrong type for the current operation" when executing the following stored procedure:

CREATE PROCEDURE dbo.Insert_Temp_ContactInfo
@.sessionid varchar(50),
@.FirstName varchar(50) = NULL,
@.LastName varchar(50) = NULL,
@.SchoolName varchar(50) = NULL,
@.address varchar(50) = NULL,
@.City varchar(50) = NULL,
@.State int = NULL,
@.Zip varchar(5) = NULL,
@.Phone varchar(10) = NULL,
@.Email varchar(50) = NULL,
@.CurrentCustomer varchar(3) = NULL,
@.ImplementationType int = NULL,
@.ProductType int = NULL,
@.Comment varchar(500) = NULL
AS
--check if a current record exists
SET NOCOUNT ON
begin
UPDATE dbo.Temp_ContactInfo
SET
FirstName = @.FirstName,
LastName = @.LastName,
SchoolName = @.SchoolName,
Address = @.address,
City = @.City,
State = @.State,
Zip = @.Zip,
Phone = @.Phone,
Email = @.Email,
CurrentCustomer = @.CurrentCustomer,
ImplementationType = @.ImplementationType,
ProductType = @.ProductType,
Comment = @.Comment
WHERE
sessionid = @.sessionid

If @.@.Rowcount = 0
INSERT INTO dbo.Temp_ContactInfo
(sessionid,
FirstName,
LastName,
SchoolName,
address,
City,
State,
Zip,
Phone,
Email,
CurrentCustomer,
ImplementationType,
ProductType,
Comment)
VALUES
(@.sessionid,
@.FirstName,
@.LastName,
@.SchoolName,
@.address,
@.City,
@.State,
@.Zip,
@.Phone,
@.Email,
@.CurrentCustomer,
@.ImplementationType,
@.ProductType,
@.Comment)
end
GO

This is code I'm using to call the procedure:

set InsertTempInfo = Server.CreateObject("ADODB.Command")
With InsertTempInfo
.ActiveConnection = MM_DBConn_STRING
.CommandText = "dbo.Insert_Temp_ContactInfo"
.CommandType = 4
.CommandTimeout = 0
.Prepared = true
.Parameters.Append .CreateParameter("@.sessionid", 200, 1,50, usrid)
.Parameters.Append .CreateParameter("@.FirstName", 200, 1,50,fname)
.Parameters.Append .CreateParameter("@.LastName", 200, 1,50,lname)
.Parameters.Append .CreateParameter("@.SchoolName", 200, 1,50,schoolname)
.Parameters.Append .CreateParameter("@.address", 200, 1,50,address)
.Parameters.Append .CreateParameter("@.City", 200, 1,50,city)
.Parameters.Append .CreateParameter("@.State", 3, 1,4,state)
.Parameters.Append .CreateParameter("@.Zip", 200, 1,5,zip)
.Parameters.Append .CreateParameter("@.Phone", 200, 1,10,phone)
.Parameters.Append .CreateParameter("@.Email", 200, 1,50,email)
.Parameters.Append .CreateParameter("@.CurrentCustomer", 200, 1,3,currentcustomer)
.Parameters.Append .CreateParameter("@.ImplementationType", 3, 1,4,implementationtype)
.Parameters.Append .CreateParameter("@.ProductType", 3, 1,4,producttype)
.Parameters.Append .CreateParameter("@.Comment", 200, 1,500,comment)
.Execute()
End With
Set InsertTempInfo = Nothing

the error is thrown on the following line:

.Parameters.Append .CreateParameter("@.State", 3, 1,4,state)

I'm using a table to hold data that I can pass back to the original form page and re-populate the fields that were not validated correctly. The stored procedure either inserts or updates the record in the temp table I've created.

So, currently, as I'm testing, I'm just passing empty values to all the parameters and the @.state parameter is failing and throwing the error.

I've double checked that the table has the state column set to integer datatype

The column is set as follows:

Name datatype length Allow Nulls
--------------
State int 4 checked

I have tried setting the default value for every column to Null in the table and then also not using a default value. Either way, I still recieve the same error?

Not sure what else to look at?

It seems the problem might be that instead of a null value being passed to the parameter that it is actually empty. Can passing an empty value to a column of datatype integer cause this problem? If so, is there a way to correct it?

Thanks for any help.Basic thing to check: Make sure the data type you are passing to the stored procedure is of the same type as the stored procedure is expecting