halifaxdal (2/7/2012)

---

You are right, I opened Configuration Manager, and checked protocol for TCP/IP there, it says it is configured as using dynamic port and the port option is empty, so...

since this is a named instance and not the default instance, I'm sure it is using dynamic ports, which will NOT be 1433.

to make it easier, i'd recommend changing...

the existing data has trailing spaces; converting the column to varchar does not auto-trim the existing data.

now if you run our original update statement, you should see the difference.

fawadafr (2/7/2012)

---

@Fahey:

Thanks for the feedback. I tried executing the following SQL statement but was unable to change the field type.

ALTER TABLE [dbo].[document_control] MODIFY COLUMN [doc_path] [varchar](256) NULL

Could you please help...

well the matching RTRIM function will remove trailing spaces...so i think you want something like this:

UPDATE [dbo].[document_control]

SET [doc_path] = LTRIM(RTRIM([doc_path]))

2008 R2...is that 64 bit?

if it is, you have to use 64 bit MYSQL drivers in order to create a linked server.

that would be one more thing to double check....if...

it's gotta start with the basics, i think:

since its an express instance, is the checkbox for allow remote connections checked? maybe via the Configuration?

next, and probably the most...

Joy Smith San (2/7/2012)

---

Hi All,

I connected to one of the server and and detached one database.

After that I was not able to do anything is SQL Server as the detached...

Jared may be right...start with the basics...

here's the proc from a thread on the subject; it's idea for setting up your mysql linked server:

http://www.sqlservercentral.com/Forums

--http://www.sqlservercentral.com/Forums/Topic340912-146-1.aspx

CREATE PROC uspCreateLinkToMySQLDB @linkedservername varchar(50), @mysqlip varchar(50),...

can you create a view on top of the staging table tat would type the data into the same matching types as the production data?

then you could binary checksum the...

Sean Lange (2/6/2012)

---

Databases don't have IP addresses. The IP address belongs to the server. Like said before you would need to have named instances running to have the same db...

Damian-167372 (2/6/2012)

---

yes I am working with the management team to do this ...

thanks a lot for your information ..

I also hard coded the script with app name something like...

awfully easy to change if you know what to look for:

:

because you are using string compare (the LIKE)

whitespace is important...if you look at your data, there is a preceeding space before every number...so your join criteria is limited to matching...

naw, it's pretty easy to review all the procs, even when they are encrypted...it's really just "obfuscation", so it just requires a couple of extra steps to see the code...