Showing posts with label background. Show all posts
Showing posts with label background. Show all posts

Wednesday, March 21, 2012

How to use SQL Svr 2005 Express in Excel 2003 VBA code?

Hello,

how can I use SQL Svr 2005 Express as database engine in background through VBA code in Excel 2003?

I want to CREATE and DELETE tables and SELECT, INSERT and UPDATE data. Is it possible to use ADO or other database objects to get in contact with SQL Svr 2005 Express?

Thanks a lot.

Christian

Yes, ADO is still supported... but... ADO 2.0 will take care of the new sophisticated features of SQL Server 2005 where ADO 1 doesn′t have a clue of, but at the end, ADO is still supported.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

This means VBA only supports ADO 1.0 and not ADO 2.0?

Do you have a code snippet for creating a connection, creating a table and selecting data from sql server express?

Thanks a lot.

Christian

|||Sorry, I was meaning ADO.NET 2.X not the old ADO.sql

How to use SQL Svr 2005 Express in Excel 2003 VBA code?

Hello,

how can I use SQL Svr 2005 Express as database engine in background through VBA code in Excel 2003?

I want to CREATE and DELETE tables and SELECT, INSERT and UPDATE data. Is it possible to use ADO or other database objects to get in contact with SQL Svr 2005 Express?

Thanks a lot.

Christian

Yes, ADO is still supported... but... ADO 2.0 will take care of the new sophisticated features of SQL Server 2005 where ADO 1 doesn′t have a clue of, but at the end, ADO is still supported.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

This means VBA only supports ADO 1.0 and not ADO 2.0?

Do you have a code snippet for creating a connection, creating a table and selecting data from sql server express?

Thanks a lot.

Christian

|||Sorry, I was meaning ADO.NET 2.X not the old ADO.

Monday, March 12, 2012

How to use linked server securely?

background: sql2k on nt5.
Can someone tell me a secured way to set up a secured linked server?
In the past, I have been using sa account and its password to set up a
linked server, but a regular user with limited permissions on ServerA can
issue any commands to a linked ServerB as sa account, right?
Is there a way to limit the use of a linked server to a NT group with sql
admins role?
Thank you.You probably ought to read Books Online subject: "linked servers, security"
This is potentially a big subject that can't be effectively dealt with via
message boards...
"== Steve Pdx==" <lins@.nospam.portptld.com> wrote in message
news:ehtZt75NEHA.1396@.TK2MSFTNGP10.phx.gbl...
> background: sql2k on nt5.
>
> Can someone tell me a secured way to set up a secured linked server?
> In the past, I have been using sa account and its password to set up a
> linked server, but a regular user with limited permissions on ServerA can
> issue any commands to a linked ServerB as sa account, right?
>
> Is there a way to limit the use of a linked server to a NT group with sql
> admins role?
>
> Thank you.
>
>|||I have read that subject i BOL.
it doesn't make much sense to me.
If I were to have a NT group called sqladmins, and i assign Bob, Chris, and
Doug to that group.
I have 2 servers, ServerA and Server B. I want sqladmis to be able to query
ServerB (any database, such as sysobjects in master database) from ServerA,
but not for other users not belong to that group.
What should I do?
Pls help! Thank you
"Don Peterson" <no1@.nunya.com> wrote in message
news:eYOCHX6NEHA.3744@.TK2MSFTNGP11.phx.gbl...
> You probably ought to read Books Online subject: "linked servers,
security"
> This is potentially a big subject that can't be effectively dealt with via
> message boards...
> "== Steve Pdx==" <lins@.nospam.portptld.com> wrote in message
> news:ehtZt75NEHA.1396@.TK2MSFTNGP10.phx.gbl...
> > background: sql2k on nt5.
> >
> >
> >
> > Can someone tell me a secured way to set up a secured linked server?
> >
> > In the past, I have been using sa account and its password to set up a
> > linked server, but a regular user with limited permissions on ServerA
can
> > issue any commands to a linked ServerB as sa account, right?
> >
> >
> >
> > Is there a way to limit the use of a linked server to a NT group with
sql
> > admins role?
> >
> >
> >
> > Thank you.
> >
> >
> >
> >
>

