Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

VB & ODBC


This topic is 8148 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

  • 1 month later...
  • Newbies

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.