Database connection authentication

Database: Sybase Adaptive Server Anwhere - Version 9.0

Distributed database is an OEM version. OEM version requires that any connection made to the database must also send an authentication command so that data base be updated in the database.

Creating a connection manually works just fine:

' -------------------------

str_auth = "SET TEMPORARY OPTION " & _


"'Company=The Company Name;" & _

"Application=BigApp;" & _


Dim connection2 As New OleDbConnection("DSN=sa_Scan")

[url removed, login to view]()

cmOle = New OleDbCommand(str_auth, connection2)

[url removed, login to view]()

' ----------------------------------

My application is using table adapters and it is not obvious how to send the command to the connection. I know that when the first 'Fill' occurs, the connection is made to the database.

' ---------------------------------------

[url removed, login to view] _

(CSRDataSet.table_srp_accountinfo, CurCust)

' -----------------------------------------

If I try to send the authentication string down the table adapter connection, as a separate command, the program tell me the connection for that table adapter is closed.

' -----------------------------------------

cmOle = New OleDbCommand(str_auth, [url removed, login to view])

[url removed, login to view]()

' -----------------------------------------

How can I send a command down the connection established by the program via the tableadapter?

Habilidades: .NET, Visual Basic

Veja mais: dsn sa_scan, signature database, set temporary option connection_authentication, database connection authentication, sybase, oem, it base company, dsn, adaptive, sybase net, can database, program basic string, temporary, data base basic, distributed server, database connection, visual sybase, visual basic connection string, sybase database, send via net, open table, data adapter, program connection, database application using, visual basic connection

Acerca do Empregador:
( 5 comentários ) Helena, United States

ID do Projeto: #154780

Concedido a:


Contact me for the quick tip and explanation. Check PMB

$35 USD em 0 dias
(24 Comentários)

2 freelancers estão ofertando em média $33 para esse trabalho


I can walk you through your problem quickly. There is an easy solution.

$30 USD in 0 dias
(0 Comentários)