Adding value in a query

I am trying to insert a value numeric + 1 in to db table but i get error when i do this

this is the code

Const SQLAsString ="INSERT INTO [PageHits] ([DefaultPage]) VALUES (@.defaultP)"

Dim myCommandAsNew Data.SqlClient.SqlCommand(SQL, myConnection)myCommand.Parameters.AddWithValue("@.DefaultP" +"1", DefaultP.Text.Trim())

myConnection.Open()

myCommand.ExecuteNonQuery()

myConnection.Close()

The Error:

Must declare the variable '@.defaultP'.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: Must declare the variable '@.defaultP'.

The code you wrote will send a parameter called @.DefaultP1 to the database.

Did you want to increase an existing value in the database? If so, you must use an UPDATE query.sql

Adding User Define fields together

This is driving me crazy! The SQL Statement refenced is shown at the end of this email.

When I try and run the statement, an error is raised saying that Undrawn_GT5MIL_LE365Days is invalid (likewise for Undrawn_LE5MIL_LE365Days). From what I can gather, it is saying that I cannot include a User Defined variable in another argument. This is unlike Access. Any suggestions?

SQL View......

SELECT TOP 100 PERCENT QRY_FacNew_Term.Category, QRY_FacNew_Term.Fac_No, QRY_FacNew_Term.Client_Number, QRY_FacNew_Term.Client_Name,

Undrawn_GT5MIL_LE365Days = CASE WHEN Undrawn_CDN >= 5000000 AND Term <= 365 THEN Undrawn_CDN ELSE 0 END,

Undrawn_GT5MIL_GT365Days = CASE WHEN (Undrawn_CDN >= 5000000 AND Term > 365) OR

(Cr_Limit_CDN IN (0, 1)) THEN Undrawn_CDN ELSE 0 END, [Undrawn_GT5MIL_LE365Days]+[Undrawn_GT5MIL_GT365Days] AS Total

FROM dbo.QRY_FacNew_Term

WHERE (Exclude <> 'Y')

ORDER BY Category, Client_NameUse brackets if name includes space:

[drawn_GT5MIL_LE365Days ] = CASE WHEN Undrawn_CDN >= 5000000 AND Term <= 365 THEN Undrawn_CDN ELSE 0 END,

adding NT AUTHORITY\NETWORK SERVICE problem

Hi,
I trying to add a login AUTHORITY\NETWORK SERVICE'. to sql 2005.
I got the error says the windows NT AUTHORITY\NETWORK SERVICE not found, pls
check the name again.
ANy ideas.Try to execute this statement
USE [master]
GO
CREATE LOGIN [NT AUTHORITY\NETWORK SERVICE] FROM WINDOWS WITH
DEFAULT_DATABASE=[master]
GO
Regards,
Manoj Raheja
MCDBA, MCITP
"mecn" wrote:

> Hi,
> I trying to add a login AUTHORITY\NETWORK SERVICE'. to sql 2005.
> I got the error says the windows NT AUTHORITY\NETWORK SERVICE not found, p
ls
> check the name again.
> ANy ideas.
>
>

Adding new field in a table which being used for replication

Hi dear friends,
I'm trying to add a new field in a table and in my desired
position (OrdinalPosition), but I can not and I get the
following error message. As this table is involved in
replication I get this error message:
('tblTransPayments' table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]
Cannot drop the table 'dbo.tblTransPayments' because it is
being used for replication.)
It should be noticed that I have lots of data in this
table and I'm not going to drop the table.
I can easily add my new field at the end of the column's
list but not as 21th column which I want to.
Thanks in advance.
If you really need the new column at a specific position, you'll have to drop the subscription, drop the publication, add the column then recreate the publication and subscription and initialize. You might want to do a nosync initialization to avoid the c
ost of the snapshot, but in this case you'll have to add the column onto the subscriber(s) table manually and if you are doing transactional replication, you'll need to create the scripts and apply them manually.
(No doubt you've seen this in other threads, but referring to columns by position rather than by name is generally seen as being a restrictive practice.)
HTH,
Paul Ibison
|||Hi -
Please check SQL BOL for "sp_repladdcolumn" and "sp_repldropcolumn".
Thanks
-Surajit
"Mattew" <anonymous@.discussions.microsoft.com> wrote in message
news:19d4101c44d7b$6507c260$a101280a@.phx.gbl...
> Hi dear friends,
> I'm trying to add a new field in a table and in my desired
> position (OrdinalPosition), but I can not and I get the
> following error message. As this table is involved in
> replication I get this error message:
> ('tblTransPayments' table
> - Unable to modify table.
> ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]
> Cannot drop the table 'dbo.tblTransPayments' because it is
> being used for replication.)
> It should be noticed that I have lots of data in this
> table and I'm not going to drop the table.
> I can easily add my new field at the end of the column's
> list but not as 21th column which I want to.
> Thanks in advance.
|||Surajit,
this won't give the ability to specify the position, and Matthew doesn't
want the column created at the end.
Regards,
Paul Ibison

