I have connected to Sybase from VB using DTS on MS SQL Server; the only problems i really had was datatypes. Money doesn't equal money, etc. Here is a bit of my code. It's much like connecting to any other ADO or ODBC device. Set oConn = CreateObject("ADODB.Connection") oConn.Open "Srvr=[servername];Driver={SYBASE SYSTEM 11};uid=[username];pwd=[password];" And yes you have to have the proper drivers installed on your machine to connect to sybase. Real programmers don't document. If it was hard to write, it should be hard to understand.
I'm not an expert but wouldn't you just create a component via its ProgId which you can lookup with the OLE/COM viewer in VC++? It's also known as the OleView tool on Start Menu | Programs | Microsoft Visual Studio 6.0 Program | Microsoft Visual Studio 6.0 Tools submenu. e.g. Set objScripObj = CreateObject("MSScriptControl.ScriptControl.1") Just trap the error (On Error....) if the Set statement fails, then it is not installed on the system or in the registry. As far as installing a missing component, you would have to provide it since it isn't already installed and if its the DUN object, I don't know about the compatability between different Windows OS.
Try this in the Focus event: TextBox1.SelectionStart = 0 and TextBox1.SelectionLength = 0
(In VB6, these are called SelStart and SelLength)
sValue = TextBox1.Text.Replace("'","''"),
or in VB6, sValue = Replace(TextBox1.Text, "'", "''")
There's also the Command object. And, you can access it from anywhere in the program. It's a string containing what was passed on the command line after the executable's filename. It's up to you to parse it. Try this...
MsgBox """" & Command & """"
Then, compile it into an exe and run it from the command line passing whatever you want. Jeremy Falcon Imputek "The happy people are those who are producing something; the bored people are those who are consuming much and producing nothing." - William Ralph Inge
check out these three links .. i hope ya get wat ya want.. ;) http://www.15seconds.com/issue/981203.htm http://www.acky.net/vb/vbtcp/index2.sht http://www.vb2themax.com/HtmlDoc.asp?Table=Articles&ID=520
thx for the reply but this environment class doesnot provide me the facility to know the group of currently logged on user.. which is the most important information about the user as far as i am concerned.. so plz hep me out..
As Ravi_Shankar pointed out (but not so clearly) the problem is that databases use single quotes (or apostrophes; your pick) to delmit the boundries of a string. In order to support the use of single quotes/apostrophes in a string the SQL specification says that a double-single quote/apostrophe '' is used (not "). So rather than the last line being "RequestTo = 'Tod O'Dell'" you need to make it "RequestTo = 'Tod O''Dell'" (note the use of the dobule-apostrophe) Hope that is a bit clearer for you :) James "Java is free - and worth every penny." - Christian Graus
TRY THE OBJECT CALLED ASP UPLOAD 2.0 BY DUNDEE SOFTWARE.its good and easy to use and pretty decent documentation is avbl..i use it for my asp page.. Why Need Parking lots in Bars when Drunken Driving is Prohibited
