Anyone support a config where you have an unix/linux (AIX here) ODBC
client connection to SQL Server database? I am looking for a simple,
supportable configuration that does not require me to learn perl or
instal a bunch of crap gnu shareware on enterprise class machines.
Please help!
Anyone support a config where you have an unix/linux (AIX here) ODBC client connection to SQL Server database? I am looking for a simple, supportable configuration that does not require me to learn perl or instal a bunch of crap gnu shareware on enterprise class machines.
Please help!
Newbie here,
I am trying to link tables from an access 2003 frontend to sql server 2005 backend.
I am doing this in a vmware test environment. I am using vmware server and running sbs 2003 and xp sp2 client. Both virtaul machine can talk to each other(using local host connection).
I have tried to create a dsn to the sql server but i cannot connect. I can ping the sbs server through the command interface but the error i get when i try to connect is :
Connection failed:
Sql state: hyt00
sqlserver error: 0
microsoft odbc sql server driver timeout expired.
spent a day trying various combinations - still no joy.
Any help would be much appreciated
Hi,
When I'm using SQL server 2005, and ODBC drive €œSQL Native Client€? I get an error when executing the below given code. Error Message: €œTransaction cannot start because more than one ODBC connection is in use.€?
But this works well with SQL Server 2000 with ODBC drive "SQL Native Client" and in SQL server 2005 also when I used ODBC drive €œSQL Server€?.
I used aTrgConn.Execute(€œBegin Transaction€?) and it's working properly. But unfortunately I cannot use this method, because I want to run the same code with Oracle ODBC as well.
Is this a known issue in SQL Native client drive with SQL server 2005? Do you know a solution for this?
Please Help..............
Thanks in advance.
Code:
Dim aTrgConn As New ADODB.connection
Dim aCmdIns As New ADODB.Command
Dim aCmdUpd As New ADODB.Command
aTrgConn.Open sConnStr
Set aCmdIns.ActiveConnection = aTrgConn
Set aCmdUpd.ActiveConnection = aTrgConn
aTrgConn.BeginTrans
Hi, everyone!I was just wondering if any of you knows of a linux/unix client(preferably on the command line) that would connect to ms sql server?Any hints would be appreciated!Roumen.
View 1 Replies View RelatedHello,
How can I assign the ODBC Database(Progress) on UNIX as publisher and SQL Server as subscriber. When I use the Enterprise Manager, I cannot see the Unix Server. I just can see the server and database in DTS.
Would you please explain the steps?
Alice
I apologize if this is not the correct forum for this posting. Looking at the descriptions, it appeared to be the best choice.
I am running Windows XP Pro SP2. I have installed the SQL Native Client for
XP. However, when I try to add a new data source through ODBC Connection
Manager, SQL Native Client is not listed as an option. I have followed this procedure on three other systems with no problems. What would be causing the
SQL Native Client to not show up in the list of available ODBC data sources?
How can i connect to the MS SQL server ruuning on Windows NT from a SOLARIS machine.?
Is there any client software available for this?
I get the following error when I try to delete files using the FTP client in a SSIS package. This is the error I get.
Error: 0xC002918E at FTP Task, FTP Task: Unable to delete remote files using "FTP Connection Manager".
Task failed: FTP Task
This is a unix server. I'm able to delete the files using other FTP clients but the FTP client in the SSIS package cannot delete the files. I read on many places on the interent that this is a known MS bug. Let me know if there is some sort of work around for this. I'm using SQL servewr 2005 SSIS packages to accomplish this task..
Thanks
Hi Folks,
I need to access the MSSQL data in Oracle.
For that i need to first create the data source (ODBC Connection) to the MSSQL server on UNIX. Can anybody help me in creating the ODBC connection.
Thanks,
Amit
HiI'm new this .I' using SQL 2005 VWD05.Could some body tell me how to upload to my host server database to to run a membership user account.I dont know what are the procedure to do on my pc in order to transfer the file on the database.Thanks
View 25 Replies View RelatedHello experts,
I need to create a File DSN on AIX Unix server which can connect to MS SQL server 2005 on a windows machine.Can anyone please give me step by step procedure how to do it.Its an urgent requirement. Please help me.
Regards
Arvind L
I have an application on:
W2K client
Sql 2000 + No SP
MS ODBC V3.8
C++
The application, running on the client, connects to SQL server for many simultaneous queries involving select, insert and update. Application creats a thread for each query. Each thread connects to the sql server via ODBC using sqlconnect.
However I find that the individual thread do not close properly and stay open even after sqldisconnect has been issued on the client. At one point I have over 1200 threads on client application trying simultaneously to connect to the server and the sqlserver is holding with 276 threads open.
I do not understand why the ODBC connection stays open even after sqldisconnect is issued. I have even tried disabling connection pooling, to no effect. The performance is very poor.
How can I issue a large number of queries to same sql server via ODBC while guaranteeing performance?
We have installed a SQL 2000 server on a windows xp-pro machine and succesfully installed DotNetNuke. Now is the problem that there is no way we can manage to get a client connected. We have tried everything, changing tcp port, setting permissions, changing registry according to document 307197 in the microsoft database and nothing helps. The only thing we can see is that in the serverlog we get a message stating that "SuperSocket Info : Bind failed on TCP port 1433". Can anyone help?Regards Ulla & Tom
View 7 Replies View RelatedHi Guys,
I'm brand new to SQL server and all that and am having a little bit of hassles getting up and running.
I have a server 2003 computer running on my lan that I installed SQL server 205 express onto. I have attatched a database that I got with a C# book..
When I go into visual studio 2005 on the client to try and connect to te server vs cannot see the server at all.. the only server that displays is the client computer(which isn't a server??) I know there is a valid connection between the two computers because I login to the server using remote access..
Also, I have enabled TCP in the SQL server configuration program..
I wonder is there any beginnger guides on how to get the whole show up and running??
Thanks..
Another newbie question...
I've got SQL Server Express installed on a server. Now I need to provide a method for the clients to know where the server is.
When using Access, I launched a dialog and the user navigated to the mdb file on the server. It worked fine.
It seems using SQL Server I just need them to select a computer to connect to. Or can it happen silently?
I would like to be able to change the configuration of a remote machine`s SQL client config.
Can anyone provide me with the registry location of where it stores the protocol and libraries?
Can`t always depend on having someone at remote to run the SQL client app.
TIA Sam Janney
Could someone please tell me what I need to do to be able to connect a user, who is on a Novell Network to a SQL Server using tcp/ip.
Do I need to make the user a member of the NT Domain or have a local user account on the NT box, where the SQL Server is installed.
Thanks,
Dane
Hi,
I have a Visual C# WinForms app which I am accessing a SQL Server 2005 database with. On the Server, I have allowed remote connections (TCP and named pipes) and enable SQL Browser as per instructions on MSDN. The app works fine on the development machine.
Server name is <machine name>SQLEXPRESS, connecting with Windows Authentication.
Server log states that it is listening on [ 'any' <ipv4> 3153].
Server named pipe provider is ready to accept connection on [ \.pipeMSSQL$SQLEXPRESSsqlquery ].
On the client (local network), when trying to open the database I get this error still:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Also on the client, I can go into the ODBC Data Source Administation, and connect to the SQL Server Database that way successfully.
What further steps can I take to allow the client to access the SQL Server?
Andrew
Hi all
I m a new member to this forum. Im a hardware engineer who rectify aome software related issues. Now our employees having problem with connecting their XP prof based clients to 2003 server from SQL query analyzer. I tried refresh sql server manager in server and tried restarting the server machine many times. sometimes it the client machine connects and disconnects immediately. i aslo tried changing the poll interval , but no use.
waiting for a speedy solutin... i know this is as easy query.
Hi,
I've just set up a new installation of SQL 7 in a WinNT4/sp5 machine so I can learn more about this stuff and I'm trying to configure a Win98 client. From the Win98 client all looks well on the surface. Interestingly when I click on the server from within the Win98 MMC/Enterprise Manager it attempts to establish a dial-up connection to my ISP. The only network protocol I have running is TCP/IP.
Also, I can do what ever I want from within Enterprise Manager and SQL Analyzer but if I attempt to execute a script using the OSQL utility at a dos prompt as follows
osql /Usa /P /i "c:sqlimplexercisech02myscript2.sql"
I get the following error
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (connect()).
Any clues as to what I need to do to straighten this out? I have a DSN for the server which tests successfully using TCP/IP on the default port 1433.
Hi there,
I'm a new comer to this APS language and hope sombody out there can help me with this
I'm trying to find codes for me to connect from ASP to Sql Server using ODBC.
Can anyone help me
Thanx
Hi all
I have problem with making Connection between two computer through SQLServer and ODBC.
I have two computers which are members of a WorkGroup network with WindowsXP(sp2) installed.
on one computer i have installed SQL Server 2000 Enterprise edition with MIX Authentication mode enabled. Also i have created a LOGIN (Sql Server Authentication) with System Administrator ROLE (SYSADMIN).in that sql server environment .
But in another computer when i want to create an ODBC connection (ControlPanelAdministrative ToolsData Sources (ODBC)) to connect to mentioned Computer with Sql server,I receive the following Error:
Access Denied...Sql Server doesn't exist.
I have disabled Windows-XP firewall on both computers but still problem persists.
By the way these two computer have one Administrator Account with DEFFERENT Passwords.
Could anyone help me.? Any help greately would be appreciated.
Kind Regards.
When you connect to SQL Server using SQLConnection, how to set client machine name(or IP address) so that you can monitor the process on Server side using Enterprise Manager?
View 2 Replies View RelatedHi,
I have a Visual C# WinForms app which I am accessing a SQL Server 2005 database with. On the Server, I have allowed remote connections (TCP and named pipes) and enable SQL Browser as per instructions on MSDN. The app works fine on the development machine.
Server name is <machine name>SQLEXPRESS, connecting with Windows Authentication.
Server log states that it is listening on [ 'any' <ipv4> 3153].
Server named pipe provider is ready to accept connection on [ \.pipeMSSQL$SQLEXPRESSsqlquery ].
On the client (local network), when trying to open the database I get this error still:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Also on the client, I can go into the ODBC Data Source Administation, and connect to the SQL Server Database that way successfully.
What further steps can I take to allow the client to access the SQL Server?
Andrew
Hi,
I have a Visual C# WinForms app which I am accessing a SQL Server 2005 database with.
On the Server, I have allowed remote connections (TCP and named pipes) and enable SQL Browser as per instructions on MSDN. The app works fine on the development machine.
Server name is SQLEXPRESS, connecting with Windows Authentication.
Server log states that it is listening on [ 'any' 3153].
Server named pipe provider is ready to accept connection on [ \.pipeMSSQL$SQLEXPRESSsqlquery ].
On the client (local network), when trying to open the database I get this error still:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Also on the client, I can go into the ODBC Data Source Administation, and connect to the SQL Server Database that way successfully.
What further steps can I take to allow the client to access the SQL Server?
Andrew
Hi All,
I've developed an application that connects to a SQL Server 2005 Express database. I created a DSN to connect to the database through ODBC. Currently, I am testing locally and everything works fine.
I would now like to install my application on another workstation and connect remotely to the database located on my development machine.
The client workstation does not have SQL Server 2005 Express installed on it because I would just like my application to connect remotely by creating the DSN and using ODBC. What I'm missing here are the database drivers. The "SQL Natice Client" is not available on this client workstation. How can I deploy the necessary drivers with my installation file so that I may create the required DSN name using the SQL Native Client driver?
Thanks!
I am trying out a simple ASP.NET application which includes access to an SQL Server Database. It works fine on my local machine when I connect to the SQL Server and use SQL commands (via C#) to access it.
But my web hosting provider uses ODBC drivers for database access (they support the SQL database type). I would like to find out how I should connect to my SQL Server database and program the access in order for it to be ODBC compatible, so that I can deploy it to my web hosting server. I should also mention that I am using Visual Web Developer 2005 Express Edition.
Thanks for any help or pointers.
Kumar
cant connect to sql server 2000 from c# 2003
View 1 Replies View Related
dear all,
in order to install a program i need to connect through SQL 2000 client to SQLserver2005.
it is possible?
We are unable to connect with Client SQL database server using VPN connection, even we are able connect with their intranet site.
We tried to connect using IP address, but no success. After that tried to ping that server with server name and IP address using command prompt, but got request time out error.
Help Me In This : My Client Applicaion Can't Connect To Sql Server 2005 Express
Story :
I have Application Coded by C# To Connect To Sql Express Data Base , And I have Form In This Application To Configure The Connection String .
This Application Is Tested Local Ok (MY Server Name :- .SqlExpress )
When i User This Application In Client In Same Network And Try To Connect To The Data Base In Server (My Server Name :- ServerNameSqlExpress ) This Error Appeared "Server Does Not Exist Or Access Denied"
Note : I Configure My Server Configuration And Enabled The Tcp/ip .
Questions :
How Can I Connect To Data Base From Client To Server Through NetWork Connection Using ServerNameInstance ?
How Can I Connect To Data Base From Client To Server Through NetWork Connection Using IpInstance ?
How Can I Connect To Data Base From Client To Server Through InterNe ?
All This Questions Using Sql Server 2005 Express .
Regards , , , ,
Mostafa Ragab Arafa
First, let me start by saying I know the answer to this, but due to politics any answer I give will be viewed with some disdain and disbelief.
A Unix/Network [rtdpmin one our sister agencies is trying to solve a problem that really does not need to be solved, but ....
The sister agency uses Information Builder's WebFocus on Unix. When they try to read my data warehouse in SQL Server 2000 it times out on them (on their end and they claim they cannot fix it) (This is using the supplied WebFocus ODBC/JDBC driver for SQL Server). This has lead to accusations of us not letting them read the data.
After much gnashing of teeth over "if you do data and data analysis for a living, why do I have to show you how to set-up an ODBC connection" we have shown them how to connect to the data, read it, and transfer it using MS-ACCESS, EXCEL, and more importantly SPSS. This is not good enough because they cannot figure out how to put it into WebFocus.
Their network person has come-up with the brilliant idea of reading the .mdf directly by installing Windows for Unix on the Unix side and then just pointing to the .mdf file and "reading it ".
Unless I have missed something somwhere (I will admit possible), I know you need a driver to read MS-SQL and that driver in every example I have seen could care less about the physical location of the .mdf file. It wants to know what database, what server (ip or name) and what security/login to use.
Could someone give me a more "technical answer" or even Microsoft's party line so I do not have this person mucking around with my production server trying to acomplish the impossible.