Post reply

connection string in sql active script

  • December 17, 2007 at 8:12 am

    #69479

    connection string;

    'ADO Connection String to the PUBS database. Most likely you will have to change your password here. See your DBA.

    Const DB_CONNECT_STRING = "Provider=SQLOLEDB.1;Data Source=(local); Initial Catalog=Pubs;user id = 'sa';password=''"

    I just to tried the DTS in this post. I modified the connection string there. It kept give me error. Will you please let me know what is best one to write the connection string.

    http://msdn.microsoft.com/msdnmag/issues/02/08/VBScriptandSQLServer2000/

    I want to loop the records in the table and email other people in html format.

    Thx.

  • December 17, 2007 at 8:30 am

    #760706

    First, using SA and a blank password is asking for trouble. Even for testing, set up a real login and user with rights to the table.

    Second, it's asking for a new password. The 2005 login is probably requiring a password change, which you'd need to use SQLCMD to connect and change.

  • December 17, 2007 at 8:42 am

    #760714

    I did the change with real pass word. it still did not work. I am wondering what is wrong. See it will set up in the sql server. most of my job did not required the info.

  • December 18, 2007 at 8:21 am

    #761049

    Hi there,

    have alook at my post.. All the code is there to do this.

    http://www.sqlservercentral.com/Forums/Topic434295-5-1.aspx

    Regards

    Dave

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply