EDN Admin
Well-known member
hi Please, much appreciate your help with this issue. I have a connection on visual Net to a Access database that is linked to an oracle 10G.
1. I have the following connection created from visual Net that it is working fine
Dim cadena As String
Dim dt As Data.DataTable
Dim da As OleDb.OleDbDataAdapter
Dim indicador As Integer
Dim conexion As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & basedatos(MDB)
The Access database has all the tables linked to an Oracle 10 g database. . The problem is that this data is with user name an password that prompt many-times during the execution of the program in visual that require to populate I am trying to add to the connection in visual the user name and password but was very hard for me.
I tried with the following sentence after DataSource and not luck also:
;User Id=PM IDxx;Password=xxxx;
;User Id=PM IDxx;Password=pass;Persist Security Info=False;
I revised The connection on the existing linked tables in access and is like this:
ODBC;DRIVER={Oracle in OraClnt_10g};SERVER=APP_PMPRO;DBQ=APP_PM_PRO;DBA=W;APA=T;EXC=F;XSM=Default;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T....RST=T;BTD=F;BAM=Ifallsucce;NUM=NLS;DPM=F;MTS=TMDI FWS=F;FBS=600.. TLO=O; TAble=PM_xxx
Please much appreciate your help on how to add the user name and password to my connection in visual net?
Thanks very much for all your help, I am not a visual NET expert but I love to create my own small programs!!
View the full article
1. I have the following connection created from visual Net that it is working fine
Dim cadena As String
Dim dt As Data.DataTable
Dim da As OleDb.OleDbDataAdapter
Dim indicador As Integer
Dim conexion As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & basedatos(MDB)
The Access database has all the tables linked to an Oracle 10 g database. . The problem is that this data is with user name an password that prompt many-times during the execution of the program in visual that require to populate I am trying to add to the connection in visual the user name and password but was very hard for me.
I tried with the following sentence after DataSource and not luck also:
;User Id=PM IDxx;Password=xxxx;
;User Id=PM IDxx;Password=pass;Persist Security Info=False;
I revised The connection on the existing linked tables in access and is like this:
ODBC;DRIVER={Oracle in OraClnt_10g};SERVER=APP_PMPRO;DBQ=APP_PM_PRO;DBA=W;APA=T;EXC=F;XSM=Default;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T....RST=T;BTD=F;BAM=Ifallsucce;NUM=NLS;DPM=F;MTS=TMDI FWS=F;FBS=600.. TLO=O; TAble=PM_xxx
Please much appreciate your help on how to add the user name and password to my connection in visual net?
Thanks very much for all your help, I am not a visual NET expert but I love to create my own small programs!!
View the full article