Sybase and VB.Net

[ptmcs]

Hi Folks,

The whole world of linking Sybase to VB.Net seems a complete mess.

Does anybody know of a good website / guide for setting up a link from VB.Net to Sybase ?

 

[mansii]

setting up a link from VB.Net to Sybase

Did you mean "setting up a connection to a Sybase database in VBNet" ?

 

[ptmcs]

Yes, setting up a link from VB.Net to Sybase,

I'd love a simple example program if possible!

 

[mansii]

Well, I do it this way:

Imports System.Data.Odbc

Public DataConn As OdbcConnection

Function FConnect() as Boolean
   DataConn = New OdbcConnection
   DataConn.ConnectionString = "DSN=MyDSN;UID=dba;PWD=sql;DatabaseName=MyDB;EngineName=MyServer;AutoStop=No;Integrated=No;"
   Try
      DataConn.Open()
      Return True
   Catch
      'Do err handling
   End Try   
End Sub

Alse, please check the VBNet Forum in how to secure the UID and PWD parameters. Another usefull site is

http://www.connectionstrings.com

Hope this helps.
mansii