Recent content by Miked811

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

Hi, I have been tasked to document/show/create the relationship of all tables in a CRM Database. I generated the script from the entire database (SQL Server 2005) and I can see from the script all the primary/foreign keys and its corresponding constraints of each table. Please see sample script...

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

hey, i got it. i commented out some lines and change the SQL statement for the insert and it worked... question though, with "conn.Close()", will this mean that all connections to the DataSet, DataTables and DataReaders etc...will be closed and all resources will be released. i mean, im used...

hi, it worked...the for loop there is important for my app. here's the real deal: For Each fleDailyFiles In arrDailyFiles sConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & fleDailtyFiles.ToString() conn.ConnectionString = sConnString...

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

Hi, Please kindly help me. It does not add the row I inserted: Dim conn As New OleDb.OleDbConnection Dim da As OleDb.OleDbDataAdapter Dim ds As New DataSet Dim sSQL As String Dim sConnString As String For Each fleDailyFiles In arrDailyFiles sConnString =...

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