SQLBase ODBC Connectoin Error

[BernicusMaximus]

Gurus,

I'm getting an error trying to connect to SQLBase 9.0 database via an ASP page. The error I am getting is (Invalid attribute/option identifier). Here is my connection string DSN=SQLBase;DB=LFEEDER;SRVR=Server1;UID=SOMEUSER;PWD=SOMEPASSWORD. I'm not doing anything fancy in the code, just trying to open the connection. In the ODBC Administrator, if I click "test connection", I get a success. Any help would be greatly appreciated.

Thanks,

Bernie

 

[LandryC]

You should be able to define the database name in your ODBC datasource so that you can just put DSN=DSNNAME;UID=SOMEUSER;PWD=SOMEPASSWORD.

 

[BernicusMaximus]

LandryC,

Thanks for the response. Unfortunately, I have tried that and a myriad other connection string settings to no avail. This is happening after an upgrade from SQLBase 8.x to 9.1. Any other ideas?

Thanks,

Bernie

 

[natiki13]

interested in a position of Centrua developer in FLA? nataliez@teaminfo.com

 

[dranath]

When you updated the database I presume that you updated the driver pack. I think our server guy put on driverpack9012win_13770.zip and then we could connect without problems.

I used the following connectionstring but am connecting using .net:

DataSource=SERVER;DRIVER={Gupta SQLBase};DATABASE=DATABASENAME;UserId=username;Password=password;

Hope this helps.