LIMIT problems

Friday, March 30, 2012

LINK WITH SQL SERVER

Hi, I'm doing a proyect with Visual Basic where I have to use a
database that I've already made on SQL SERVER. In my computer I had to
install WINDOWS 2000 family server, to be able to install SQL SERVER
as server not as a client, I can see perfectly and totally the
database from VB.

The problem is that now I have a laptop, and I want to continue
developing on it, I already installed everything like in the other
one, but I can't see SQL SERVER as a provider when I want to make the
connection. So I don't know if I have to do something special in order
to see it from Visual Basic.

I don't want to make a network, I just want to keep with the proyect
from the laptop.

Please somebody help me.Gloria (gloriarr2001@.yahoo.com.mx) writes:
> Hi, I'm doing a proyect with Visual Basic where I have to use a
> database that I've already made on SQL SERVER. In my computer I had to
> install WINDOWS 2000 family server, to be able to install SQL SERVER
> as server not as a client, I can see perfectly and totally the
> database from VB.
> The problem is that now I have a laptop, and I want to continue
> developing on it, I already installed everything like in the other
> one, but I can't see SQL SERVER as a provider when I want to make the
> connection. So I don't know if I have to do something special in order
> to see it from Visual Basic.

I'm not really sure what you mean with that you cannot see SQL Server as
provider. Do you run your program, and you fail to connect? Or is it
somehow missing in the developement environment? In the latter case,
you may be better off asking in a Visual Basic newsgroup.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||The fact is that when I try to make a connection from Visual Basic, I
have to specified the provider of OLE DB, so I use Microsoft OLE DB
Provider for SQL Sever, and when I try to check the connection there's
an error, there is no problem with Visual Basic, so I think that I do
something wrong with the SQL SERVER installation.

Is there anything that you suggest I can do?|||Gloria (gloriarr2001@.yahoo.com.mx) writes:
> The fact is that when I try to make a connection from Visual Basic, I
> have to specified the provider of OLE DB, so I use Microsoft OLE DB
> Provider for SQL Sever, and when I try to check the connection there's
> an error, there is no problem with Visual Basic, so I think that I do
> something wrong with the SQL SERVER installation.
> Is there anything that you suggest I can do?

Could you post the relevant piece of code?

There are a numbe of possibilities, but not having to access to your
machine, I'm in the dark.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||gloriarr2001@.yahoo.com.mx (Gloria) wrote in message news:<334b61a7.0404282149.1839acf1@.posting.google.com>...
> The fact is that when I try to make a connection from Visual Basic, I
> have to specified the provider of OLE DB, so I use Microsoft OLE DB
> Provider for SQL Sever, and when I try to check the connection there's
> an error, there is no problem with Visual Basic, so I think that I do
> something wrong with the SQL SERVER installation.
> Is there anything that you suggest I can do?

Have you installed the SQL Server client on your laptop?|||Not quite sure what you mean by "see SQL Server as a provider".

1. You need to have the SQL Server Client Tools installed on your
laptop.

2. Your laptop needs to be able to see the server in Network.

3. You need to "register" your database in the EnterpriseManager on
your laptop.

Alternatively, if you mean you can't create a UDL, the steps are:
A. In Windows Explorer, select File | New | text file.
B. Rename the resulting textfile to have .udl as its extension,
e.g. MyDatabase.udl. You will get a warning about changing the file
extension, ignore it.
C. Open the udl. Here's the stupid part -- when you open it, it
will be on the SECOND page of the wizard, which is only for ODBC
connections. You have to go to the FIRST page to find the SQL Server
OLE DB provider.
D. Now you can define your connection string like
Dim MyDB As Connection
Set MyDB = New Connection
MyDB.ConnectionString = "file name=c:\MyDatabase.udl"

HTH :)

On 28 Apr 2004 12:34:47 -0700, gloriarr2001@.yahoo.com.mx (Gloria)
wrote:

>Hi, I'm doing a proyect with Visual Basic where I have to use a
>database that I've already made on SQL SERVER. In my computer I had to
>install WINDOWS 2000 family server, to be able to install SQL SERVER
>as server not as a client, I can see perfectly and totally the
>database from VB.
>The problem is that now I have a laptop, and I want to continue
>developing on it, I already installed everything like in the other
>one, but I can't see SQL SERVER as a provider when I want to make the
>connection. So I don't know if I have to do something special in order
>to see it from Visual Basic.
>I don't want to make a network, I just want to keep with the proyect
>from the laptop.
>Please somebody help me.

