<div class="meta" robots="noindex">

</div>

Method

# ODBCDatabase.GetInfo

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

<div class="warning">

<div class="title">

Warning

</div>

This item was deprecated in version 2019r2. Please use `ODBCDatabase.ConnectionInfo<odbcdatabase.connectioninfo>` as a replacement.

</div>

## Description

Returns general information about the driver and data source associated with a connection. Returns a `Variant</api/data_types/variant>` that contains either a `String</api/data_types/string>` or an `Integer</api/data_types/integer>`, based on the attribute.

## Notes

`ODBCConstant</api/databases/odbcconstant>` contains integer values that you can use with this function.

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

### References

[SQLGetInfo ODBC funtion](http://msdn.microsoft.com/en-us/library/windows/desktop/ms711681(v=vs.85).aspx)

## Sample code

Check if the connected ODBC database supports stored procedures:

``` xojo
Dim db As New ODBCDatabase

If Not db.Connect Then
  MsgBox("Error: " + db.ErrorMessage)
End If

MsgBox(db.GetInfo(ODBCConstant.SQL_PROCEDURES))
```

## Compatibility

All project types on all supported operating systems.