Hi experts,
I am doing an application which takes the DSN name from user in text
box and then open the ODBC data source dialog box. i.e. I want the
(ODBC data source administrator) form which comes after clicking on
ODBC data source icon in administrative tools.
Now my problem is that is it possible to call that system form
(utility) through my program or I have to design the same form (ODBC
data source administrator).
If I can call that form then please tell me how....i can do that?
Any help will be appreciated.
Thanks
DineshYou would be better off posting this in a C# newsgroup. This is for
Reporting Services.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dinesh" <dinesht15@.gmail.com> wrote in message
news:1166091132.509799.4510@.f1g2000cwa.googlegroups.com...
> Hi experts,
> I am doing an application which takes the DSN name from user in text
> box and then open the ODBC data source dialog box. i.e. I want the
> (ODBC data source administrator) form which comes after clicking on
> ODBC data source icon in administrative tools.
> Now my problem is that is it possible to call that system form
> (utility) through my program or I have to design the same form (ODBC
> data source administrator).
> If I can call that form then please tell me how....i can do that?
> Any help will be appreciated.
> Thanks
> Dinesh
>
Showing posts with label box. Show all posts
Showing posts with label box. Show all posts
Monday, March 26, 2012
Friday, March 23, 2012
How to connect SQL Server to an Oracle database
I need to connect to an Oracle database (8i) running in a UNIX box, with SQL
Server running in AD.
If anyone has done it, kindly let me know since this is new territory for me.
Thanks,
Neil
Install the Oracle client on the SQL Server box.
Configure the client side (SQL Server box) tnsnames, Oracle
alias as needed for your Oracle environment.
Configure a linked server, following the books online topic:
OLE DB Provider for Oracle
as well as the following article:
HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in
SQL Server
http://support.microsoft.com/?id=280106
-Sue
On Fri, 13 Jan 2006 09:31:39 -0800, N.Ordiers
<NOrdiers@.discussions.microsoft.com> wrote:
>I need to connect to an Oracle database (8i) running in a UNIX box, with SQL
>Server running in AD.
>If anyone has done it, kindly let me know since this is new territory for me.
>Thanks,
>Neil
Server running in AD.
If anyone has done it, kindly let me know since this is new territory for me.
Thanks,
Neil
Install the Oracle client on the SQL Server box.
Configure the client side (SQL Server box) tnsnames, Oracle
alias as needed for your Oracle environment.
Configure a linked server, following the books online topic:
OLE DB Provider for Oracle
as well as the following article:
HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in
SQL Server
http://support.microsoft.com/?id=280106
-Sue
On Fri, 13 Jan 2006 09:31:39 -0800, N.Ordiers
<NOrdiers@.discussions.microsoft.com> wrote:
>I need to connect to an Oracle database (8i) running in a UNIX box, with SQL
>Server running in AD.
>If anyone has done it, kindly let me know since this is new territory for me.
>Thanks,
>Neil
How to connect SQL Server to an Oracle database
I need to connect to an Oracle database (8i) running in a UNIX box, with SQL
Server running in AD.
If anyone has done it, kindly let me know since this is new territory for me
.
Thanks,
NeilInstall the Oracle client on the SQL Server box.
Configure the client side (SQL Server box) tnsnames, Oracle
alias as needed for your Oracle environment.
Configure a linked server, following the books online topic:
OLE DB Provider for Oracle
as well as the following article:
HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in
SQL Server
http://support.microsoft.com/?id=280106
-Sue
On Fri, 13 Jan 2006 09:31:39 -0800, N.Ordiers
<NOrdiers@.discussions.microsoft.com> wrote:
>I need to connect to an Oracle database (8i) running in a UNIX box, with SQ
L
>Server running in AD.
>If anyone has done it, kindly let me know since this is new territory for m
e.
>Thanks,
>Neil
Server running in AD.
If anyone has done it, kindly let me know since this is new territory for me
.
Thanks,
NeilInstall the Oracle client on the SQL Server box.
Configure the client side (SQL Server box) tnsnames, Oracle
alias as needed for your Oracle environment.
Configure a linked server, following the books online topic:
OLE DB Provider for Oracle
as well as the following article:
HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in
SQL Server
http://support.microsoft.com/?id=280106
-Sue
On Fri, 13 Jan 2006 09:31:39 -0800, N.Ordiers
<NOrdiers@.discussions.microsoft.com> wrote:
>I need to connect to an Oracle database (8i) running in a UNIX box, with SQ
L
>Server running in AD.
>If anyone has done it, kindly let me know since this is new territory for m
e.
>Thanks,
>Neil
Monday, March 12, 2012
How to conenct Ms-Sql server from Unix box.
Hi,
How do conenct Ms-Sql server from Unix/Sun box. currently I am running Ms-Sql 2000 on Nt server witn win2003 . Previously I use to connect Ms-sql server from Unix by using Sybase isql utility but it seems with new version of Sql-Server, it's not working.
Is there any open client /utility provided by Microsoft to connect server from unix machine.
Thanks,
-Uttam
Are you writing a program?
Do you have an ODBC driver installed? You should be able to connect over
that driver through TCP/IP.. Port 1433 is SQL Server's default port to
listen to incoming traffic.
Using the old Sybase method uses the SQL Server/Sybase Tabular Data Stream
format to communicate. (Probably much faster than using standard ODBC, but
ODBC will work). Try looking around for FreeTDS. I think it will support
SQL 2000. I know it supports through SQL Server 7.0.
There may be some security issues as well. You may need to ensure that the
SQL Server is using Mixed Authentication. If it is NT Authentication only,
then you will need a Windows Account mapped in to SQL Server. IIRC
kerberos can be helpful here to validate your UNIX login with an Active
Directory login.
I'm sure someone will correct me if I'm wrong. =)
Rick Sawtell
MCT, MCSD, MCDBA
"Uttam" <Uttam@.discussions.microsoft.com> wrote in message
news:E829C6EF-A04D-41FD-A2A4-ECB935CA9868@.microsoft.com...
> Hi,
> How do conenct Ms-Sql server from Unix/Sun box. currently I am running
Ms-Sql 2000 on Nt server witn win2003 . Previously I use to connect Ms-sql
server from Unix by using Sybase isql utility but it seems with new version
of Sql-Server, it's not working. Is there any open client /utility provided
by Microsoft to connect server from unix machine.
> Thanks,
> -Uttam
How do conenct Ms-Sql server from Unix/Sun box. currently I am running Ms-Sql 2000 on Nt server witn win2003 . Previously I use to connect Ms-sql server from Unix by using Sybase isql utility but it seems with new version of Sql-Server, it's not working.
Is there any open client /utility provided by Microsoft to connect server from unix machine.
Thanks,
-Uttam
Are you writing a program?
Do you have an ODBC driver installed? You should be able to connect over
that driver through TCP/IP.. Port 1433 is SQL Server's default port to
listen to incoming traffic.
Using the old Sybase method uses the SQL Server/Sybase Tabular Data Stream
format to communicate. (Probably much faster than using standard ODBC, but
ODBC will work). Try looking around for FreeTDS. I think it will support
SQL 2000. I know it supports through SQL Server 7.0.
There may be some security issues as well. You may need to ensure that the
SQL Server is using Mixed Authentication. If it is NT Authentication only,
then you will need a Windows Account mapped in to SQL Server. IIRC
kerberos can be helpful here to validate your UNIX login with an Active
Directory login.
I'm sure someone will correct me if I'm wrong. =)
Rick Sawtell
MCT, MCSD, MCDBA
"Uttam" <Uttam@.discussions.microsoft.com> wrote in message
news:E829C6EF-A04D-41FD-A2A4-ECB935CA9868@.microsoft.com...
> Hi,
> How do conenct Ms-Sql server from Unix/Sun box. currently I am running
Ms-Sql 2000 on Nt server witn win2003 . Previously I use to connect Ms-sql
server from Unix by using Sybase isql utility but it seems with new version
of Sql-Server, it's not working. Is there any open client /utility provided
by Microsoft to connect server from unix machine.
> Thanks,
> -Uttam
How to conenct Ms-Sql server from Unix box.
Hi,
How do conenct Ms-Sql server from Unix/Sun box. currently I am running Ms-Sq
l 2000 on Nt server witn win2003 . Previously I use to connect Ms-sql serve
r from Unix by using Sybase isql utility but it seems with new version of Sq
l-Server, it's not working.
Is there any open client /utility provided by Microsoft to connect server f
rom unix machine.
Thanks,
-UttamAre you writing a program?
Do you have an ODBC driver installed? You should be able to connect over
that driver through TCP/IP.. Port 1433 is SQL Server's default port to
listen to incoming traffic.
Using the old Sybase method uses the SQL Server/Sybase Tabular Data Stream
format to communicate. (Probably much faster than using standard ODBC, but
ODBC will work). Try looking around for FreeTDS. I think it will support
SQL 2000. I know it supports through SQL Server 7.0.
There may be some security issues as well. You may need to ensure that the
SQL Server is using Mixed Authentication. If it is NT Authentication only,
then you will need a Windows Account mapped in to SQL Server. IIRC
kerberos can be helpful here to validate your UNIX login with an Active
Directory login.
I'm sure someone will correct me if I'm wrong. =)
Rick Sawtell
MCT, MCSD, MCDBA
"Uttam" <Uttam@.discussions.microsoft.com> wrote in message
news:E829C6EF-A04D-41FD-A2A4-ECB935CA9868@.microsoft.com...
> Hi,
> How do conenct Ms-Sql server from Unix/Sun box. currently I am running
Ms-Sql 2000 on Nt server witn win2003 . Previously I use to connect Ms-sql
server from Unix by using Sybase isql utility but it seems with new version
of Sql-Server, it's not working. Is there any open client /utility provided
by Microsoft to connect server from unix machine.
> Thanks,
> -Uttam
How do conenct Ms-Sql server from Unix/Sun box. currently I am running Ms-Sq
l 2000 on Nt server witn win2003 . Previously I use to connect Ms-sql serve
r from Unix by using Sybase isql utility but it seems with new version of Sq
l-Server, it's not working.
Is there any open client /utility provided by Microsoft to connect server f
rom unix machine.
Thanks,
-UttamAre you writing a program?
Do you have an ODBC driver installed? You should be able to connect over
that driver through TCP/IP.. Port 1433 is SQL Server's default port to
listen to incoming traffic.
Using the old Sybase method uses the SQL Server/Sybase Tabular Data Stream
format to communicate. (Probably much faster than using standard ODBC, but
ODBC will work). Try looking around for FreeTDS. I think it will support
SQL 2000. I know it supports through SQL Server 7.0.
There may be some security issues as well. You may need to ensure that the
SQL Server is using Mixed Authentication. If it is NT Authentication only,
then you will need a Windows Account mapped in to SQL Server. IIRC
kerberos can be helpful here to validate your UNIX login with an Active
Directory login.
I'm sure someone will correct me if I'm wrong. =)
Rick Sawtell
MCT, MCSD, MCDBA
"Uttam" <Uttam@.discussions.microsoft.com> wrote in message
news:E829C6EF-A04D-41FD-A2A4-ECB935CA9868@.microsoft.com...
> Hi,
> How do conenct Ms-Sql server from Unix/Sun box. currently I am running
Ms-Sql 2000 on Nt server witn win2003 . Previously I use to connect Ms-sql
server from Unix by using Sybase isql utility but it seems with new version
of Sql-Server, it's not working. Is there any open client /utility provided
by Microsoft to connect server from unix machine.
> Thanks,
> -Uttam
Subscribe to:
Posts (Atom)