Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Miked811

    Select, Insert, Update and Delete Example

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

    Link Field is NULL from SQL Server of BINARY Data Type

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

    Link Field is NULL from SQL Server of BINARY Data Type

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

    How To Show/Create Relationship Diagram from Existing CRM Database

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

    How To Show/Create Relationship Diagram from Existing CRM Database

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

    How To Show/Create Relationship Diagram from Existing CRM Database

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

    What will happen when ODBC password will be changed

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

    Query SQL Server and MS Access Database

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

    Query SQL Server and MS Access Database

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

    Row does not get inserted to DB

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

    Row does not get inserted to DB

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

    Row does not get inserted to DB

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

    Row does not get inserted to DB

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

    Row does not get inserted to DB

    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 =...
  15. Miked811

    VPN Auto Configuration of Remote Users

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

    IP Address Work Around to Access VPN

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

    IP Address Work Around to Access VPN

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

    How to Populate a DataGrid - Framework 1.1

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

    How to Populate a DataGrid - Framework 1.1

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

    Difference between System.Data.Odbc and System.Data.OleDb

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

Part and Inventory Search

Back
Top