How to use linked server securely?

background: sql2k on nt5.
Can someone tell me a secured way to set up a secured linked server?
In the past, I have been using sa account and its password to set up a
linked server, but a regular user with limited permissions on ServerA can
issue any commands to a linked ServerB as sa account, right?
Is there a way to limit the use of a linked server to a NT group with sql
admins role?
Thank you.
You probably ought to read Books Online subject: "linked servers, security"
This is potentially a big subject that can't be effectively dealt with via
message boards...
"== Steve Pdx==" <lins@.nospam.portptld.com> wrote in message
news:ehtZt75NEHA.1396@.TK2MSFTNGP10.phx.gbl...
> background: sql2k on nt5.
>
> Can someone tell me a secured way to set up a secured linked server?
> In the past, I have been using sa account and its password to set up a
> linked server, but a regular user with limited permissions on ServerA can
> issue any commands to a linked ServerB as sa account, right?
>
> Is there a way to limit the use of a linked server to a NT group with sql
> admins role?
>
> Thank you.
>
>
|||I have read that subject i BOL.
it doesn't make much sense to me.
If I were to have a NT group called sqladmins, and i assign Bob, Chris, and
Doug to that group.
I have 2 servers, ServerA and Server B. I want sqladmis to be able to query
ServerB (any database, such as sysobjects in master database) from ServerA,
but not for other users not belong to that group.
What should I do?
Pls help! Thank you
"Don Peterson" <no1@.nunya.com> wrote in message
news:eYOCHX6NEHA.3744@.TK2MSFTNGP11.phx.gbl...
> You probably ought to read Books Online subject: "linked servers,
security"[vbcol=seagreen]
> This is potentially a big subject that can't be effectively dealt with via
> message boards...
> "== Steve Pdx==" <lins@.nospam.portptld.com> wrote in message
> news:ehtZt75NEHA.1396@.TK2MSFTNGP10.phx.gbl...
can[vbcol=seagreen]
sql
>

How to use linked server securely?

background: sql2k on nt5.
Can someone tell me a secured way to set up a secured linked server?
In the past, I have been using sa account and its password to set up a
linked server, but a regular user with limited permissions on ServerA can
issue any commands to a linked ServerB as sa account, right?
Is there a way to limit the use of a linked server to a NT group with sql
admins role?
Thank you.You probably ought to read Books Online subject: "linked servers, security"
This is potentially a big subject that can't be effectively dealt with via
message boards...
"== Steve Pdx==" <lins@.nospam.portptld.com> wrote in message
news:ehtZt75NEHA.1396@.TK2MSFTNGP10.phx.gbl...
> background: sql2k on nt5.
>
> Can someone tell me a secured way to set up a secured linked server?
> In the past, I have been using sa account and its password to set up a
> linked server, but a regular user with limited permissions on ServerA can
> issue any commands to a linked ServerB as sa account, right?
>
> Is there a way to limit the use of a linked server to a NT group with sql
> admins role?
>
> Thank you.
>
>|||I have read that subject i BOL.
it doesn't make much sense to me.
If I were to have a NT group called sqladmins, and i assign Bob, Chris, and
Doug to that group.
I have 2 servers, ServerA and Server B. I want sqladmis to be able to query
ServerB (any database, such as sysobjects in master database) from ServerA,
but not for other users not belong to that group.
What should I do?
Pls help! Thank you
"Don Peterson" <no1@.nunya.com> wrote in message
news:eYOCHX6NEHA.3744@.TK2MSFTNGP11.phx.gbl...
> You probably ought to read Books Online subject: "linked servers,
security"
> This is potentially a big subject that can't be effectively dealt with via
> message boards...
> "== Steve Pdx==" <lins@.nospam.portptld.com> wrote in message
> news:ehtZt75NEHA.1396@.TK2MSFTNGP10.phx.gbl...
can[vbcol=seagreen]
sql[vbcol=seagreen]
>

Friday, March 9, 2012

