Cor,
In this other program I get also an error at conn.open
No error information available: DB_SEC_E_AUTH_FAILED(0x80040E4D).
at System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr)
at System.Data.OleDb.OleDbConnection.InitializeProvid er()
at System.Data.OleDb.OleDbConnection.Open()
at database_20_jan_2004.Form1.btnDatabase_Click(Objec t sender, EventArgs
e) in C:\Documents and Settings\Eigenaar\Mijn documenten\Visual Studio
Projects\Laptop\database 20 jan 2004\Form1.vb:line 80
Private Sub btnDatabase_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnDatabase.Click
Dim ds As New DataSet()
ds = New DataSet("import")
Dim Connectionstring As String
Connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Password=""; User
ID=Admin;Data Source=C:\backup Compaq MV500\TAGS\Access\2003.mdb;Mode=Share
Deny None;Extended Properties="";Jet OLEDB:System database="";Jet
OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine
Type=5;Jet OLEDB:Database Locking Mode=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:Compact Without Replica Repair=False;Jet OLEDB:SFP=False"
'Connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Password=""; User
ID=Admin;Data Source=C:\TAGS\Access\2003.mdb;Mode=Share Deny None;Extended
Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet
OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database
Locking Mode=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:Compact Without Replica Repair=False;Jet
OLEDB:SFP=False"
Dim connection1 As OleDb.OleDbConnection = New
OleDb.OleDbConnection(Connectionstring)
Dim command1 As OleDb.OleDbCommand = New OleDb.OleDbCommand("Select * from
import")
command1.CommandType = CommandType.Text
Try
connection1.Open()
Catch ex As Exception
txtError.Text = ex.Message & vbCrLf
txtError.Text = txtError.Text & ex.StackTrace
End Try
'command1.Connection = connection1
'Dim OleDbDataAdapter1 As OleDb.OleDbDataAdapter = New
OleDb.OleDbDataAdapter()
'OleDbDataAdapter1.SelectCommand = command1
'OleDbDataAdapter1.TableMappings.Add("Table", "import")
'OleDbDataAdapter1.Fill(ds)
'Dim datagrid1 As New DataGrid()
'datagrid1.SetDataBinding(ds, "import")
End Sub
"Wim" <wi***********@pandora.be> schreef in bericht
news:JU********************@phobos.telenet-ops.be...
Hi Cor,
How can I check if I made a connection with the designer?
ADO.NET and VB.NET It is new to me, so maybe I make basic mistake....
Thanks,
Wim
"Cor" <no*@non.com> schreef in bericht
news:%2***************@tk2msftngp13.phx.gbl... Hi Wim,
What is on line 63 it gives me a little bit the idea that you did make a
connection with the designer and that you try to overule that with a new
connection string. (I tried that once and that did work).
But it seems to me that you get an error on line 63 (because when you
use the designer and a form, that is at the beginning of the code).
Just an Idea.
Cor
Kan het installeerbare ISAM-bestand niet vinden.
Are you sure Domenique understand this?
:-)