Recent content by riarc

I want to create a DTS to import data from a MySQL db does anybody know how? It looks like SQL server 2000 doesn't support MySQL. At least I can't find any drivers to do so. I do have sp2 installed. I looked on MySQL.com and couldn't find anything either. Can anyone offer any suggestions?

I know this is a dumb question but this the first time I have tried to create a web page. How do I get the value of a select box. I have this tag <SELECT name=&quot;loc&quot;> that I am inserting loctions from my db. When the user selects a location I want to call my next asp page...

I have an active x user document that I call from an asp page. The problem is when I try to open the app ie won't associate a program type with it and it asks me if I want to open or save the file to disk. When I say open it will prompt me for an app type. I have registrered the dll. I can't...

That worked great CodeFish. Thanks you just saved me alot of time.

Thanks I will try them both to see what works best for my app.

I need to parse a string to remove and quotes so I can insert the string into my DB. I want to write a Public Function that I can just pass a string. How can I do this?

I thought that was the case but I was confused as to why the recordset was not open. I thought it was an ASP problem. Thanks for your help.

That worked... How did you know that. And why does that work?

Here is the proc.. I was able to see that the procedure fires in profiler. but when I try to get a recordcount I get an error msg saying that you can't use recordcount when the resordset is closed. But I take out the temp table it works fine. I thought maybe it was a permissions thing with...

I have an ASP page that is executing a stored procedure on a SQL server. There is a temp table in the proc. The procedure is executing but the recordset is not opening. must I do something special when I use a temp table in my proc. If I remove the temp table I get a recordset

Is it possible to call an ASP page from my menu?

I want to call an asp page from my menu in a VB app. How can I do that? my app is an Active X document that calls a form with a menu on it. I want to use ASP pages to format my reports.

That works.. thanks..I give the users access to a global DB where I have a table that tells me what applications the users can access and access level. I use NT auth. for that. But I don't give them rights application databases. I create a proxy acount for each app and I grant rights to the...

We are using VB 6 and the client PC are win 2000, some are XP. and the server is 2000. My DB is a SQL server.

I a VB app and I want to know the user that has logged onto the computer so I can enter a audit log in my DB. How can I do that?