DSN question

[Former Community Member]

I didn't get an answer to my post the other day, so I'm trying again. Can I create a DSN on a server and have a form connect to it to access content from a SQL database? I've got a form that works perfectly on my machine with the correct data populating the form from the database, but anyone else gets an ODBC error saying that the data source name can not be found.



If I can't, what are my alternatives?

[Former Community Member]

Michelle,



Did you create an identical DSN on the malfunctioning machine? You would need the DSN on all machines that will be using the form to allow them to access the data.



Thanks

Pam