3 Replies - 1666 Views - Last Post: 06 May 2007 - 10:08 AM Rate Topic: -----

#1 Dilerious  Icon User is offline

  • D.I.C Regular
  • member icon

Reputation: 2
  • View blog
  • Posts: 280
  • Joined: 30-December 05

SQL connection

Posted 05 May 2007 - 11:06 AM

I am using VWD [Visual web developer 2005 express edition] and when testing it uses Microsoft SQL server to view it locally. But my web server uses mySQL, so I made a sql connection and made my own connection string, but it didn't work. Anyone know how I can connect to my .MDF database using a connection string or something else?
Is This A Good Question/Topic? 0
  • +

Replies To: SQL connection

#2 Jayman  Icon User is offline

  • Student of Life
  • member icon

Reputation: 418
  • View blog
  • Posts: 9,532
  • Joined: 26-December 05

Re: SQL connection

Posted 05 May 2007 - 01:01 PM

You can find samples of all the connections string for any database here.
Was This Post Helpful? 0
  • +
  • -

#3 Dilerious  Icon User is offline

  • D.I.C Regular
  • member icon

Reputation: 2
  • View blog
  • Posts: 280
  • Joined: 30-December 05

Re: SQL connection

Posted 06 May 2007 - 03:18 AM

Okay thank you.
I've found the right connection string and have changed it to suit my server and database.
But where do I put the connection string?
Was This Post Helpful? 0
  • +
  • -

#4 JellyBean  Icon User is offline

  • D.I.C Head

Reputation: 6
  • View blog
  • Posts: 60
  • Joined: 25-April 07

Re: SQL connection

Posted 06 May 2007 - 10:08 AM

View PostDilerious, on 6 May, 2007 - 03:18 AM, said:

But where do I put the connection string?

You can put it in the web.config file.

This article describes reading from the <connectionStrings>, and has an example <connectionStrings> section.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1