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
Moved to SQL 2008 now Jump to Last Post not workin
New Topic
Topic Locked
Printer Friendly
Author
Topic
Lon2
Junior Member
USA
151 Posts
Posted - 08 May 2010 : 12:10:05
We moved our forums to SQL 2008 Server and now the "Jump to Last Post
" is not working correctly for topics that have more than 1 page.
Please forgive me if this has been brought up before. I did not find it when searching Snitz.
Is there a fix?
ruirib
Snitz Forums Admin
Portugal
26364 Posts
Posted - 08 May 2010 : 12:25:38
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=68217&SearchTerms=Jump,last,post,OLEDB
Snitz 3.4 Readme
|
Like the support? Support Snitz too
Lon2
Junior Member
USA
151 Posts
Posted - 08 May 2010 : 13:27:26
Thanks for the quick response! Can you recommend an OLEDB connection string that works with SQL 2008 Server?
This works (but not Last Post): "Driver={SQL Server Native Client 10.0};Server=localhost;Database=xxx;Uid=xxx;Pwd=xxx;"
This doesn't at all: "Provider=SQLOLEDB;Data Source=localhost;Database=xxx;Uid=xxx;Pwd=xxx;"
Edited by - Lon2 on 08 May 2010 13:59:38
Lon2
Junior Member
USA
151 Posts
Posted - 08 May 2010 : 14:49:19
Got it working with the following connection string:
"Provider=SQLNCLI10;Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;"
Source:
SQL Server Native Client 10.0 OLE DB Provider
ruirib
Snitz Forums Admin
Portugal
26364 Posts
Posted - 08 May 2010 : 14:53:11
In my experience with 2008, the last should work, but also something like:
strConnString= "Provider=SQLNCLI10;Server=server;database=dbname;uid=youruserid;pwd=yourpassword;"
P.S.: You posted before I managed to write my own reply, but seems you got it.
Snitz 3.4 Readme
|
Like the support? Support Snitz too
Topic
New Topic
Topic Locked
Printer Friendly
Jump To:
Select Forum
Announcements
Announcements: Security Related Bug Fixes
Announcements: Community
Announcements: New Releases
A Testing Area
Testing Forums
Help Groups for Snitz Forums 2000 Users
Help: General / MVC version(v1.XX)
Help: General / Classic ASP versions(v3.4.XX)
Help: General / Previous versions
Help: Database: MS Access
Help: Database: MS SQL Server
Help: Database: MySql
Help: Mail Configuration
Help: MOD Implementation
Help: Authentication: NT
Help: General / Current Version (Old)
Frequently Asked Questions
FAQ About This Site
HOW DO I FAQs
FAQs for Using Snitz with Access
FAQs for Using Snitz with mySQL
FAQs for Using Snitz with SQLServer
FAQ for Beginners to Snitz Forums
FAQ For Developers
FAQ for Webmasters
FAQ Addition Requests
Snitz Forums 2000 MOD-Group
Mod Integration Project (BUG Reports)
MOD Completed Add-Ons
MOD Add-On Forum (W/Code)
MOD Add-On Forum (W/O Code)
Community Forums
Graphics & Style in Snitz!
Suggest forum.snitz.com Content
Show-Off Your Forums
Code Support: ASP (Non-Forum Related)
Code Support: ASP.NET (Non-Forum Related)
Community Discussions (All other subjects)
Snitz Forums 2000 DOC-Group
DOC Discussion
DOC In-Box
DOC Out-Box
Snitz Forums 2000 DEV-Group
DEV Bug Reports (Open)
DEV Discussions (General)
DEV Discussions (Oracle)
DEV Discussions (VFP)
DEV Bug Reports (Closed)
DEV Internationalization (v4-archive)
DEV Internationalization (v4)
URLs and Other Resources
Snitz Forums 2000 - Classic ASP version
SnitzBitz
Snitz MVC development site
Snitz Downloads/etc...
SourceForge
--------------------
Home
Active Topics
Frequently Asked Questions
Member Information
Search Page
Snitz Forums 2000
© 2000-2021 Snitz™ Communications
This page was generated in 0.15 seconds.
Topic Locked
Posted - 08 May 2010 : 12:10:05
" is not working correctly for topics that have more than 1 page.
