| SitePoint Sponsor |
|
|
User Tag List
Results 1 to 6 of 6
Thread: MySQL -> MS SQL 2000
-
Oct 25, 2002, 12:02 #1Froot r gewd
- Join Date
- May 2002
- Location
- North Star State
- Posts
- 597
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
MySQL -> MS SQL 2000
I'm using the Data Transformation Services, and all works fine except one thing...
On some tables, it gives an error saying "Incorrect Syntax Near ')'"
Now, there isn't because I've dumped my tables using phpMyAdmin and it hasn't given errors...so why is MS SQL giving errors about it?
On one of my tables there's some 15,000 rows, and mind you I don't want to do that by HAND...
It DOES import most tables, but it doesn't import a couple tables...unfortunately, they have a LOT of rows...
Does anyone know a rememdy, and is it a good idea to switch from mySQL to MS SQL for an ASP site?"Sometimes little is more."
Kamran A
Web Dev/Designer
Keyboard not found: Please Press F1 to Continue
-
Oct 25, 2002, 12:33 #2\m/ R.I.P. Dimebag! \m/
- Join Date
- Dec 2001
- Location
- erie, pa
- Posts
- 1,130
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
/me wonders how a 14 yr old afforded a MS SQL Server license.
-- JIM BOLLA
Wanna play Halo 2? My XBOX Live gamertag: crowdozer
-
Oct 25, 2002, 14:13 #3Froot r gewd
- Join Date
- May 2002
- Location
- North Star State
- Posts
- 597
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Dad
We have a MSDN Universal Subscription
"Sometimes little is more."
Kamran A
Web Dev/Designer
Keyboard not found: Please Press F1 to Continue
-
Oct 25, 2002, 15:58 #4SitePoint Addict
- Join Date
- Jun 2001
- Location
- Newcastle, England
- Posts
- 268
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Tackling the "is it a good idea to switch from mySQL to MS SQL for an ASP site?" question, the answer is... "it depends".
If you're looking for shared hosting, there aren't that many that offer MySQL on Windows (but there are some). Aside from that, if MySQL is good enough for your needs now then there's no reason it won't be good enough with ASP. ASP can certainly interface with MySQL just fine, so it being ASP (rather than PHP or whatever) doesn't have a real bearing on changing.
Given that, I'd only change if I needed something MS SQL offered, or if there was a specific hosting requirement.
As far as your error goes, I'm afriad I don't know. Is there anything else which might give us an idea - does it tell you which row or which column the error appears in? Could it perhaps be happening in some kind of string-type field on a record which contains an apostraphe?
-
Oct 28, 2002, 12:28 #5Froot r gewd
- Join Date
- May 2002
- Location
- North Star State
- Posts
- 597
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
No, and that's what sucks...I have no idea where the error is!
Later today I will look more closely.
I currently use mySQL with ASP and it works fine. The problem is with a new host we found, it only has MS SQL and not mySQL..."Sometimes little is more."
Kamran A
Web Dev/Designer
Keyboard not found: Please Press F1 to Continue
-
Oct 28, 2002, 13:06 #6Froot r gewd
- Join Date
- May 2002
- Location
- North Star State
- Posts
- 597
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
I figured it out
Some 'varchar' field lengths were '-1' and I had to change it to a positive number...
But, now I have a new error I started a new thread 
"Sometimes little is more."
Kamran A
Web Dev/Designer
Keyboard not found: Please Press F1 to Continue
Bookmarks