Wrox Home  
Search P2P Archive for: Go

  Return to Index  

aspx thread: RBase Database


Message #1 by "Robert Horn" <robertho@m...> on Mon, 6 May 2002 21:10:21 +1000
Hello,

I am trying to get an RBase database connected up to .NET. It has an ODBC
Driver that works fine in VB 6, but I have not been able to get it to do
anything in .NET. The following is what I get if I try and connect up with
the following ConnectionString:

Provider=MSDASQL.1;Password=***;Persist Security Info=True;User
ID=***;Extended
Properties="DSN=Bizman;DBQ=C:\RBase\RBWIN65\Bizman.RB1;UID=***;PWD=***"

Error:

The .Net Data OLE DB Provider(System.Data.OleDb) does not support the
MSDASQL Provider, Microsoft OLE DB Provider for ODBC Drivers


If I change the providor  SQLOLEDB it comes up with an error of :

Login failed for user '***'. Invalid connection string attribute.

If I have the first selected for the Server Explorer, it allows be to browse
the tables, but I cannot add a Connection or DataAdapter.

Does anyone have any data about this, or had any success in connecting up to
an RBase database?

Regards
Robert




Message #2 by "Samuel Engelman" <samuel_engelman@p...> on Tue, 7 May 2002 09:16:15 -0400
You should use the ODBC.Net data provider


|---------+--------------------------------------->
|         |   "Robert Horn" <robertho@m...> |
|         |                                       |
|         |                                       |
|         |   Monday May 6, 2002 07:10 AM         |
|         |   Please respond to "ASP+"            |
|         |                                       |
|---------+--------------------------------------->
  >---------------------------------------------------------------------------------------------------|
  |                                                                                                   |
  |       To:                                         "ASP+" <aspx@p...>                      |
  |       cc:                                                                                         |
  |       Subject:   [aspx] RBase Database                                                            |
  >---------------------------------------------------------------------------------------------------|




Hello,

I am trying to get an RBase database connected up to .NET. It has an ODBC
Driver that works fine in VB 6, but I have not been able to get it to do
anything in .NET. The following is what I get if I try and connect up with
the following ConnectionString:

Provider=MSDASQL.1;Password=***;Persist Security Info=True;User
ID=***;Extended
Properties="DSN=Bizman;DBQ=C:\RBase\RBWIN65\Bizman.RB1;UID=***;PWD=***"

Error:

The .Net Data OLE DB Provider(System.Data.OleDb) does not support the
MSDASQL Provider, Microsoft OLE DB Provider for ODBC Drivers


If I change the providor  SQLOLEDB it comes up with an error of :

Login failed for user '***'. Invalid connection string attribute.

If I have the first selected for the Server Explorer, it allows be to
browse
the tables, but I cannot add a Connection or DataAdapter.

Does anyone have any data about this, or had any success in connecting up
to
an RBase database?

Regards
Robert









  Return to Index