Connect to remote MYSQL From the local mssql

Connect to remote MYSQL From the local mssqlOn Fri, 21 Dec 2007 03:51:41 -0800 (PST), zhuxingsheng@.gmail.com
wrote:

By creating a Linked Server? Look it up in Books Online.
-Tom.

Quote:

Originally Posted by

>how ?

|||On 21.12.2007 12:51, zhuxingsheng@.gmail.com wrote:

Quote:

Originally Posted by

how ?

You picked the wrong group.

robert|||On Dec 21, 1:51 pm, zhuxingsh...@.gmail.com wrote:

Quote:

Originally Posted by

how ?

Use Linked Servers!|||On 22.12.2007 18:57, Robert Klemme wrote:

Quote:

Originally Posted by

On 21.12.2007 12:51, zhuxingsheng@.gmail.com wrote:

Quote:

Originally Posted by

>how ?

>
You picked the wrong group.

Sorry, I just recognize I made a complete fool out of myself. Please
just ignore my previous posting. Thank you!

Cheers

robert

Connect to MSSQL from UNIX

Hi experts,
I am new in java programming. I am wana to write an application program to access MSSQL2000 from UNIX. But unfortunately, I am faile. (The program can access to MSSQL2000 from microsoft platform.). Anyone can help me to solve this program ? Thank you.
David Hunag
F.Y.I.
OS : HPUX 10.20
JDK : 1.1.8
..cshrc :
...
set mypath = ( . /usr/bin /usr/sbin /usr/local/bin )
set optpath = ( /opt/java/bin /usr/local/perl5/bin )
set hp93kpath = ( /opt/hp93000/soc/prod_env/bin )
set path=( $mypath $optpath $hp93kpath )
setenv classpath /opt/msSQL2000jdbc/lib/.msbase.jar: /opt/msSQL2000jdbc/lib/mssqkserver.jar:/opt/msSQL2000jdbc/lib/msutil.jar
...
?2004 Microsoft Corporation. All rights reserved. Terms of Use | Privacy Statement
Hi,
You need an ODBC driver middleware installed on the
UNIX box itself, so that it can talk to the SQL Server
Have a look into the old post for more more info,
http://groups.google.co.in/groups?q=...+unix&hl=en&lr
=&ie=UTF-8&selm=oopoaEevBHA.2288%40cpmsftngxa09&rnum=10
Thanks
Hari
MCDBA
"David Huang" <huangjuichung@.yahoo.com> wrote in message
news:6274A7C7-7C80-4D15-A46B-C6A8BC683EF5@.microsoft.com...
> Hi experts,
> I am new in java programming. I am wana to write an application program to
access MSSQL2000 from UNIX. But unfortunately, I am faile. (The program can
access to MSSQL2000 from microsoft platform.). Anyone can help me to solve
this program ? Thank you.
> David Hunag
> F.Y.I.
> OS : HPUX 10.20
> JDK : 1.1.8
> .cshrc :
> ...
> set mypath = ( . /usr/bin /usr/sbin /usr/local/bin )
> set optpath = ( /opt/java/bin /usr/local/perl5/bin )
> set hp93kpath = ( /opt/hp93000/soc/prod_env/bin )
> set path=( $mypath $optpath $hp93kpath )
> setenv classpath /opt/msSQL2000jdbc/lib/.msbase.jar:
/opt/msSQL2000jdbc/lib/mssqkserver.jar:/opt/msSQL2000jdbc/lib/msutil.jar
> ...
>
>
>
> 2004 Microsoft Corporation. All rights reserved. Terms of Use | Privacy
Statement
>

connect through php

Shall I connect to MSSQL through odbc_connect from php?
I tried such line in my program:
$aDBLink=@.mssql_connect("ALMA-BEBJ7CJJQH/innetdb","A","");
but $aDBLink returned false. my MS Sql server's name is just ALMA-BEBJ7CJJQH and in my wwwroot folder I put innetdb.mdf file...but it doesn't work. could you help me please?
What's the error you are getting?
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Tonya" <Tonya@.discussions.microsoft.com> wrote in message
news:D2EA0C1E-6D97-47FC-AB6F-B672AFB41440@.microsoft.com...
Shall I connect to MSSQL through odbc_connect from php?
I tried such line in my program:
$aDBLink=@.mssql_connect("ALMA-BEBJ7CJJQH/innetdb","A","");
but $aDBLink returned false. my MS Sql server's name is just ALMA-BEBJ7CJJQH
and in my wwwroot folder I put innetdb.mdf file...but it doesn't work. could
you help me please?

