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. 5 2742
Gloria (gl**********@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, so****@algonet.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...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 (gl**********@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, so****@algonet.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp gl**********@yahoo.com.mx (Gloria) wrote in message news:<33**************************@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, gl**********@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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Nigo |
last post by:
Hi there
Is it posible to make a link (to a php-file on a server) in an email
that, when you click on it, sends info about who the reciver of the
email is?
Lets say I send out an email thru...
|
by: Xerxes |
last post by:
Hi,
how can I activate a login when someone clicks on a link? I want only
authorized users to have access to the pages accessible through the
links.
Thanks.
|
by: chris |
last post by:
Hi there,
I'd like ASP.NET (C#, preferably) to highlight the active link in the
navigation menu of my site. At present the links are anchors within a
..ascx user control, which appears on all...
|
by: Viken Karaguesian |
last post by:
Hello all,
I'm making a calendar section in a website. Each month is its own page and
navigated by Previous / Next links. I have it working now with standard
hyperlinks, but I want to learn how...
|
by: trichert |
last post by:
Ok , developing a .aspx page with Visual Web Studio (the full page is
at the bottom). Basically its a page that displays all my computers
and the current logged on user pulling data from a live...
|
by: Mica Cooper |
last post by:
Hi,
I need to pass some info in a javascript submit.
<a href="javascript:document.formName.submit();">Submit Form</a>
Normally a link would do page.jsp?x1=1&x2=2&x3=3 and you would pull x1,...
|
by: traceable1 |
last post by:
I have a couple new servers - Windows 2003 R2 - with SQL Server 2000
SP4 installed. They are all Active/Active clustered instances (my
first ones).
I am trying to create database links to other...
|
by: mosscliffe |
last post by:
I am trying to create a link to a file, which I can then use in an
HTML page.
The system is Linux on a hosted web service, running python 2.3.
Other than that I have no knowledge of the system....
|
by: ted |
last post by:
I have an old link that was widely distributed. I would now like to
put a link on that old
page that will go to a new page without displaying anything.
|
by: mister-Ed |
last post by:
I am displaying subcategories in my datalist, and now I have a
bizarre thing happen when I add a new subcategory record in my sql
database, the new subcategory link does not click into the next...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |