Connecting to MSSQL

Post your questions and problem reports here

Moderator: kfury77

Forum rules
Please try to follow these guidelines. This will help to receive faster and more accurate response.
  • Check the Support section of the corresponding product first. Chances are you will find your answer there;
  • Do not create new topics for already reported problems. Add your comments to the existing topics instead;
  • Create separate topic for each problem request. Do NOT post a number of non-related problem reports in a single topic;
  • Give your topic a meaningful title. Titles such as "A question," "Bug report" and "Help!" provide others no clue what your message is about;
  • Include the version number of the software you are using;
  • This is not an official customer support helpdesk. If you need a prompt and official response, please contact our support team directly instead. It may take a while until you receive a reply in the forum;
Post Reply
User avatar
syrupcore
Top Contributor
Posts: 917
Joined: Thu Jul 21, 2005 12:58 am
Location: Portland, Oregon, usa
Contact:
Contact syrupcore

Connecting to MSSQL

Post by syrupcore »

Is it possible to connect to an MSSQL database using the SQL explorer? I couldn't connect using the same information I use to connect in MS Visual Studio. I tried just using "MySQL" as the option in webbuilder.

Thanks,
Will
Top
User avatar
chrisjlocke
Top Contributor
Posts: 995
Joined: Mon Aug 01, 2005 4:12 pm
Location: Essex, UK
Contact:
Contact chrisjlocke

Post by chrisjlocke »

What error do you get? There is already a (sort of) topic about it here:
http://forums.blumentals.net/viewtopic.php?t=1203
Top
User avatar
syrupcore
Top Contributor
Posts: 917
Joined: Thu Jul 21, 2005 12:58 am
Location: Portland, Oregon, usa
Contact:
Contact syrupcore

Post by syrupcore »

Hi Chris,

Thanks. I saw that thread but it felt like a hijack to add my question.. : )

the error is: "SQL Error: Can't connect to MySQL server on 'mydatabase.connection.com' (10061)"

where mydatabase.connection is my actual connection url.

I assumed that meant it tried to connect and realized it wasn't and actual MySQL database (MSSQL instead) and died.

Thanks for any help.

Will
Top
User avatar
chrisjlocke
Top Contributor
Posts: 995
Joined: Mon Aug 01, 2005 4:12 pm
Location: Essex, UK
Contact:
Contact chrisjlocke

Post by chrisjlocke »

I assume it would need a MSSQL driver. Unsure where you could get one, or whether its WeBuilder friendly...

Initially mis-read your problem to be related to an MySQL database, not MSSQL.
Top
User avatar
syrupcore
Top Contributor
Posts: 917
Joined: Thu Jul 21, 2005 12:58 am
Location: Portland, Oregon, usa
Contact:
Contact syrupcore

Post by syrupcore »

Thanks Chris.

I figure it's a driver issue as well but I also have no idea where to find the driver for it. Searching ms.com is worse than eating liver.

Will
Top
User avatar
Karlis
Site Admin
Posts: 3605
Joined: Mon Jul 15, 2002 5:24 pm
Location: Riga, Latvia, Europe
Contact:
Contact Karlis

Post by Karlis »

MSSQL latest versions no more provide drivers and are only accessible via ODBC, not directly, thus MSSQL is not currently supported.
Karlis Blumentals
Blumentals Software
www.blumentals.net
Top
User avatar
syrupcore
Top Contributor
Posts: 917
Joined: Thu Jul 21, 2005 12:58 am
Location: Portland, Oregon, usa
Contact:
Contact syrupcore

Post by syrupcore »

odbc. bah. I hate microsoft.

thanks karlis.

Will
Top
Post Reply

Return to “HTMLPad / Rapid CSS / Rapid PHP / WeBuilder Support”