connect through php

Shall I connect to MSSQL through odbc_connect from php?
I tried such line in my program:
$aDBLink=@.mssql_connect("ALMA-BEBJ7CJJQH/innetdb","A","");
but $aDBLink returned false. my MS Sql server's name is just ALMA-BEBJ7CJJQH
and in my wwwroot folder I put innetdb.mdf file...but it doesn't work. coul
d you help me please?What's the error you are getting?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Tonya" <Tonya@.discussions.microsoft.com> wrote in message
news:D2EA0C1E-6D97-47FC-AB6F-B672AFB41440@.microsoft.com...
Shall I connect to MSSQL through odbc_connect from php?
I tried such line in my program:
$aDBLink=@.mssql_connect("ALMA-BEBJ7CJJQH/innetdb","A","");
but $aDBLink returned false. my MS Sql server's name is just ALMA-BEBJ7CJJQH
and in my wwwroot folder I put innetdb.mdf file...but it doesn't work. could
you help me please?

Connect from FreeBSD

What is the best way/best driver to use to connect to MSSQL Server from
FreeBSD 4.x/5.x without using FreeTDS ?
I'm having odd/unknown problems with FreeTDS and am looking for an
alternative
Thanks
If you're using Java there are several JDBC drivers available. DataDirect
and JNetDirect both offer them. I think DataDirect also offers an ODBC
driver that runs under linux that can connect to SQL Server.
Michael Otey
"Johnny" <Johnny@.Knoxville.com> wrote in message
news:Ow4Udv6tEHA.4040@.tk2msftngp13.phx.gbl...
> What is the best way/best driver to use to connect to MSSQL Server from
> FreeBSD 4.x/5.x without using FreeTDS ?
> I'm having odd/unknown problems with FreeTDS and am looking for an
> alternative
> Thanks
>
|||I'm connecting from C
...forgot to mention that
"Michael Otey" <mikeo@.teca.com> wrote in message
news:eJ1Y#oGuEHA.3788@.TK2MSFTNGP09.phx.gbl...
> If you're using Java there are several JDBC drivers available. DataDirect
> and JNetDirect both offer them. I think DataDirect also offers an ODBC
> driver that runs under linux that can connect to SQL Server.
> Michael Otey
> "Johnny" <Johnny@.Knoxville.com> wrote in message
> news:Ow4Udv6tEHA.4040@.tk2msftngp13.phx.gbl...
>
|||Then you'll probably need to look at the DataDirect ODBC driver.
Michael Otey
"Johnny" <Johnny@.Knoxville.com> wrote in message
news:ejPzuiquEHA.4008@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> I'm connecting from C
> ...forgot to mention that
>
>
> "Michael Otey" <mikeo@.teca.com> wrote in message
> news:eJ1Y#oGuEHA.3788@.TK2MSFTNGP09.phx.gbl...
DataDirect[vbcol=seagreen]
from
>
|||Johnny
There are two alternatives from http://www.openlinksw.com. One
provides a Client/Server and the other a Client only installation. You
haven't stated what problems you're having with FreeTDS but we might
be able to help here as we've done extensive work with our SQLServer
drivers.
For more information, please visit uda.openlinksw.com and follow the
links for Software Availability. If you're using C, you might also be
interested in the iODBC project at www.iodbc.org.
Regards
Emmon Simbo
Technical Services
"Michael Otey" <mikeo@.teca.com> wrote in message news:<utz0$4uuEHA.200@.TK2MSFTNGP11.phx.gbl>...[vbcol=seagreen]
> Then you'll probably need to look at the DataDirect ODBC driver.
> Michael Otey
> "Johnny" <Johnny@.Knoxville.com> wrote in message
> news:ejPzuiquEHA.4008@.TK2MSFTNGP10.phx.gbl...
> DataDirect
> from
|||iODBC looks interesting but in the languages link, it doesn't list C ;(
am I wrong ?
www.iodbc.org
"Emmon Simbo" <esimbo@.openlinksw.co.uk> wrote in message
news:2c804093.0410260434.45fab0c@.posting.google.co m...
> Johnny
> There are two alternatives from http://www.openlinksw.com. One
> provides a Client/Server and the other a Client only installation. You
> haven't stated what problems you're having with FreeTDS but we might
> be able to help here as we've done extensive work with our SQLServer
> drivers.
> For more information, please visit uda.openlinksw.com and follow the
> links for Software Availability. If you're using C, you might also be
> interested in the iODBC project at www.iodbc.org.
> Regards
> Emmon Simbo
> Technical Services
> "Michael Otey" <mikeo@.teca.com> wrote in message
news:<utz0$4uuEHA.200@.TK2MSFTNGP11.phx.gbl>...[vbcol=seagreen]
ODBC[vbcol=seagreen]

