Database Discussion - SQL 2005 server asp connection

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??