how to connect with password via ODBC

[jyeast]

Does anybody know how to connect to a FM database with a password via = ODBC ? I am using ASP to connect via ODBC. When FM database has a password nothing works... when it is without a password I can retreive the data I want. There must be some way I can send the password? Thank you.

Got it!

dim oConn

set oConn = Server.CreateObject("ADODB.connection")

oConn.ConnectionString = "Provider=MSDASQL.1;Password=test;Persist Security Info=True;Data Source=FileMakerODBC"

[ May 16, 2001: Message edited by: jasonyeast ]