Connect from FreeBSD

What is the best way/best driver to use to connect to MSSQL Server from
FreeBSD 4.x/5.x without using FreeTDS ?
I'm having odd/unknown problems with FreeTDS and am looking for an
alternative
ThanksIf you're using Java there are several JDBC drivers available. DataDirect
and JNetDirect both offer them. I think DataDirect also offers an ODBC
driver that runs under linux that can connect to SQL Server.
Michael Otey
"Johnny" <Johnny@.Knoxville.com> wrote in message
news:Ow4Udv6tEHA.4040@.tk2msftngp13.phx.gbl...
> What is the best way/best driver to use to connect to MSSQL Server from
> FreeBSD 4.x/5.x without using FreeTDS ?
> I'm having odd/unknown problems with FreeTDS and am looking for an
> alternative
> Thanks
>|||I'm connecting from C
...forgot to mention that
"Michael Otey" <mikeo@.teca.com> wrote in message
news:eJ1Y#oGuEHA.3788@.TK2MSFTNGP09.phx.gbl...
> If you're using Java there are several JDBC drivers available. DataDirect
> and JNetDirect both offer them. I think DataDirect also offers an ODBC
> driver that runs under linux that can connect to SQL Server.
> Michael Otey
> "Johnny" <Johnny@.Knoxville.com> wrote in message
> news:Ow4Udv6tEHA.4040@.tk2msftngp13.phx.gbl...
>|||Then you'll probably need to look at the DataDirect ODBC driver.
Michael Otey
"Johnny" <Johnny@.Knoxville.com> wrote in message
news:ejPzuiquEHA.4008@.TK2MSFTNGP10.phx.gbl...
> I'm connecting from C
> ...forgot to mention that
>
>
> "Michael Otey" <mikeo@.teca.com> wrote in message
> news:eJ1Y#oGuEHA.3788@.TK2MSFTNGP09.phx.gbl...
DataDirect[vbcol=seagreen]
from[vbcol=seagreen]
>|||Johnny
There are two alternatives from http://www.openlinksw.com. One
provides a Client/Server and the other a Client only installation. You
haven't stated what problems you're having with FreeTDS but we might
be able to help here as we've done extensive work with our SQLServer
drivers.
For more information, please visit uda.openlinksw.com and follow the
links for Software Availability. If you're using C, you might also be
interested in the iODBC project at www.iodbc.org.
Regards
Emmon Simbo
Technical Services
"Michael Otey" <mikeo@.teca.com> wrote in message news:<utz0$4uuEHA.200@.TK2MSFTNGP11.phx.gbl>
..[vbcol=seagreen]
> Then you'll probably need to look at the DataDirect ODBC driver.
> Michael Otey
> "Johnny" <Johnny@.Knoxville.com> wrote in message
> news:ejPzuiquEHA.4008@.TK2MSFTNGP10.phx.gbl...
> DataDirect
> from|||iODBC looks interesting but in the languages link, it doesn't list C ;(
am I wrong ?
www.iodbc.org
"Emmon Simbo" <esimbo@.openlinksw.co.uk> wrote in message
news:2c804093.0410260434.45fab0c@.posting.google.com...
> Johnny
> There are two alternatives from http://www.openlinksw.com. One
> provides a Client/Server and the other a Client only installation. You
> haven't stated what problems you're having with FreeTDS but we might
> be able to help here as we've done extensive work with our SQLServer
> drivers.
> For more information, please visit uda.openlinksw.com and follow the
> links for Software Availability. If you're using C, you might also be
> interested in the iODBC project at www.iodbc.org.
> Regards
> Emmon Simbo
> Technical Services
> "Michael Otey" <mikeo@.teca.com> wrote in message
news:<utz0$4uuEHA.200@.TK2MSFTNGP11.phx.gbl>...[vbcol=seagreen]
ODBC[vbcol=seagreen]