Adding new field in a table which being used for replication

Hi dear friends,
I'm trying to add a new field in a table and in my desired
position (OrdinalPosition), but I can not and I get the
following error message. As this table is involved in
replication I get this error message:
('tblTransPayments' table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]
Cannot drop the table 'dbo.tblTransPayments' because it is
being used for replication.)
It should be noticed that I have lots of data in this
table and I'm not going to drop the table.
I can easily add my new field at the end of the column's
list but not as 21th column which I want to.
Thanks in advance.If you really need the new column at a specific position, you'll have to dro
p the subscription, drop the publication, add the column then recreate the p
ublication and subscription and initialize. You might want to do a nosync in
itialization to avoid the c
ost of the snapshot, but in this case you'll have to add the column onto the
subscriber(s) table manually and if you are doing transactional replication
, you'll need to create the scripts and apply them manually.
(No doubt you've seen this in other threads, but referring to columns by pos
ition rather than by name is generally seen as being a restrictive practice.
)
HTH,
Paul Ibison|||Hi -
Please check SQL BOL for "sp_repladdcolumn" and "sp_repldropcolumn".
Thanks
-Surajit
"Mattew" <anonymous@.discussions.microsoft.com> wrote in message
news:19d4101c44d7b$6507c260$a101280a@.phx
.gbl...
> Hi dear friends,
> I'm trying to add a new field in a table and in my desired
> position (OrdinalPosition), but I can not and I get the
> following error message. As this table is involved in
> replication I get this error message:
> ('tblTransPayments' table
> - Unable to modify table.
> ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]
> Cannot drop the table 'dbo.tblTransPayments' because it is
> being used for replication.)
> It should be noticed that I have lots of data in this
> table and I'm not going to drop the table.
> I can easily add my new field at the end of the column's
> list but not as 21th column which I want to.
> Thanks in advance.|||Surajit,
this won't give the ability to specify the position, and Matthew doesn't
want the column created at the end.
Regards,
Paul Ibison

Adding Measures to Report - receive error

Hello,

My report, which has a matrix and a chart work fine. Then...

I click on the Data tab, drag a measure into the results grid. At this point I haven't added the new measure to the matrix or anything in Layout.

I click the Preview tab and get the following message: "The definition of the report XXX is invalid. More than one data set, data region, or grouing in the report has the name 'YYY'. Data set, data region and grouping names must be unique within a report.

Ok, I get the point. But why and how would adding a measure give me this issue? Where can I even find where this is being duplicated?

The message refers to a name that is a parameter, and I don't see anything in there that might cause this.

Thank you for the help.

-Gumbatman

I've just got this same message myself - and am trying to figure it out. I had a report that was working fine in Preview...then I went to try to add a parameter, couldn't get it to work so deleted it. Now the report won't preview at all...keep getting this message.

I've even deleted ALL of the layout fields - but still get the error.

The DATA tab retrieves my data fine without a problem.

Help please ?

Phil

Adding headers to matrix

Hi,
how can I add headers to my matrixcolumns?
I created a table inside the merged cell above, but this won't export
to excel: i get the error "Data Regions within table/matrix cells are ignored."

