Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 500 error using supplied SQL connect string		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

putimeswebmaster
New Member

67 Posts
Posted - 13 May 2002 :  21:41:28  Show Profile  Visit putimeswebmaster's Homepage
If I use:

strConnString = "Provider=SQLOLEDB;Data Source=snitz;Initial Catalog=popuptimes;User ID=popuptimes;Password=crankit77;"

I get an http 500 error. If I use:

strConnString = "driver={SQL Server};server=64.224.17.168;uid=popuptimes;pwd=crankit77;database=popuptimes" '## MS SQL Server 2000

It works just fine. Sound familiar?

Pop Up Times Webmaster
http://www.popuptimes.com

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 13 May 2002 :  21:45:04  Show Profile  Send ruirib a Yahoo! Message
Why don't you use the IP for the Data Source in the first string also?

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Go to Top of Page

putimeswebmaster
New Member

67 Posts
Posted - 13 May 2002 :  22:25:52  Show Profile  Visit putimeswebmaster's Homepage
I thought it was looking for a dsn.
Works fine with the IP.

Thanks !!

Pop Up Times Webmaster
http://www.popuptimes.com

Edited by - putimeswebmaster on 13 May 2002 22:27:28
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 13 May 2002 :  22:34:08  Show Profile  Send ruirib a Yahoo! Message
quote:

I thought it was looking for a dsn.

A DSN is used in a stand alone manner in the connection string (well almost) since the server and database are specified when you setup the DSN.
quote:

Works fine with the IP.

This one will be faster than any other driver, so this is the one to use.
quote:

Thanks !!

You are welcome .

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.26 seconds. Powered By: Snitz Forums 2000 Version 3.4.07