.NET (Core and Framework)

15-May-09 21:39

Hi Experts,

I am developing an Asp.Net 2.0 website, with MySql 6.0 connector and same Membership provider. Every thing was running until I uploaded my page having use of that connector 6.0

I simply used this

using MySql.Data.MySqlClient;

and made the connection in code

like this

System.Data.OleDb.OleDbConnection conn= new System.Data.OleDb.OleDbConnection();

this code is running absolutely fine on my computer but its not working when I upload the page.

It shows this error:
CS0433: The type 'MySql.Data.MySqlClient.MySqlConnection' exists in both 'c:\windows\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\1e4eaa05\e62de4c8\assembly\dl3\cf265f44\00f987f7_7669c801\MySql.Data.DLL' and 'c:\windows\assembly\GAC_MSIL\MySql.Data\1.0.7.31597__36c71baaebd03a5d\MySql.Data.dll'

When I checked I found a difference in dll version. Server is having Mysql 4.0.

Please tell me how to overcome this issue. I just checked my local computer where I havent found that dll in temporary asp.net files.

Thanks in advance.

Dave Kreskowiak17-May-09 6:15

17-May-09 6:15

Upgrade the server to the same library version as you're using.

Or, downgrade the library on your development machine to match the server's version - if you can still find the old version on the web somewhere.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

JayKhatri27-May-09 19:12

27-May-09 19:12

Hi Dave,

I have switched to MySql Connector 5.1.5.0 and similarly my host has changed db from 4.0 version to 5.0 but problem persists. Now I am completely puzzled what to do.

Please help me out.

Best Regards

Jay Khatri

P.S.: for your ready reference my host is having this version (MySQL - 5.0.21-community-nt)

Dave Kreskowiak28-May-09 2:05

28-May-09 2:05

Your going to have to work with the ISP to figure this one out. I just told you the first thing I would try. I don't use MySQL for anything.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

JayKhatri28-May-09 3:16

28-May-09 3:16

Hi Dave,

My problem have been solved by this:

<remove assembly="MySql.Data" />
<add assembly="*" />

This has removed the dll from GAC and added all again. So I can even use different version of dll by this.

Thanks for your support.

Best Regards

Jay Khatri

JayKhatri17-May-09 21:40

Web setup project fails in Windows vista and IIS7

17-May-09 21:40

thanks for your reply.

I have already requested my host to upgrade the version from 4.0 to 5.0. And I have also shifted from 6.0 and 5.0 MySql. Now waiting for the cp change in my host panel.

Muhammad Sohaib Yousaf15-May-09 2:12

Muhammad Sohaib Yousaf

15-May-09 2:12

I am trying to install a vs2005 web setup project in window vista with iis7 but give me error of "setup has been intrupted"
is there any problem bcoz i got stuck in this problem any help would be appreciated\
thanks sohaib.

Re: Web setup project fails in Windows vista and IIS7

Dave Kreskowiak15-May-09 4:11

Finding IP Address of Device Connected To PC via LAN Cable.

15-May-09 4:11

Do NOT post the same question to multiple forums. You will not get an answer any faster, and it's considered very rude.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

VikashGohil14-May-09 21:43

VikashGohil

14-May-09 21:43

Hello,

I want to develop an application that can display me the IP address of any device, may it be Mobile or another PC or any device that has an IP address, when connected to my PC via LAN Cable.

for eg. if my PC IP is 192.168.1.1 and another device IP is say 65.62.1.10, then how can i get the device IP address after connecting the device with LAN Cable.

I want to Develop using VB.net, so anyone can help me in this case.

Any idea would be of great help.

Thanks in Advance, awaiting for replies.

Re: Finding IP Address of Device Connected To PC via LAN Cable.

Dave Kreskowiak15-May-09 4:12

Re: Finding IP Address of Device Connected To PC via LAN Cable.

15-May-09 4:12

You don't know how TCP/IP works, do you?

If you directly connect a device to your PC's ethernet card using a crossover cable, the device you connect has to have an IP on the same subnet as your PC, otherwise, you won't be able to talk to it at all.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

VikashGohil16-May-09 21:42

VikashGohil

16-May-09 21:42

Hello,

Dave Thanks For the reply.

I Know What you said is correct, but then that is exactly what my query is.

I tell you, we use one device which is COM to LAN Converter.

Now this device has it's own IP Address, which we can set acc. to our network settings.

