473,382 Members | 1,252 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

Server Explorer - Add Data Connection - Add new Data Provider to l

Does anyone know how to add a new data provider to Visual Studio - to the
Provider list in Server Explorer. I am using Sybase's ADO.NET Data Provider.
It has been added to my GAC and appears in my References.
However, I would like to add the provider to the Provider list in Server
Explorer. Thanks.
~Marsha
Nov 16 '05 #1
1 3723
Hi Marsha,

The ability to connect directly to ADO .NET providers is not supported in
Visual Studio .NET 2003; you can only use OLE DB providers here. In Visual
Studio .NET 2005, however, we have replaced the data connection
architecture with a new, extensible mechanism that allows any kind of data
provider to add and enhance their design time experience inside Visual
Studio. That is, in order for the Sybase .NET data provider to appear and
be functional from within the Server Explorer, Sybase or a data provider
extender would need to supply some extra features that provide design time
support for the provider.

I hope this answers your question.

Thanks,
Stephen Provine
VS Data Team [MSFT]

--------------------
Thread-Topic: Server Explorer - Add Data Connection - Add new Data Provider to lthread-index: AcTyf0ErtliJFeJFTTKUuMUBZ55bNw==
X-WBNR-Posting-Host: 63.97.92.130
From: =?Utf-8?B?TWFyc2hh?= <Ma****@discussions.microsoft.com>
Subject: Server Explorer - Add Data Connection - Add new Data Provider to l
Date: Tue, 4 Jan 2005 09:03:04 -0800
Lines: 6
Message-ID: <A4**********************************@microsoft.co m>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.dotnet.languages.csharp
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFT NGP08.phx.gbl!TK2MSFTNGXA0
3.phx.gblXref: cpmsftngxa10.phx.gbl microsoft.public.dotnet.languages.csharp:297004
X-Tomcat-NG: microsoft.public.dotnet.languages.csharp

Does anyone know how to add a new data provider to Visual Studio - to the
Provider list in Server Explorer. I am using Sybase's ADO.NET Data Provider. It has been added to my GAC and appears in my References.
However, I would like to add the provider to the Provider list in Server
Explorer. Thanks.
~Marsha


Nov 16 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Greg P | last post by:
I know this is a long post, please bear with me. I have been working on this all weekend to no avail although I have done a good amount of research (see most pertinent links that I've looked at...
7
by: Greg P | last post by:
I know this is a long post, please bear with me. I have been working on this all weekend to no avail although I have done a good amount of research (see most pertinent links that I've looked at...
14
by: Marcus | last post by:
I have a function that simply returns TRUE if it can connect to a particular Sql Server 2005 express, or FALSE if it cannot. I am getting some strange error codes returned when the computer that...
4
by: Ralph | last post by:
I am trying out the dataform wizard in visual studio using a sql server 2003 database. It seems to want to create ole db adapters and connections and commands. How do I make it use sql commands...
9
by: Gabriel | last post by:
Hello, I installed SQL server 2005 SP1 on a Windows XP SP2 From Visual Studio, I'm trygin to create a connection to a database, but I receive this error but I'm creating the connection (I...
0
by: tamayi | last post by:
I have a problem (like most others posting issues on this forum :) ) I have a remote server running Windows XP SP2, with both SQL Server 2005 Express with Advanced Features and SQL 2000...
17
by: Anil Gupte | last post by:
I am using the following to try to connect to the database, but it does not seem to be working. Dim sConnString sConnString = "Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security...
6
by: Dmitry Perets | last post by:
Hello, I am trying to work with MS SQL Server 7 from the release version of Visual Studio 2008 + LINQ to SQL. And the problem is that the LINQ to SQL designer doesn't accept my tables saying...
5
by: Cirene | last post by:
I just deployed my new ASP.NET (3.5 FW) site to the hosting company I'm using, webhost4life. NOTE: I HAVE deployed other SQL Server sites to the same account with no issues. Now I'm getting...
0
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...
0
isladogs
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...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.