Help me with this error = MS SQL SERVER LOGIN - Connection Failed: SQL State: 'HYT00' , SQL Server Error: 0
Posted on 2004-08-30
The title stated the error that occurs when im trying to make an application using DATA ENVIRONMENT in VB6 to MSDE..I have 2 PC, the server has MSDE RelA (Already configured...i guess) and the other PC has VB6 SP6, making a connection string through OLEDB SQL SERVER was succesfull, the server was seen BUT when im trying to make a command (remember im using data environment here) that error occurs.. To make my brain hurts a little more, i removed my DATA ENVIRONMENT and utilize a ADO control instead. The connection was succesfull and datasource(table) was seen and my app is up and running!!!!!So now how come when i used ADODC the the connection and datasource (table) was succesfully connected to my app while in data environment the connection to the server&DB was succesfull BUT in the command(table) are not and that error always appearing???
All i want to use is the "Data environment" not ADODC, though i know DATA Environment uses ado as reference, so please help me experts...