Binding controls on data access page to a SQL stored procedure

J

Jim Gabel

When I bind a combo box to a stored procedure in a DAP, it works ok on our
intranet, but fails when called over the internet. If I populate the combo
box thru code (in a script), it works in both intra and inter net. I'd like
to use the SQL stored procedure because it seems to run much faster than
code. The error over the internet is: "Data Provider could not be
initialized". Followed by "SQL Server does not exist or access denied".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run a SQL Stored Procedure from VBA 0
Making form based on stored procedure 0
Access can't find stored procedure after scripting on sql server 2
Stored Procedure, Forms and Input Parameters 3
Data return from SQL Stored procedure... 0
How to invoke a sql stored procedure from ACCESS 6
From Access how to create stored procedure in SQL server 4
Stored Procedure vs. View for Access 2

Top