OLEDB Connection
OLEDB Connection
OLEDB Connection
OLEDB Connection
OLEDB Connection
OLEDB Connection OLEDB Connection OLEDB Connection OLEDB Connection OLEDB Connection OLEDB Connection OLEDB Connection OLEDB Connection
OLEDB Connection OLEDB Connection
OLEDB Connection
Go Back  Xtreme Visual Basic Talk > > > OLEDB Connection


Reply
 
Thread Tools Display Modes
  #1  
Old 12-18-2003, 08:53 AM
gterry gterry is offline
Newcomer
 
Join Date: Dec 2003
Posts: 1
Question OLEDB Connection


Hello,
when i am trying to connect to microsoft access 2000 database the following message appears: "Test connection failed because of an error in initializing provider. Catastrophic failure". I tried to reinstall Visual Studio .NET but the problem remains. Could you help me please? Thank you in advance.
Reply With Quote
  #2  
Old 12-18-2003, 09:23 AM
Csharp's Avatar
CsharpOLEDB Connection Csharp is offline
Senior Contributor

* Expert *
 
Join Date: Jul 2003
Location: Ashby, Leicestershire.
Posts: 967
Default

here's a quick working example i knocked up last week for someone...
Code:
Try Dim ConString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Environment.GetFolderPath(Environment.SpecialFolder.Personal) & "\db1.MDB" Dim objConnection As New Data.OleDb.OleDbConnection(ConString) Dim objCommand As New Data.OleDb.OleDbCommand("SELECT * FROM Table1", objConnection) Dim objAdapter As New Data.OleDb.OleDbDataAdapter(objCommand) Dim objTable As New Data.DataTable("Table1") objAdapter.Fill(objTable) DataGrid1.DataSource = objTable objConnection.Close() Catch ex As Exception MessageBox.Show(ex.Message) End Try
__________________
~~ please don't PM me regarding code, I only reply to personnal messages ~~
Reply With Quote
  #3  
Old 12-18-2003, 10:09 AM
Optikal's Avatar
OptikalOLEDB Connection Optikal is offline
Codeaholic

Retired Leader
* Guru *
 
Join Date: Oct 2002
Location: Winnipeg, MB, Canada
Posts: 4,543
Default

Sounds like your trying to use a Data Provider that isn't installed on your machine.
__________________
There are 10 types of people in this world, those that understand binary, and those that don't.
Reply With Quote
  #4  
Old 12-18-2003, 10:21 PM
king_salman king_salman is offline
Newcomer
 
Join Date: Nov 2003
Location: PAKISTAN
Posts: 7
Default Try this

in server explorer select connections add new connection in provider select microsoft jet 4.0 oledb provider click next then selet database you want by browsing,then enter user name and password specify your read write lock type and then test connection it will suceed.click the properties of connection in serve explorer.selct the information from there and then append or replace as required in your case in follwing
vb:
"Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data
Source=" & Path & _
" ;Mode=Share Deny None;Exte" & _
"nded Properties="""";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet O" & _
"LEDB:Database Password="""";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mod" & _
"e=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet" & _
" OLEDB:New Database Password="""";Jet OLEDB:Create System Database=False;Jet OLEDB" & _
":Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:C" & _
"ompact Without Replica Repair=False;Jet OLEDB:SFP=False"
.have a nice time
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
multi connections, one port? burningodzilla Communications 5 08-02-2005 05:04 PM
How to clean up after global ADO Connection???? ChubbyArse Database and Reporting 0 03-10-2003 06:56 AM
Checking for Internet Connection rajbly Communications 1 09-02-2002 07:19 AM
OLEDB connection to Oracle 7.1.4 zubie Database and Reporting 2 02-27-2002 02:20 AM
WinSock vbsupernewbie Communications 1 09-12-2001 10:20 PM

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
OLEDB Connection
OLEDB Connection
OLEDB Connection OLEDB Connection
OLEDB Connection
OLEDB Connection
OLEDB Connection OLEDB Connection OLEDB Connection OLEDB Connection OLEDB Connection OLEDB Connection OLEDB Connection
OLEDB Connection
OLEDB Connection
 
OLEDB Connection
OLEDB Connection
 
-->