Need Help- How to setup a ODBC connection string for Access 97

[john9]

Can someone please show me the correct method to automatically logon to Oracle from Access 97 via the SQL pass-through method. I am trying to eliminate the need for my users to manually logon (via ODBC) to the Oracle database.

This is my code - - -


begin

"ODBC; Driver={MicroSoft Oracle ODBC name}; Server={Oracle server name.world}; Database={Oracle Database name}; Uid={Oracle user ID}; Pwd={Oracle user ID password}";

sp_backup_naic_stage1;

end;

 

[neemi]

Try this function:-

Public Function LinkToODBC(SourceTable As String, DestinationTable As String, UId As String, Pwd As String)

' Link to ODBC Tables

DoCmd.TransferDatabase acLink, "ODBC Database", "ODBC;DSN=SI;UID=" & UId & ";pwd=" & Pwd, acTable, SourceTable, DestinationTable

End Function

Neemi