connect by DSN

Hi,

how can i connect MSSQL through System DSN. i know how to create DSN. but i don't know how to code the connection string.

regards,

SeeConnectionStrings.com.

Ryan

Confused about MSSQL Express installations

I have this confusion because as I am trying to install "SQL Server Management Studio Express", the installers said I already have it.

Q1. Do I need it if I already have SQL Server Management Studio for Server 2005?

Q2.

How many ways to have SQL Express installed on your PC?

- Seperate downloads

- Visual Studio 2005 Retail

- SQL Server 2005

In that regards, will all methods are basically install the same set of components into the machine?

Q3. I don't find any relevant item in the "Add or Remove Programs" regarding to SQL Express.

Is that because SQLExpress is just an database instance not a application item?

Q4. Where are the files of Express in the file system?

I saw in c:\Program files\Microsoft SQL Server, a few directories like

80, 90, MSSQL.1, MSSQL.2, MSSQL.3, MSSQL.3, MSSQL.4

Which one of those belongs to SQL Express and which belongs to SQL Server 2005?

Is the directory structure identical with other types of installation (standalone and VS IDE)?

Thanks

Stanley

If you have the full version of SQL Management studio the installer will not allow you to install the express version as it is already installed.

Each of the numbered directories refers to an instance of sql server 2005 installed on the system. The engine tool and shared files are stored inside the version directories ie 80 or 90... where 80 is sql server 2000 and 90 is sql server 2005.

|||I too have had problems re the above. I uninstalled what I had, and then reinstalled my first download of SQLexpress. I configured (re help), added in online books, searched for answers re an interface and found something on dnncreative forum re the management download. This time I was able to install it.

Sorry for not being too specific, but it all became a blurr. Perhaps you could try without configuring, if that doesnt work, youll find what you need to know online amongst the configuring ...

conflict Problem Help

Hello Everybody
I am having merge Replication using MSSQL 2000 sp3 latest security patch,
My replication is server1 Publisher, server2 subscriber, server3
subscriber,
Server4 subscriber, server5 subscriber. I am using schedule around 1:00
AM every day, In Server2 we insert 5 rows some value, and 5 rows sending to
Server3 using DTS with Insert statement, and server3 we update the 5Rows,
and sending to Server4 or server2, this all process everything done before
synchronize. I am using default conflict revolver, becoz some table dont
have date time field. When I run the merge agent, I got some conflict in
conflict tables. Automatically delete some row in subscriber.
How to resolve those problems. I need urgent help.
The same row was updated at 'THSWPSW002.GCP' and deleted at
'BKKNTS370.GCPTEST'.
The resolver chose the deletion as the winner.
3:3 conflict_type : reason_code
The same column(s) of the same row was updated at both 'SERVER1.APPTEST' and
' SERVER2.APPTEST '.
The resolver chose the update from ' SERVER1.APPTEST ' as the winner.
2:2
The row was inserted at ' SERVER5.APPTEST ' but could not be inserted at '
SERVER1.APPTEST '. Violation of PRIMARY KEY constraint
'PK__T_M_SUPPLIER__3607E224'. Cannot insert duplicate key in object
'T_M_SUPPLIER'.
5:2627
The row was inserted at 'SERVER1.APPTEST' but could not be inserted at
'SERVER2.APPTEST'. Violation of PRIMARY KEY constraint
'PK__T_M_SUPPLIER__38CF4036'. Cannot insert duplicate key in object
'T_M_SUPPLIER'.
6:2627
The same row was updated at both 'SERVER1.APPTEST' and 'SERVER5.APPTEST'.
The resolver chose the update from 'BKKNTS370.GCPTEST' as the winner.
1:1
Thanks
Sam
Sam,
please take a look at this article and see if it applies:
http://support.microsoft.com/default...&Product=sql2k
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thanks,
Still i have problem some conflict.
i change mergearticle error 'flase'
could you tell me how to handule ?
Sam
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:ui2754ILGHA.2276@.TK2MSFTNGP15.phx.gbl...
> Sam,
> please take a look at this article and see if it applies:
> http://support.microsoft.com/default...&Product=sql2k
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>