cannot open requested database

[LTusing]

I have an Access form connected to data located on SQL Server. The Access form contains a command button to call a SQLServer sproc. The command button works fine in another form that has the following datatypes: int and smalldatetime. However when adding the connection string in another form that has identical connection parameters but different datatypes including: int, datetime, and char it fails to call the stored procedure because it is unable to open the requested database. Our IT department has assured me that I have all access possible and they further provided a personal SQL sign-on, with failure and passed the connection string requesting adPrompt and failure again including Trusted connection. I am at a loss and at a critical point in finalizing this project. I am open to any recommendations. Thank you!

 

[Crowley16]

can you provide the connection string you're using?

--------------------
Procrastinate Now!

 

[LTusing]

Thank you, I figured it out. Apparently, a trigger command which was being called at a similar time was conflicting with ability to call a similar named procedure. Thanks much!!