Rich,

The following works fine in my system.

SELECT

* FROM OPENQUERY(MYSQLTEST,'SELECT * FROM...

Jim,

I have just tried to make a connection to SQL Server 2005 from a VB 6.0 adodc and a data environment and they work.  I used the SQL Server Native Client...

Hi Rich,

I recently installed a link to a MySql DBMS running on Windows XP professional and it works just fine.  I used the odbc 3.51.12 driver from the MySql Web site.

regards

Shaun

Have you considered the varchar(MAX) datatype.  This is certainly capable of storing more than 8000 characters

regards

Shaun

Hi Daniela,

If you download Sql Server Management Studio Express edition, you can set up logins etc.  Hopefully you will have selected mixed mode authentication when you installed Sql Server express.

Just to clarify, it is SSIS that supports the TRIM() function

http://msdn2.microsoft.com/en-us/library/ms139947.aspx

It wouldn't have worked in this case though because it only recognises spaces.

My apologies

Shaun

Forgive me if I have misunderstood but ltrim trims leading spaces.  If you wish to trim trailing spaces, you should use rtrim or indeed trim which will truncate leading and trailing...

Vida,

Another option might be an application, Activex control, FoxPro project or vbscript  (depending upon the tools available to you).  DTS could invoke methods of an object that extracts data from SQL Server...

Hi Vida,

Be careful because linked servers often provide read only access when used in conjunction with SQL Server.

For example:

msdn.microsoft.com/library/en-us/dv_foxhelp/html/dggrfoledbproviderforvisualfoxpro.asp

This page states that the foxpro OLEDB...

Hi Mark,

The connection string will be very much the same.  Something to look out for though is that SQL Server Express is SQL Server 2005 based rather than SQL Server 2000...

Hi Mark,

A couple of questions first

What version of SQL Server are you using?

Are you using Visual Studio.Net or another IDE?

Is it a Web application or a desktop app?

In General though!

You will...

Hi Gavin,

This may be the second post because something strange happened to my last one.

My company provides access to documents via the web and we use a number of approaches.  The following...

David,

If you ar using the Visual Studio IDE, all you have to do to recompile your project following a change is to run it.  The environment will take care of...

Hi David,

I'm glad that everything is now working:

You are not wrong about the number of ways to manipulate data within the .Net framework.

Please do make the effort to differentiate between...

David,

I assume that you are using untyped DataSets.  This being the case I would think that a Select Statement would be needed to generate the appropriate structure.

There is another type...