SQLBase database connection problem.

Question

_{Thursday, February 22, 2007 12:12 PM}

Hello All,

Has anyone been able to connect to an SQLBase database on the local server as I have been getting connection problems like:

 System.Data.Odbc.OdbcException: ERROR [08001] [Gupta][ODBC Driver][SQLBase]00401 DBA COD Cannot open database

 My connection string is:

<add name="ODBCDataConnectionString" connectionString="DRIVER={Gupta SQLBase};DSN=WEBTEST;SERVER=127.0.0.1;UID=TESTUID;PWD=TESTID;" providerName="System.Data.Odbc" />

Can anyone post an example of how they connect to their SQLBase server so that I can work out what I'm doing wrong?

Thanks! 

All replies (5)

_{Monday, February 26, 2007 4:16 AM ✅Answered}

I've been trying to connect to the database with .NET but it looks like a database problem.  The vendor of the system was using 8.5 version of SQLBase and support for .NET 2.0 and this problem is only fixed in versions after 9.0.

This is listed as being fixed in a driver update on this page:

http://www.guptaworldwide.com/Downloads/dpfixes13770.htm

87256 .NET Framework 2.0 using ODBC driver with a simple SELECT raises exception: "SUCCESS_WITH_INFO - unable to allocate an environment handle."

 I am trying to get the vendor to install the updated version which looks like it should solve the problem!

_{Thursday, February 22, 2007 2:29 PM}

Hi there,

              perhaps these two links can be helpful

http://www.connectionstrings.com/?carrier=sqlbase

http://guptaworldwide.com/onlinedocs/sb/books/connecting/index.htm

Regards,

Fernando

_{Friday, February 23, 2007 4:46 AM}

Hi Fernando,

 I have used those resources and I still get connection problems.... another one of which is:

 Exception Details: System.InvalidOperationException: SUCCESS_WITH_INFO - unable to allocate an environment handle.

Does anyone have any idea what I am doing wrong?

Thanks.

_{Tuesday, February 27, 2007 8:04 AM}

At least you have a clue, I'd like to give you more help but I've never used that database engine.

Regards,

Fernando.

_{Tuesday, July 10, 2007 3:48 PM}

Might I recommend using OLEDB to connect?  I have connected SQLBase and .Net in both SQLBase 8.5 and 9.0

Provider=SQLBASEOLEDB.1;Data Source=[Database];User ID=[UserID]