|
 |
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
|
|
 |