Re: Using the following connection parameter to call sp from Access

Try changing "Database=" to "Initial Catalog=". Also, using sa is considered
a bad practice, you should create a user just for the database your app is
using and assign minimum privileges required to run the application.

Roman

--
Roman Rehak
http://sqlblog.com/blogs/roman_rehak



"Jack" <Jack@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CF874F68-1818-47C4-8607-4A22B69B513D@xxxxxxxxxxxxxxxx
Hi,
I am using the following connection string from Access vba to call stored
procedure. However, there is error in the connection. When I am checking
the
same connection from the control Panel using dsn, the connection shows
success. I would appreciate if someone can tell me what's wrong with this
string. Thanks

adhcADH2KSQLCnn = "Provider=SQLOLEDB;" & _
"Data Source=ADH2KSQL;Database=ADH2KSQL;User Id=sa;Password=abcd;"


.

Relevant Pages

  • Re: Deployment + Vista
    ... I'm talking about the user being able to edit the server connection setting ... MSI will allow you to edit the app directory, ... function in order to put together the connection string something like: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: [SOLVED] Cannot display provider-specific login prompt
    ... scenario where the program wouldn't have to know about the database, ... ConnectionStringBuilder up to a PropertyGrid for the end user to populate), ... details of the connection, for the sake of the program being able to connect ... information about the connection string that I will need. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Complicated Connection Problems bewteen ADP and SQL Server
    ... front end on the 5-8 workstations where the users happen to sit. ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... thought that I should instead change my connection string to something ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Fujitsu NetCobol 8.0
    ... You cannot use a connection string in the way you have shown and expect it ... Any Fujitsu NetCobol / PowerCobol users here? ... Use the ADO control provided in PowerCOBOL, ...
    (comp.lang.cobol)
  • Re: Changing Connection String programmatically
    ... This is a good situation for putting the connection string information in the app.config file. ... every year we will create new database. ... change the body of the private void InitConnection(), ...
    (microsoft.public.sqlserver.connect)
Loading