thx,
FrankHi!
I had the same problem, and i found a solution for the embedded data regions in EXCEL! Altough it is a limitation in RS :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_dc_v1_8yhy.asp
There is a solution! Have a look at the riport item "List" in design mode! It has almost the same functionality like teh "Table". You have to manually add headers over the "List" and manually place the textboxes hierarchical inside the list if you want to group fields, but it has a big advantage! Inside the "List" every embedded data regions (just like matrix, or subreport) are displayed correctly in EXCEL!
IMPORTANT: if you place embedded data regions in a "List" you have to right click on the "List" and select properties. On the first tab of the property window click "edit details group" and you must specify grouping expressions here. For examle if there are "Parent" and "Child" rows inside a "List", a good grouping expression would be the Parent row ID.
I hope this helps:)
Rolf|||Oh! And to adding matrix headers, for columns, you have to create a rectangle instead of a table. And place textbox-es inside the rectangle. And finally drag and drop the rectangle inside a merged matrix columnheader cell.
Rolf|||

I am a newbie to the RS and need much more information then given here.

Can anybody please show me an example implementation of the same.

Tanveer

|||I have found the same problem with the "List" object in Reporting Services. Renders fine in HTML and PDF but Excel displays "Data Regions within table/matrix cells are ignored". Very frustrating limitation|||

Unfortunately there is no viable workaround for this particular limitation of the Excel renderer. Data regions cannot be nested in table or matrix cells. We are working to add this functinonality in the next version of Reporting Services.

Tanveer, please let us know specifically what questions you have and we'll do our best to answer.

-Chris

|||Do you have a timeline of when the next version of RS is going to be available?|||

This is exactly what brings touble down the road, One recommends RS over CR and then, when I implement a large matrix report which for very valid reasons is embedded within a table, I receive a user response that this stuff just simply doesn't work. I TRULY wish this stuff would just work as it is supposed to. I hate the fact that Microsoft's marketing machine is better and faster than it's technical arm which does absolutely nothing for our credibility!

Why include the option to export to Excel if it does not work?!

Adding headers to matrix

Hi,
how can I add headers to my matrixcolumns?
I created a table inside the merged cell above, but this won't export
to excel: i get the error "Data Regions within table/matrix cells are
ignored."
thx,
FrankI'm assuming you mean the top left cell of the matrix?
Add a rectangle outside the data region, insert a textbox for each
column heading formatting, sizing and positioning them accordingly.
Cut the rectangle and paste it into the matrix cell.
--
Regards
Chris
Frank Mestdagh wrote:
> Hi,
> how can I add headers to my matrixcolumns?
> I created a table inside the merged cell above, but this won't export
> to excel: i get the error "Data Regions within table/matrix cells are
> ignored."
> thx,
> Frank|||Thanks Chris!!! I am going to try that ... it seems hokey that we cant have
the OPTION to iniclude column headings for that area to me! I will try what
you suggested.
"Chris McGuigan" wrote:
> I'm assuming you mean the top left cell of the matrix?
> Add a rectangle outside the data region, insert a textbox for each
> column heading formatting, sizing and positioning them accordingly.
> Cut the rectangle and paste it into the matrix cell.
> --
> Regards
> Chris
>
> Frank Mestdagh wrote:
> > Hi,
> > how can I add headers to my matrixcolumns?
> > I created a table inside the merged cell above, but this won't export
> > to excel: i get the error "Data Regions within table/matrix cells are
> > ignored."
> >
> > thx,
> > Frank
>

Adding headers to matrix

Hi,
how can I add headers to my matrixcolumns?
I created a table inside the merged cell above, but this won't export
to excel: i get the error "Data Regions within table/matrix cells are ignored."

thx,
FrankHi!
I had the same problem, and i found a solution for the embedded data regions in EXCEL! Altough it is a limitation in RS :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_dc_v1_8yhy.asp
There is a solution! Have a look at the riport item "List" in design mode! It has almost the same functionality like teh "Table". You have to manually add headers over the "List" and manually place the textboxes hierarchical inside the list if you want to group fields, but it has a big advantage! Inside the "List" every embedded data regions (just like matrix, or subreport) are displayed correctly in EXCEL!
IMPORTANT: if you place embedded data regions in a "List" you have to right click on the "List" and select properties. On the first tab of the property window click "edit details group" and you must specify grouping expressions here. For examle if there are "Parent" and "Child" rows inside a "List", a good grouping expression would be the Parent row ID.
I hope this helps:)
Rolf|||Oh! And to adding matrix headers, for columns, you have to create a rectangle instead of a table. And place textbox-es inside the rectangle. And finally drag and drop the rectangle inside a merged matrix columnheader cell.
Rolf|||

