Test page
Use this page to learn how to enter content.
Press the edit tab at the top of this page to get into the edit mode.
Save the page at the bottom and look at the results.
To be able to edit pages you must have a registered account.
Go to the main page and follow the link there to create an account.
Next a horizontal line :
Another horizontal line:
163
How to use OLEDB to access SQLBase from SQLServer 
Some sites running MS SQLServer may wish they had used SQLBase from the start !
They can however access the data held in a SQLBase database
directly from SQLServer via a 'Linked Server' and a Gupta OLEDB driver called SQLBaseOLEDB.dll ,
found in the SQLBase run-time folder.
The 'bitness' of both SQLServer , SQLBase and the Driver must all be the same i.e. 64 or 32 bit.
If you are runing SQLBase 12 , the minimum version you can use is 12.0.1 for this to work .
Once you have created the SQLServer 'Linked Server' , then granted rights to it , you can
Select , Update,Insert or Delete SQLBase data directly from SQLServer ( e.g. from SS Management Studio ).
The syntax of the 'Select' differs from Inserts , Updates etc.
Download the script to see a woring example running against 'ISLAND' database:
1) Create a Linked Server
2) Create login rights to SQLBase
3) Sample DML using the new Linked Server
| Feature | Sample | Functions(s) |
|---|---|---|
| Set, clear & test bits | SalExtension | SalNumberBitClear
SalNumberBitIsSet SalNumberBitSet |
| XOR | SubClasser.zip | SalNumberBitXor |
| CHAR | 1 | |
| DOUBLE | 8 | |
| DWORD | 4 | |
| FLOAT | 8 | |
| HANDLE | 4 | |
| INT | 4 | |
| LONG | 4 | |
| LPVOID | 4 | |
| UINT | 4 | |
| ULONG | 4 | |
| WORD | 2 |
