Newbies RickDavis Posted May 7, 2002 Newbies Share Posted May 7, 2002 I have created an ODBC connection to a FM Pro 5.5 database file, but when I do this it is asking for a password every time I open the connection or try to run a query. This application needs to be automated so there will be not user sitting in front of the computer to interact with the application. Is there a way that I can pass this password to the database? Link to comment Share on other sites More sharing options...
Newbies Jonas_A Posted June 13, 2002 Newbies Share Posted June 13, 2002 Are you trying it on a local machine or over the network via IP? I have done it locally, and the solution is pretty simple. Using ODBC, define the connectionstring like this: ODBCConnStr1_FM = "Driver={FileMaker Pro};" & _ "Dbq=;" & _ "Uid=;" & _ "Pwd=yourpassword;" Note that my solution does not use a odbc data source, but instead crates one at runtime. However, it is pretty much the same principle of passing the password if you use an odbc data source. /Jonas Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8148 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now