Search results for query: *

Hi, I'm new to ASP.NET and I would like to ask if someone can provide me a very simple code to manipulate data using the SQL Commands in the above subject. To keep it simple, say, just 1 textbox and 5 buttons (Next, Prev, Insert, Update and Delete). I'd like to see code of an unbound text box...

Hi, It shows the number 4 for the lenght of the information in the field for all records 12000+ records. I'm sorry but I gave you the wrong info about SQL Server. In SQL Server it only shows <BINARY> in all the 12000+ records. But, in the CRM Application, it shows the random information...

Hi, I have several tables in SQL Server 2005 that I linked to MS Access 2003. Now, these linked tables have some fields that are of Binary Data Type. When I open the linked table in MS Access, the fields with binary type shows NULL or Empty values, but in SQL Server they are not. Please help...

Thanks Markos...I'll try it...thank you so much for your help...

Hi Markros, I tried that already but the relationship connections are not there. What I need is for it to automatically identify the relationship of all the tables. Please help me, there more than 150 tables and I need to determine which tables connect or relates to another table. Thanks

...of each table. Please see sample script below that I cut and pasted: GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[RSys_Last_Id]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[RSys_Last_Id]( [TblName]...

Hi, Our DBA created a username and password in SQL Server specific for ODBC connection to be used by Crystal Reports 10. I created several Crystal Reports 10 using the specific username and password to connect to the database used by the reports. These reports are called from a 3rd party ERP...

Hi John, Thank you very much for your response. I will work on it now. Link Server it is. Mike

Hi Guys, I want to query 2 databases. The first DB is SQL Server 2000 and the 2nd is MS Access. I created this simple query in SQL Server but, it gives me an error saying "Invalid Object Name", where ODBC_TBL2 is an ODBC connection SELECT TBL1.Field1 FROM TBL1 INNER JOIN ODBC_TBL2.Field1...

hey Christiaan, thanks a lot for your help...my app is good to go for now and will add some more functionalities...

...you know what i mean? cmd = New OleDb.OleDbCommand cmd.CommandText = "INSERT INTO DNC IN 'C:\history.mdb' SELECT DNC.* FROM DNC" 'cmd.CommandText = "INSERT INTO DNC (phonenum) VALUES (@phonenum)" 'cmd.Parameters.Add(New...

...conn.Open() 'The insert command ... ... cmd.ComandText = "INSERT INTO DNC IN " & 'C:\history.mdb' SELECT DNC.* FROM DNC" ... ... Next I am using System.IO to get/read files from a directory. where: 1) arrDailyFiles = are the mdb files in an array in a...

hi, yes, that it precisely what i want to do. the display is just secondary, it can be disregarded. my main concern is the insertion of data to the dnc table which i would like to learn. i have tried the commandbuilder and seem not get it to write to the table too. on the other hand, is there...

...Data Source=C:\DNC.mdb" conn.ConnectionString = sConnString conn.Open() da = New OleDb.OleDbDataAdapter("SELECT * FROM DNC ORDER BY PhoneNum ASC", conn) da.Fill(ds) sSQL = "INSERT INTO DNC (phonenum) VALUES ('1234567890')" da.InsertCommand = New OleDb.OleDbCommand(sSQL, conn)...

Hi, Is it possible to automate a Windows VPN connection of remote clients using some vbscripts? I need it because my remote clients are just the typical computer users who only knows the ABC's of computing and a walk through the steps in configuring their machines will take forever. Please...

Hi LarryTheCucumber, I only added the names and ip in the 7 servers hosts file which did not work. After adding the names and ip to the workstations hosts file per your suggestion, it worked. Thank you very much for your help. Mike

Hi, I would just like to know if there is a work around to this problem. I can connect to our VPN and access all resources in our 7 servers. The problem is, I need to enter the internal IP address of each resource that I want to access: i.e. \\10.0.0.23\share or...

I tried that, but I am using VS 2003 (VB NET 2003) .NET FRAMEWORK 1.1 and DataGrid1.DataBind is not available, I believe it is available in .NET FRAMEWORK 2 and VB NET 2005. The version we have is only that of 2003. Thanks

Hi, Im trying to populate a DataGrid with a DateReader in .NET FrameWork 1.1 and its not happening. These are only what I can find and it is for .NET Framework 2. dgDataGrid.DataSource = myReader dgDataGrid.DataBind() or Dim source As New BindingSource source.DataSource = DataReader...

Hi, I found a nice site to help out those who are new to VB.NET and ADO.NET. It might not be much, but a good start. I just wanted to share it with you. I'm getting somewhere now and looking up to creating my first VB.NET App, converting my VB 6 apps (not just converting it but fully making it...