Do SQL Server 2005/CLR Triggers support .config Files?

Does anyone know if it's possible to use the standard .config file within a CLR Trigger to read properties via the System.Configuration namespace

I guess it's not possible because the CLR Trigger needs to be compiled as an assembly which is hosted by SQL Server

Thanks

Jason

Hi,

http://groups.google.de/group/microsoft.public.sqlserver.programming/browse_frm/thread/6d635c2cd23fed7

CLR stuff in SQL Server does not work like those know from "normal" applications. Although you can use the Configuration class to load a configuration somewhere stored on disk, you have to keep in mind, that every namespace / class that you use with are not approved as safe will lower down your security, because you have to mark them as unsafe / external access.

Perhaps any other posters has some other experiences about that.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||Hi,
I think the “CLR Triggers for SQL Server 2005” article on
http://aspalliance.com/1273_CLR_Triggers_for_SQL_Server_2005
may be helpful in this discussion.

This popular white paper is written by a software engineer from our organization Mindfire Solutions (http://www.mindfiresolutions.com).

I hope you find it useful!

Cheers,
Byapti

Do SQL 7 CALs count for a SQL 2000 install?

Hi,
I have a client with SQL 7 and they need to go to SQL 2000 via an upgrade to
run their now updated app. Do their existing SQL 7 CALs allow then to access
the SQL 2000 server or do they have to buy all the CALs again. Or maybe there
is some upgrade price.
Their vendor has priced 60 SQL 200 CALs at £8,100.00 - which isnt too cheap(!)
Thanks.From the server EULA:
"Any CAL must have the same or later version number than the corresponding
version number of the Server Software being used."
http://www.microsoft.com/sql/howtobuy/default.asp
Ask the vendor about upgrade pricing.
--
David Portas
SQL Server MVP
--

Do SQL 7 CALs count for a SQL 2000 install?

Hi,
I have a client with SQL 7 and they need to go to SQL 2000 via an upgrade to
run their now updated app. Do their existing SQL 7 CALs allow then to access
the SQL 2000 server or do they have to buy all the CALs again. Or maybe ther
e
is some upgrade price.
Their vendor has priced 60 SQL 200 CALs at ￡8,100.00 - which isnt too cheap
(!)
Thanks.From the server EULA:
"Any CAL must have the same or later version number than the corresponding
version number of the Server Software being used."
http://www.microsoft.com/sql/howtobuy/default.asp
Ask the vendor about upgrade pricing.
David Portas
SQL Server MVP
--

Do SQL 7 CALs count for a SQL 2000 install?

Hi,
I have a client with SQL 7 and they need to go to SQL 2000 via an upgrade to
run their now updated app. Do their existing SQL 7 CALs allow then to access
the SQL 2000 server or do they have to buy all the CALs again. Or maybe there
is some upgrade price.
Their vendor has priced 60 SQL 200 CALs at ￡8,100.00 - which isnt too cheap(!)
Thanks.
From the server EULA:
"Any CAL must have the same or later version number than the corresponding
version number of the Server Software being used."
http://www.microsoft.com/sql/howtobuy/default.asp
Ask the vendor about upgrade pricing.
David Portas
SQL Server MVP

DNS problems in ASP

I hope that I'm right here.
We have an intranet-site in ASP where, till now the data was in an
Access database and we connected to the data via DNS.
Now we would like to change the data to a SQL-server.
For me, it seems logic that logic that everything should work after
creating a new DNS to the new data.
It doesn't!
None of the tables where found, ... After some search I found that I
need to prefix the tables with the owner.
I suppose that I do something wrong here and that there is a solution
for this.
Also I keep a local copy of the site to develop new pages where I also
would like to keep the data in Access so that I don't work with the
real data.
Many thanks in advance,
Filip
What tool did you use to migrate from Access to SQL Server?
You mention that you need to preface the tables with their owner.
Does that mean that a table within Access called tblData is now:
owner.tblData
or
ownertblData
If tables were created with the incorrect name you can change the table
names pretty easily. Look up sp_rename within Books Online
http://msdn2.microsoft.com/en-us/library/ms203721.aspx
If the owner of the table is not dbo and is some database user that you have
within SQL Server you should change the owner to dbo.
Look up sp_changeobjectowner within Books Online.
Once the owner is changed to dbo you should not have to specify the owner of
the table when you retrieve data from the tables.
Now that you are using SQL Server you might want to look into using stored
procedures to perform all your data access (CRUD - create, read, update,
delete)...but lets take things one step at a time.
Keith Kratochvil
"FilMar" <FilMar@.gmail.com> wrote in message
news:1159948972.268238.108090@.c28g2000cwb.googlegr oups.com...
>I hope that I'm right here.
> We have an intranet-site in ASP where, till now the data was in an
> Access database and we connected to the data via DNS.
> Now we would like to change the data to a SQL-server.
> For me, it seems logic that logic that everything should work after
> creating a new DNS to the new data.
> It doesn't!
> None of the tables where found, ... After some search I found that I
> need to prefix the tables with the owner.
> I suppose that I do something wrong here and that there is a solution
> for this.
> Also I keep a local copy of the site to develop new pages where I also
> would like to keep the data in Access so that I don't work with the
> real data.
> Many thanks in advance,
> Filip
>
|||Thanks Keith, that does the trick.
In Access they become owner_tblData but there you can rename them
without problems. In ASP they need to be [owner].[tbl_Data] if there
not owned by dbo but that is now solved with your solution.
BTW: we did the migration with the upsize wizard of Access as it seems
it does the job far better than the import/export of SQL-server.
Many thanks,
Filip
Keith Kratochvil schreef:
[vbcol=seagreen]
> What tool did you use to migrate from Access to SQL Server?
> You mention that you need to preface the tables with their owner.
> Does that mean that a table within Access called tblData is now:
> owner.tblData
> or
> ownertblData
> If tables were created with the incorrect name you can change the table
> names pretty easily. Look up sp_rename within Books Online
> http://msdn2.microsoft.com/en-us/library/ms203721.aspx
> If the owner of the table is not dbo and is some database user that you have
> within SQL Server you should change the owner to dbo.
> Look up sp_changeobjectowner within Books Online.
> Once the owner is changed to dbo you should not have to specify the owner of
> the table when you retrieve data from the tables.
>
> Now that you are using SQL Server you might want to look into using stored
> procedures to perform all your data access (CRUD - create, read, update,
> delete)...but lets take things one step at a time.
>
> --
> Keith Kratochvil
>
> "FilMar" <FilMar@.gmail.com> wrote in message
> news:1159948972.268238.108090@.c28g2000cwb.googlegr oups.com...
|||I am glad that I could help!
Keith Kratochvil
"FilMar" <FilMar@.gmail.com> wrote in message
news:1160572041.620932.71790@.b28g2000cwb.googlegro ups.com...
> Thanks Keith, that does the trick.
> In Access they become owner_tblData but there you can rename them
> without problems. In ASP they need to be [owner].[tbl_Data] if there
> not owned by dbo but that is now solved with your solution.
> BTW: we did the migration with the upsize wizard of Access as it seems
> it does the job far better than the import/export of SQL-server.
> Many thanks,
> Filip
> Keith Kratochvil schreef:
>

DNS problems in ASP

I hope that I'm right here.
We have an intranet-site in ASP where, till now the data was in an
Access database and we connected to the data via DNS.
Now we would like to change the data to a SQL-server.
For me, it seems logic that logic that everything should work after
creating a new DNS to the new data.
It doesn't!
None of the tables where found, ... After some search I found that I
need to prefix the tables with the owner.
I suppose that I do something wrong here and that there is a solution
for this.
Also I keep a local copy of the site to develop new pages where I also
would like to keep the data in Access so that I don't work with the
real data.
Many thanks in advance,
FilipWhat tool did you use to migrate from Access to SQL Server?
You mention that you need to preface the tables with their owner.
Does that mean that a table within Access called tblData is now:
owner.tblData
or
ownertblData
If tables were created with the incorrect name you can change the table
names pretty easily. Look up sp_rename within Books Online
http://msdn2.microsoft.com/en-us/library/ms203721.aspx
If the owner of the table is not dbo and is some database user that you have
within SQL Server you should change the owner to dbo.
Look up sp_changeobjectowner within Books Online.
Once the owner is changed to dbo you should not have to specify the owner of
the table when you retrieve data from the tables.
Now that you are using SQL Server you might want to look into using stored
procedures to perform all your data access (CRUD - create, read, update,
delete)...but lets take things one step at a time.
Keith Kratochvil
"FilMar" <FilMar@.gmail.com> wrote in message
news:1159948972.268238.108090@.c28g2000cwb.googlegroups.com...
>I hope that I'm right here.
> We have an intranet-site in ASP where, till now the data was in an
> Access database and we connected to the data via DNS.
> Now we would like to change the data to a SQL-server.
> For me, it seems logic that logic that everything should work after
> creating a new DNS to the new data.
> It doesn't!
> None of the tables where found, ... After some search I found that I
> need to prefix the tables with the owner.
> I suppose that I do something wrong here and that there is a solution
> for this.
> Also I keep a local copy of the site to develop new pages where I also
> would like to keep the data in Access so that I don't work with the
> real data.
> Many thanks in advance,
> Filip
>|||Thanks Keith, that does the trick.
In Access they become owner_tblData but there you can rename them
without problems. In ASP they need to be [owner].[tbl_Data] if there
not owned by dbo but that is now solved with your solution.
BTW: we did the migration with the upsize wizard of Access as it seems
it does the job far better than the import/export of SQL-server.
Many thanks,
Filip
Keith Kratochvil schreef:
[vbcol=seagreen]
> What tool did you use to migrate from Access to SQL Server?
> You mention that you need to preface the tables with their owner.
> Does that mean that a table within Access called tblData is now:
> owner.tblData
> or
> ownertblData
> If tables were created with the incorrect name you can change the table
> names pretty easily. Look up sp_rename within Books Online
> http://msdn2.microsoft.com/en-us/library/ms203721.aspx
> If the owner of the table is not dbo and is some database user that you ha
ve
> within SQL Server you should change the owner to dbo.
> Look up sp_changeobjectowner within Books Online.
> Once the owner is changed to dbo you should not have to specify the owner
of
> the table when you retrieve data from the tables.
>
> Now that you are using SQL Server you might want to look into using stored
> procedures to perform all your data access (CRUD - create, read, update,
> delete)...but lets take things one step at a time.
>
> --
> Keith Kratochvil
>
> "FilMar" <FilMar@.gmail.com> wrote in message
> news:1159948972.268238.108090@.c28g2000cwb.googlegroups.com...|||I am glad that I could help!
Keith Kratochvil
"FilMar" <FilMar@.gmail.com> wrote in message
news:1160572041.620932.71790@.b28g2000cwb.googlegroups.com...
> Thanks Keith, that does the trick.
> In Access they become owner_tblData but there you can rename them
> without problems. In ASP they need to be [owner].[tbl_Data] if the
re
> not owned by dbo but that is now solved with your solution.
> BTW: we did the migration with the upsize wizard of Access as it seems
> it does the job far better than the import/export of SQL-server.
> Many thanks,
> Filip
> Keith Kratochvil schreef:
>
>

DMO Programming

Hello All,
I'm learning SQL-DMO programming via VBScript and I'm new to VBScript
programming as well. Would anyone know
of a News Group exclusively for DMO programming ?
Thanks,
GopiAFAIK, there are no newsgroups. However, you might find some resources here
at: http://www.sqldev.net/sqldmo.htm
Anith|||You might want to know that DMO is "dead" as of SQL Server 2005. It will be
there, but at the 2000
level (new functionality for 2005 will not be exposed in DMO). The successor
of DMO is called SMO.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"rgn" <gopinathr@.healthasyst.com> wrote in message news:uOqqXX4vFHA.2132@.TK2MSFTNGP15.phx.g
bl...
> Hello All,
> I'm learning SQL-DMO programming via VBScript and I'm new to VBScript prog
ramming as well. Would
> anyone know
> of a News Group exclusively for DMO programming ?
> Thanks,
> Gopi
>|||Hello Tibor,
I saw the SQLServer 2005 CTP CD (DVD ?) in the office today and I will look
at it tomorrow in the office (I'm at home now).
I was going through the following link
"http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx" and I
was wondering :
[1] If the CTP CD contains Express Edition also.
[2] And which of these editions will I be able to install (I mean the
Database engine and not just the Client Side Tools)
in my XP Professional Workstation at the office.
Thanks for your suggestion :)
Gopi
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uwIZLt4vFHA.2556@.TK2MSFTNGP15.phx.gbl...
> You might want to know that DMO is "dead" as of SQL Server 2005. It will
> be there, but at the 2000 level (new functionality for 2005 will not be
> exposed in DMO). The successor of DMO is called SMO.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "rgn" <gopinathr@.healthasyst.com> wrote in message
> news:uOqqXX4vFHA.2132@.TK2MSFTNGP15.phx.gbl...
>|||Tibor,
I think I found what I was looking for with respect to the "System
Requirements" from the following link.
http://download.microsoft.com/downl...sSQLEXP2005.htm
However, I'm not sure if the CD contains the Express Edition as well
Gopi
"gopi" <rgopinath@.hotmail.com> wrote in message
news:%23XJG2f6vFHA.724@.TK2MSFTNGP14.phx.gbl...
> Hello Tibor,
> I saw the SQLServer 2005 CTP CD (DVD ?) in the office today and I will
> look at it tomorrow in the office (I'm at home now).
> I was going through the following link
> "http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx" and I
> was wondering :
> [1] If the CTP CD contains Express Edition also.
> [2] And which of these editions will I be able to install (I mean the
> Database engine and not just the Client Side Tools)
> in my XP Professional Workstation at the office.
> Thanks for your suggestion :)
> Gopi
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:uwIZLt4vFHA.2556@.TK2MSFTNGP15.phx.gbl...
>|||> However, I'm not sure if the CD contains the Express Edition as well
I'm sorry, I don't know that, since I don't have that CD. You might want to
post this on the beta
newsgroups...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"gopi" <rgopinath@.hotmail.com> wrote in message news:eYeK4l6vFHA.3688@.tk2msftngp13.phx.gbl.
.
> Tibor,
> I think I found what I was looking for with respect to the "System Require
ments" from the
> following link.
> http://download.microsoft.com/downl...sSQLEXP2005.htm
> However, I'm not sure if the CD contains the Express Edition as well
> Gopi
> "gopi" <rgopinath@.hotmail.com> wrote in message news:%23XJG2f6vFHA.724@.TK2
MSFTNGP14.phx.gbl...
>

Distributed Trans. Coordinator for DAO and RDO

We access 2 different databases in our program. One of them is SQL database, we aceess it via RDO and the other one is Access database, used via DAO.
Now we need to "synchronize" 2 transaction that are carried against these databases. More precisely, we have 2 transactions, one upon DAO connection, the second upon RDO, and we need them to obey 2-Phase Commit protocol rules when commiting.
Anyone has faced similar task? Do we need to handle the transaction synchronization ourselves or there is a sort of DTC that can handle the situation?
Thank You in advance.

The Jet/Access database engine does not support distributed transactions. You'd need to handle the transaction synchronization yourself.

David Sceppa
ADO.NET Program Manager
Microsoft