Web Wiz Support and Community Forums : WebWiz + mySQL ODBC 2.5 or MSSQL2000 https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 07:32:06 +0000 Mon, 23 Jul 2007 13:15:00 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=22879 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[WebWiz + mySQL ODBC 2.5 or MSSQL2000 : hi n7Epsilon, Ihave same problem...]]> https://forums.webwiz.net/webwiz-mysql-odbc-2-5-or-mssql2000_topic22879_post125226.html#125226 Author: dvixco
Subject: 22879
Posted: 23 July 2007 at 1:15pm

hi n7Epsilon,
I have same problem with you. did you solve the problem or any body who can help me?
when posting new data to MySQL database the error occures:
 

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Invalid string or buffer length

I read the article on http://bugs.mysql.com/bug.php?id=13776 but still problem is persisting.
 
]]> Mon, 23 Jul 2007 13:15:00 +0000 https://forums.webwiz.net/webwiz-mysql-odbc-2-5-or-mssql2000_topic22879_post125226.html#125226 <![CDATA[WebWiz + mySQL ODBC 2.5 or MSSQL2000 : Ok we got mySQL working (host...]]> https://forums.webwiz.net/webwiz-mysql-odbc-2-5-or-mssql2000_topic22879_post121210.html#121210 Author: n7Epsilon
Subject: 22879
Posted: 12 March 2007 at 6:58pm

Ok we got mySQL working (host upgraded to latest mySQL connector), but facing trouble when posting new replies getting:
[Microsoft][ODBC Driver Manager] Invalid string or buffer length

Can anyone offer any suggestion ? I tried the workaround in the last comment in this mySQL bug:
http://bugs.mysql.com/bug.php?id=13776

But error still persists, any help or suggestion appreciated.
]]> Mon, 12 Mar 2007 18:58:36 +0000 https://forums.webwiz.net/webwiz-mysql-odbc-2-5-or-mssql2000_topic22879_post121210.html#121210 <![CDATA[WebWiz + mySQL ODBC 2.5 or MSSQL2000 : Hello,We are currently trying...]]> https://forums.webwiz.net/webwiz-mysql-odbc-2-5-or-mssql2000_topic22879_post121190.html#121190 Author: n7Epsilon
Subject: 22879
Posted: 11 March 2007 at 8:12pm

Hello,
We are currently trying to switch our WebWiz forum installation over to SQL due to slowdowns and server load caused by the Access database growing too much.

We have both MSSQL 2000 and mySQL at our disposal.

In migrating to either of them, we are facing many troubles:
1. mySQL
- After hours spent transferring database and using tools like bigdump to transfer the database, we finally got the data in. But discovered that our host does not support the myODBC 3.51 driver, only 2.5.

Is it safe to change the connection string to use 2.5, what are the implications of this ? and if there are, Can we do anything to workaround them by changing forum code ?

2. MSSQL
- We have spent many days trying to transfer Access database to MSSQL with failures.
- We do not have direct control of MSSQL (no Enterprise Manager) as this is a shared host, so we are stuck with Access Upsizing wizard as far as I know.
- Using that seems to succeed but it consistently fails with tblThread (refuses to transfer) and access doesn't say the error. Using packet sniffer I discovered it is trying to delete a procedure and server is replying with procedure doesn't exist...
- I tried with a 3rd party tool to administer and import the records of tblThread manually. It seems to succeed but with one problem.

The column Topic_ID is not correctly imported, instead it is simply incremented for each inserted record and this completely corrupts the database structure.

Trying to fix it gives me "Cannot modify field Topic_ID" from the server. This happens when I imported with structures only and no relations and with relationships too. Any fix for this ?

- Can someone tell us the optimum settings for upsize wizard to insure correct import ? A post here indicates so but following same steps gives us failure in tblThread upsize.

Waiting patiently for response,
Thank you for co-operation.


Edited by n7Epsilon - 11 March 2007 at 9:01pm]]> Sun, 11 Mar 2007 20:12:19 +0000 https://forums.webwiz.net/webwiz-mysql-odbc-2-5-or-mssql2000_topic22879_post121190.html#121190