Now this device manufacturer has a software where in when the device is connected to the PC, it displays the IP address of the device regd. of whether it matches with network or no.

Also we can then change the IP Address from the software.

So how come this software is able to get the IP Address even if it is not as per our network settings.

Could you give some info. on this.

Thanks In Advance.

Re: Finding IP Address of Device Connected To PC via LAN Cable.

Dave Kreskowiak17-May-09 3:27

[RESOLVED] Trying to use smo to create an insert stored proc which returns identity [modified]

17-May-09 3:27

Your going to have to ask the manufacturer how the device is discovered. I'm thinking the device might be broadcasting an advertising packet of some kind that the software listens for.

You can see if this is true by using a network sniffer, like Ethereal[^].

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

bobishkindaguy14-May-09 14:12

Re: Trying to use smo to create an insert stored proc which returns identity

14-May-09 14:12

I'm trying to use smo to create an insert stored proc which returns the identity of the newly created row.

Here's my code, which returns a "create failed" message without other relevant details.

(The mMyDatabase reference in the code is a Microsoft.SqlServer.Management.Smo.Database that has been successfully connected to. I can post the code for that part if you need it.)

Public Sub AddInsertActivityStoredProcedure()
    Dim Name As String = "InsertActivityRow"
    If mMyDatabase.StoredProcedures.Contains(Name) Then
      mMyDatabase.StoredProcedures(Name).Drop()
    End If

    Dim An_SP As New StoredProcedure(mMyDatabase, Name, "dbo")

    'An_SP.TextHeader = "???"
    An_SP.TextMode = False
    An_SP.AnsiNullsStatus = False
    An_SP.QuotedIdentifierStatus = False

    An_SP.Parameters.Add(New StoredProcedureParameter(An_SP, "@UserFK", DataType.Int))
    An_SP.Parameters.Add(New StoredProcedureParameter(An_SP, "@MachineFK", DataType.Int))
    An_SP.Parameters.Add(New StoredProcedureParameter(An_SP, "@ActivityDate", DataType.Int))
    An_SP.Parameters.Add(New StoredProcedureParameter(An_SP, "@Activity", DataType.Int))
    An_SP.Parameters.Add(New StoredProcedureParameter(An_SP, "@TableAffected", DataType.Int))
    An_SP.Parameters.Add(New StoredProcedureParameter(An_SP, "@RowAffected", DataType.Int))
    An_SP.Parameters.Add(New StoredProcedureParameter(An_SP, "@NewPK", DataType.Int))

    An_SP.TextBody = "set nocount on" + NewLine
    An_SP.TextBody = "INSERT INTO [ADV4SQL].[dbo].[ADVActivities]"
    An_SP.TextBody += " ([AcUserFK]"
    An_SP.TextBody += " ,[AcMachineFK]"
    An_SP.TextBody += " ,[AcDate]"
    An_SP.TextBody += " ,[AcActivity]"
    An_SP.TextBody += " ,[AcTableAffected]"
    An_SP.TextBody += " ,[AcRowAffected])"
    An_SP.TextBody += " VALUES"
    An_SP.TextBody += " (@UserFK"
    An_SP.TextBody += " ,@MachineFK,"
    An_SP.TextBody += " ,@ActivityDate, "
    An_SP.TextBody += " ,@Activity, "
    An_SP.TextBody += " ,@TableAffected, "
    An_SP.TextBody += " ,@RowAffected, )" + NewLine
    An_SP.TextBody += "@NewPK= SCOPE_IDENTITY() " + NewLine
    An_SP.Create()

  End Sub

modified on Sunday, May 17, 2009 4:41 PM

Dave Kreskowiak15-May-09 4:15

Re: Trying to use smo to create an insert stored proc which returns identity

15-May-09 4:15

You might want to export to script an existing stored procedure using SQL Server Management Studio first. Take a look at what it output, then you can model your code to create an equivilent string. It doesn't look like adding NewLines at the end of each statement is a valid statement terminator to SQL Server.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

led mike15-May-09 9:21

led mike

15-May-09 9:21

FYI: Your OP replied to himself instead of you.

Re: Trying to use smo to create an insert stored proc which returns identity

bobishkindaguy15-May-09 6:28

Re: Trying to use smo to create an insert stored proc which returns identity

15-May-09 6:28

Thanks, Dave.
The NewLine was just environment.newline in a var.
I took them off and made sure there were spaces at the beginning or end of each chunk, so that the problem wouldn't be a syntax error.

