SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    Froot r gewd SubKamran's Avatar
    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

  2. #2
    \m/ R.I.P. Dimebag! \m/ JimBolla's Avatar
    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

  3. #3
    Froot r gewd SubKamran's Avatar
    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

  4. #4
    SitePoint 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?

  5. #5
    Froot r gewd SubKamran's Avatar
    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

  6. #6
    Froot r gewd SubKamran's Avatar
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •