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 / Current Version (Old)
 how to use DSN? help		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

round
New Member

Taiwan
67 Posts
Posted - 29 May 2001 :  14:10:13  Show Profile
My hosting provider asks me to use DSN, but I have no idea how to use it.

This is my strConnString :

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Inetpub\queerbbs\db\snitz2000.mdb;" '## MS Access 2000

my DSN name is snitz, where I can add DSN? Thanks again.

round

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 29 May 2001 :  14:13:54  Show Profile
strConnString = "DSN=snitz"
Go to Top of Page

round
New Member

Taiwan
67 Posts
Posted - 29 May 2001 :  14:23:56  Show Profile
Thanks, but I am still confused, does the whole strConnString look like:

strConnString = "DSN=snitz" = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Inetpub\queerbbs\db\snitz2000.mdb;" '## MS Access 2000

Also, any advantage of using DSN? Thanks again.


round
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 29 May 2001 :  15:01:29  Show Profile
No, your connect string will just look like this:

strConnString = "DSN=snitz"


DSN-less connections are supposed to be a little faster.
Go to Top of Page

round
New Member

Taiwan
67 Posts
Posted - 29 May 2001 :  15:20:21  Show Profile
That's too bad
That means my hosting provider forces me to have slower connection.

round
Go to Top of Page

round
New Member

Taiwan
67 Posts
Posted - 29 May 2001 :  22:53:13  Show Profile
After I use strConnString = "DSN=snitz", I got following error message:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
/inc_top.asp, line 51

Thanks again.


round
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 29 May 2001 :  22:58:36  Show Profile
Did you setup the DSN yourself? If not, you'll need to contact your webhost and check with them.
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 1.22 seconds. Powered By: Snitz Forums 2000 Version 3.4.07