Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM ODBC Driver » View Thread |
Messages 1 to 4 of 4 total |
Visual Studio Data Connections and ODBC Driver |
Thu, Mar 23 2006 9:36 PM | Permanent Link |
Mike F | 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 |
Fri, Mar 24 2006 1:13 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Fri, Mar 24 2006 2:12 PM | Permanent Link |
Mike F | "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 |
Fri, Mar 24 2006 4:36 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |