Database connection authentication

Completado Publicado Jun 25, 2007 Pagado a la entrega
Completado Pagado a la entrega

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 " & _

"CONNECTION_AUTHENTICATION=" & _

"'Company=The Company Name;" & _

"Application=BigApp;" & _

"Signature=000fa55157.......;"

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?

.NET Visual Basic

Nº del proyecto: #154780

Sobre el proyecto

2 propuestas Proyecto remoto Activo Jun 26, 2007

Adjudicado a:

yugolancer

Contact me for the quick tip and explanation. Check PMB

$35 USD en 0 días
(24 comentarios)
6.2

2 freelancers están ofertando un promedio de $33 por este trabajo

jingyen

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

$30 USD en 0 días
(0 comentarios)
0.0