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.

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...

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.

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 others,...

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 I get ONLY ONE ROW without any...

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?

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...

Looping Queries in Oracle using data from SQL Server

I have a table of entries from SQL server called PID. Each of this entry should follow the following select * from HR.TABLES a START WITH a.SID = '0' CONNECT BY PRIOR a.parentid = a.sid' Where I have '0' in the query above, should take all the values from PID. Is there a easy way to write this?...

Website and database connection

can anybody tell me how to connect the MS sql database with the jsp pages....I got the ip address and username with the password...I know how to connect it in a local system...but I dont know how to connect it with the database in the web server....Please help me to solve this matter

Unable to import data using DSN file from SQL Server to Microsoft Excel or Access?

hi ALL, i have a strange situation, there is few people who is not able to load data from sql server using dsn file. I have used correct method, i have used odbc driver -sqlserver... i believe every thing should be fine. I have check the access permission for that user. that is not the issue....

VB.NET app cannot login to SQL Server 2005 after upgrade from SQL Server 2000

I have a VB.Net application which connects to an SQL2000 database and I recently upgraded to SQL2005 and after the upgrade my app does not want to connect to SQL2005 using the same password I used to connect to SQL2000. if I change the login password to all uppercase characters in SQL2005...

How to connect PowerBuilder 10 with Microsoft SQL Server?

connect Powerbuilder 10 with Microsoft SQL??

Setting a username and password in SQL Server

How do I set the username and password in SQL Server to allow connection to the database?

How can I connect my local machine to the SQL Server 2005 Enterprise Edition?

How can I connect my local machine to the SQL Server 2005 Enterprise Edition?? I can't even run the local service instance