I am a newbie to the RS and need much more information then given here.

Can anybody please show me an example implementation of the same.

Tanveer

|||I have found the same problem with the "List" object in Reporting Services. Renders fine in HTML and PDF but Excel displays "Data Regions within table/matrix cells are ignored". Very frustrating limitation|||

Unfortunately there is no viable workaround for this particular limitation of the Excel renderer. Data regions cannot be nested in table or matrix cells. We are working to add this functinonality in the next version of Reporting Services.

Tanveer, please let us know specifically what questions you have and we'll do our best to answer.

-Chris

|||Do you have a timeline of when the next version of RS is going to be available?|||

This is exactly what brings touble down the road, One recommends RS over CR and then, when I implement a large matrix report which for very valid reasons is embedded within a table, I receive a user response that this stuff just simply doesn't work. I TRULY wish this stuff would just work as it is supposed to. I hate the fact that Microsoft's marketing machine is better and faster than it's technical arm which does absolutely nothing for our credibility!

Why include the option to export to Excel if it does not work?!

Adding headers to matrix

Hi,
how can I add headers to my matrixcolumns?
I created a table inside the merged cell above, but this won't export
to excel: i get the error "Data Regions within table/matrix cells are ignored."

thx,
FrankHi!
I had the same problem, and i found a solution for the embedded data regions in EXCEL! Altough it is a limitation in RS :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_dc_v1_8yhy.asp
There is a solution! Have a look at the riport item "List" in design mode! It has almost the same functionality like teh "Table". You have to manually add headers over the "List" and manually place the textboxes hierarchical inside the list if you want to group fields, but it has a big advantage! Inside the "List" every embedded data regions (just like matrix, or subreport) are displayed correctly in EXCEL!
IMPORTANT: if you place embedded data regions in a "List" you have to right click on the "List" and select properties. On the first tab of the property window click "edit details group" and you must specify grouping expressions here. For examle if there are "Parent" and "Child" rows inside a "List", a good grouping expression would be the Parent row ID.
I hope this helps:)
Rolf|||Oh! And to adding matrix headers, for columns, you have to create a rectangle instead of a table. And place textbox-es inside the rectangle. And finally drag and drop the rectangle inside a merged matrix columnheader cell.
Rolf|||

I am a newbie to the RS and need much more information then given here.

Can anybody please show me an example implementation of the same.

Tanveer

|||I have found the same problem with the "List" object in Reporting Services. Renders fine in HTML and PDF but Excel displays "Data Regions within table/matrix cells are ignored". Very frustrating limitation|||

Unfortunately there is no viable workaround for this particular limitation of the Excel renderer. Data regions cannot be nested in table or matrix cells. We are working to add this functinonality in the next version of Reporting Services.

Tanveer, please let us know specifically what questions you have and we'll do our best to answer.

-Chris

|||Do you have a timeline of when the next version of RS is going to be available?|||

This is exactly what brings touble down the road, One recommends RS over CR and then, when I implement a large matrix report which for very valid reasons is embedded within a table, I receive a user response that this stuff just simply doesn't work. I TRULY wish this stuff would just work as it is supposed to. I hate the fact that Microsoft's marketing machine is better and faster than it's technical arm which does absolutely nothing for our credibility!

Why include the option to export to Excel if it does not work?!

Adding headers to matrix

Hi,
how can I add headers to my matrixcolumns?
I created a table inside the merged cell above, but this won't export
to excel: i get the error "Data Regions within table/matrix cells are ignored."

