Saving Username/password For A Filemaker Data Source

Legacy Poster

• August 20, 2014 02:57

I've added a FileMaker ODBC data source, and in the Database Connection Setup dialog I've checked "Save User Name and Password to BarTender Document". However, every time I print or do anything in the Database Connection Setup dialog, I'm prompted for a user name and password.

 

I've tried modifying the registry to hold the username and password to no avail; it keeps prompting.

 

I've tried using a File DSN unsuccessfully; without providing UID and PWD parameters it "works" but is still prompting me for the username and password. However, when I do provide the UID and PWD params, it tells me the password is incorrect (and I'm certain that it is correct).

 

There's no way I can deploy this to a production environment with it constantly prompting for usernames and passwords with every label being printed...

 

Any ideas?

 

 

0

• 

  Shotaro Ito

  ★ BarTender Hero ★

  • August 22, 2014 05:37

  Any ideas?

  Hmm.. try to keep the user name in System DSN / User DSN, then test using simple vb script etc

  http://forums.codeguru.com/showthread.php?331453-Using-ODBC-in-VBA-(Excel)

   

  (or MS Access) to check the setting is kept or not.

  If that cannot be kept, that makes the ODBC driver is not correctly setup or faulty.

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • August 25, 2014 19:55

  Hmm.. try to keep the user name in System DSN / User DSN, then test using simple vb script etc

  http://forums.codeguru.com/showthread.php?331453-Using-ODBC-in-VBA-(Excel)

   

  (or MS Access) to check the setting is kept or not.

  If that cannot be kept, that makes the ODBC driver is not correctly setup or faulty.

   

  I don't believe there is anything wrong with the ODBC setup or the driver itself; at least with all of the FileMaker drivers I've used, there hasn't been a spot within the driver setup to specify a username and password (expect for testing the connection) for either a System or User DSN. Every application I've used has stored the username/password in the app itself.

   

  That's why I was exploring the File DSN since I figured I'd be able to specify the username/password there, but alas, as mentioned, it does not appear to work.

  0
• 

  Shotaro Ito

  ★ BarTender Hero ★

  • August 26, 2014 10:10

  I don't believe there is anything wrong with the ODBC setup or the driver itself; at least with all of the FileMaker drivers I've used, there hasn't been a spot within the driver setup to specify a username and password (expect for testing the connection) for either a System or User DSN. Every application I've used has stored the username/password in the app itself.

   

  That's why I was exploring the File DSN since I figured I'd be able to specify the username/password there, but alas, as mentioned, it does not appear to work.

  Hi, Try this method - use OLEDB for general ODBC provider.

  http://forums.seagullscientific.com/index.php?/topic/1471-filemaker-advanced-server-v12-odbc-constantly-asking-for-username-pw/

  0
• 

  gülsün öner

  ★ BarTender Hero ★

  • November 01, 2019 15:31

  I dowloaded  BT-2019 144231 and enter username as mail account with password which is setted in my account but ı am gettin message as wrong username and password

  help please

  fad@thefad.co

  0

Please sign in to leave a comment.