What is the error? Can you paste it here?

Hi,
Nothing offence but if you search with this keyword on daniweb "sql connection" you will see lot of good results. Also I would suggest you to read some SQL Books to start with.

By transparent do you mean it should match the color of the form?

Try this code to first create a transparent window:

Private Declare Function GetWindowLong Lib "user32" Alias "GetWindowLongA" (ByVal hWnd As Long, ByVal nIndex As Long) As Long
Private Declare...

When you say their password to your app, do you mean just an application with access control?

I have found a ready to use parallel port component here:
http://www.zealsoft.com/ntport/download.html

Install the exe and you can then add the component to your project IDE. Its an easy to use...

Do you want to buy a thirdparty component or re-invent the wheel?

Please check the column format of that excel file. Set it to text.

Here is how you can play wav files.
1. Add a command button and a common dialog box. Copy and paste the sndPlaySound Declare statement from the API Viewer into your application. Also copy the...

How are you trying to load the music files? What format are you going with? Any dll's or ocx controls used?

If you know the base time then based on the current time you can use something like this:

Assuming EST as the base time

CST = DateAdd("h", -1, Now)
MST = DateAdd("h", -2, Now)
PST =...

What will you consider as the base time?

What sample do you want? The link in vbsqluser (http://www.daniweb.com/forums/member191895.html) post has some samples. Let me know if you need more elanorate one.

Also Try replacing the single quote with 2 single quotes or a double quote. That should work.

It seems you are trying to connect to MySQL Database for this purpose.

Try to use a path which does not contain any spaces in the folder name. Let me know what happens, For eg: use the file path as :

"C:\Data\filename.txt"

Also how do you get this filename?

So how do you know where to look for the file if you dont know the path?

I think thats what i posted in my first post. Please take time to read before posting.

Please see the post before you post redundant replies.

Create a dll file using VC++ Win32 Dynamic-Link Library Project type.
Compile the dll and register it in system32.

You need to compile this cpp class as a .DLL and then refer this dll in your VB propject.

You are good to go.

Do you have a fixed path for the data files? And in what format are these files? .CSV or TXT?

You can put the same code in the form load on the timer control and it will only refresh the textbox control with the new values. It will not load the form again but yes it redraws the form window....

What's the code on the refresh button? Currenlty i think you were getting the temp. on the form load also.
You can do this by using a timer control on the form and make the interval "1000" which...

try this instead:

System.Windows.Forms.Application.DoEvents()

What happens when you use the same code in VB.NET?

Where are you reading the temperature from?

You can use any of the Driver based on your requirement.

using SQL Server Native Driver is the fastest. Then comes OLEDB and then ODBC.

You can even write a generic data access class to make...

You can use these Connection Strings for SQL 2000:

ODBC with Standard Security
Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

ODBC with Trusted...

Please read the article here with full demo source (http://www.coderewind.com/?categ&view_article=55)

Let me know if this works for you.

I will be posting an article on my soon with source code.

No Problem. Anytime. You can contribute on my site too. here (http://www.coderewind.com)

Try this:

Sub DeleteSheets()
dim xl as new excel.application
dim wb as excel.workbook
set wb=xl.workbooks.open("c:\test.xls"
xl.application.displayalerts=false
If...

Let me know if it helps. You can download and read more code articles on my site (http://www.coderewind.com).

You can use this command line utility.

http://support.microsoft.com/default.aspx?scid=KB;en-us;q311272

Are you trying to disable and enable LAN?

What are you trying to accomplish?

Thats good! Glad you resolved it.

Here is another way of doing it. After you populate your excel file with all the records. Run this function.

Public Sub InsertRows()
Dim xl As Excel.Application
Dim wb As Excel.Workbook
...