Oracle and Connectionstring

Results 1 to 2 of 2

Thread: Oracle and Connectionstring

  1. #1
    Join Date
    Dec 1969

    Default Oracle and Connectionstring

    I am trying to connect to an Oracle database from an IIS web server. This is my connection string:<BR>strConnect= "DBQ=crrmsprd;DSN=ccccc;UID=yyyyy;PASSWORD=zzzzz;" <BR><BR>Is there anything wrong? It is not working. I check the connection state which gives me a value of 0.<BR><BR>Please help?

  2. #2
    Join Date
    Dec 1969

    Default RE: Oracle and Connectionstring

    You&#039re far better off not using your dsn. Try something like this...<BR><BR>cn.connectionstring = "Provider=MSDAORA.1;Password=" & pass_word & ";User ID=" & user_name & ";Data Source=" & server_name & ";Persist Security Info=True"<BR><BR>If you paste that in and substitute your variable names where needed, it should work.<BR><BR>Good Luck!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts