Print Page | Close Window

SQL 2005 server asp connection

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=22985
Printed Date: 29 March 2026 at 10:53am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: SQL 2005 server asp connection
Posted By: fototrefpunt
Subject: SQL 2005 server asp connection
Date Posted: 27 March 2007 at 2:46pm
Hi everybody,
 
I think I need to re-configure the database_connection.asp
 
My provider is telling me this:

SQLOLEDB and SQL Native Client are both connection protocols, you don't use one to connect to the other.

* SQLOLEDB is part of the MDAC protocols, you can use it to connect to SQL Server 2005, but it doesn't support some of the new 2005 objects.

* SQL Native Client (SNAC) is the new 2005 connection protocol. It support using ODBC, OLEDB and Shared Memory connections and supports all the new 2005 "stuff".

How can I configure the Database connection with the correct string? Does anybody have an example for me? I am kind of stuck....
 
Regards.



Replies:
Posted By: fototrefpunt
Date Posted: 27 March 2007 at 5:57pm
Update:
 
I have changed this line:
strCon = "Provider=SQLOLEDB;Connection Timeout=90;" & strCon
To:
strCon = "Driver={SQL Native Client};Connection Timeout=90;" & strCon
 
And I can access the forum.
 
But when I try to login I get the folowing error:
Server Error in Forum Application
An error has occured while writing to the database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_loginUser()_update_USR_Code
File Name:- functions_login.asp

Error details:-
Microsoft OLE DB Provider for ODBC Drivers
Query cannot be updated because the FROM clause is not a single simple table name.
Can somebody tell me whats wrong?
 
Best regards Gerry


Posted By: WebWiz-Bruce
Date Posted: 27 March 2007 at 6:56pm
If this is for Web Wiz Forums it has been designed and built to run with SQLOLEDB driver and will not run with the SQL Native Client driver.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: fototrefpunt
Date Posted: 27 March 2007 at 7:15pm
Is there no way around this? Can you tell me the difference between SQLOLEDB and the native client??



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net