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: Database: MS SQL Server
 CONNECTING THROUGH A DSN		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

b4dt
Starting Member

2 Posts
Posted - 27 February 2004 :  14:11:25  Show Profile
Hi all!
I think I need some help here. I want to know how to connect to the forum database (MSSQL) using a DSN (most likely a system DSN).
I was trying to connect to my database from config.asp using the DSN that I created earlier but I get an error message. I believe it must have been due to a configuration problem.
This was what I wrote:

my_Conn.Open "DSN=myDSN;Uid=myUsername;Pwd=myPassword"

And this was the error:

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
I am sure the database exists, and i successfully connected with the connection string that came with the forum software.
I am using the latest version.
Is there a different way to use the DNS to connect to the database?
Please help.

B4dt

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 27 February 2004 :  16:22:31  Show Profile  Send ruirib a Yahoo! Message
I would advise against using a DSN. Using an OLEDB connection is faster and will give less problems.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts
Posted - 27 February 2004 :  17:07:48  Show Profile
The error indicates the problem is in the DSN configuration on the server, not in your asp code that is connecting to the DSN.
======
Doug G
======
Computer history and help at www.dougscode.com
Go to Top of Page

b4dt
Starting Member

2 Posts
Posted - 28 February 2004 :  04:52:10  Show Profile
My ISP requires the use of a DSN. As a matter of fact, once you create a database onthe ISPs database server, a DSN is automatically generated for you.
I think I will have to contact my ISP for more help then, since the error is not in my code.
Thanks, everyone.

B4dt
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.18 seconds. Powered By: Snitz Forums 2000 Version 3.4.07