PDA

Click to See Complete Forum and Search --> : DB Connectivity with SQL Server using OleDb

mahesh_575
Mar 25th, 2004, 05:39 AM
DB Connectivity with SQL Server using OleDb : [IIS and DB are on different machines.]

<%@ Page Language="VB" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
<script runat="server">

Sub Page_Load(sender As Object, e As EventArgs)

Dim conTest As OleDbConnection
Dim cmdTest As OleDbCommand
Dim rdrTest As OleDbDataReader

conTest = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Server=IP Address of DB Server;Database=DB Name;User ID=uname;Password=pwd;Integrated Security=SSPI")
conTest.Open
cmdTest = New OleDbCommand ( "select * from tblAdmin", conTest)
rdrTest = cmdTest.ExecuteReader
gridTest.DataSource = rdrTest
gridTest.DataBind
rdrTest.Close
cmdTest.Dispose
conTest.Close

End Sub

Errors occurred :

[OleDbException (0x80040e21): 複数ステップの OLE DB の操作でエラーが農生しました。各 OLE DB の状態の値を確認して_ださい。作業は終了しませんでした。]
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20
System.Data.OleDb.OleDbConnection.CreateProviderError(Int32 hr) +23
System.Data.OleDb.OleDbConnection.CreateProvider(OleDbConnectionString constr) +107
System.Data.OleDb.OleDbConnection.Open() +203
ASP.test_oledb_sqlserver_aspx.Page_Load(Object sender, EventArgs e) +41
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731

Please kindly suggest some solution.

Regards
Mahesh
nemaroller
Mar 29th, 2004, 05:12 PM
As long as you understand OLEDB is not performance optimized for MS SQL SERVER...

I think your connection string is incorrect:

conTest = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Server=IP Address of DB Server;Database=DB Name;User ID=uname;Password=pwd;Integrated Security=SSPI")
mahesh_575
Mar 30th, 2004, 03:33 AM
Hi

Thanks, db connectivity problem has been solved.

Now trying file handling [csv file] from asp.net.

There is one csv file and I am trying to open that file, read contents and display in dropdownlist web control.

Can u suggest something.

Thanks
Mahesh