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

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

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

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

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'm new to VB.NET. I just want to know what is the difference between System.Data.Odbc and System.Data.OleDb? Which is the best Namespace to use when manipulating data in MS Acess or SQL Server? Its more of an Advantages and Disadvantages question? Thanks a lot in advance Mike

Hi, I have an Active Directory that have an OU structure below. Head Office IT Accounting Finance etc... Where Head Office is the Root OU and the ones below are sub OUs. This code works fine when I run it: strBase = "<LDAP://ou=Head Office,dc=kuplax,dc=com>" strFilter =...

Hi, What is wrong with this statement? SELECT Campaign.BillingState, Count(Campaign.BillingState) FROM Campaign INNER JOIN Mcalcode ON Campaign.CallResultCode = Mcalcode.CallResultCode GROUP BY Campaign.BillingState, Mcalcode.Redialable, DateDiff(d,DateTimeofCall,getDate()) > 24 HAVING...

Hi, I have an ASP Page that holds all the functions I created named Function.asp and it looks like this: Function setCn1(strSQL) Dim strConn1, rsRecord strConn1 = "Provider=SQLOLEDB.1; SERVER=SQL1; UID=ABC; PWD=DEF; Database=DBRecords" Set rsRecord =...

Hi, I was given the task to integrate Active Directory with VB6. Is there a way to do it in VB6. Please help Thanks Mike

Hi, I have a HistoryTable that has a Primary Key Field and is set with Identity=1, Identity Seed=1 and Identity Increment=1. I also have an identical WorkingTable. I need to move the records from this table to the HistoryTable. When I execute this SQL Insert: INSERT INTO HistoryTable SELECT...

Hi Guys, How do i query tables from 2 different databases using "JOINS" and without doing a "link" from the other database. I can do this: SELECT TblName.* FROM TblName IN 'c:\DB\DBName.mdb' I tried to add a JOIN but it says syntax error FROM...Please help Thanks

Hi Guys, I have an access table that has an index column. This table is used to store all the "dialed" phone #s provided by the "client" to call, as in telemarketing phone #s. Lets call it CalledTbl structure below: CalledTbl --------- Phonenum - Index: (Yes No Duplicates) At the end of the...

Hi, I have several ODBC Connections configured in the ODBC Data Source Administrator to different databases. I want to put the User DSN "Name" and "Driver" columns into a result set. Is this possible? Thanks.

Hi, I have this code below using CDOSYS. It works fine and perfect. 1) Im just wondering what is the "CDO.Configuration" for? It is because, it uses the schemas.microsoft etc...I tried using without it and the code does not work. 2) Should it be always be schemas.microsoft as default? or...

Hi I am trying to display pictures from a folder with space, e.g.: <img src=C:\MyWeb\Images\Pix One\Pix1.jpg> This does not display the file But if I make it like this: e.g.: <img src=C:\MyWeb\Images\PixOne\Pix1.jpg> This displays the file Is there a way to display the file using "Pix One"...