Just wondering is your oracle listener service is up and running ?

start---->Run --CMD

>lsnrctl and enter

Is that giving some message saying that listener is listening following services etc

please...

Hi

Thanks for getting back to me

I created created linked server by using MSDASQL provider and running that statement from TSQL

with current restrictioons i cant' change...

Thanks for the information .But My issue is when i run my sql statement it is working fine but inserting blank data in longtext column field on MYSQL

SQL Table...

Helo paul

In your query try with to_number(NumCol)

example

exec('select to_number(empno),ename from emp') at oralinksrv

Regards

Reddy

Hi

In oracle there is file called TNSNAMES.ORA in client software

when you trying to connect to oracle server from clinet usually u do

>connect username/pwd@sidname

that sid will...

I fixed it

@server = N'MySqLLinkedserver',

@srvproduct=N'mysqldb', @provider=N'MSDASQL',

@provstr=N'Driver={MySQL ODBC 3.51 Driver};

Server=myserver.com;UID=myuser;PWD=mypassword;Database=mydatabase;Option=3;'

By changing option=8

Regards

Reddy

I fixed it

@server = N'MySqLLinkedserver',

@srvproduct=N'mysqldb', @provider=N'MSDASQL',

@provstr=N'Driver={MySQL ODBC 3.51 Driver};

Server=myserver.com;UID=myuser;PWD=mypassword;Database=mydatabase;Option=3;'

By changing option=8

Regards

Reddy

@server = N'MySqLLinkedserver',

@srvproduct=N'mysqldb', @provider=N'MSDASQL',

@provstr=N'Driver={MySQL ODBC 3.51 Driver};

Server=myserver.com;UID=myuser;PWD=mypassword;Database=mydatabase;Option=3;'

The problem has been solved -- by changing the option =8 which is required for reading big results

Option=3 is not sufficient