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]