Search results for query: *

I am just beginning to develop applications in VB.NET using the visual studio 2005. I am relativly new to .net as I have been doing my development in VB6. I am running a SQL 6.5 soon to be 2000 compatiable DB database. Currently I compile a VB6 exe and place it on a network share, this allows...

Hello All, I am new to SQL server but not database servers. I worked with Pervasive SQL for years and I have a couple of questions as our current company is having some problems. We seem to be having server speed issues and I cant figure out why. Here is the setup: Dual Intel 3 gig Xeons...

Hey, I have a schedule table tha tholds an autonumber PK, a job number, Scheduled date adn scheduled hours. The user needs to view this data in a two week period. The Start and end date will be passed ot the sp from VB I need to return a list that looks like this: In: Begin Date = '08/01/04'...

Hey all! I am building a form that I need to display a crosstab of data and display it on a VB 6 form. The purpose is for schduling, so I need display along the top each day within the two week period, and below that a list of job numbers that are scheduled, if that job is scheduled on any of...

I am using the Datagrid control called Datagrid (MSDATGRD.OCX) adn I am trying to set it' sdata source to an ADODB recordset and I am getting the Type Mismatch error, any ideas? I know my recordset is returning data (debug.print) All i removed from my code was the actual SQL statement and the...

I am trying to pass a set of paremters to a sql stored procedure, various ints, varchars and dates. Now m yprog save say 20 fields, but only 10 are required so the function must be able to run with the bare bones data, now this should not be a problem, except, I use three dates in the stored...

I have SQL Server 7 running on NT server. Enterprise manager has stopped running, when you try to run it a Dr.Watsn erro rcoems up indicatiing an application log is being generated. The following ar ethe only two errors that appear when this happens. The Open Procedure for service...

I am trying to create a function in SQL 7 but the FUNCTION keyword does not turn blue and I get incorrect syntax near the word fumction when I try and compile my code. Has anyone encountered this or an give any insight or ideas regarding this. Thanks so much. Copper

I have an array of file names that I want to sort so that when my code uses the array to populate a treeview it will put then in the proper order. Here's my problem, I have a dir of files that I use the GetFiles function to get the files in the specified dir. The files are named as follows...

I'm hosting an intranet on the latest version of IIS running on Win 2K server. I am hosting ASP.net applications but Session variables and cookies do not work ? Any suggestions, When I test the pages on my local host machine (I used a seperate machine with local IIS for development at first...

I'm hosting an intranet on the latest version of IIS running on Win 2K server. I am hosting ASP.net applications but Session variables and cookies do not work ? Any suggestions, When I test the pages on my local host machine (I used a seperate machine with local IIS for development at first...

I'm using Basic Authentication on my IIS and session variables aren't being saved? Is there a setting in IIS or IE that I'm missing?

I have a set of pages that I'm beginnning an Intranet with. One page accesses a file server to diaply contents of it and another grabs information and display's it from a SQL database. Now the web server is running Win2K and IIS 5 or above. And when I browse the pages locally the impersonation...

hi, I've got multiple datalists on one page, and they are populated dynamically according to queries that are run to get the required data. Now, there is a dynamic number of records that either of the lists will have. I am displaying them one below the other. How do I set it so that they won't...

I have an access 97 DB with a report that I need to export automatically to a pdf file using VBA code when it is generated. I have the full version adobe acrobat installed, but I have not been able to find how i can accomplish this. Anyone know how to do this or where i should be looking...

I am using VB.Net to search through a specfied drive and find access97 databases. Once a database is found i want to search it for a specfic linked table. The problem I'm having is that it will work on some DB's and on others it will not show any of it's linked tables. Any ideas would be most...

I have a crystal report that i want to open then export to adobe .pdf or .doc, just somthing other than crystal report for the purpose of emailing it. Any ideas??? Thanx as always Copper

I have a table with an ID and an Image datatype and I'm trying to insert a jpg file into the image field. Does anyone know the SQl syntax to do this. Muchly appreciated as always Copper

I am looking at creating a SQL DSN that when called will prompt the user for a user name and password. Any one know how i can accomplish this? Thanks So Much Copper

I'm looking for any way to unlock an MS Access MDE file so that i can view the code in a module. I don't even know for sure if this can be done, but i figured if anyone knows, it's you. It doesn't have to unlock it so to say, just as long as i can access the code module. Thanks, muchos...