LINK WITH SQL SERVER

[Gloria]

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.

[Erland Sommarskog]

Re: LINK WITH SQL SERVER

Gloria (gloriarr2001@y ahoo.com.mx) writes:[color=blue]
> 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.[/color]

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/techinfo/productdoc/2000/books.asp

[Gloria]

Re: LINK WITH SQL SERVER

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?

[Erland Sommarskog]

Re: LINK WITH SQL SERVER

Gloria (gloriarr2001@y ahoo.com.mx) writes:[color=blue]
> 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?[/color]

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/techinfo/productdoc/2000/books.asp

[chris nolan]

Re: LINK WITH SQL SERVER

gloriarr2001@ya hoo.com.mx (Gloria) wrote in message news:<334b61a7. 0404282149.1839 acf1@posting.go ogle.com>...[color=blue]
> 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?[/color]

Have you installed the SQL Server client on your laptop?

[Ellen K.]

Re: LINK WITH SQL SERVER

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 EnterpriseManag er 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.Connection String = "file name=c:\MyDatab ase.udl"


HTH :)

On 28 Apr 2004 12:34:47 -0700, gloriarr2001@ya hoo.com.mx (Gloria)
wrote:
[color=blue]
>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.[/color]

[Gloria]

Re: LINK WITH SQL SERVER

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?

[RSMEINER]

Re: LINK WITH SQL SERVER

>Well, I don't want to make a network, so there's no need to install[color=blue]
>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?
>[/color]

Tell us what the error msg is.


Randy

http://members.aol.com/rsmeiner

[Erland Sommarskog]

Re: LINK WITH SQL SERVER

Gloria (gloriarr2001@y ahoo.com.mx) writes:[color=blue]
> 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).[/color]

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/techinfo/productdoc/2000/books.asp

[Ellen K.]

Re: LINK WITH SQL SERVER

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@ya hoo.com.mx (Gloria)
wrote:
[color=blue]
>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?[/color]

[Gloria]

Re: LINK WITH SQL SERVER

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?

[RSMEINER]

Re: LINK WITH SQL SERVER

>Well, I don't want to make a network, so there's no need to install[color=blue]
>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?
>[/color]

Tell us what the error msg is.


Randy

http://members.aol.com/rsmeiner

[Erland Sommarskog]

Re: LINK WITH SQL SERVER

Gloria (gloriarr2001@y ahoo.com.mx) writes:[color=blue]
> 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).[/color]

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/techinfo/productdoc/2000/books.asp

[Ellen K.]

Re: LINK WITH SQL SERVER

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@ya hoo.com.mx (Gloria)
wrote:
[color=blue]
>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?[/color]

[Gloria]

Re: LINK WITH SQL SERVER

Ellen K. <72322.enno.ess peeayem.1016@co mpuserve.com> wrote in message news:<nguh90dua gqp6p85vqmg6664 n8babe7r8d@4ax. com>...[color=blue]
> How do you expect to talk to the database on the other box if the
> laptop isn't connected to it?
>[/color]
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.