LINK WITH SQL SERVER

I don't want to make a network, I just want to keep with the proyect
from the laptop.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Could you post the relevant piece of code?

There are a numbe of possibilities, but not having to access to your
machine, I'm in the dark.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Have you installed the SQL Server client on your laptop?|||Not quite sure what you mean by "see SQL Server as a provider".

1. You need to have the SQL Server Client Tools installed on your
laptop.

2. Your laptop needs to be able to see the server in Network.

3. You need to "register" your database in the EnterpriseManager on
your laptop.

HTH :)

On 28 Apr 2004 12:34:47 -0700, gloriarr2001@.yahoo.com.mx (Gloria)
wrote:

What do you think I can do?|||>Well, I don't want to make a network, so there's no need to install
>SQL as client on my laptop, I just want to develop on it, and the
>problem appears when I creat the UDL, during I try to choose the
>database, and an error about the provider appears (that it can be
>use).
>What do you think I can do?

Tell us what the error msg is.

Randy
http://members.aol.com/rsmeiner|||Gloria (gloriarr2001@.yahoo.com.mx) writes:
> Well, I don't want to make a network, so there's no need to install
> SQL as client on my laptop, I just want to develop on it, and the
> problem appears when I creat the UDL, during I try to choose the
> database, and an error about the provider appears (that it can be
> use).

I don't understand what you mean by "make a network", but since you
gooc have good use for having Query Analyzer and friends on the
machine while developing, I suggest that you install the client
part of SQL Server. You are not making a network that way anyway.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||How do you expect to talk to the database on the other box if the
laptop isn't connected to it?

On 4 May 2004 11:37:22 -0700, gloriarr2001@.yahoo.com.mx (Gloria)
wrote:

>Well, I don't want to make a network, so there's no need to install
>SQL as client on my laptop, I just want to develop on it, and the
>problem appears when I creat the UDL, during I try to choose the
>database, and an error about the provider appears (that it can be
>use).
>What do you think I can do?|||Well, I don't want to make a network, so there's no need to install
SQL as client on my laptop, I just want to develop on it, and the
problem appears when I creat the UDL, during I try to choose the
database, and an error about the provider appears (that it can be
use).

Tell us what the error msg is.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||How do you expect to talk to the database on the other box if the
laptop isn't connected to it?

On 4 May 2004 11:37:22 -0700, gloriarr2001@.yahoo.com.mx (Gloria)
wrote:

>Well, I don't want to make a network, so there's no need to install
>SQL as client on my laptop, I just want to develop on it, and the
>problem appears when I creat the UDL, during I try to choose the
>database, and an error about the provider appears (that it can be
>use).
>What do you think I can do?|||Ellen K. <72322.enno.esspeeayem.1016@.compuserve.com> wrote in message news:<nguh90duagqp6p85vqmg6664n8babe7r8d@.4ax.com>...
> How do you expect to talk to the database on the other box if the
> laptop isn't connected to it?
Well, wath I want to do is have the database in the laptop, I already
created there, I can use the query analyzer, but in the UDL
construction, there's an error after I dropdown on the databases box.sql

Link with parameters

Hi,
is it possible to start a Report via Link (from Desktop) with start
parameter like an
ASP-Script
For example:
...report.rdl?Year=2007&Month=6...
Thank you
HansThat's what URL access in RS is for.
Amarnath
"Hans" wrote:
> Hi,
> is it possible to start a Report via Link (from Desktop) with start
> parameter like an
> ASP-Script
> For example:
>
> ...report.rdl?Year=2007&Month=6...
>
> Thank you
> Hans
>|||That what I mean ist to start the report from Desktop inclusive
parameters.
Hans|||ok,
so this is a sample you can use to see how it works if you have implemented
the samples and hosted the reports on localserver. copy this url from
desktop.. also you can write asp.net to mask this url and give just a
hyperlink from the page.. see the parameters also passed.
http://server/reportserver?/Sales/Northwest/Employee Sales
Report&rs:Command=Render&EmployeeID=1234
Amarnath
"Hans" wrote:
> That what I mean ist to start the report from Desktop inclusive
> parameters.
> Hans
>|||I tried this, but it doesn=B4t work. The report opens, but there=B4s not
selected parameter value.
Thanks,
Hans|||Hans,
Have you pasted my sample link as a whole URL because it is wraped in the
post.
Incase you have done this pl ignore, you said there is no parameter value,
so I thought you have not pasted the whole URL.
Amarnath, MCTS
"Hans" wrote:
> I tried this, but it doesnÂ´t work. The report opens, but thereÂ´s not
> selected parameter value.
>
> Thanks,
> Hans
>

