Hi!
I am having problems setting up a new Data Connection in Visual Studio Server Explorer using DBISAM ODBC Trial Version 3.30.1.1 and
DBISAM Dabatase 3.21. I setup the ODBC driver without any problems. In VS, I click Add Connection. I select "Microsoft OLE DB Provider for
ODBC Drivers" as the Provider and click Next. Then it doesn't matter if I pick "Use Data Source Name" (I setup a datasource also) or if I
select "Use Connection String". Either way gives a "Test Connection Succeeded". Then, when I click on OK, it gives me "Unable to connect to
database. Catastropic failure".

Anybody have an idea of what is going on?

Thanks!
Mike

Mike,

<< I am having problems setting up a new Data Connection in Visual Studio
Server Explorer using DBISAM ODBC Trial Version 3.30.1.1 and DBISAM Dabatase
3.21. I setup the ODBC driver without any problems. In VS, I click Add
Connection. I select "Microsoft OLE DB Provider for ODBC Drivers" as the
Provider and click Next. Then it doesn't matter if I pick "Use Data Source
Name" (I setup a datasource also) or if I select "Use Connection String".
Either way gives a "Test Connection Succeeded". Then, when I click on OK, it
gives me "Unable to connect to database. Catastropic failure". >>

You don't want to use ADO.NET with the ODBC driver - use the ODBC.NET data
provider instead.  It provides the best and most seamless access method.  If
you need further help with this, just let me know what version of VS you're
using and I'll help you get it set up.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Mike,

<< I am having problems setting up a new Data Connection in Visual Studio
Server Explorer using DBISAM ODBC Trial Version 3.30.1.1 and DBISAM Dabatase
3.21. I setup the ODBC driver without any problems. In VS, I click Add
Connection. I select "Microsoft OLE DB Provider for ODBC Drivers" as the
Provider and click Next. Then it doesn't matter if I pick "Use Data Source
Name" (I setup a datasource also) or if I select "Use Connection String".
Either way gives a "Test Connection Succeeded". Then, when I click on OK, it
gives me "Unable to connect to database. Catastropic failure". >>

You don't want to use ADO.NET with the ODBC driver - use the ODBC.NET data
provider instead.  It provides the best and most seamless access method.  If
you need further help with this, just let me know what version of VS you're
using and I'll help you get it set up.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim:

I am using VS 2003 version 7.1.3088 (1.1 framework). If you have instructions on this, please forward.

Thanks!
Mike

Mike,

<< I am using VS 2003 version 7.1.3088 (1.1 framework). If you have
instructions on this, please forward. >>

Okay, follow these steps:

1) Drop an ODBCConnection component on your form.
2) In the properties toolbox, click on the down arrow to the right of the
ConnectionString property.
3) Select the New Connection option in the list.
4) Select the ODBC data source name that you wish to use from the dialog
that appears and click on the OK button.

That will add the appropriate connection component.  You can then use the
ODBCCommand and ODBCDataAdapter components to query/display data using the
ODBCConnection component that you just created.  Just make sure that the
Connection property of the ODBCCommand component(s) that you use for the
Select, Insert, Update, Delete statements are pointing to the ODBCConnection
that you just created.

--
Tim Young
Elevate Software
www.elevatesoft.com