I did create the stored procedure based on code generated for an INSERT on the ADVActivities table, which has 7 fields including the primary key.

I am new to stored procedures and I can't see how to take the auto-scripted code for INSERT and make a stored procedure out of it.

Dave Kreskowiak15-May-09 12:05

Re: Trying to use smo to create an insert stored proc which returns identity [modified]

15-May-09 12:05

Is the scripted SQL marked up with anything?? Like Go statements, semi-colons, whatever...??

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

bobishkindaguy17-May-09 9:39

Re: Trying to use smo to create an insert stored proc which returns identity

17-May-09 9:39

If I take the .TextBody string that this sub creates, and paste it into SQL Server Management Studio in a new Stored Procedure window, and press "Execute", the stored procedure is created perfectly.

If I run this sub, it fails.

(The mMyDatabase var is populated with a properly-connected database/connection.)

I've tried removing the BEGIN/END items, removing the parameters, changing the .TextMode, the .AnsiNullsStatus, the .QuotedIdentifierStatus, in every combination I can think of, and it still fails.

Thanks for any help!

Public Sub CreateInsertActivityStoredProcedure()

  Dim Name As String = "InsertActivityRow"
  If mMyDatabase.StoredProcedures.Contains(Name) Then
    mMyDatabase.StoredProcedures(Name).Drop()
  End If

  Dim An_SP As New StoredProcedure(mMyDatabase, Name, "dbo")

  'An_SP.TextHeader = "???"
  An_SP.TextMode = False
  An_SP.AnsiNullsStatus = False
  An_SP.QuotedIdentifierStatus = False

  'these are the input paramters
  An_SP.Parameters.Add(New StoredProcedureParameter(An_SP, "@UserFK", DataType.Int))
  An_SP.Parameters.Add(New StoredProcedureParameter(An_SP, "@MachineFK", DataType.Int))
  An_SP.Parameters.Add(New StoredProcedureParameter(An_SP, "@ActivityDate", DataType.DateTime))
  An_SP.Parameters.Add(New StoredProcedureParameter(An_SP, "@Activity", DataType.Int))
  An_SP.Parameters.Add(New StoredProcedureParameter(An_SP, "@TableAffected", DataType.Int))
  An_SP.Parameters.Add(New StoredProcedureParameter(An_SP, "@RowAffected", DataType.Int))

  'this is the output parameter
  Dim An_OutputParameter As StoredProcedureParameter = New StoredProcedureParameter(An_SP, "@NewPK", DataType.Int)
  An_OutputParameter.IsOutputParameter = True
  An_SP.Parameters.Add(An_OutputParameter)

  'start the string (the rest use += )
  An_SP.TextBody = ""

  An_SP.TextBody += "CREATE PROCEDURE InsertActivityRow"
  An_SP.TextBody += " @UserFK int,"
  An_SP.TextBody += " @MachineFK int,"
  An_SP.TextBody += " @ActivityDate datetime,"
  An_SP.TextBody += " @Activity int,"
  An_SP.TextBody += " @TableAffected int,"
  An_SP.TextBody += " @RowAffected int,"
  An_SP.TextBody += " @NewPK int OUT"
  An_SP.TextBody += " AS"
  An_SP.TextBody += " BEGIN"
  An_SP.TextBody += " SET NOCOUNT ON"
  An_SP.TextBody += " INSERT INTO ADV4SQL.dbo.ADVActivities"
  An_SP.TextBody += " ("
  An_SP.TextBody += " AcUserFK,"
  An_SP.TextBody += " AcMachineFK,"
  An_SP.TextBody += " AcDate,"
  An_SP.TextBody += " AcActivity,"
  An_SP.TextBody += " AcTableAffected,"
  An_SP.TextBody += " AcRowAffected"
  An_SP.TextBody += " )"
  An_SP.TextBody += " VALUES"
  An_SP.TextBody += " ("
  An_SP.TextBody += " @UserFK,"
  An_SP.TextBody += " @MachineFK,"
  An_SP.TextBody += " @ActivityDate,"
  An_SP.TextBody += " @Activity,"
  An_SP.TextBody += " @TableAffected,"
  An_SP.TextBody += " @RowAffected"
  An_SP.TextBody += " )"
  An_SP.TextBody += " SET @NewPK = SCOPE_IDENTITY() "
  An_SP.TextBody += " END"

  An_SP.Create()

End Sub

modified on Sunday, May 17, 2009 3:48 PM

bobishkindaguy17-May-09 10:57