Link with encryption example for 2005

Is there any link where I can see how the new security model wrt
keys/certificates work ? I am looking for examples. to play around with.See my blog - a link to is in my signature.
Thanks
Laurentiu Cristofor [MSFT]
Software Development Engineer
SQL Server Engine
http://blogs.msdn.com/lcris/
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hassan" <Hassan@.hotmail.com> wrote in message
news:etpA4MdPHHA.3268@.TK2MSFTNGP03.phx.gbl...
> Is there any link where I can see how the new security model wrt
> keys/certificates work ? I am looking for examples. to play around with.
>

Link two tables using partial word match

Hi All,

I need to link two tables using partial word match.

How can I write a SQL statement to do so? (I am using MS-Access.)

Table One: [Table Name: tblStreet] [Field Name: Street]
123 ABC Street
124 ABC Street
125 ABC Street
1 XYZ AVE
2 XYZ AVE
3 XYZ AVE
10 CBS Street
11 CBS Street
12 CBS Street
100 Apple Road
101 Apple Road
102 Apple Road

Table Two: [Table Name: tblWord] [Field Name: Word]
ABC
CBS

The output should be:

123 ABC Street
124 ABC Street
125 ABC Street
10 CBS Street
11 CBS Street
12 CBS Street

Could this be done?

Thank you in advanced.

- Grasshopper -SQL Learner wrote:

Quote:

Originally Posted by

Hi All,
>
I need to link two tables using partial word match.
>
How can I write a SQL statement to do so? (I am using MS-Access.)
>
Table One: [Table Name: tblStreet] [Field Name: Street]
123 ABC Street
124 ABC Street
125 ABC Street
1 XYZ AVE
2 XYZ AVE
3 XYZ AVE
10 CBS Street
11 CBS Street
12 CBS Street
100 Apple Road
101 Apple Road
102 Apple Road
>
Table Two: [Table Name: tblWord] [Field Name: Word]
ABC
CBS
>
The output should be:
>
123 ABC Street
124 ABC Street
125 ABC Street
10 CBS Street
11 CBS Street
12 CBS Street
>
Could this be done?
>
Thank you in advanced.
>
- Grasshopper -

SELECT t.* FROM tblStreet t WHERE EXISTS(SELECT 1 FROM tblWord w WHERE
t.Street LIKE '%'+Word+'%')

--------
Alex Kuznetsov
http://sqlserver-tips.blogspot.com/
http://sqlserver-puzzles.blogspot.com/|||Thank you so much Alex! It works. The only thing is that I replaced
the "%" with "*" since this is Transact SQL in Access. : )

By the way, is there any good book that I can use to learn SQL of this
kind?

- Grasshopper -

Link two tables in UPDATE - ERR:single-row subquery returns more than one row

1 UPDATE PM_ASSIGNMENTS
2 SET PM_ASSIGNMENTS.JOB_TYPE_CODE = (SELECT PM_TASK_DETAILS.JOB_TYPE_CODE
3 FROM PM_ASSIGNMENTS, PM_TASK_DETAILS
4 WHERE ((PM_ASSIGNMENTS.TASK_NUMBER) = (PM_TASK_DETAILS.TASK_NUMBER))
5* AND (PM_ASSIGNMENTS.TASK_NUMBER = '1000'))
SQL> /
SET PM_ASSIGNMENTS.JOB_TYPE_CODE = (SELECT PM_TASK_DETAILS.JOB_TYPE_CODE
*
ERROR at line 2:
ORA-01427: single-row subquery returns more than one rowthe sub-query is returning more than one row for the given condition.

either group-by them, or give all user-key conditions.

regards,
Raghu.sql

Link Two tables

Hi All,
I want link two tables from two different database located on different server. they both are not have unique reference.
Table1 from db1 is one field(Emp_id) is auto increment number And another one is table2 from db2(Newly created table). I need some fields from table1.db1 to table2 db2. When all are user modified table1.db1 then automatically update table2.db2

thanksI think you recieved answer to your question.

http://www.msdner.com/forum/thread586326.html

Not sure what else you are looking for.

Friday, March 30, 2012

LINK WITH SQL SERVER

LINK WITH SQL SERVER

Link with parameters

Link with encryption example for 2005

Link two tables using partial word match

Link two tables in UPDATE - ERR:single-row subquery returns more than one row

Link Two tables

LIMIT problems

Blog Archive

About Me