thx,
FrankHi!
I had the same problem, and i found a solution for the embedded data regions in EXCEL! Altough it is a limitation in RS :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_dc_v1_8yhy.asp
There is a solution! Have a look at the riport item "List" in design mode! It has almost the same functionality like teh "Table". You have to manually add headers over the "List" and manually place the textboxes hierarchical inside the list if you want to group fields, but it has a big advantage! Inside the "List" every embedded data regions (just like matrix, or subreport) are displayed correctly in EXCEL!
IMPORTANT: if you place embedded data regions in a "List" you have to right click on the "List" and select properties. On the first tab of the property window click "edit details group" and you must specify grouping expressions here. For examle if there are "Parent" and "Child" rows inside a "List", a good grouping expression would be the Parent row ID.
I hope this helps:)
Rolf|||Oh! And to adding matrix headers, for columns, you have to create a rectangle instead of a table. And place textbox-es inside the rectangle. And finally drag and drop the rectangle inside a merged matrix columnheader cell.
Rolf|||

I am a newbie to the RS and need much more information then given here.

Can anybody please show me an example implementation of the same.

Tanveer

|||I have found the same problem with the "List" object in Reporting Services. Renders fine in HTML and PDF but Excel displays "Data Regions within table/matrix cells are ignored". Very frustrating limitation|||

Unfortunately there is no viable workaround for this particular limitation of the Excel renderer. Data regions cannot be nested in table or matrix cells. We are working to add this functinonality in the next version of Reporting Services.

Tanveer, please let us know specifically what questions you have and we'll do our best to answer.

-Chris

|||Do you have a timeline of when the next version of RS is going to be available?|||

This is exactly what brings touble down the road, One recommends RS over CR and then, when I implement a large matrix report which for very valid reasons is embedded within a table, I receive a user response that this stuff just simply doesn't work. I TRULY wish this stuff would just work as it is supposed to. I hate the fact that Microsoft's marketing machine is better and faster than it's technical arm which does absolutely nothing for our credibility!

Why include the option to export to Excel if it does not work?!

Adding headers to matrix

Hi,
how can I add headers to my matrixcolumns?
I created a table inside the merged cell above, but this won't export
to excel: i get the error "Data Regions within table/matrix cells are ignored."

thx,
FrankHi!
I had the same problem, and i found a solution for the embedded data regions in EXCEL! Altough it is a limitation in RS :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_dc_v1_8yhy.asp
There is a solution! Have a look at the riport item "List" in design mode! It has almost the same functionality like teh "Table". You have to manually add headers over the "List" and manually place the textboxes hierarchical inside the list if you want to group fields, but it has a big advantage! Inside the "List" every embedded data regions (just like matrix, or subreport) are displayed correctly in EXCEL!
IMPORTANT: if you place embedded data regions in a "List" you have to right click on the "List" and select properties. On the first tab of the property window click "edit details group" and you must specify grouping expressions here. For examle if there are "Parent" and "Child" rows inside a "List", a good grouping expression would be the Parent row ID.
I hope this helps:)
Rolf|||Oh! And to adding matrix headers, for columns, you have to create a rectangle instead of a table. And place textbox-es inside the rectangle. And finally drag and drop the rectangle inside a merged matrix columnheader cell.
Rolf|||

I am a newbie to the RS and need much more information then given here.

Can anybody please show me an example implementation of the same.

Tanveer

|||I have found the same problem with the "List" object in Reporting Services. Renders fine in HTML and PDF but Excel displays "Data Regions within table/matrix cells are ignored". Very frustrating limitation|||

Unfortunately there is no viable workaround for this particular limitation of the Excel renderer. Data regions cannot be nested in table or matrix cells. We are working to add this functinonality in the next version of Reporting Services.

Tanveer, please let us know specifically what questions you have and we'll do our best to answer.

-Chris

|||Do you have a timeline of when the next version of RS is going to be available?|||

This is exactly what brings touble down the road, One recommends RS over CR and then, when I implement a large matrix report which for very valid reasons is embedded within a table, I receive a user response that this stuff just simply doesn't work. I TRULY wish this stuff would just work as it is supposed to. I hate the fact that Microsoft's marketing machine is better and faster than it's technical arm which does absolutely nothing for our credibility!

Why include the option to export to Excel if it does not work?!

Adding column problem

