Connecting to non SQL database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When i try to connect to an old UniVerse database (using their ODBC drivers)
visual studio (vc# standard) gives me an error saying something to the effect
that this version can only connect to Access/SQL databases. What version of
visual c# or visual studio do I need to connect to any ODBC complient
database?
 
When i try to connect to an old UniVerse database (using their ODBC
drivers)
visual studio (vc# standard) gives me an error saying something to the
effect
that this version can only connect to Access/SQL databases. What version
of
visual c# or visual studio do I need to connect to any ODBC complient
database?
Click to expand...

Nothing to do with Visual Studio per se. I would suggest that you ditch ODBC
and use OleDb instead. The following link should assist:

http://www.able-consulting.com/MDAC...viders.htm#OLEDBProviderForUniDataAndUniVerse
 
¤ When i try to connect to an old UniVerse database (using their ODBC drivers)
¤ visual studio (vc# standard) gives me an error saying something to the effect
¤ that this version can only connect to Access/SQL databases. What version of
¤ visual c# or visual studio do I need to connect to any ODBC complient
¤ database?

The Server Explorer in the Standard version is somewhat limited, however you can still use code to
create your connections. If you have an ODBC driver you should be able to use the
Microsoft.Data.ODBC namespace. There is an example below:

Public Sub ConnectToOracleODBC()

Dim ODBCConnection As New Microsoft.Data.Odbc.OdbcConnection


ODBCConnection.ConnectionString = "DRIVER={Microsoft ODBC for Oracle};" & _
"SERVER=ServerName;" & _
"UID=userID;PWD=password;"

ODBCConnection.Open()

'...
'...
'...

ODBCConnection.Close()

End Sub


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Back
Top