how to use Foodmart sample reports?

i'm new to reporting service and would appreciate some helps with the
problem i ran into.
background: sql2k on w2k3 with sp3a. sql analysis service, vs .net
2003. and reporting service.
I set up the distributed installation, sql server, reporting server,
analysis service on the same box, but the report designer and vs .net
2003 are on developer's machine.
After installation and upload of the sample database (AdventureWorks),
all the reports worked except Foodmart Sales report. see error msg:
============== An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
Cannot create a connection to data source 'FoodMart 2000'.
(rsErrorOpeningConnection) Get Online Help
Unspecified error
===============
how to make this report works? i've installed the analysis services on
the server, but i didn't see a database for foodmart on the sql server
(i saw AdventureWorks, ReportServer, ReportServerTempDb)
Thank you!Foodmart is the sample database that ships with SQL Server 2000. You should
be able to find the foodmart cube with your original SQL distribution.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"lins" <steve.lin@.powells.com> wrote in message
news:1106169708.806166.137040@.c13g2000cwb.googlegroups.com...
> i'm new to reporting service and would appreciate some helps with the
> problem i ran into.
> background: sql2k on w2k3 with sp3a. sql analysis service, vs .net
> 2003. and reporting service.
> I set up the distributed installation, sql server, reporting server,
> analysis service on the same box, but the report designer and vs .net
> 2003 are on developer's machine.
> After installation and upload of the sample database (AdventureWorks),
> all the reports worked except Foodmart Sales report. see error msg:
> ==============> An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> Cannot create a connection to data source 'FoodMart 2000'.
> (rsErrorOpeningConnection) Get Online Help
> Unspecified error
> ===============> how to make this report works? i've installed the analysis services on
> the server, but i didn't see a database for foodmart on the sql server
> (i saw AdventureWorks, ReportServer, ReportServerTempDb)
> Thank you!
>|||i saw the foodmart cube in analysis service, but not as a database in
sql server. am i missing something here? can someone give me some step
by step check list to make that reprot works? i searched online help
and microsoft site and found no info how reporting services work with
analysis servcies.
thank you.|||Yes, foodmart is a cube. here's the description of the sample report:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_samplereports_v1_0jlf.asp
here's a description of how to install AS and the foodmart sample database:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmad/aginstalling_5trn.asp
Once this is done, you'll need to configure the report's datasource to
access the foodmart database (cube). You can do this on the
properties->data sources tab for the report.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"lins" <steve.lin@.powells.com> wrote in message
news:1106248441.279279.304390@.c13g2000cwb.googlegroups.com...
>i saw the foodmart cube in analysis service, but not as a database in
> sql server. am i missing something here? can someone give me some step
> by step check list to make that reprot works? i searched online help
> and microsoft site and found no info how reporting services work with
> analysis servcies.
> thank you.
>|||thank you for the reply. as i said earlier, i'm new to reporting
service. i wonder if someone has worked with the foodmart sample
report before can provide me a sample data soruce connection string.
the current one on my reporting server for the foodmart looks like this
Connection Type: OLE DB
Connection String: Provider=MSOLAP.2;Client Cache Size=25;Data
Source=localhost;Initial Catalog=FoodMart 2000;Auto Synch Period=10000
(but this connection string is not working for me. )
and i'm using Windows NT Integrated Security.
thank you.|||Do you have Analysis Services deployed on your machine?
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"lins" <steve.lin@.powells.com> wrote in message
news:1106259008.263757.204280@.z14g2000cwz.googlegroups.com...
> thank you for the reply. as i said earlier, i'm new to reporting
> service. i wonder if someone has worked with the foodmart sample
> report before can provide me a sample data soruce connection string.
> the current one on my reporting server for the foodmart looks like this
> Connection Type: OLE DB
> Connection String: Provider=MSOLAP.2;Client Cache Size=25;Data
> Source=localhost;Initial Catalog=FoodMart 2000;Auto Synch Period=10000
> (but this connection string is not working for me. )
> and i'm using Windows NT Integrated Security.
> thank you.
>