I consulted the SQL2K help for adding a table and copied the code and
substituted my own variables, but I get an error message about incorrect
syntax regarding the AS in line 1. I'm a newbie and am bummed that the code
provided in the help doesn't work--I'm assuming there's something I don't
know here. Here's the code:
---
Dim t_AssessmentItem As SQLDMO.Table
Dim OutputAssessmentLevelID As New SQLDMO.Column
OutputAssessmentLevelID.Name = "ShelfLife"
OutputAssessmentLevelID.Datatype = "CodeID"
OutputAssessmentLevelID.AllowNulls = False
OutputAssessmentLevelID.DRIDefault.Int = "AssessmentLevelID"
Set t_AssessmentItem = _
oSQLServer.Databases("PowerSuasionDevLocal").Tables("t_AssessmentItem")
t_AssessmentItem.BeginAlter
t_AssessmentItem.Columns.Add OutputAssessmentLevelID
t_AssessmentItem.DoAlter
--
Thanks for your help,
karolus> OutputAssessmentLevelID.DRIDefault.Int = "AssessmentLevelID"
I don't see an Int property for the DRIDefault object. You might try
specifying a default constraint name and value instead. For example:
OutputAssessmentLevelID.DRIDefault.Name = "DF_t_AssessmentItem_ShelfLife"
OutputAssessmentLevelID.DRIDefault.Text = "0"
Hope this helps.
Dan Guzman
SQL Server MVP
"Karolus" <Karolus@.discussions.microsoft.com> wrote in message
news:DA68ACB7-098B-4282-92C6-23A24E024C1B@.microsoft.com...
>I consulted the SQL2K help for adding a table and copied the code and
> substituted my own variables, but I get an error message about incorrect
> syntax regarding the AS in line 1. I'm a newbie and am bummed that the
> code
> provided in the help doesn't work--I'm assuming there's something I don't
> know here. Here's the code:
> ---
> Dim t_AssessmentItem As SQLDMO.Table
> Dim OutputAssessmentLevelID As New SQLDMO.Column
> OutputAssessmentLevelID.Name = "ShelfLife"
> OutputAssessmentLevelID.Datatype = "CodeID"
> OutputAssessmentLevelID.AllowNulls = False
> OutputAssessmentLevelID.DRIDefault.Int = "AssessmentLevelID"
> Set t_AssessmentItem = _
> oSQLServer.Databases("PowerSuasionDevLocal").Tables("t_AssessmentItem")
> t_AssessmentItem.BeginAlter
> t_AssessmentItem.Columns.Add OutputAssessmentLevelID
> t_AssessmentItem.DoAlter
> --
> Thanks for your help,
> karolus|||"Karolus" <Karolus@.discussions.microsoft.com> wrote in message
news:DA68ACB7-098B-4282-92C6-23A24E024C1B@.microsoft.com...
> I consulted the SQL2K help for adding a table and copied the code
and
> substituted my own variables, but I get an error message about
incorrect
> syntax regarding the AS in line 1. I'm a newbie and am bummed that
the code
> provided in the help doesn't work--I'm assuming there's something I
don't
> know here. Here's the code:
> ---
> Dim t_AssessmentItem As SQLDMO.Table
> Dim OutputAssessmentLevelID As New SQLDMO.Column
> OutputAssessmentLevelID.Name = "ShelfLife"
> OutputAssessmentLevelID.Datatype = "CodeID"
> OutputAssessmentLevelID.AllowNulls = False
> OutputAssessmentLevelID.DRIDefault.Int = "AssessmentLevelID"
> Set t_AssessmentItem = _
>
oSQLServer.Databases("PowerSuasionDevLocal").Tables("t_AssessmentItem"
)
> t_AssessmentItem.BeginAlter
> t_AssessmentItem.Columns.Add OutputAssessmentLevelID
> t_AssessmentItem.DoAlter
> --
> Thanks for your help,
> karolus
Karolus,
You say your problem is about "incorrect syntax regard the AS in line
1".
It looks like you are using VB/VBA. Have you set a reference to the
"Microsoft SQLDMO Object Library"?
If you haven't, then "SQLDMO.Column" will not work.
Check:
VBA = Tools > References
VB = Project > References
Sincerely,
Chris O.