VB & ODBC

[RickDavis]

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?

[Jonas_A]

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