MS SQL Help needed...

Jack_Sparrow

Well-known member
  • Jun 16, 2008
    42,522
    1
    16,927
    113
    Black Pearl
    මම වලින් SQL server Express 2008 R2 හදපු database එකකට Visual Studio 2008 C#.NET වලට connect (connection open) කරද්දි, error 40 එක එනවා

    2m6jsdj.png


    database එකේ TCP/IP protocols and remote access ඔක්කොම enable කරලා තියෙන්නේ.... connection string එක user name password ඔක්කොම හරි , net එකේ error 40 වලට කරන්න කියල තියන ඔක්කොම කලා.. ඒත් වැඩ නැහැ...

    මේකට විසඳුමක් කවුරුහරි දන්නවද? :confused::confused:
     

    nazim12191

    Member
    Sep 4, 2009
    54
    1
    0
    You are referencing the wrong DLL file.

    The tutorial you linked to says "MySql.Data.dll"

    That is what you should be setting a reference to.

    It should be in the following folder:

    C:\Program Files (x86)\MySQL\MySQL Connector Net n.n.n\bin\.NET N.N

    where the n.n.n are version numbers of the version installed/.net version you are using.
     

    Jack_Sparrow

    Well-known member
  • Jun 16, 2008
    42,522
    1
    16,927
    113
    Black Pearl
    You are referencing the wrong DLL file.

    The tutorial you linked to says "MySql.Data.dll"

    That is what you should be setting a reference to.

    It should be in the following folder:

    C:\Program Files (x86)\MySQL\MySQL Connector Net n.n.n\bin\.NET N.N

    where the n.n.n are version numbers of the version installed/.net version you are using.

    sorry machan Im connecting Microsoft SQL SERVER... not mysql :baffled: