Visual Basic

FirstPrevNext

Re: VB SQL Connectivity through Internet. 19-Feb-01 13:31 19-Feb-01 13:31  I have done this many times with the following code. Basically, I create a connection string and use ADO and OLEDB to perform the connection. Here is a code snippet. strServerName = "127.0.0.1" ' Substitute your IP Address here strDatabaseName = "YourDB" ' Substitute your Database name strUserName = "YourUser" ' Substitute your UserName strPassword = "Password" ' and Pasword here. ' Initialize the database connection string mstrConnStr = "server=" & strServerName & ";database=" & strDatabaseName & ";provider=SQLOLEDB;uid=" & strUserName & ";pwd=" & strPassword ' Instantiate an ADO Connection Object - Trivial code left out ' Then, open the connection. mobjConn.Open mstrConnStr ' Do some error checking here That's all there is to it! Rob Re: VB SQL Connectivity through Internet. Jason Cono14-May-01 9:08 Jason Cono 14-May-01 9:08  You need to make sure that the SQL Server is set up to use TCP\IP protocol and then on your client machines in the setup of the DSN you need to make sure they are trying to connect via TCP and not Named Pipes (which would only work in you intranet). Jason Cono, MCSD Service app - How do I tell if a user logs in? Dave Midgley17-Jan-01 23:06 Dave Midgley 17-Jan-01 23:06  I'm writing a VB app that will be deployed as a service (using SRVANY) under NT. It sits as an icon on the system tray, and puts up a visible dialog when clicked. The problem is that if it is started automatically before the user logs in the Shell_NotifyIcon function can't display the icon in the system tray because there is no task bar. Then when a user does log in there's no icon. Can anyone tell me how I can recognise when a user has logged in (or out) so that I can manage the icon properly? Dave Re: Service app - How do I tell if a user logs in? jkgh18-Jan-01 2:11 jkgh 18-Jan-01 2:11  .. what about something which [tries to] talks to the service which the user logged on in 'Startup' or the non-user visible eqiv. [Like VNC] Bon chance Al. ATL Student Re: Service app - How do I tell if a user logs in? Dave Midgley18-Jan-01 2:54 Dave Midgley 18-Jan-01 2:54  I'm sorry, I must be thick because I don't understand a word of that. What do you mean by "the service which the user logged on in 'Startup'"? What is VNC? Dave Dave Re: Service app - How do I tell if a user logs in? jkgh21-Jan-01 9:55 jkgh 21-Jan-01 9:55  Write your service as usual, and then write secondary app which you can place in the user startup folder which tries to connect to your service. VNC is a remote control app, which is well respected and exists under GPL I think: http://www.uk.research.att.com/vnc/ It also gives an icon in the 'clock box' when running as a service. Al. ATL Student Antialiasing Question neil8-Jan-01 1:47 neil 8-Jan-01 1:47  Hi, Does anyone know how to switch on (or off) antialiasing in a RichEdit Control? Cheers Neil How to use IPAdress Control in VB ?? Patrick4-Jan-01 2:12 Patrick 4-Jan-01 2:12  I would like to use the IPAddress Control as provided by Microsoft in a VB Application. In VB, unlike VC, you can't just add the control to a form, it is just not in the toolbox. I tried to create a new (subclassed) ActiveX control but I could not get things to work. Does anyone know how to get this to work? Or can someone explain to me, why it can't be done (if so)? Greetings, Patrick macro in word 2-Jan-01 2:55 2-Jan-01 2:55  Does any one know how can i find if a word or excel has a macro in it from a vb program . As 26-Dec-00 2:39 26-Dec-00 2:39  Hi everyone, I want to make a website and to show tumbnails of images. I can't find any free component or source code to solve this problem. Does anybody to help me? Best regards, Leslie Re: As 1-Jan-01 16:03 1-Jan-01 16:03  Check http://www.vbpj.com and other link off the site for a control. You could also write a VB COM DLL to search your directory of images and write out HTML text based from your listing. WM_SYSCHAR appears twice Andreas Jäger14-Dec-00 6:30 Andreas Jäger 14-Dec-00 6:30  Is it a bug in Visual Basic? When pressing a key while holding down the ALT-key, normally a WM_SYSCHAR message is generated (WM_SYSKEYUP and WM_SYSKEYDOWN, too). Writing a program with VB, this WM_SYSCHAR message appears twice with the same wParam and lParam. The message-time differs by 10 milliseconds. VC programs do not have this phenomen. Re: WM_SYSCHAR appears twice 1-Jan-01 16:05 1-Jan-01 16:05  I suspect theres a delay in VB and its coming up twice or your keyborad is really sensitive. I notice key events react differently in VB. Progress Bar on top of a Status bar. SudhaShriram6-Dec-00 1:00 SudhaShriram 6-Dec-00 1:00  How can I paste a Progress bar on top a Status bar in an MDI form. Any help would be apprieciated. Thanks Re: Progress Bar on top of a Status bar. Wolfram Steinke13-Dec-00 13:33 Wolfram Steinke 13-Dec-00 13:33  A simple way is to add a pane to the status bar as a separator and then in CMainFrame::OnCreate, create the progress control with the size of that separator. Then use CmdUI to enable it, and it is ready for use. I can send you an example is you like. Happy programming!! Re: Progress Bar on top of a Status bar. 1-Jan-01 16:14 1-Jan-01 16:14  Check out http://www.mvps.org/btmtz Save to a file 5-Dec-00 10:09 5-Dec-00 10:09  If I want to save something to a file , how to do it? Re: Save to a file 1-Jan-01 16:16 1-Jan-01 16:16  Open "vbfordummys.txt" for output as #1 print #1,"Ive never read a vb book in my life!" close #1 Lecture Archving 5-Dec-00 6:06 5-Dec-00 6:06  My project is actually lecture archiving . I suppose to screen capture whenever there is a refresh of any active application and when it does so , i will screen capture and save it into a file. However , before the screen capture occurs , there is a voice talking on a microphone which is connected to the PC and this voice is being recorded . So now I have 2 files . With these 2 files , I need to playback the voice recorded and at the same time show the captured screen output. I need to know if VB is capable of playing back the recorded voice and also show the captured screen ? Re: Lecture Archving 1-Jan-01 16:20 1-Jan-01 16:20  How about the MS Multimedia Control? You can also use the Windows API to do this depending on what format your are saving your data to. Synchronization 5-Dec-00 4:53 5-Dec-00 4:53  If I need to save the screen capture output into a file, and later i need to syunchronize with another file . What I mean by synchronizing with another file is that , when this screen capture file is open which shows the screen that I have just captured and at the same time I need to open another file which plays back a recorded sound file. Can VB do this ? Synchronization 5-Dec-00 4:53 5-Dec-00 4:53  If I need to save the screen capture output into a file, and later i need to syunchronize with another file . What I mean by synchronizing with another file is that , when this screen capture file is open which shows the screen that I have just captured and at the same time I need to open another file which plays back a recorded sound file. Can VB do this ? Re: Synchronization 1-Jan-01 16:22 1-Jan-01 16:22  Yes, see thread "Lectute Archiving" Windows API message 4-Dec-00 6:41 4-Dec-00 6:41  Can VB obtain a message from an application queue and then pass to a callback procedure something like VC++ getmessage and dispatch message ? Re: Windows API message 1-Jan-01 16:24 1-Jan-01 16:24  Your can monitor for User Messages if thats what your asking. Check out VB Programmers Guide to WIN32 API.

Last Visit: 31-Dec-99 18:00     Last Update: 17-May-24 17:59 Refresh ᐊ Prev1...4806480748084809481048114812481348144815 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.