hi,

i have a question, and please help me, i have a friend who is currently using VS 2003 in their office, when he is making his connection string, he is using it like this "DIM = conn as oledb........ and soon"

 but when i try to do that in our office where we are using VS2005, i can't find or the intellisense did not popup any "OLEDB" or anything in it.

is there no "OLEBD" in the VS2005 or if there is, who can i put it there or if there is none, what is the alternative for it??

thanks for the help of anyone.
 

HI

May i know for which database you want it to connect......... 

 sql server 2000 enterprise

my development software is VS2005

thanks for the reply., 

Hi

You can use the OLEDB in Visual studio 2005 below is the sample example

Ex: 

 Dim constring As String = "......." 'your connection string in double quotes
 Dim con1 As OleDb.OleDbConnection = New OleDb.OleDbConnection(constring)
 Dim command As OleDb.OleDbCommand = New OleDb.OleDbCommand("", con1)
 con1.Open()
 command.ExecuteReader()

Feel free to ask  

But when i try to type this

Avinash Desai:

Dim con1 As OleDb.OleDbConnection

the intelisense does not popup 

Hi

Use following Import statement

<%@ Page Language="VB" AutoEventWireup="False"
EnableSessionState="False" EnableViewState="False" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.Odbc" %>

OR

Without importing those you can use following code

 
        Dim constring As String = "......." 'your connection string in double quotes
        Dim con1 As Data.OleDb.OleDbConnection = New Data.OleDb.OleDbConnection(constring)
        Dim command As Data.OleDb.OleDbCommand = New Data.OleDb.OleDbCommand("", con1)
        con1.Open()
        command.ExecuteReader()
 
 
  

 Hi.,

Thanks for your answer, it really help me to know more about VS2005,

thanks again.,

SALAMAT PO.,