Thanks for replying dalchri,
I did have my user settings setup incorrectly and it turns out that the Windows firewall settings blocking port 3306.
Got it working now
Thanks
I'm having problems in trying to remote connect to a database and it's driving me nuts.
Database is on server, trying to connect to it through internet using MySQL Control Center with following settings:
Name: Lucca
HostName: IP address of server
UserName: Beeps
Password: """"
Port: 3306
I've...
Sure! You can get the file name by using a dialog box to pick your file:
Dim dia As Object
Set dia = Application.FileDialog(msoFileDialogFolderPicker)
If dia.Show = 0 Then 'user pressed cancel
Exit Sub
Else
strFileName = dia.SelectedItems(1) 'user selected a...
Hi Ormsk,
You could try:
Me.yourlistbox.SetFocus
Chr (13)
I think that the set focus method is available in Access 97. This will set the cursor to your list box and the carriage return will select the first item.
Try putting this on your formload event.
Hope that it gets you started...
Ok, I think that I really figured out the problem.
In IIS, where you configure the IP address of the site, you can have all unassigned or specify an address.
In my case, I set the IP address to a specified address from unassigned, then I started having problems again. Once I switched it back...
alright, solved the problem.
I just un/re-installed IIS and that seemed to do the trick. That seemed as good as any answer because it only takes a minute.
I tried both of your suggestions, and when they didn't work, I went back to step 1.
Thanks for the effort.
Regards,
Brian
In the web.config file add
<appSettings>
<add key = "DBConn"
value = "Provider = Microsoft.Jet.OLeDB.4.0; data source=C:\Inetpub\wwwroot\[appName]\[DatabaseName].mdb;"/>
</appSettings>
after the </system.web> tag.
Then all you have to do create the connection string anywhere in your app...
Hi,
In trying to create or open a previous ASP.Net applications, I get the following error dialog:
The default Web access mode for this project is set to file share, but the project folder at 'http://localhost/WebApplication1 cannot be opened with the path 'c:\inetpub\wwwroot\WebApplication1'...
Oh yeah,
I know that the files are not a .csv, but that's how they are saved coming from the "propritary" database. I also have found out that there are slight deviations from this format. Loops seems to work through this though, but I need to test it further.
vb5prgrmr
You are the man!! Thanks for the tip. I think that this is a great place to start. I need to brush up on my file access chops since I haven't had to use it in a while.
I'm working on incorporating a ADO recordset to capture the data and am having a little trouble. I'll repost as I...
Hi,
I was wondering what would be the best vehicle to read through a series of .csv files of varying sizes? I would like to be able to sort through the entries. Here's an example of one of the files:
Date: 02/12/2004 Time: 01:21:22 System Name: D134P1
Name: 0099A52PDI03
Operator: SYSTEM...
Hi CharlieIT,
I just have had success with the XMLSerializer object for a Windows application. I used the technique here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconanexampleofxmlserializationwithxmlserializer.asp
to serialize database connection...
Thanks
RhythmAce, Magellem, and manarath.
This weekend I picked up a copy of Suse Pro and installed it on an extra laptop. I am completely amazed. It only cost $40, and I could figure out quite a lot for me being a complete beginner in this world. OpenOffice is pretty good for being free...
Hi all,
I was wondering if anybody could give me a direction to place my first steps in using Linux? I've read through a couple forums here to get a idea, but the vast amount of choices has me a little confused on a place to start. Mandrake, Red Hat, GNU....arrgh!
My programming experience...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.