Search results for query: *

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

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

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?

I know this is a simple question, but I am very new to asp. How do I add the values from a recordset to a select box. I know VB so I tried to use add item but that didn't work. this is what I got so far. How do i get write the rst to the locations select box? <DIV align=&quot;center&quot;>...

Can SQL server force an app to use encryption?

I want to send an e-mial that notifies a few users that a new event has been created. I want to include the event id and the user that has been assigned to develop that event. I will also need to CC a few people. I don't want to bring up outlook to do this. I just want the mail to be sent...

How do use the InStr function to validate a Social Security number? XXX-XX-XXXX Should I look for the dashes?

Does anybody know how to minimize a container from an Active X user_document? I tried to get the name of the container with this code but it didn't work. msgbox user_document.parent.name

If I grant a users access to my SQL server DB how can I check permissions with my VB app at logon. I looked in the sysusers table but that doesn't check password.

I am contecting to SQL server 2000. Which is the preferred location for my cursor? client or server? I am trying to get a recordcount and I keep getting a -1. Can anybody offer any suggestions. riarc

Does anyone know the max number of parameters that you can append to a command object to pass to a SQL procedure? I have 22 and I am getting an error message that would lead me to think that there are to many parameters.

I am updating my recordset and for some reason I keep getting and error msg. Can anybody see anything wrong with this? My rs is open and it is an Optimistic With rstCustomerInfo .Fields(&quot;l_name&quot;) = txtLastName.Text .Fields(&quot;f_name&quot;) = txtFirstName.Text...

Does anybody know the max number of parameters that you can append to a command object. I have a command object with 15 parameters appended to it and when I try to exec, I get a to many param error. The database is SQL server so I know I can have alot more than 15 parameters.

I am executing a stored procedure with a keyset cursor type on my recordset. why would it change to a forward only cursor type when the record set is executed? I am using SQL server 7.

How do you .MovePrevious? I have a recordset that was opened with a keyset cursor type. Do I have to asign the adMovePrevious constant to the cursor? .MoveNext works fine. What am I doing wrong? Public Function CreateRsDetails() DBConnect True Dim cmDetail As ADODB.Command...