ODBC connection to the SQL server from the iSeries
Is there a way on the iSeries to establish an ODBC connection to the SQL server?
Answer Question
| May 5, 2011 6:14 PM
iSeries Access, ODBC, ODBC Permissions, SQL Server, SQL Server connectivity
Is there a way on the iSeries to establish an ODBC connection to the SQL server?
Answer Question
| May 5, 2011 6:14 PM
iSeries Access, ODBC, ODBC Permissions, SQL Server, SQL Server connectivity
Problem with Visual Studio 2010 and SQL Server 2008.
Hello friends! I am new here in this forum. I have a simple question. I am using Visual Studio 2010. But the SQL Server 2008 that comes with it does not have Management Studio with it. So I have installed SQL Server 2008 again seperately in my machine. Now I want to know how to [...]
Answer Question
| May 3, 2011 11:54 AM
ASP.NET, SQL Server 2008, SQL Server configuration, SQL Server connectivity, Visual Studio 2010
Hello friends! I am new here in this forum. I have a simple question. I am using Visual Studio 2010. But the SQL Server 2008 that comes with it does not have Management Studio with it. So I have installed SQL Server 2008 again seperately in my machine. Now I want to know how to [...]
Answer Question
| May 3, 2011 11:54 AM
ASP.NET, SQL Server 2008, SQL Server configuration, SQL Server connectivity, Visual Studio 2010
Multi Location Software in VB.Net
I want to create multi location software in VB.net .Basically, my scenario is like ………..software should work for 9 branches. One main branch where SQL server is located and rest all sites are remote site where software installed and directly connected to central SQL server. Please give me some idea how it is possible for [...]
Answer Question
| March 15, 2011 7:02 AM
SQL Server, SQL Server configuration, SQL Server connectivity, VB .NET
I want to create multi location software in VB.net .Basically, my scenario is like ………..software should work for 9 branches. One main branch where SQL server is located and rest all sites are remote site where software installed and directly connected to central SQL server. Please give me some idea how it is possible for [...]
Answer Question
| March 15, 2011 7:02 AM
SQL Server, SQL Server configuration, SQL Server connectivity, VB .NET
How to connect Visual Basic 6.0 to wampserver using odbc
Sir, please give me the proceedure in connecting visual basic 6.0 to wampserver using odbc. show me on how to configure odbc in order to connect wampserver. Give me an example code of edit, delete and save using visual basic 6.0. Your help is appreciated a lot.
Answer Question
| September 26, 2012 6:52 AM
SQL Server, SQL Server connectivity, VB 6.0, Visual Basic 6.0, WAMP Stack, Windows XP SP3
Sir, please give me the proceedure in connecting visual basic 6.0 to wampserver using odbc. show me on how to configure odbc in order to connect wampserver. Give me an example code of edit, delete and save using visual basic 6.0. Your help is appreciated a lot.
Answer Question
| September 26, 2012 6:52 AM
SQL Server, SQL Server connectivity, VB 6.0, Visual Basic 6.0, WAMP Stack, Windows XP SP3
Connect Powerbuilder in SQL Server 2005
how to connect the sqlserver 2005 database in power builder
Answer Question
| February 1, 2011 12:36 PM
PowerBuilder, SQL 2005, SQL Server 2005, SQL Server connectivity
how to connect the sqlserver 2005 database in power builder
Answer Question
| February 1, 2011 12:36 PM
PowerBuilder, SQL 2005, SQL Server 2005, SQL Server connectivity
Connecting VC6 to SQL server
how can i connect VC++6 MFC application to SQL server? plz help m out!!
Answer Question
| November 2, 2010 5:04 PM
SQL Server, SQL Server connectivity, VC++, VC++ 6, VC6
how can i connect VC++6 MFC application to SQL server? plz help m out!!
Answer Question
| November 2, 2010 5:04 PM
SQL Server, SQL Server connectivity, VC++, VC++ 6, VC6
(provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53
Promblem:1) SQL SERVER is up and the instance connect is running. 2) All required ports on Firewall is open/ also try to disable Firewall but no success. 3) TCP/IP protocol is ENABLE. SQL SERVER port is by Default 1433. 4) Also try this: the probelm is the Instance name from the client is not resolved, [...]
Answer Question
| July 13, 2010 4:22 PM
SQL Server connectivity, SQL Server error messages, SQL Server Remote Connections, TCP/IP Protocols
Promblem:1) SQL SERVER is up and the instance connect is running. 2) All required ports on Firewall is open/ also try to disable Firewall but no success. 3) TCP/IP protocol is ENABLE. SQL SERVER port is by Default 1433. 4) Also try this: the probelm is the Instance name from the client is not resolved, [...]
Answer Question
| July 13, 2010 4:22 PM
SQL Server connectivity, SQL Server error messages, SQL Server Remote Connections, TCP/IP Protocols
Connecting to the SQL- SERVER from VS-2008 C#
How can I connect to the SQL SERVER from the VS-08 C# and how can I insert, modify and view the database in SQL SERVER.
Answer Question
| July 15, 2010 11:55 AM
Connecting to SQL SERVER FROM C#, SQL Server connectivity, SQL Server database, Visual C# 2008, Visual Studio 2008
How can I connect to the SQL SERVER from the VS-08 C# and how can I insert, modify and view the database in SQL SERVER.
Answer Question
| July 15, 2010 11:55 AM
Connecting to SQL SERVER FROM C#, SQL Server connectivity, SQL Server database, Visual C# 2008, Visual Studio 2008
how I can connect my local SQL server2008 with another one via internet?
how I can connect my local SQL server2008 with another one via internet?
Answer Question
| April 9, 2011 3:51 PM
Remote access servers, SQL connectivity, SQL Server 2008, SQL Server connectivity
how I can connect my local SQL server2008 with another one via internet?
Answer Question
| April 9, 2011 3:51 PM
Remote access servers, SQL connectivity, SQL Server 2008, SQL Server connectivity
Local clients loose connection to local SQL Server when system network drops connection to HQ.
When line to primary Domain controller is dropped, some of the current logged on clients are dropped by SQL when they try to access the database. For some clients, the application still works just fine. The clients are all set up and authenticated in the local Domain Controller. It is my thought that the authentication [...]
Answer Question
| March 19, 2010 9:14 PM
Active Directory, SQL Server 2005, SQL Server 2005 connectivity, SQL Server connectivity, VB
When line to primary Domain controller is dropped, some of the current logged on clients are dropped by SQL when they try to access the database. For some clients, the application still works just fine. The clients are all set up and authenticated in the local Domain Controller. It is my thought that the authentication [...]
Answer Question
| March 19, 2010 9:14 PM
Active Directory, SQL Server 2005, SQL Server 2005 connectivity, SQL Server connectivity, VB
Sudden SQL errors keep Business Contact Manager from loadingHELP – Sudden SQL errors keep Business Contact Manager from loading
Answer Question
| March 29, 2010 5:18 AM
SQL Server 2005 connectivity, SQL Server connectivity, SQL Server error messages
Answer Question
| March 29, 2010 5:18 AM
SQL Server 2005 connectivity, SQL Server connectivity, SQL Server error messages
sql server 2005 service will not start
I have a new server running server running windows 2003 and sql server 2005. when I turn on allow remote connections and restart sql service the service fails to start. If I turn off allow remote connections the sql service starts with no problems. I have been unable to find any potential solution to this [...]
Answer Question
| May 26, 2011 10:16 PM
SQL Server 2005, SQL Server 2005 connectivity, SQL Server connectivity
I have a new server running server running windows 2003 and sql server 2005. when I turn on allow remote connections and restart sql service the service fails to start. If I turn off allow remote connections the sql service starts with no problems. I have been unable to find any potential solution to this [...]
Answer Question
| May 26, 2011 10:16 PM
SQL Server 2005, SQL Server 2005 connectivity, SQL Server connectivity
SQL server STD 05 between Sites
besides buying Enterprise($$$$$.$$), how else can I keep these servers (sych’d, mirrored, ???) via a network link between cities? Server1(win-sql-05)DB <> Server2(win-sql-05)DB
Answer Question
| February 18, 2010 5:04 AM
sql link sycn, SQL Server 2005, SQL Server 2005 Standard Edition, SQL Server connectivity
besides buying Enterprise($$$$$.$$), how else can I keep these servers (sych’d, mirrored, ???) via a network link between cities? Server1(win-sql-05)DB <> Server2(win-sql-05)DB
Answer Question
| February 18, 2010 5:04 AM
sql link sycn, SQL Server 2005, SQL Server 2005 Standard Edition, SQL Server connectivity
SQL Server connectivity on V3R7 AS/400 server
Hello All, Can any tell me all the steps to coneect Sql Server to V3R7 version of AS/400. Thanks in advance.
Answer Question
| June 12, 2009 6:53 AM
AS/400 interoperability, SQL Server connectivity, SQL Server interoperability, V3R7
Hello All, Can any tell me all the steps to coneect Sql Server to V3R7 version of AS/400. Thanks in advance.
Answer Question
| June 12, 2009 6:53 AM
AS/400 interoperability, SQL Server connectivity, SQL Server interoperability, V3R7
Can’t create ODBC connection to sql 2005 instance
I have a server 2003 two node cluster with SQL 2005 installed. The orginal instance is working fine and there is no connection problem. I have created a second instance and can connect with the SQL Management Studio. When i try to create a ODBC connection from my client os both XP and VISTA both [...]
Answer Question
| April 26, 2009 4:20 PM
ODBC, SQL Server 2005, SQL Server 2005 connectivity, SQL Server connectivity, SQL Server Management Studio, Vista, Windows Server 2003, Windows XP
I have a server 2003 two node cluster with SQL 2005 installed. The orginal instance is working fine and there is no connection problem. I have created a second instance and can connect with the SQL Management Studio. When i try to create a ODBC connection from my client os both XP and VISTA both [...]
Answer Question
| April 26, 2009 4:20 PM
ODBC, SQL Server 2005, SQL Server 2005 connectivity, SQL Server connectivity, SQL Server Management Studio, Vista, Windows Server 2003, Windows XP
VB2008 and Connection to SQL
Is there any way to connect to a SQL server using Vb2008? I’m trying to add a datasource but this allows me to conenct locally only.
Answer Question
| December 5, 2011 12:32 PM
SQL Server connectivity, VB 2008, Visual Basic, Visual Basic .NET Web services
Is there any way to connect to a SQL server using Vb2008? I’m trying to add a datasource but this allows me to conenct locally only.
Answer Question
| December 5, 2011 12:32 PM
SQL Server connectivity, VB 2008, Visual Basic, Visual Basic .NET Web services
CRViewer Logon Failed error within Visual Basic 6
I developed and tested a VB6 program that runs CR Viewer accessing with RDC Crystal Reports 11 reports from a folder on a remote server and uses data and queries from SQL2000 on the same server. All operating systems use MS XP. My problem is that the program works on my desktop and a few [...]
Answer Question
| March 27, 2009 11:40 AM
CRViewer, Crystal Reports 11, Crystal Reports XI, Database connectivity, SQL, SQL Server 2000, SQL Server connectivity, VB 6, Visual Basic, Visual Basic 6
I developed and tested a VB6 program that runs CR Viewer accessing with RDC Crystal Reports 11 reports from a folder on a remote server and uses data and queries from SQL2000 on the same server. All operating systems use MS XP. My problem is that the program works on my desktop and a few [...]
Answer Question
| March 27, 2009 11:40 AM
CRViewer, Crystal Reports 11, Crystal Reports XI, Database connectivity, SQL, SQL Server 2000, SQL Server connectivity, VB 6, Visual Basic, Visual Basic 6
Sybase to SQL Server via linkserver
I have set up a SQL link server between an SQLserver 2005 on a W2003 R2 and a SYBASE 12.5.0.2 server on a IBM AIX H70 system. I use the Sybase ODBC driver 04.20.00.67 The problem is than most of the times (there is no pattern ) when I select rows from a Sybase table [...]
Answer Question
| March 30, 2009 9:27 AM
Database connectivity, IBM AIX, Linked Server, ODBC, SQL Server 2005, SQL Server connectivity, Sybase 12.5.0.2, Sybase connectivity
I have set up a SQL link server between an SQLserver 2005 on a W2003 R2 and a SYBASE 12.5.0.2 server on a IBM AIX H70 system. I use the Sybase ODBC driver 04.20.00.67 The problem is than most of the times (there is no pattern ) when I select rows from a Sybase table [...]
Answer Question
| March 30, 2009 9:27 AM
Database connectivity, IBM AIX, Linked Server, ODBC, SQL Server 2005, SQL Server connectivity, Sybase 12.5.0.2, Sybase connectivity
How to connect my application using Visual Studio 2005 to a SQL Server database?
how to connect my application using visual studio 2005 to a database using sql server?
Answer Question
| May 30, 2009 12:27 AM
Database connectivity, Database programming, SQL Server connectivity, SQL Server database, Visual Studio, Visual Studio 2005
how to connect my application using visual studio 2005 to a database using sql server?
Answer Question
| May 30, 2009 12:27 AM
Database connectivity, Database programming, SQL Server connectivity, SQL Server database, Visual Studio, Visual Studio 2005
How to retrieve, add and update data from SQL Server 2005 manually using VB.NET 2005?
Hey guys!!! I’m quite new to VB.NET 2005. I need to know how to add, update and retrieve data manually using VB.NET 2005. In the software which I’m trying to implement, data is entered in text boxes and then they are updated/added into an SQL table. When retrieving the data, for example: A student is [...]
Answer Question
| March 9, 2009 11:01 AM
Data Junction, Extract Transform Load, INSERT statement, SELECT statement, SQL Server 2005, SQL Server connectivity, VB.NET 2005, Visual Basic .NET, Visual Basic 2005
Hey guys!!! I’m quite new to VB.NET 2005. I need to know how to add, update and retrieve data manually using VB.NET 2005. In the software which I’m trying to implement, data is entered in text boxes and then they are updated/added into an SQL table. When retrieving the data, for example: A student is [...]
Answer Question
| March 9, 2009 11:01 AM
Data Junction, Extract Transform Load, INSERT statement, SELECT statement, SQL Server 2005, SQL Server connectivity, VB.NET 2005, Visual Basic .NET, Visual Basic 2005
