I also have the same problem connecting to SQL server from VB6.
Any help will be appreciated.
**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
.
Re: Create Storedprocedure with VB6? Is this possible? ...VB6 and ADO no .NET ... can SQL Server Management Studio." ... Can VB6 create a stored procedure on the fly. ... something similar) exactly what you're sending to the db engine (via ADO),... (microsoft.public.vb.database.ado)
Re: T-SQL and OLE Automation ... A library created as type ActiveX.exe will run out of the SQL Server... To deploy a .dll, you make it, using the VB6 file/make command, then copy to ... Creating COM libraries with VB6 is probably better discussed in a VB ... > OLE automation and I'm not sure how to write the application on the VB6 ... (microsoft.public.sqlserver.programming)
Re: T-SQL and OLE Automation ... components from VB6 now that VB.Net is so well established as that code will ... Choose a path to save the .dll & remember where it is. ... If you are running your SQL Server on that machine, ... >> Greg Linwood... (microsoft.public.sqlserver.programming)
Connection.Execute and SQL stored procedures .....asp, the connection object and MS SQL Server as the DB can help me out. ... Five of the six calls execute as expected. ... This particular stored procedure does quite a bit of work within the DB, ... (microsoft.public.sqlserver.odbc)
Re: Heres a rather broad question... ... I'm familiar enough with using ADO with VBScript/Javascript in ASP pages, ... authentication or permission issues with SQL Server 2000. ...IIS user doesn't have the proper permissions to access the database, ... (microsoft.public.data.ado)
