Re: Stored Procedure from Access

"scott" <sbailey@xxxxxxxxxxxxxxx> wrote in message
news:%23$xf26pYGHA.3704@xxxxxxxxxxxxxxxxxxxx
My problem is that i'm linking to the sql tables.

I don't follow you. When you use a pass-through query or execute a
stored procedure via an ADO connection to the server, it doesn't involve
linked tables at all. You have to specify a suitable connect string for
the query, of course, and for the ADO method you have to provide a
Connection object, which will have to be opened with a suitable connect
string.

can your code be
modified so a server and login credentials be supplied?

I'm not sure what you have in mind. I usually use Windows
Authentication for the SQL Server connection, but if you're not going to
do that, I believe you can pass the credentials as part of the connect
string. Are you talking about having your code prompt the user for the
connect string and credentials, and then building the connect string on
the fly?

can i use the same asp code i use within access to run a sproc?

I don't know what you mean. If you're talking about VBScript code from
an ASP application, then the ADO elements will be the same, though you'd
have to change calls to Server.CreateObject to just CreateObject (for
late binding).

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


.

Relevant Pages

  • Re: Complicated Connection Problems bewteen ADP and SQL Server
    ... I did try to add "tcp:" onto the front of the server name. ... On the network library question, ... I added in the command "Network Library=DBMSSOCN" into my connection string. ... my inital test ADO connection worked just fine. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Cross Transactions between ADO & ADO.Net
    ... connection--it thrashes the server unnecessarily and discards useful server ... goes away and quietly reopen the connection when they return. ... > DTC transactions are not only heavy, they might also cause deadlocks due ... We even call ADO ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OLE DB connection string in SharePoint for Sybase ASA
    ... > odbc in that SharePoint connection string setting? ... Each DBMS has its own proprietary set of Connection String ... Kevin Spencer ... >>> Server Error: An error occurred while retrieving the list of Databases ...
    (microsoft.public.frontpage.client)
  • Re: ADO controls
    ... >> You need at least three pieces of information to create the connection ... >> string - the name of the SQL Server, the name of the instance, and the ... >> assume that SQL Server is on the current machine. ...
    (microsoft.public.vb.database.ado)
  • Re: Disabling ASP.net 2.0 Membership
    ... provider and the default connection string. ... There are two primary reasons for creating a custom membership provider. ... I also don't want to undertake a migration from my Commerce Server ... An error has occurred while establishing a connection to the server. ...
    (microsoft.public.dotnet.framework.aspnet)